GRASS Programmer's Manual
6.4.2(2012)
|
00001 00015 #include <string.h> 00016 #include <grass/dbmi.h> 00017 00018 static void print_priv(); 00019 00026 void db_print_table_definition(FILE * fd, dbTable * table) 00027 { 00028 int ncols, col; 00029 dbColumn *column; 00030 00031 fprintf(fd, "table:%s\n", db_get_table_name(table)); 00032 fprintf(fd, "description:%s\n", db_get_table_description(table)); 00033 print_priv(fd, "insert", db_get_table_insert_priv(table)); 00034 print_priv(fd, "delete", db_get_table_delete_priv(table)); 00035 00036 ncols = db_get_table_number_of_columns(table); 00037 fprintf(fd, "ncols:%d\n", ncols); 00038 for (col = 0; col < ncols; col++) { 00039 column = db_get_table_column(table, col); 00040 fprintf(fd, "\n"); 00041 db_print_column_definition(fd, column); 00042 } 00043 } 00044 00051 void db_print_column_definition(FILE * fd, dbColumn * column) 00052 { 00053 dbString value_string; 00054 00055 fprintf(fd, "column:%s\n", db_get_column_name(column)); 00056 fprintf(fd, "description:%s\n", db_get_column_description(column)); 00057 fprintf(fd, "type:%s\n", db_sqltype_name(db_get_column_sqltype(column))); 00058 fprintf(fd, "len:%d\n", db_get_column_length(column)); 00059 fprintf(fd, "scale:%d\n", db_get_column_scale(column)); 00060 fprintf(fd, "precision:%d\n", db_get_column_precision(column)); 00061 fprintf(fd, "default:"); 00062 if (db_test_column_has_default_value(column)) { 00063 db_init_string(&value_string); 00064 db_convert_column_default_value_to_string(column, &value_string); 00065 fprintf(fd, "%s", db_get_string(&value_string)); 00066 } 00067 fprintf(fd, "\n"); 00068 fprintf(fd, "nullok:%s\n", 00069 db_test_column_null_allowed(column) ? "yes" : "no"); 00070 print_priv(fd, "select", db_get_column_select_priv(column)); 00071 print_priv(fd, "update", db_get_column_update_priv(column)); 00072 } 00073 00074 static void print_priv(FILE * fd, char *label, int priv) 00075 { 00076 fprintf(fd, "%s:", label); 00077 switch (priv) { 00078 case DB_GRANTED: 00079 fprintf(fd, "yes"); 00080 break; 00081 case DB_NOT_GRANTED: 00082 fprintf(fd, "no"); 00083 break; 00084 default: 00085 fprintf(fd, "?"); 00086 break; 00087 } 00088 fprintf(fd, "\n"); 00089 }