GRASS GIS 8 Programmer's Manual
8.2.2dev(2023)-3d2c704037
|
DBMI Library (base) - table management. More...
Go to the source code of this file.
Functions | |
dbTable * | db_alloc_table (int ncols) |
Allocate a table with a specific number of columns. More... | |
void | db_init_table (dbTable *table) |
Initialize the table to zero. More... | |
void | db_free_table (dbTable *table) |
Free the table. More... | |
int | db_set_table_name (dbTable *table, const char *name) |
Set the name of the table. More... | |
const char * | db_get_table_name (dbTable *table) |
Get the name of the table. More... | |
int | db_set_table_description (dbTable *table, const char *description) |
Set the description of the table. More... | |
const char * | db_get_table_description (dbTable *table) |
Get the description of the table. More... | |
int | db_get_table_number_of_columns (dbTable *table) |
Return the number of columns of the table. More... | |
void | db_set_table_select_priv_granted (dbTable *table) |
Grant selection privileges for all columns. More... | |
void | db_set_table_select_priv_not_granted (dbTable *table) |
Set selection privileges not granted for all columns. More... | |
int | db_get_table_select_priv (dbTable *table) |
Get table select privileges. More... | |
void | db_set_table_update_priv_granted (dbTable *table) |
Grant update privileges for all columns. More... | |
void | db_set_table_update_priv_not_granted (dbTable *table) |
Set update privileges not granted for all columns. More... | |
int | db_get_table_update_priv (dbTable *table) |
Get table update privileges. More... | |
void | db_set_table_insert_priv_granted (dbTable *table) |
Grant insert privileges for table. More... | |
void | db_set_table_insert_priv_not_granted (dbTable *table) |
Set insert privileges not granted for table. More... | |
int | db_get_table_insert_priv (dbTable *table) |
Get table insert privileges. More... | |
void | db_set_table_delete_priv_granted (dbTable *table) |
Grant delete privileges for table. More... | |
void | db_set_table_delete_priv_not_granted (dbTable *table) |
Set delete privileges not granted for table. More... | |
int | db_get_table_delete_priv (dbTable *table) |
Get table delete privileges. More... | |
dbColumn * | db_get_table_column (dbTable *table, int idx) |
Returns column structure for given table and column number. More... | |
dbColumn * | db_get_table_column_by_name (dbTable *table, const char *name) |
Returns column structure for given table and column name. More... | |
int | db_set_table_column (dbTable *table, int idx, dbColumn *column) |
Set a specific column for given table and column number. More... | |
int | db_append_table_column (dbTable *table, dbColumn *column) |
Append a specific column to given table. More... | |
dbTable * | db_clone_table (dbTable *src) |
Make a new exact copy of an existing table. More... | |
int | db_table_to_sql (dbTable *table, dbString *sql) |
Create SQL CREATE sring from table definition. More... | |
DBMI Library (base) - table management.
(C) 1999-2009, 2011 by the GRASS Development Team
This program is free software under the GNU General Public License (>=v2). Read the file COPYING that comes with GRASS for details.
Definition in file dbmi_base/table.c.
dbTable* db_alloc_table | ( | int | ncols | ) |
Allocate a table with a specific number of columns.
ncols | number of columns which should be allocated |
Definition at line 28 of file dbmi_base/table.c.
Referenced by P_Create_Aux2_Table(), and P_Create_Aux4_Table().
Append a specific column to given table.
table | Pointer to dbTable |
column | Pointer to a dbColumn to append. A copy of the column is stored, so the original column can be deleted. |
Definition at line 372 of file dbmi_base/table.c.
References _db_table::columns, db_copy_column(), DB_FAILED, DB_OK, db_realloc(), NULL, and _db_table::numColumns.
Make a new exact copy of an existing table.
New memory is allocated for the clone, the columns-content will be copied too.
src | Pointer to dbTable |
Definition at line 392 of file dbmi_base/table.c.
void db_free_table | ( | dbTable * | table | ) |
Free the table.
table | pointer to dbTable |
Definition at line 68 of file dbmi_base/table.c.
Referenced by db_free_cursor().
Returns column structure for given table and column number.
table | pointer to dbTable |
idx | column index (starting with '0') |
Definition at line 307 of file dbmi_base/table.c.
References _db_table::columns, NULL, and _db_table::numColumns.
Referenced by P_Create_Aux2_Table(), and P_Create_Aux4_Table().
Returns column structure for given table and column name.
table | pointer to dbTable |
name | the name of the column |
Definition at line 323 of file dbmi_base/table.c.
int db_get_table_delete_priv | ( | dbTable * | table | ) |
Get table delete privileges.
table | pointer to dbTable |
Definition at line 293 of file dbmi_base/table.c.
References _db_table::priv_delete.
const char* db_get_table_description | ( | dbTable * | table | ) |
Get the description of the table.
table | pointer to dbTable |
Definition at line 126 of file dbmi_base/table.c.
int db_get_table_insert_priv | ( | dbTable * | table | ) |
Get table insert privileges.
table | pointer to dbTable |
Definition at line 261 of file dbmi_base/table.c.
References _db_table::priv_insert.
const char* db_get_table_name | ( | dbTable * | table | ) |
Get the name of the table.
table | pointer to dbTable |
Definition at line 101 of file dbmi_base/table.c.
int db_get_table_number_of_columns | ( | dbTable * | table | ) |
Return the number of columns of the table.
table | pointer to dbTable |
Definition at line 138 of file dbmi_base/table.c.
int db_get_table_select_priv | ( | dbTable * | table | ) |
Get table select privileges.
table | pointer to dbTable |
Definition at line 197 of file dbmi_base/table.c.
int db_get_table_update_priv | ( | dbTable * | table | ) |
Get table update privileges.
table | pointer to dbTable |
Definition at line 229 of file dbmi_base/table.c.
void db_init_table | ( | dbTable * | table | ) |
Initialize the table to zero.
table | pointer to dbTable |
Definition at line 56 of file dbmi_base/table.c.
Set a specific column for given table and column number.
table | Pointer to dbTable |
idx | Column index (starting with '0'). The index must be in range. |
column | Pointer to a dbColumn to insert. A copy of the column stored, so the original column can be deleted. |
Definition at line 354 of file dbmi_base/table.c.
References _db_table::columns, db_copy_column(), DB_FAILED, DB_OK, and _db_table::numColumns.
void db_set_table_delete_priv_granted | ( | dbTable * | table | ) |
Grant delete privileges for table.
table | pointer to dbTable |
Definition at line 271 of file dbmi_base/table.c.
References DB_GRANTED, and _db_table::priv_delete.
void db_set_table_delete_priv_not_granted | ( | dbTable * | table | ) |
Set delete privileges not granted for table.
table | pointer to dbTable |
Definition at line 281 of file dbmi_base/table.c.
References DB_NOT_GRANTED, and _db_table::priv_delete.
int db_set_table_description | ( | dbTable * | table, |
const char * | description | ||
) |
Set the description of the table.
table | pointer to dbTable |
name | description of the table |
Definition at line 114 of file dbmi_base/table.c.
Referenced by P_Create_Aux2_Table(), and P_Create_Aux4_Table().
void db_set_table_insert_priv_granted | ( | dbTable * | table | ) |
Grant insert privileges for table.
table | pointer to dbTable |
Definition at line 239 of file dbmi_base/table.c.
References DB_GRANTED, and _db_table::priv_insert.
void db_set_table_insert_priv_not_granted | ( | dbTable * | table | ) |
Set insert privileges not granted for table.
table | pointer to dbTable |
Definition at line 249 of file dbmi_base/table.c.
References DB_NOT_GRANTED, and _db_table::priv_insert.
int db_set_table_name | ( | dbTable * | table, |
const char * | name | ||
) |
Set the name of the table.
table | pointer to dbTable |
name | The name of the table |
Definition at line 89 of file dbmi_base/table.c.
Referenced by P_Create_Aux2_Table(), and P_Create_Aux4_Table().
void db_set_table_select_priv_granted | ( | dbTable * | table | ) |
Grant selection privileges for all columns.
table | pointer to dbTable |
Definition at line 175 of file dbmi_base/table.c.
void db_set_table_select_priv_not_granted | ( | dbTable * | table | ) |
Set selection privileges not granted for all columns.
table | pointer to dbTable |
Definition at line 185 of file dbmi_base/table.c.
void db_set_table_update_priv_granted | ( | dbTable * | table | ) |
Grant update privileges for all columns.
table | pointer to dbTable |
Definition at line 207 of file dbmi_base/table.c.
void db_set_table_update_priv_not_granted | ( | dbTable * | table | ) |
Set update privileges not granted for all columns.
table | pointer to dbTable |
Definition at line 217 of file dbmi_base/table.c.
Create SQL CREATE sring from table definition.
table | pointer to dbTable |
sql | dbString to store the SQL CREATE string |
Definition at line 424 of file dbmi_base/table.c.