1opentrep-dbmgr(1)                  OpenTREP                  opentrep-dbmgr(1)
2
3
4

NAME

6       opentrep-dbmgrInteractive command-line utility to manage the SQL
7       database (SQLite3 or MySQL)
8

SYNOPSIS

10       opentrep-dbmgr [--prefix] [-v|--version] [-h|--help] [-p|--porfile
11       <POR-file-path>] [-d|--xapiandb <Xapian-travel-database-path>]
12       [-t|--sqldbtype <SQL-database-type>] [-s|--sqldbconx <SQL-database-
13       connection-string>] [-l|--log <path-to-output-log-file>]
14

DESCRIPTION

16       opentrep-dbmgr is a small program to manage the relational (SQL)
17       database. For now, only SQLite3 and MariaDB/MySQL databases are
18       supported. The file with the list of the ORI-maintained POR (points of
19       reference) may be parsed, and the corresponding content inserted into
20       the SQL database. At the prompt, launch the 'help' or 'tutorial'
21       command to heva more details.
22
23       opentrep-dbmgr accepts the following options:
24
25       --prefix
26        Show the Opentrep installation prefix.
27
28       -v, --version
29        Print the currently installed version of Opentrep on the standard
30       output.
31
32       -h, --help
33        Produce that message and show usage.
34
35       -p, --porfile <POR-file-path>
36        Path (directory and file name) of the file of POR (points of
37       reference). Usually, the file is ori_por_public.csv, for which the
38       latest version may be found in the OpenTravelData project on GitHub:
39       http://github.com/opentraveldata/optd/tree/trunk/refdata/ORI
40
41       -d, --xapiandb <Xapian-travel-database-path>
42        Path (directory) to the Xapian travel database. The indexer creates,
43       or overwrites it when it already exists, the Xapian database. It
44       materialises as a collection of data files within a directory usually
45       named 'traveldb'.
46
47       -t, --sqldbtype <SQL-database-type>
48        SQL database type, e.g., nosql (no SQL database), sqlite, mysql
49
50       -s, --sqldbconx <SQL-database-connection-string>
51        SQL database connection string, e.g., ~/tmp/opentrep/sqlite_travel.db
52       (for SQLite3), 'db=trep_trep user=trep password=trep' (for MySQL)
53
54       -l, --log <path-to-output-log-file>
55        Path (absolute or relative) of the output log file.
56
57       See the output of the `opentrep-dbmgr --help' command for default
58       options.
59
60       Once the program is launched, just type the 'help' command to get the
61       full list of all the possible commands and their parameters. Note that
62       that program features the auto-completion of commands.
63

EXAMPLES

65       With SQLite3
66        opentrep-dbmgr -t sqlite -s /tmp/opentrep/sqlite_travel.db
67
68       With MySQL
69        opentrep-dbmgr -t mysql -s 'db=trep_trep user=trep password=trep'
70

SEE ALSO

72       opentrep-indexer(1), opentrep-searcher(1), opentrep-config(1),
73       opentrep-library(3)
74

SUPPORT

76       Please report any bugs to http://github.com/trep/opentrep/issues
77

79       Copyright © 2009-2016 Denis Arnaud
80
81       See the COPYING file for more information on the (LGPLv2+) license, or
82       directly on Internet:
83        http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html
84
85
86
87Version 0.07.1                  Sat Feb 23 2019              opentrep-dbmgr(1)
Impressum