SISU - SEARCH, RALPH AMISSAH ***************************** SISU SEARCH =========== SISU SQLITE =========== 1. SQLITE --------- 1.1 NAME ........ *SiSU* - Structured information, Serialized Units - a document publishing system. 1.2 DESCRIPTION ............... 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 *SiSU* to populate an sqlite database, this being part of *SiSU* - man sisu). 1.3 SYNOPSIS ............ sisu -d [instruction] [filename/wildcard if required] sisu -d --(sqlite|pg) --[instruction] [filename/wildcard if required] 1.4 COMMANDS ............ 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 *-d or --sqlite* may be used interchangeably. 1.4.1 CREATE AND DESTROY DATABASE ................................. *--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) *sisu -d --createdb* creates database where no database existed before *sisu -d --create* creates database tables where no database tables existed before *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). *sisu -d --recreate* destroys existing database and builds a new empty database structure 1.4.2 IMPORT AND REMOVE DOCUMENTS ................................. *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). *sisu -d --update -v [filename/wildcard]* updates file contents in database *sisu -d --remove -v [filename/wildcard]* removes specified document from sqlite database. DOCUMENT INFORMATION (METADATA) ******************************* METADATA -------- Document Manifest @ *Dublin Core* (DC) /DC tags included with this document are provided here./ DC Title: _SiSU - Search_ DC Creator: _Ralph Amissah_ DC Rights: _Copyright (C) Ralph Amissah 2007, part of SiSU documentation, License GPL 3_ DC Type: _information_ DC Date created: _2002-08-28_ DC Date issued: _2002-08-28_ DC Date available: _2002-08-28_ DC Date modified: _2007-09-16_ DC Date: _2007-09-16_ *Version Information* Sourcefile: _sisu_sqlite.sst_ Filetype: _SiSU text 0.58_ Sourcefile Digest, MD5(sisu_sqlite.sst)= _2ffb869c7c41615ca4ec83d8bd70470d_ 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)= _20fc43cf3eb6590bc3399a1aef65c5a9_ *Generated* Document (metaverse) last generated: _Mon Sep 24 15:35:00 +0100 2007_ Generated by: _SiSU_ _0.59.0_ of 2007w38/0 (2007-09-23) Ruby version: _ ruby 1.8.6 (2007-06-07 patchlevel 36) [i486-linux]_ ============================================================================== title: SiSU - Search creator: Ralph Amissah rights: Copyright (C) Ralph Amissah 2007, part of SiSU documentation, License GPL 3 type: information subject: ebook, epublishing, electronic book, electronic publishing, electronic document, electronic citation, data structure, citation systems, search date.created: 2002-08-28 date.issued: 2002-08-28 date.available: 2002-08-28 date.modified: 2007-09-16 date: 2007-09-16 ============================================================================== nil Other versions of this document: manifest: http://www.jus.uio.no/sisu/sisu_sqlite/sisu_manifest.html html: http://www.jus.uio.no/sisu/sisu_sqlite/toc.html pdf: http://www.jus.uio.no/sisu/sisu_sqlite/portrait.pdf http://www.jus.uio.no/sisu/sisu_sqlite/landscape.pdf plaintext (plain text): http://www.jus.uio.no/sisu/sisu_sqlite/plain.txt at: http://www.jus.uio.no/sisu * Generated by: SiSU 0.59.0 of 2007w38/0 (2007-09-23) * Ruby version: ruby 1.8.6 (2007-06-07 patchlevel 36) [i486-linux] * Last Generated on: Mon Sep 24 15:35:01 +0100 2007 * SiSU http://www.jus.uio.no/sisu