% SiSU 4.0

@title: SiSU
 :subtitle: Sqlite / search

@creator:
 :author: Amissah, Ralph

@date:
 :published: 2007-09-16
 :created: 2002-08-28
 :issued: 2002-08-28
 :available: 2002-08-28
 :modified: 2012-10-03

@rights:
 :copyright: Copyright (C) Ralph Amissah 2007
 :license: GPL 3 (part of SiSU documentation)

@classify:
 :topic_register: electronic documents:SiSU:document:sqlite;SiSU:manual:sqlite;electronic documents:SiSU:manual:sqlite;SiSU:document:sqlite;SiSU:document:sqlite
 :subject: ebook, epublishing, electronic book, electronic publishing, electronic document, electronic citation, data structure, citation systems, search

@make:
 :manpage: section=7; name=sisu - package to install what sisu needs to to populate a postgresql database (postgresql dependency component); synopsis=sisu -dv [filename/wildcard ]\n sisu -dv [instruction]

:A~? @title @creator

% :B~? SiSU Sqlite

1~sqlite Sqlite

2~ Name

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


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).

2~ Synopsis

_1 sisu -d [instruction] [filename/wildcard if required]

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


2~ 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.

3~ create and destroy database

!_ --sqlite --createall<br>
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<br>
creates database where no database existed before

!_ sisu -d --create<br>
creates database tables where no database tables existed before

!_ sisu -d --dropall<br>
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<br>
destroys existing database and builds a new empty database structure

3~ import and remove documents

!_ sisu -d --import -v [filename/wildcard]<br>
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]<br>
updates file contents in database

!_ sisu -d --remove -v [filename/wildcard]<br>
removes specified document from sqlite database.