% SiSU 4.0
@title: SiSU
:subtitle: 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:postgresql;SiSU:manual:postgresql;electronic documents:SiSU:manual:postgresql;SiSU:document:postgresql;SiSU:document:postgresql;
: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 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
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
3~ import and remove documents
!_ 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.