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
|
#include "gis.h"
#include "dbmi.h"
#include "glocale.h"
int print_priv ();
int print_column_definition(dbColumn *);
int
print_table_definition(table)
dbTable *table;
{
int ncols, col;
dbColumn *column;
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);
fprintf(stdout, "ncols:%d\n", ncols);
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(column)
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 (label, priv)
char *label;
{
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;
}
|
