.TH "sisu_sqlite" "1" "2007-09-16" "0.59.0" "SiSU"
.SH
SISU \- SEARCH,
RALPH AMISSAH
.BR

.SH
SISU SEARCH
.BR

.SH
SISU SQLITE
.BR

.SH
1. SQLITE
.BR

.SH
1.1 NAME

.BR
.B SiSU
\- Structured information, Serialized Units \- a document publishing system.

.SH
1.2 DESCRIPTION

.BR
Information related to using sqlite with sisu (and related to the sisu_sqlite
dependency package, which is a dummy package to install dependencies needed for
.B SiSU
to populate an sqlite database, this being part of
.B SiSU
\- man sisu).

.SH
1.3 SYNOPSIS

.BR
  sisu \-d \ [instruction] \ [filename/wildcard \ if \ required]

.BR
  sisu \-d \-\-(sqlite|pg) \-\-[instruction] \ [filename/wildcard \ if \
  required]

.SH
1.4 COMMANDS

.BR
Mappings to two databases are provided by default, postgresql and sqlite, the
same commands are used within sisu to construct and populate databases however
\-d (lowercase) denotes sqlite and \-D (uppercase) denotes postgresql,
alternatively \-\-sqlite or \-\-pgsql may be used

.BR
.B \-d or \-\-sqlite
may be used interchangeably.

.SH
1.4.1 CREATE AND DESTROY DATABASE

.TP
.B \ \-\-sqlite \ \-\-createall
\ initial \ step, \ creates \ required \ relations \ (tables, \ indexes) \ in
\ existing \ (sqlite) \ database \ (a \ database \ should \ be \ created \
manually \ and \ given \ the \ same \ name \ as \ working \ directory, \ as \
requested) \ (rb.dbi) \

.TP
.B \ sisu \ \-d \ \-\-createdb
\ creates \ database \ where \ no \ database \ existed \ before \

.TP
.B \ sisu \ \-d \ \-\-create
\ creates \ database \ tables \ where \ no \ database \ tables \ existed \
before \

.TP
.B \ sisu \ \-d \ \-\-dropall
\ destroys \ database \ (including \ all \ its \ content)! \ kills \ data \
and \ drops \ tables, \ indexes \ and \ database \ associated \ with \ a \
given \ directory \ (and \ directories \ of \ the \ same \ name). \

.TP
.B \ sisu \ \-d \ \-\-recreate
\ destroys \ existing \ database \ and \ builds \ a \ new \ empty \ database
\ structure \

.SH
1.4.2 IMPORT AND REMOVE DOCUMENTS

.TP
.B \ sisu \ \-d \ \-\-import \ \-v \ \ [filename/wildcard]
populates database with the contents of the file. Imports documents(s)
specified to an sqlite database (at an object level).

.TP
.B \ sisu \ \-d \ \-\-update \ \-v \ \ [filename/wildcard]
updates file contents in database

.TP
.B \ sisu \ \-d \ \-\-remove \ \-v \ \ [filename/wildcard]
removes specified document from sqlite database.

.SH
DOCUMENT INFORMATION (METADATA)
.BR

.SH
METADATA
.BR

.BR
Document Manifest @
<http://www.jus.uio.no/sisu/sisu_manual/sisu_sqlite/sisu_manifest.html>

.BR
.B Dublin Core
(DC)

.BR
.I DC tags included with this document are provided here.

.BR
DC Title:
.I SiSU \- Search

.BR
DC Creator:
.I Ralph Amissah

.BR
DC Rights:
.I Copyright (C) Ralph Amissah 2007, part of SiSU documentation, License GPL
3

.BR
DC Type:
.I information

.BR
DC Date created:
.I 2002\-08\-28

.BR
DC Date issued:
.I 2002\-08\-28

.BR
DC Date available:
.I 2002\-08\-28

.BR
DC Date modified:
.I 2007\-09\-16

.BR
DC Date:
.I 2007\-09\-16

.BR
.B Version Information

.BR
Sourcefile:
.I sisu_sqlite.sst

.BR
Filetype:
.I SiSU text 0.58

.BR
Sourcefile Digest, MD5(sisu_sqlite.sst)=
.I 2ffb869c7c41615ca4ec83d8bd70470d

.BR
Skin_Digest:
MD5(/home/ralph/grotto/theatre/dbld/sisu\-dev/sisu/data/doc/sisu/sisu_markup_samples/sisu_manual/_sisu/skin/doc/skin_sisu_manual.rb)=
.I 20fc43cf3eb6590bc3399a1aef65c5a9

.BR
.B Generated

.BR
Document (metaverse) last generated:
.I Mon Sep 24 15:36:18 +0100 2007

.BR
Generated by:
.I SiSU
.I 0.59.0
of 2007w38/0 (2007\-09\-23)

.BR
Ruby version:
.I ruby 1.8.6 (2007\-06\-07 patchlevel 36) \ [i486\-linux]


.TP
Other versions of this document:
.TP
manifest: <http://www.jus.uio.no/sisu/sisu_sqlite/sisu_manifest.html>
.TP
html: <http://www.jus.uio.no/sisu/sisu_sqlite/toc.html>
.TP
pdf: <http://www.jus.uio.no/sisu/sisu_sqlite/portrait.pdf>
.TP
pdf: <http://www.jus.uio.no/sisu/sisu_sqlite/landscape.pdf>
." .TP
." manpage: http://www.jus.uio.no/sisu/sisu_sqlite/sisu_sqlite.1
.TP
at: <http://www.jus.uio.no/sisu>
.TP
.TP
* Generated by: SiSU 0.59.0 of 2007w38/0 (2007-09-23)
.TP
* Ruby version: ruby 1.8.6 (2007-06-07 patchlevel 36) [i486-linux]
.TP
* Last Generated on: Mon Sep 24 15:36:32 +0100 2007
.TP
* SiSU http://www.jus.uio.no/sisu