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
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
|
/**
* \file create_table.c
*
* \brief Low level SQLite table creation.
*
* This program is free software under the GNU General Public License
* (>=v2). Read the file COPYING that comes with GRASS for details.
*
* \author Radim Blazek
* \author Support for multiple connections by Markus Metz
*
* \date 2005-2011
*/
#include <grass/dbmi.h>
#include <grass/glocale.h>
#include "globals.h"
#include "proto.h"
/**
* \fn int db__driver_create_table (dbTable *table)
*
* \brief SQLite create table.
*
* \param[in] table
* \return int DB_FAILED on error; DB_OK on success
*/
int db__driver_create_table(dbTable *table)
{
int col, ncols;
sqlite3_stmt *statement;
dbString sql;
const char *rest;
int ret;
G_debug(3, "db__driver_create_table()");
db_init_string(&sql);
/* db_table_to_sql ( table, &sql ); */
db_set_string(&sql, "create table ");
db_append_string(&sql, db_get_table_name(table));
db_append_string(&sql, " ( ");
ncols = db_get_table_number_of_columns(table);
for (col = 0; col < ncols; col++) {
dbColumn *column = db_get_table_column(table, col);
const char *colname = db_get_column_name(column);
int sqltype = db_get_column_sqltype(column);
int collen = db_get_column_length(column);
char buf[32];
G_debug(3, "%s (%s)", colname, db_sqltype_name(sqltype));
if (col > 0)
db_append_string(&sql, ", ");
db_append_string(&sql, colname);
db_append_string(&sql, " ");
switch (sqltype) {
case DB_SQL_TYPE_CHARACTER:
sprintf(buf, "varchar(%d)", collen);
db_append_string(&sql, buf);
break;
case DB_SQL_TYPE_SMALLINT:
db_append_string(&sql, "smallint");
break;
case DB_SQL_TYPE_INTEGER:
db_append_string(&sql, "integer");
break;
case DB_SQL_TYPE_REAL:
db_append_string(&sql, "real");
break;
case DB_SQL_TYPE_DOUBLE_PRECISION:
db_append_string(&sql, "double precision");
break;
case DB_SQL_TYPE_DECIMAL:
db_append_string(&sql, "decimal");
break;
case DB_SQL_TYPE_NUMERIC:
db_append_string(&sql, "numeric");
break;
case DB_SQL_TYPE_DATE:
db_append_string(&sql, "date");
break;
case DB_SQL_TYPE_TIME:
db_append_string(&sql, "time");
break;
case DB_SQL_TYPE_TIMESTAMP:
db_append_string(&sql, "timestamp");
break;
case DB_SQL_TYPE_INTERVAL:
db_append_string(&sql, "interval");
break;
case DB_SQL_TYPE_TEXT:
db_append_string(&sql, "text");
break;
case DB_SQL_TYPE_SERIAL:
db_append_string(&sql, "serial");
break;
default:
G_warning("Unknown column type (%s)", colname);
return DB_FAILED;
}
}
db_append_string(&sql, " )");
G_debug(3, " SQL: %s", db_get_string(&sql));
/* SQLITE bug?
* If the database schema has changed, sqlite can prepare a statement,
* but sqlite can not step, the statement needs to be prepared anew again */
while (1) {
ret =
sqlite3_prepare(sqlite, db_get_string(&sql), -1, &statement, &rest);
if (ret != SQLITE_OK) {
db_d_append_error("%s\n%s\n%s", _("Unable to create table:"),
db_get_string(&sql),
(char *)sqlite3_errmsg(sqlite));
db_d_report_error();
sqlite3_finalize(statement);
db_free_string(&sql);
return DB_FAILED;
}
ret = sqlite3_step(statement);
/* get real result code */
ret = sqlite3_reset(statement);
if (ret == SQLITE_SCHEMA) {
sqlite3_finalize(statement);
/* try again */
}
else if (ret != SQLITE_OK) {
db_d_append_error("%s\n%s", _("Error in sqlite3_step():"),
(char *)sqlite3_errmsg(sqlite));
db_d_report_error();
sqlite3_finalize(statement);
return DB_FAILED;
}
else
break;
}
sqlite3_finalize(statement);
db_free_string(&sql);
return DB_OK;
}
|
