<?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: Mon Sep 24 15:34:56 +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 - Search
</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 - Search,<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>