sisu − package to install what sisu needs to to populate a postgresql database (postgresql dependency component)
sisu −Dv [filename/wildcard ] sisu −Dv [instruction]
RALPH AMISSAH
SiSU − Structured information, Serialized Units − a document publishing system, postgresql dependency package
Information related to using postgresql with sisu (and related to the sisu_postgresql dependency package, which is a dummy package to install dependencies needed for SiSU to populate a postgresql database, this being part of SiSU − man sisu).
sisu −D [instruction] [filename/wildcard if required]
sisu −D −−pg −−[instruction] [filename/wildcard if required]
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 −−pgsql may be used interchangeably.
−−pgsql −−createall
initial step, creates required relations (tables, indexes) in existing (postgresql) 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
sisu −D −−import −v [filename/wildcard]
populates database with the contents of the file. Imports documents(s) specified to a postgresql 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 postgresql database.
Document Manifest @ <http://sisudoc.org/sisu_manual/sisu_postgresql/sisu_manifest.html>
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_postgresql.sst
Filetype: SiSU text 0.58
Sourcefile Digest, MD5(sisu_postgresql.sst)= 9010e85001c50e30ba2ab69f9097825a
Skin_Digest: MD5(skin_sisu_manual.rb)= 20fc43cf3eb6590bc3399a1aef65c5a9
Generated
Document (metaverse) last generated: Sat Sep 29 17:05:38 +0100 2007
Generated by: SiSU 0.59.1 of 2007w39/2 (2007−09−25)
Ruby version: ruby 1.8.6 (2007−06−07 patchlevel 36) [i486−linux]
Other versions of this document:
manifest:
<http://www.jus.uio.no/sisu/sisu_postgresql/sisu_manifest.html>
html: <http://www.jus.uio.no/sisu/sisu_postgresql/toc.html>
pdf: <http://www.jus.uio.no/sisu/sisu_postgresql/portrait.pdf>
pdf: <http://www.jus.uio.no/sisu/sisu_postgresql/landscape.pdf>
at: <http://www.jus.uio.no/sisu>
* Generated by: SiSU 0.59.1 of 2007w39/2 (2007-09-25)
* Ruby version: ruby 1.8.6 (2007-06-07 patchlevel 36) [i486-linux]
* Last Generated on: Sat Sep 29 17:05:39 +0100 2007
* SiSU http://www.jus.uio.no/sisu