.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