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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
|
<!-- manual page source format generated by PolyglotMan v3.2, -->
<!-- available at http://polyglotman.sourceforge.net/ -->
<html>
<head>
<title>"sisu_postgresql"("1") manual page</title>
</head>
<body bgcolor='white'>
<a href='#toc'>Table of Contents</a><p>
SISU - SISU INFORMATION STRUCTURING UNIVERSE - SEARCH [0.58], RALPH AMISSAH
<p> SISU SEARCH
<p> SISU POSTGRESQL
<p> 1. POSTGRESQL
<p> 1.1 NAME
<p> <b>SiSU</b> - Structured
information, Serialized Units - a document publishing system, postgresql
<p>dependency package
<p> 1.2 DESCRIPTION
<p> 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 <b>SiSU</b> to populate
a postgresql database, this being part of <b>SiSU</b> - man sisu).
<p> 1.3 SYNOPSIS
<p> sisu -D [instruction] [filename/wildcard if required]<br>
<p> sisu -D --pg --[instruction] [filename/wildcard if required]<br>
<p> 1.4 COMMANDS
<p> 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
<p> <b>-D or --pgsql</b> may
be used interchangeably.
<p> 1.4.1 CREATE AND DESTROY DATABASE
<p>
<dl>
<dt><b> --pgsql --createall</b>
</dt>
<dd> 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
<p> </dd>
<dt><b> sisu -D --createdb</b> </dt>
<dd> creates database where no database
existed before as
<p> </dd>
<dt><b> sisu -D --create</b> </dt>
<dd> creates database tables where no database
tables existed before database tables where no database tables existed
<p> </dd>
<dt><b> sisu -D --Dropall</b> </dt>
<dd> 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
<p> </dd>
<dt><b> sisu -D --recreate</b> </dt>
<dd> destroys existing
<p> database and builds a new empty database structure
<p> </dd>
</dl>
1.4.2 IMPORT AND REMOVE
<p>DOCUMENTS
<p>
<dl>
<dt><b> sisu -D --import -v [filename/wildcard]</b> </dt>
<dd>populates database with
the contents of the file. Imports documents(s) specified to a postgresql
database (at an object level).
<p> </dd>
<dt><b> sisu -D --update -v [filename/wildcard]</b> </dt>
<dd>updates
<p>file contents in database
<p> </dd>
<dt><b> sisu -D --remove -v [filename/wildcard]</b> </dt>
<dd>removes
specified document from postgresql database.
<p> </dd>
</dl>
DOCUMENT INFORMATION (METADATA)
<p> METADATA
<p> Document Manifest @ <<a href='http://www.jus.uio.no/sisu/sisu_manual/sisu_postgresql/sisu_manifest.html'>http://www.jus.uio.no/sisu/sisu_manual/sisu_postgresql/sisu_manifest.html</a>
>
<p> <b>Dublin Core</b> (DC)
<p> <i>DC</i> tags included with this document are provided here.
<p> DC Title: <i>SiSU</i> - SiSU information Structuring Universe - Search [0.58]
<p>
DC Creator: <i>Ralph</i> Amissah
<p> DC Rights: <i>Copyright</i> (C) Ralph Amissah 2007,
part of SiSU documentation, License GPL 3
<p> DC Type: <i>information</i>
<p> DC Date
created: <i>2002-08-28</i>
<p> DC Date issued: <i>2002-08-28</i>
<p> DC Date available: <i>2002-08-28</i>
<p> DC Date modified: <i>2007-09-16</i>
<p> DC Date: <i>2007-09-16</i>
<p> <b>Version Information</b>
<p> Sourcefile: <i>sisu_postgresql.sst</i>
<p> Filetype: <i>SiSU</i> text 0.58
<p> Sourcefile
Digest, MD5(sisu_postgresql.sst)= <i>b81ba44e7946dfaf03d26f0dc5d749ab</i>
<p> Skin_Digest:
MD5(/home/ralph/grotto/theatre/dbld/sisu-dev/sisu/data/doc/sisu/sisu_markup_samples/sisu_manual/_sisu/skin/doc/skin_sisu_manual.rb)=
<p><i>20fc43cf3eb6590bc3399a1aef65c5a9</i>
<p> <b>Generated</b>
<p> Document (metaverse) last
generated: <i>Sun</i> Sep 23 01:14:03 +0100 2007
<p> Generated by: <i>SiSU</i> <i>0.58.3</i> of
2007w36/4 (2007-09-06)
<p> Ruby version: <i>ruby</i> 1.8.6 (2007-06-07 patchlevel 36)
[i486-linux]
<p>
<p>
<dl>
<dt>Other versions of this document: </dt>
<dd></dd>
<dt>manifest: <<a href='http://www.jus.uio.no/sisu/sisu_postgresql/sisu_manifest.html'><a href='http://www.jus.uio.no/sisu/sisu_postgresql/sisu_manifest.html'>http://www.jus.uio.no/sisu/sisu_postgresql/sisu_manifest.html</a>
</a>
>
</dt>
<dd></dd>
<dt>html: <<a href='http://www.jus.uio.no/sisu/sisu_postgresql/toc.html'><a href='http://www.jus.uio.no/sisu/sisu_postgresql/toc.html'>http://www.jus.uio.no/sisu/sisu_postgresql/toc.html</a>
</a>
> </dt>
<dd></dd>
<dt>pdf: <<a href='http://www.jus.uio.no/sisu/sisu_postgresql/portrait.pdf'><a href='http://www.jus.uio.no/sisu/sisu_postgresql/portrait.pdf'>http://www.jus.uio.no/sisu/sisu_postgresql/portrait.pdf</a>
</a>
>
</dt>
<dd></dd>
<dt>pdf: <<a href='http://www.jus.uio.no/sisu/sisu_postgresql/landscape.pdf'><a href='http://www.jus.uio.no/sisu/sisu_postgresql/landscape.pdf'>http://www.jus.uio.no/sisu/sisu_postgresql/landscape.pdf</a>
</a>
> </dt>
<dd> </dd>
<dt>at: <<a href='http://www.jus.uio.no/sisu'><a href='http://www.jus.uio.no/sisu'>http://www.jus.uio.no/sisu</a>
</a>
>
</dt>
<dd></dd>
<dt>* Generated by: SiSU 0.58.3 of 2007w36/4 (2007-09-06) </dt>
<dd></dd>
<dt>* Ruby version: ruby
1.8.6 (2007-06-07 patchlevel 36) [i486-linux] </dt>
<dd></dd>
<dt>* Last Generated on: Sun Sep 23
01:14:07 +0100 2007 </dt>
<dd></dd>
<dt>* SiSU <a href='http://www.jus.uio.no/sisu'>http://www.jus.uio.no/sisu</a>
</dt>
<dd></dd>
</dl>
<p>
</body>
</html>
|
