summaryrefslogtreecommitdiffstats
path: root/data/doc/sisu/markup-samples/v3/sisu_manual/sisu_postgresql.sst
blob: 7987296daba06cb8b634b32b68b13b7cf42d3de6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
% SiSU 2.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: 2011-02-07

@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;
 :type: information
 :subject: ebook, epublishing, electronic book, electronic publishing, electronic document, electronic citation, data structure, citation systems, search

@links:
 { SiSU Homepage }http://www.sisudoc.org/
 { SiSU Manual }http://www.sisudoc.org/sisu/sisu_manual/
 { Book Samples & Markup Examples }http://www.jus.uio.no/sisu/SiSU/examples.html
 { SiSU Download }http://www.jus.uio.no/sisu/SiSU/download.html
 { SiSU Changelog }http://www.jus.uio.no/sisu/SiSU/changelog.html
 { SiSU Git repo }http://git.sisudoc.org/?p=code/sisu.git;a=summary
 { SiSU List Archives }http://lists.sisudoc.org/pipermail/sisu/
 { SiSU @ Debian }http://packages.qa.debian.org/s/sisu.html
 { SiSU Project @ Debian }http://qa.debian.org/developer.php?login=sisu@lists.sisudoc.org
 { SiSU @ Wikipedia }http://en.wikipedia.org/wiki/SiSU

@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]

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