% SiSU 0.58

@title: SiSU

@subtitle: Search

@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

@level: new=C; break=1; num_top=1

@skin: skin_sisu_manual

@bold: /Gnu|Debian|Ruby|SiSU/

@links: { SiSU Manual }http://www.jus.uio.no/sisu/sisu_manual/
{ Book Samples and Markup Examples }http://www.jus.uio.no/sisu/SiSU/2.html
{ SiSU @ Wikipedia }http://en.wikipedia.org/wiki/SiSU
{ SiSU @ Freshmeat }http://freshmeat.net/projects/sisu/
{ SiSU @ Ruby Application Archive }http://raa.ruby-lang.org/project/sisu/
{ SiSU @ Debian }http://packages.qa.debian.org/s/sisu.html
{ SiSU Download }http://www.jus.uio.no/sisu/SiSU/download.html
{ SiSU Changelog }http://www.jus.uio.no/sisu/SiSU/changelog.html
{ SiSU help }http://www.jus.uio.no/sisu/sisu_manual/sisu_help/
{ SiSU help sources }http://www.jus.uio.no/sisu/sisu_manual/sisu_help_sources/

:A~? @title @creator

:B~? SiSU Search

:C~? SiSU Postgresql

1~postgresql Postgresql

2~ Name

SiSU - Structured information, Serialized Units - a document publishing system, postgresql dependency package

2~ Description

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

2~ Synopsis

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

_1 sisu -D --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 --pgsql
may be used interchangeably.

3~ create and destroy database

!_ --pgsql --createall<br>
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<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 a postgresql 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 postgresql database.