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
|
#include <grass/gis.h>
#include <grass/dbmi.h>
#include "local_proto.h"
#include <grass/glocale.h>
int print_table_definition(dbDriver *driver, dbTable *table)
{
int ncols, col, nrows;
dbColumn *column;
char buf[1024];
dbString stmt;
fprintf(stdout, "table:%s\n", db_get_table_name(table));
fprintf(stdout, "description:%s\n", db_get_table_description(table));
print_priv("insert", db_get_table_insert_priv(table));
print_priv("delete", db_get_table_delete_priv(table));
ncols = db_get_table_number_of_columns(table);
db_init_string(&stmt);
sprintf(buf, "select * from %s", db_get_table_name(table));
db_set_string(&stmt, buf);
nrows = db_get_table_number_of_rows(driver, &stmt);
fprintf(stdout, "ncols:%d\n", ncols);
fprintf(stdout, "nrows:%d\n", nrows);
for (col = 0; col < ncols; col++) {
column = db_get_table_column(table, col);
fprintf(stdout, "\n");
print_column_definition(column);
}
return 0;
}
int print_column_definition(dbColumn *column)
{
dbString value_string;
fprintf(stdout, "column:%s\n", db_get_column_name(column));
fprintf(stdout, "description:%s\n", db_get_column_description(column));
fprintf(stdout, "type:%s\n",
db_sqltype_name(db_get_column_sqltype(column)));
fprintf(stdout, "len:%d\n", db_get_column_length(column));
fprintf(stdout, "scale:%d\n", db_get_column_scale(column));
fprintf(stdout, "precision:%d\n", db_get_column_precision(column));
fprintf(stdout, "default:");
if (db_test_column_has_default_value(column)) {
db_init_string(&value_string);
db_convert_column_default_value_to_string(column, &value_string);
fprintf(stdout, "%s", db_get_string(&value_string));
}
fprintf(stdout, "\n");
fprintf(stdout, "nullok:%s\n",
db_test_column_null_allowed(column) ? "yes" : "no");
print_priv("select", db_get_column_select_priv(column));
print_priv("update", db_get_column_update_priv(column));
return 0;
}
int print_priv(char *label, int priv)
{
fprintf(stdout, "%s:", label);
switch (priv) {
case DB_GRANTED:
fprintf(stdout, "yes");
break;
case DB_NOT_GRANTED:
fprintf(stdout, "no");
break;
default:
fprintf(stdout, "?");
break;
}
fprintf(stdout, "\n");
return 0;
}
|
