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 OPTD-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 optd_por_public.csv, for which the
38       latest version may be found in the OpenTravelData project on GitHub:
39       https://github.com/opentraveldata/opentraveldata/tree/master/opentraveldata
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-2019 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.7                  Sat Aug 1 2020               opentrep-dbmgr(1)
Impressum