From 306aed5b8a559aad2fb944a946ffdda9713f07ec Mon Sep 17 00:00:00 2001
From: Ralph Amissah <ralph@amissah.com>
Date: Sat, 6 Mar 2010 09:47:55 -0500
Subject: introducing version 2, major patch, (version 1 libraries retained)

---
 .../sisu_manual/sisu_postgresql.sst                | 98 ++++++++++++++++++++++
 1 file changed, 98 insertions(+)
 create mode 100644 data/doc/sisu/v2/sisu_markup_samples/sisu_manual/sisu_postgresql.sst

(limited to 'data/doc/sisu/v2/sisu_markup_samples/sisu_manual/sisu_postgresql.sst')

diff --git a/data/doc/sisu/v2/sisu_markup_samples/sisu_manual/sisu_postgresql.sst b/data/doc/sisu/v2/sisu_markup_samples/sisu_manual/sisu_postgresql.sst
new file mode 100644
index 00000000..addf1bd1
--- /dev/null
+++ b/data/doc/sisu/v2/sisu_markup_samples/sisu_manual/sisu_postgresql.sst
@@ -0,0 +1,98 @@
+% SiSU 2.0
+
+@title: SiSU
+ :subtitle: Search
+
+@creator: :author: Amissah, Ralph
+
+@rights: Copyright (C) Ralph Amissah 2007, part of SiSU documentation, License GPL 3
+
+@classify:
+ :topic_register: electronic documents:SiSU:document:postgresql;SiSU:manual:postgresql;electronic documents:SiSU:manual:postgresql;SiSU:document:postgresql;SiSU:document:postgresql;
+ :type: information
+ :subject: ebook, epublishing, electronic book, electronic publishing, electronic document, electronic citation, data structure, citation systems, search
+
+% used_by: sisu_manual.ssm SiSU.ssm
+
+@date:
+ :published: 2007-09-16
+ :created: 2002-08-28
+ :issued: 2002-08-28
+ :available: 2002-08-28
+ :modified: 2009-12-16
+
+@make:
+ :num_top: 1
+ :breaks: new=C; break=1
+ :skin: skin_sisu_manual
+ :bold: /Gnu|Debian|Ruby|SiSU/
+ :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]
+
+@links:
+ { SiSU Manual }http://www.jus.uio.no/sisu/sisu_manual/
+ { Book Samples and Markup Examples }http://www.jus.uio.no/sisu/SiSU/examples.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 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.
+
-- 
cgit v1.2.3