1 /*!
2 * \file db/dbmi_client/delete_tab.c
3 *
4 * \brief DBMI Library (client) - delete table
5 *
6 * (C) 1999-2008 by the GRASS Development Team
7 *
8 * This program is free software under the GNU General Public
9 * License (>=v2). Read the file COPYING that comes with GRASS
10 * for details.
11 *
12 * \author Joel Jones (CERL/UIUC), Radim Blazek
13 */
14
15 #include <grass/dbmi.h>
16 #include <grass/glocale.h>
17 #include "macros.h"
18
19 /*!
20 \brief Delete table
21
22 \param drvname driver name
23 \param dbname database name
24 \param tblname table name
25
26 \return DB_OK on success
27 \return DB_FAILED on failure
28 */
db_delete_table(const char * drvname,const char * dbname,const char * tblname)29 int db_delete_table(const char *drvname, const char *dbname, const char *tblname)
30 {
31 dbDriver *driver;
32 dbString sql;
33
34 G_debug(3, "db_delete_table(): driver = %s, db = %s, table = %s\n",
35 drvname, dbname, tblname);
36
37 /* Open driver and database */
38 driver = db_start_driver_open_database(drvname, dbname);
39 if (driver == NULL) {
40 G_warning(_("Unable open database <%s> by driver <%s>"), dbname,
41 drvname);
42 return DB_FAILED;
43 }
44
45 /* Delete table */
46 /* TODO test if the tables exist */
47 db_init_string(&sql);
48 db_set_string(&sql, "drop table ");
49 db_append_string(&sql, tblname);
50 G_debug(3, "%s", db_get_string(&sql));
51
52 if (db_execute_immediate(driver, &sql) != DB_OK) {
53 G_warning(_("Unable to drop table: '%s'"),
54 db_get_string(&sql));
55 db_close_database_shutdown_driver(driver);
56 return DB_FAILED;
57 }
58
59 db_close_database_shutdown_driver(driver);
60
61 return DB_OK;
62 }
63