aboutsummaryrefslogtreecommitdiffhomepage
path: root/data/doc/manuals_generated/sisu_manual/sisu_postgresql/scroll.xhtml
blob: a8f730de8df8ccc180a4a76c00da1ccb366935c6 (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
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
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/css" href="../_sisu/css/xhtml.css"?>
<!-- Document processing information:
     * Generated by: SiSU 0.59.0 of 2007w38/0 (2007-09-23)
     * Ruby version: ruby 1.8.6 (2007-06-07 patchlevel 36) [i486-linux]
     * 
     * Last Generated on: Sun Sep 23 04:12:21 +0100 2007
     * SiSU http://www.jus.uio.no/sisu
-->

<document>
<head>
	<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
	<meta>Title:</meta>
	<title class="dc">
		SiSU - SiSU information Structuring Universe - Search [0.58]
	</title>
	<br />
	<meta>Creator:</meta>
	<creator class="dc">
		Ralph Amissah
	</creator>
	<br />
	<meta>Rights:</meta>
	<rights class="dc">
		Copyright (C) Ralph Amissah 2007, part of SiSU documentation, License GPL 3
	</rights>
	<br />
	<meta>Type:</meta>
	<type class="dc">
		information
	</type>
	<br />
	<meta>Subject:</meta>
	<subject class="dc">
		ebook, epublishing, electronic book, electronic publishing, electronic document, electronic citation, data structure, citation systems, search
	</subject>
	<br />
	<meta>Date created:</meta>
	<date_created class="extra">
		2002-08-28
	</date_created>
	<br />
	<meta>Date issued:</meta>
	<date_issued class="extra">
		2002-08-28
	</date_issued>
	<br />
	<meta>Date available:</meta>
	<date_available class="extra">
		2002-08-28
	</date_available>
	<br />
	<meta>Date modified:</meta>
	<date_modified class="extra">
		2007-09-16
	</date_modified>
	<br />
	<meta>Date:</meta>
	<date class="dc">
		2007-09-16
	</date>
	<br />
</head>
<body>
<object id="1">
	<text class="h1">
		SiSU - SiSU information Structuring Universe - Search [0.58],<br />
Ralph Amissah
	</text>
	<ocn>1</ocn>
</object>
<object id="2">
	<text class="h2">
		SiSU Search
	</text>
	<ocn>2</ocn>
</object>
<object id="3">
	<text class="h3">
		SiSU Postgresql
	</text>
	<ocn>3</ocn>
</object>
<object id="4">
	<text class="h4">
		1. Postgresql 
	</text>
	<ocn>4</ocn>
</object>
<object id="5">
	<text class="h5">
		1.1 Name
	</text>
	<ocn>5</ocn>
</object>
<object id="6">
	<text class="norm">
		<b>SiSU</b> - Structured information, Serialized Units - a document
publishing system, postgresql dependency package
	</text>
	<ocn>6</ocn>
</object>
<object id="7">
	<text class="h5">
		1.2 Description
	</text>
	<ocn>7</ocn>
</object>
<object id="8">
	<text class="norm">
		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).
	</text>
	<ocn>8</ocn>
</object>
<object id="9">
	<text class="h5">
		1.3 Synopsis
	</text>
	<ocn>9</ocn>
</object>
<object id="10">
	<text class="indent1">
		 sisu -D [instruction] [filename/wildcard if required]
	</text>
	<ocn>10</ocn>
</object>
<object id="11">
	<text class="indent1">
		 sisu -D --pg --[instruction] [filename/wildcard if required]
	</text>
	<ocn>11</ocn>
</object>
<object id="12">
	<text class="h5">
		1.4 Commands
	</text>
	<ocn>12</ocn>
</object>
<object id="13">
	<text class="norm">
		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
	</text>
	<ocn>13</ocn>
</object>
<object id="14">
	<text class="norm">
		<b>-D or --pgsql</b> may be used interchangeably.
	</text>
	<ocn>14</ocn>
</object>
<object id="15">
	<text class="h6">
		1.4.1 create and destroy database
	</text>
	<ocn>15</ocn>
</object>
<object id="16">
	<text class="norm">
		<b>--pgsql --createall</b><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)
	</text>
	<ocn>16</ocn>
</object>
<object id="17">
	<text class="norm">
		<b>sisu -D --createdb</b><br /> creates database where no database
existed before
	</text>
	<ocn>17</ocn>
</object>
<object id="18">
	<text class="norm">
		<b>sisu -D --create</b><br /> creates database tables where no database
tables existed before
	</text>
	<ocn>18</ocn>
</object>
<object id="19">
	<text class="norm">
		<b>sisu -D --Dropall</b><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).
	</text>
	<ocn>19</ocn>
</object>
<object id="20">
	<text class="norm">
		<b>sisu -D --recreate</b><br /> destroys existing database and builds a
new empty database structure
	</text>
	<ocn>20</ocn>
</object>
<object id="21">
	<text class="h6">
		1.4.2 import and remove documents
	</text>
	<ocn>21</ocn>
</object>
<object id="22">
	<text class="norm">
		<b>sisu -D --import -v [filename/wildcard]</b><br /> populates database
with the contents of the file. Imports documents(s) specified to a
postgresql database (at an object level).
	</text>
	<ocn>22</ocn>
</object>
<object id="23">
	<text class="norm">
		<b>sisu -D --update -v [filename/wildcard]</b><br /> updates file
contents in database
	</text>
	<ocn>23</ocn>
</object>
<object id="24">
	<text class="norm">
		<b>sisu -D --remove -v [filename/wildcard]</b><br /> removes specified
document from postgresql database.
	</text>
	<ocn>24</ocn>
</object>
</body>
</document>