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
|
<!-- manual page source format generated by PolyglotMan v3.2, -->
<!-- available at http://polyglotman.sourceforge.net/ -->
<html>
<head>
<title>"sisu_sqlite"("1") manual page</title>
</head>
<body bgcolor='white'>
<a href='#toc'>Table of Contents</a><p>
SISU - SEARCH, RALPH AMISSAH
<p> SISU SEARCH
<p> SISU SQLITE
<p> 1. SQLITE
<p> 1.1
<p>NAME
<p> <b>SiSU</b> - Structured information, Serialized Units - a document publishing
system.
<p> 1.2 DESCRIPTION
<p> Information related to using sqlite with sisu
(and related to the sisu_sqlite dependency package, which is a dummy package
to install dependencies needed for <b>SiSU</b> to populate an sqlite 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 --(sqlite|pg) --[instruction] [filename/wildcard if <br>
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 --sqlite</b> may
be used interchangeably.
<p> 1.4.1 CREATE AND DESTROY DATABASE
<p>
<dl>
<dt><b> --sqlite --createall</b>
</dt>
<dd> initial step, creates required relations (tables, indexes) in existing
(sqlite) database (a database should be created 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
<p> existing database and builds a new empty database structure
<p> </dd>
</dl>
1.4.2 IMPORT
<p>AND REMOVE 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 an sqlite
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 sqlite database.
<p> </dd>
</dl>
DOCUMENT INFORMATION (METADATA)
<p> METADATA
<p> Document Manifest @ <<a href='http://sisudoc.org/sisu_manual/sisu_sqlite/sisu_manifest.html'>http://sisudoc.org/sisu_manual/sisu_sqlite/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> - Search
<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_sqlite.sst</i>
<p> Filetype: <i>SiSU</i> text
<p>0.58
<p> Sourcefile Digest, MD5(sisu_sqlite.sst)= <i>2ffb869c7c41615ca4ec83d8bd70470d</i>
<p> 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)=
<p><i>20fc43cf3eb6590bc3399a1aef65c5a9</i>
<p> <b>Generated</b>
<p> Document (metaverse) last
generated: <i>Wed</i> Sep 26 08:59:00 +0100 2007
<p> Generated by: <i>SiSU</i> <i>0.59.1</i> of
2007w39/2 (2007-09-25)
<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_sqlite/sisu_manifest.html'><a href='http://www.jus.uio.no/sisu/sisu_sqlite/sisu_manifest.html'>http://www.jus.uio.no/sisu/sisu_sqlite/sisu_manifest.html</a>
</a>
>
</dt>
<dd></dd>
<dt>html: <<a href='http://www.jus.uio.no/sisu/sisu_sqlite/toc.html'><a href='http://www.jus.uio.no/sisu/sisu_sqlite/toc.html'>http://www.jus.uio.no/sisu/sisu_sqlite/toc.html</a>
</a>
> </dt>
<dd></dd>
<dt>pdf: <<a href='http://www.jus.uio.no/sisu/sisu_sqlite/portrait.pdf'><a href='http://www.jus.uio.no/sisu/sisu_sqlite/portrait.pdf'>http://www.jus.uio.no/sisu/sisu_sqlite/portrait.pdf</a>
</a>
>
</dt>
<dd></dd>
<dt>pdf: <<a href='http://www.jus.uio.no/sisu/sisu_sqlite/landscape.pdf'><a href='http://www.jus.uio.no/sisu/sisu_sqlite/landscape.pdf'>http://www.jus.uio.no/sisu/sisu_sqlite/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.59.1 of 2007w39/2 (2007-09-25) </dt>
<dd></dd>
<dt>* Ruby version: ruby
1.8.6 (2007-06-07 patchlevel 36) [i486-linux] </dt>
<dd></dd>
<dt>* Last Generated on: Wed Sep 26
08:59:05 +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>
|