SISU - SISU INFORMATION STRUCTURING UNIVERSE - SEARCH [0.58],
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 @
<http://www.jus.uio.no/sisu/sisu_manual/sisu_sqlite/sisu_manifest.html>


*Dublin Core* (DC)


/DC tags included with this document are provided here./


DC Title: _SiSU - SiSU information Structuring Universe - Search [0.58]_


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)= _61ba58f6a2f5cc9651b985a8eabb96e9_


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: _Sun Sep 23 04:11:05 +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 - SiSU information Structuring Universe - Search [0.58]

	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: Sun Sep 23 04:11:52 +0100 2007
* SiSU http://www.jus.uio.no/sisu