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
|
/****************************************************************************
*
* MODULE: db.databases
* AUTHOR(S): Radim Blazek <radim.blazek gmail.com> (original contributor)
* Glynn Clements <glynn gclements.plus.com>,
* Markus Neteler <neteler itc.it>
* PURPOSE: lists all databases for a given driver
* COPYRIGHT: (C) 2002-2006, 2012 by the GRASS Development Team
*
* This program is free software under the GNU General
* Public License (>=v2). Read the file COPYING that
* comes with GRASS for details.
*
*****************************************************************************/
#include <stdlib.h>
#include <grass/dbmi.h>
#include <grass/gis.h>
#include <grass/glocale.h>
struct {
char *driver;
char *location;
} parms;
/* function prototypes */
static void parse_command_line(int, char **);
int main(int argc, char **argv)
{
dbDriver *driver;
dbHandle *handles;
dbString locations;
int nlocs = 0;
int count, i;
db_init_string(&locations);
parse_command_line(argc, argv);
if (parms.location) {
db_set_string(&locations, parms.location);
nlocs = 1;
}
driver = db_start_driver(parms.driver);
if (driver == NULL)
G_fatal_error(_("Unable to start driver <%s>"), parms.driver);
if (db_list_databases(driver, &locations, nlocs, &handles, &count) !=
DB_OK) {
db_shutdown_driver(driver);
G_fatal_error(
_("Unable to list databases. "
"Try to define correct connection settings by db.login."));
}
db_shutdown_driver(driver);
for (i = 0; i < count; i++) {
fprintf(stdout, "%s\n", db_get_handle_dbname(&handles[i]));
}
if (count < 1)
G_important_message(_("No databases found"));
exit(EXIT_SUCCESS);
}
static void parse_command_line(int argc, char **argv)
{
struct Option *driver, *location;
struct GModule *module;
/* Initialize the GIS calls */
G_gisinit(argv[0]);
driver = G_define_standard_option(G_OPT_DB_DRIVER);
driver->options = db_list_drivers();
driver->answer = (char *)db_get_default_driver_name();
driver->guisection = _("Connection");
location = G_define_option();
location->key = "location";
location->type = TYPE_STRING;
location->required = NO;
/* location->multiple = YES; ? */
location->label = _("Location");
location->description = _("Path for SQLite driver, or connection string "
"for PostgreSQL driver");
location->key_desc = "name";
location->guisection = _("Connection");
/* Set description */
module = G_define_module();
G_add_keyword(_("database"));
G_add_keyword(_("attribute table"));
G_add_keyword(_("SQL"));
module->description =
_("Lists all databases for a given driver and location.");
if (G_parser(argc, argv))
exit(EXIT_FAILURE);
parms.driver = driver->answer;
parms.location = location->answer ? location->answer : "";
}
|
