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
|
/**************************************************************
* db.tables driver=name database=name
*
*
* list all tables in a database
****************************************************************/
#include <stdlib.h>
#include "gis.h"
#include "dbmi.h"
#include "codes.h"
#include "glocale.h"
struct {
char *driver, *database;
int s;
} parms;
void parse_command_line();
int
main(int argc, char *argv[])
{
dbDriver *driver;
dbHandle handle;
dbString *names;
int i, count;
int system_tables;
parse_command_line (argc, argv);
driver = db_start_driver(parms.driver);
if (driver == NULL)
G_fatal_error(_("No db connection for driver <%s> defined. Run db.connect"), parms.driver);
db_init_handle (&handle);
db_set_handle (&handle, parms.database, NULL);
if (db_open_database(driver, &handle) != DB_OK)
exit(ERROR);
system_tables = parms.s;
if(db_list_tables (driver, &names, &count, system_tables) != DB_OK)
exit(ERROR);
for (i = 0; i < count; i++)
fprintf(stdout, "%s\n", db_get_string (&names[i]));
db_close_database(driver);
db_shutdown_driver(driver);
exit(OK);
}
void
parse_command_line(int argc, char *argv[])
{
struct Option *driver, *database;
struct Flag *p, *s;
struct GModule *module;
char *drv, *db;
/* Initialize the GIS calls */
G_gisinit(argv[0]) ;
driver = G_define_option();
driver->key = "driver";
driver->type = TYPE_STRING;
driver->options = db_list_drivers();
driver->required = NO;
driver->description = _("driver name");
if ( (drv=db_get_default_driver_name()) )
driver->answer = drv;
database = G_define_option();
database->key = "database";
database->type = TYPE_STRING;
database->required = NO;
database->description = _("database name");
if ( (db=db_get_default_database_name()) )
database->answer = db;
p = G_define_flag();
p->key = 'p';
p->description = _("print tables and exit");
s = G_define_flag();
s->key = 's';
s->description = _("system tables instead of user tables");
/* Set description */
module = G_define_module();
module->description = _("List all tables for a given database.");
if(G_parser(argc, argv))
exit(ERROR);
parms.driver = driver->answer;
parms.database = database->answer;
parms.s = s->answer;
}
|
