summaryrefslogtreecommitdiffstats
path: root/data/doc/sisu/markup-samples/sisu_manual/sisu_sqlite.sst
diff options
context:
space:
mode:
Diffstat (limited to 'data/doc/sisu/markup-samples/sisu_manual/sisu_sqlite.sst')
-rw-r--r--data/doc/sisu/markup-samples/sisu_manual/sisu_sqlite.sst82
1 files changed, 82 insertions, 0 deletions
diff --git a/data/doc/sisu/markup-samples/sisu_manual/sisu_sqlite.sst b/data/doc/sisu/markup-samples/sisu_manual/sisu_sqlite.sst
new file mode 100644
index 0000000..a73ae16
--- /dev/null
+++ b/data/doc/sisu/markup-samples/sisu_manual/sisu_sqlite.sst
@@ -0,0 +1,82 @@
+% 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.