GRASS Programmer's Manual 6.4.1(2011)
printtab.c
Go to the documentation of this file.
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 }
 All Data Structures Files Functions Variables Typedefs Enumerations Enumerator Defines