SISU - SEARCH, RALPH AMISSAH

SISU SEARCH

SISU POSTGRESQL

1. POSTGRESQL

1.1 NAME

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

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

1.3 SYNOPSIS

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

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

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

1.4.1 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) the  same  name  as  working  directory,  as

 sisu  -D  --createdb

 creates  database  where  no  database  existed  before  as

 sisu  -D  --create

 creates  database  tables  where  no  database  tables  existed before  database  tables  where  no  database  tables  existed

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

 sisu  -D  --recreate

 destroys  existing

 database  and  builds  a  new  empty  database  structure

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.

METADATA

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)= 5f9ca1acb186a64f8e924876892dc25e

Skin_Digest: MD5(/home/ralph/grotto/theatre/dbld/builds/sisu/sisu/data/doc/sisu/sisu_markup_samples/sisu_manual/_sisu/skin/doc/skin_sisu_manual.rb)=

20fc43cf3eb6590bc3399a1aef65c5a9

Generated

Document (metaverse) last generated: Wed Sep 26 08:59:00 +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: Wed Sep 26 08:59:04 +0100 2007

* SiSU http://www.jus.uio.no/sisu