[lsc-changes] [Ldap Synchronization...] page added: documentation:howto:hsqldb

[webmaster]

A page in your DokuWiki was added or changed. Here are the details:

Date : 2014/03/04 16:56
Browser : Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:27.0) Gecko/20100101 Firefox/27.0
IP-Address : 88.173.78.196
Hostname : mne69-10-88-173-78-196.fbx.proxad.net
Old Revision: none
New Revision: http://lsc-project.org/wiki/documentation/howto/hsqldb
Edit Summary: created
User : coudot

====== HSQLDB ======

LSC provides HSLQDB library and a utility script that allow to use this database to store temporary synchronization data, for example to use a CSV file as a source.

===== Script location =====

LSC provides a wrapper to manage the packaged HSQLDB database, it is located in the LSC bin directory and is named ''hsqldb''.

You can execute it to see the possible options:
<code bash>
$ bin/hsqldb

bin/hsqldb [<option>]

One option from available options is:
--import <file> [<table>] [<separator>] Import data from CSV file
--drop [<table>] Drop data
--show [<table>] Show data from database
--start Start the server
--stop Stop the server
--status Display server status
--help Print informations
</code>

===== Start/stop HSQLDB =====

Start HSQLB will the following command:
<code bash>
$ bin/hsqldb --start
</code>

You can then check the status:
<code bash>
$ bin/hsqldb --status
HSQLDB Server is running (PID 7020)
</code>

To stop it:
<code bash>
$ bin/hsqldb --stop
</code>

<note important>If you stop HSQLDB, all registered data will be lost.</note>

===== Import CSV data =====

By default, your HSQLDB database is empty. You can load the data with this command:
<code bash>
$ bin/hsqldb --import tutorial.csv
1 lines imported into table csvdata
</code>

<note tip>By default, data are loaded in table ''csvdata'' but you can change the table name, for example:
<code bash>
$ bin/hsqldb --import tutorial.csv tutorial
1 lines imported into table tutorial
</code>
</note>

You can then display imported data:
<code bash>
$ bin/hsqldb --show
UID SN GIVENNAME CN MAIL
---- --- --------- -------- ----------------
jdoe Doe John John Doe jdoe at example.com
</code>

<note tip>You can specify the table name after the ''--show'' option.</note>

===== Remove data =====

You can remove data by dropping a table:
<code bash>
$ bin/hsqldb --drop
</code>

<note tip>You can specify the table name after the ''--drop'' option.</note>