diff options
Diffstat (limited to 'data/doc/sisu/html/sisu_sqlite.7.html')
| -rw-r--r-- | data/doc/sisu/html/sisu_sqlite.7.html | 228 |
1 files changed, 161 insertions, 67 deletions
diff --git a/data/doc/sisu/html/sisu_sqlite.7.html b/data/doc/sisu/html/sisu_sqlite.7.html index 4d85c37b..139501b2 100644 --- a/data/doc/sisu/html/sisu_sqlite.7.html +++ b/data/doc/sisu/html/sisu_sqlite.7.html @@ -1,91 +1,185 @@ - <!-- manual page source format generated by PolyglotMan v3.2, --> +<!-- manual page source format generated by PolyglotMan v3.2, --> <!-- available at http://polyglotman.sourceforge.net/ --> <html> <head> -<title>sisu_sqlite(7) manual page</title> +<title>"sisu_sqlite"("1") manual page</title> </head> <body bgcolor='white'> <a href='#toc'>Table of Contents</a><p> +SISU - SISU INFORMATION STRUCTURING UNIVERSE - SEARCH [0.58], RALPH AMISSAH + +<p> SISU SEARCH +<p> SISU SQLITE +<p> 1. SQLITE +<p> 1.1 NAME +<p> <b>SiSU</b> - Structured information, +Serialized Units - a document publishing system. +<p> 1.2 DESCRIPTION +<p> 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</b> +to populate an sqlite database, this being part of <b>SiSU</b> - man sisu). +<p> 1.3 -<h2><a name='sect0' href='#toc0'>Name</a></h2> -<b>SiSU</b> - Structured information, Serialized Units - a document -publishing system, sqlite dependency package <p> -This is a dummy package to -install the dependencies required by SiSU to populate an sqlite database - -<h2><a name='sect1' href='#toc1'>Synopsis</a></h2> -<b>sisu</b> <i>-d</i> [instruction] [filename/wildcard if required] <p> -<b>sisu</b> <i>-d</i> --(sqlite|pg) ---[instruction] [filename/wildcard if required] <p> +<p>SYNOPSIS +<p> sisu -d [instruction] [filename/wildcard if required]<br> -<h2><a name='sect2' href='#toc2'>Description</a></h2> -<b>sisu_sqlite</b> <i>is</i> -part of SiSU (man sisu) sisu_sqlite is a dummy package to install dependencies -needed for sisu to populate an sqlite database, documented in man sisu +<p> sisu -d --(sqlite|pg) --[instruction] [filename/wildcard if <br> + required]<br> -<h2><a name='sect3' href='#toc3'>databases</a></h2> - +<p> 1.4 COMMANDS +<p> 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 +<p> <b>-d or --sqlite</b> may +be used interchangeably. +<p> 1.4.1 CREATE AND DESTROY DATABASE +<p> <dl> -<dt>dbi - database interface </dt> -<dd><b>-d</b> set for <i>sqlite</i> </dd> +<dt><b> --sqlite --createall</b> +</dt> +<dd> initial step, creates required relations (tables, indexes) in existing + (sqlite) database (a database should be created as requested) (rb.dbi) the + same name as working directory, as +<p> </dd> + +<dt><b> sisu -d --createdb</b> </dt> +<dd> creates database where + no database existed before as +<p> </dd> -<dt><b>--sqlite --createall</b> </dt> -<dd>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) </dd> +<dt><b> sisu -d --create</b> </dt> +<dd> creates database tables where + no database tables existed before database tables where no database tables + existed +<p> </dd> -<dt><b>--sqlite --import -v </b> </dt> -<dd><i>[filename/wildcard]</i> -imports data specified to (sqlite) db (rb.dbi) </dd> +<dt><b> sisu -d --dropall</b> </dt> +<dd> 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). a +<p> </dd> -<dt><b>--sqlite --update -v </b> </dt> -<dd><i>[filename/wildcard]</i> -updates/imports specified data to (sqlite) db (rb.dbi) </dd> +<dt><b> sisu -d --recreate</b> </dt> +<dd> destroys -<dt><b>--sqlite --remove -v </b> -</dt> -<dd><i>[filename/wildcard]</i> removes specified data to (sqlite) db (rb.dbi) </dd> +<p> existing database and builds a new empty database structure +<p> </dd> +</dl> +1.4.2 IMPORT + +<p>AND REMOVE DOCUMENTS +<p> +<dl> + +<dt><b> sisu -d --import -v [filename/wildcard]</b> </dt> +<dd>populates database +with the contents of the file. Imports documents(s) specified to an sqlite +database (at an object level). +<p> </dd> -<dt><b>--sqlite ---dropall </b> </dt> -<dd>kills data" and drops (postgresql) db, tables & indexes </dd> +<dt><b> sisu -d --update -v [filename/wildcard]</b> </dt> +<dd>updates -<dt><b>--sqlite ---recreate </b> </dt> -<dd>kills data" and drops and rebuilds empty (postgresql) db, tables -& </dd> +<p>file contents in database +<p> </dd> + +<dt><b> sisu -d --remove -v [filename/wildcard]</b> </dt> +<dd>removes +specified document from sqlite database. +<p> </dd> </dl> -indexes </blockquote> +DOCUMENT INFORMATION (METADATA) -<h2><a name='sect4' href='#toc4'>Further Information</a></h2> +<p> METADATA +<p> Document Manifest @ <<a href='http://www.jus.uio.no/sisu/sisu_manual/sisu_sqlite/sisu_manifest.html'>http://www.jus.uio.no/sisu/sisu_manual/sisu_sqlite/sisu_manifest.html</a> +> + +<p> <b>Dublin Core</b> (DC) +<p> <i>DC</i> tags included with this document are provided here. + +<p> DC Title: <i>SiSU</i> - SiSU information Structuring Universe - Search [0.58] <p> -For more information on <i>SiSU</i> see: <i><<a href='http://www.jus.uio.no/sisu'>http://www.jus.uio.no/sisu</a> -></i> + DC Creator: <i>Ralph</i> Amissah +<p> DC Rights: <i>Copyright</i> (C) Ralph Amissah 2007, +part of SiSU documentation, License GPL 3 +<p> DC Type: <i>information</i> +<p> DC Date +created: <i>2002-08-28</i> +<p> DC Date issued: <i>2002-08-28</i> +<p> DC Date available: <i>2002-08-28</i> + +<p> DC Date modified: <i>2007-09-16</i> +<p> DC Date: <i>2007-09-16</i> +<p> <b>Version Information</b> + +<p> Sourcefile: <i>sisu_sqlite.sst</i> +<p> Filetype: <i>SiSU</i> text 0.58 +<p> Sourcefile Digest, +MD5(sisu_sqlite.sst)= <i>61ba58f6a2f5cc9651b985a8eabb96e9</i> +<p> 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)= + +<p><i>20fc43cf3eb6590bc3399a1aef65c5a9</i> +<p> <b>Generated</b> +<p> Document (metaverse) last +generated: <i>Sun</i> Sep 23 01:14:03 +0100 2007 +<p> Generated by: <i>SiSU</i> <i>0.58.3</i> of +2007w36/4 (2007-09-06) +<p> Ruby version: <i>ruby</i> 1.8.6 (2007-06-07 patchlevel 36) + [i486-linux] +<p> +<p> +<dl> + +<dt>Other versions of this document: </dt> +<dd></dd> + +<dt>manifest: <<a href='http://www.jus.uio.no/sisu/sisu_sqlite/sisu_manifest.html'><a href='http://www.jus.uio.no/sisu/sisu_sqlite/sisu_manifest.html'>http://www.jus.uio.no/sisu/sisu_sqlite/sisu_manifest.html</a> +</a> +> +</dt> +<dd></dd> + +<dt>html: <<a href='http://www.jus.uio.no/sisu/sisu_sqlite/toc.html'><a href='http://www.jus.uio.no/sisu/sisu_sqlite/toc.html'>http://www.jus.uio.no/sisu/sisu_sqlite/toc.html</a> +</a> +> </dt> +<dd></dd> + +<dt>pdf: <<a href='http://www.jus.uio.no/sisu/sisu_sqlite/portrait.pdf'><a href='http://www.jus.uio.no/sisu/sisu_sqlite/portrait.pdf'>http://www.jus.uio.no/sisu/sisu_sqlite/portrait.pdf</a> +</a> +> +</dt> +<dd></dd> + +<dt>pdf: <<a href='http://www.jus.uio.no/sisu/sisu_sqlite/landscape.pdf'><a href='http://www.jus.uio.no/sisu/sisu_sqlite/landscape.pdf'>http://www.jus.uio.no/sisu/sisu_sqlite/landscape.pdf</a> +</a> +> </dt> +<dd> </dd> + +<dt>at: <<a href='http://www.jus.uio.no/sisu'><a href='http://www.jus.uio.no/sisu'>http://www.jus.uio.no/sisu</a> +</a> +> +</dt> +<dd></dd> + +<dt>* Generated by: SiSU 0.58.3 of 2007w36/4 (2007-09-06) </dt> +<dd></dd> + +<dt>* Ruby version: ruby +1.8.6 (2007-06-07 patchlevel 36) [i486-linux] </dt> +<dd></dd> + +<dt>* Last Generated on: Sun Sep 23 +01:14:07 +0100 2007 </dt> +<dd></dd> + +<dt>* SiSU <a href='http://www.jus.uio.no/sisu'>http://www.jus.uio.no/sisu</a> + </dt> +<dd></dd> +</dl> <p> -or <i>man</i> sisu -<h2><a name='sect5' href='#toc5'>Author</a></h2> -Ralph Amissah <i><ralph@amissah.com></i> or <i><ralph.amissah@gmail.com></i> - -<h2><a name='sect6' href='#toc6'>See Also</a></h2> -<a href='http:~/bin/man2html?sisu:1'><b>sisu(1)</a> -,</b> <a href='http:~/bin/man2html?sisu:8'><b>sisu(8)</a> -,</b> <a href='http:~/bin/man2html?sisu_postgresql:7'><b>sisu_postgresql(7)</a> -,</b> <a href='http:~/bin/man2html?sisu_vim:7'><b>sisu_vim(7)</b></a> - <p> - -<hr><p> -<a name='toc'><b>Table of Contents</b></a><p> -<ul> -<li><a name='toc0' href='#sect0'>Name</a></li> -<li><a name='toc1' href='#sect1'>Synopsis</a></li> -<li><a name='toc2' href='#sect2'>Description</a></li> -<li><a name='toc3' href='#sect3'>databases</a></li> -<li><a name='toc4' href='#sect4'>Further Information</a></li> -<li><a name='toc5' href='#sect5'>Author</a></li> -<li><a name='toc6' href='#sect6'>See Also</a></li> -</ul> </body> </html> |