2
/****************************************************************************
5
* AUTHOR(S): Radim Blazek <radim.blazek gmail.com> (original contributor)
6
* Glynn Clements <glynn gclements.plus.com>, Markus Neteler <neteler itc.it>
7
* PURPOSE: list the column names for a table
8
* COPYRIGHT: (C) 2002-2006 by the GRASS Development Team
10
* This program is free software under the GNU General Public
11
* License (>=v2). Read the file COPYING that comes with GRASS
14
*****************************************************************************/
18
#include <grass/gis.h>
19
#include <grass/dbmi.h>
20
#include <grass/glocale.h>
25
char *driver, *database, *table;
29
/* function prototypes */
30
static void parse_command_line(int, char **);
33
int main(int argc, char **argv)
41
parse_command_line(argc, argv);
43
if (!db_table_exists(parms.driver, parms.database, parms.table)) {
44
G_warning(_("Table <%s> not found in database <%s> using driver <%s>"),
45
parms.table, parms.database, parms.driver);
49
driver = db_start_driver(parms.driver);
51
G_fatal_error(_("Unable to start driver <%s>"), parms.driver);
53
db_init_handle(&handle);
54
db_set_handle(&handle, parms.database, NULL);
55
if (db_open_database(driver, &handle) != DB_OK)
56
G_fatal_error(_("Unable to open database <%s>"), parms.database);
57
db_set_error_handler_driver(driver);
59
db_init_string(&table_name);
60
db_set_string(&table_name, parms.table);
61
if (db_describe_table(driver, &table_name, &table) != DB_OK)
62
G_fatal_error(_("Unable to describe table <%s>"), parms.table);
64
db_close_database(driver);
65
db_shutdown_driver(driver);
67
ncols = db_get_table_number_of_columns(table);
68
for (col = 0; col < ncols; col++)
69
fprintf(stdout, "%s\n",
70
db_get_column_name(db_get_table_column(table, col)));
76
static void parse_command_line(int argc, char **argv)
78
struct Option *driver, *database, *table;
79
struct GModule *module;
82
/* Initialize the GIS calls */
85
table = G_define_standard_option(G_OPT_DB_TABLE);
86
table->required = YES;
88
driver = G_define_standard_option(G_OPT_DB_DRIVER);
89
driver->options = db_list_drivers();
90
if ((drv = db_get_default_driver_name()))
91
driver->answer = (char *) drv;
93
database = G_define_standard_option(G_OPT_DB_DATABASE);
94
if ((db = db_get_default_database_name()))
95
database->answer = (char *) db;
98
module = G_define_module();
99
G_add_keyword(_("database"));
100
G_add_keyword(_("attribute table"));
101
module->description = _("List all columns for a given table.");
103
if (G_parser(argc, argv))
106
parms.driver = driver->answer;
107
parms.database = database->answer;
108
parms.table = table->answer;