DBMI Library (base) - table management. More...

#include <stdlib.h>
#include <string.h>
#include <grass/gis.h>
#include <grass/dbmi.h>

Include dependency graph for dbmi_base/table.c:

Functions
dbTable *	db_alloc_table (int ncols)
	Allocate a table with a specific number of columns.

void	db_init_table (dbTable *table)
	Initialize the table to zero.

void	db_free_table (dbTable *table)
	Free the table.

int	db_set_table_name (dbTable table, const char name)
	Set the name of the table.

const char *	db_get_table_name (dbTable *table)
	Get the name of the table.

int	db_set_table_description (dbTable table, const char description)
	Set the description of the table.

const char *	db_get_table_description (dbTable *table)
	Get the description of the table.

int	db_get_table_number_of_columns (dbTable *table)
	Return the number of columns of the table.

void	db_set_table_select_priv_granted (dbTable *table)
	Grant selection privileges for all columns.

void	db_set_table_select_priv_not_granted (dbTable *table)
	Set selection privileges not granted for all columns.

int	db_get_table_select_priv (dbTable *table)
	Get table select privileges.

void	db_set_table_update_priv_granted (dbTable *table)
	Grant update privileges for all columns.

void	db_set_table_update_priv_not_granted (dbTable *table)
	Set update privileges not granted for all columns.

int	db_get_table_update_priv (dbTable *table)
	Get table update privileges.

void	db_set_table_insert_priv_granted (dbTable *table)
	Grant insert privileges for table.

void	db_set_table_insert_priv_not_granted (dbTable *table)
	Set insert privileges not granted for table.

int	db_get_table_insert_priv (dbTable *table)
	Get table insert privileges.

void	db_set_table_delete_priv_granted (dbTable *table)
	Grant delete privileges for table.

void	db_set_table_delete_priv_not_granted (dbTable *table)
	Set delete privileges not granted for table.

int	db_get_table_delete_priv (dbTable *table)
	Get table delete privileges.

dbColumn *	db_get_table_column (dbTable *table, int idx)
	Returns column structure for given table and column number.

dbColumn *	db_get_table_column_by_name (dbTable table, const char name)
	Returns column structure for given table and column name.

int	db_set_table_column (dbTable table, int idx, dbColumn column)
	Set a specific column for given table and column number.

int	db_append_table_column (dbTable table, dbColumn column)
	Append a specific column to given table.

dbTable *	db_clone_table (dbTable *src)
	Make a new exact copy of an existing table.

int	db_table_to_sql (dbTable table, dbString sql)
	Create SQL CREATE string from table definition.

Detailed Description

DBMI Library (base) - table management.

This program is free software under the GNU General Public License (>=v2). Read the file COPYING that comes with GRASS for details.

Author: Joel Jones (CERL/UIUC), Radim Blazek; Doxygenized by Martin Landa <landa.martin gmail.com> (2011)

Definition in file dbmi_base/table.c.

Function Documentation

◆ db_alloc_table()

dbTable * db_alloc_table ( int ncols )

Allocate a table with a specific number of columns.

Parameters

ncols number of columns which should be allocated

Returns: allocated dbTable; NULL in case of an error

Definition at line 28 of file dbmi_base/table.c.

References _db_table::columns, db_calloc(), db_free(), db_init_column(), db_init_table(), db_malloc(), NULL, and _db_table::numColumns.

Referenced by db__recv_table_definition(), db_alloc_cursor_table(), db_clone_table(), P_Create_Aux2_Table(), and P_Create_Aux4_Table().

◆ db_append_table_column()

int db_append_table_column	(	dbTable *	table,
		dbColumn *	column
	)

Append a specific column to given table.

Parameters

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.

Returns: DB_OK on success; DB_FAILURE on error

Definition at line 374 of file dbmi_base/table.c.

References _db_table::columns, db_copy_column(), DB_FAILED, DB_OK, db_realloc(), NULL, and _db_table::numColumns.

◆ db_clone_table()

dbTable * db_clone_table ( dbTable * src )

Make a new exact copy of an existing table.

New memory is allocated for the clone, the columns-content will be copied too.

Parameters

src	Pointer to dbTable

Returns: A new alloacted clone of the given table on success; NULL on error

Definition at line 396 of file dbmi_base/table.c.

References _db_table::columns, db_alloc_table(), db_copy_column(), db_copy_string(), db_get_table_number_of_columns(), _db_table::description, NULL, _db_table::priv_delete, _db_table::priv_insert, and _db_table::tableName.

◆ db_free_table()

void db_free_table ( dbTable * table )

Free the table.

Parameters

table pointer to dbTable

Definition at line 68 of file dbmi_base/table.c.

References _db_table::columns, db_free(), db_free_column(), db_free_string(), _db_table::description, _db_table::numColumns, and _db_table::tableName.

Referenced by db_column_sqltype(), db_d_create_table(), db_d_describe_table(), db_free_cursor(), db_get_column(), and Vect_write_ascii().

◆ db_get_table_column()

dbColumn * db_get_table_column	(	dbTable *	table,
		int	idx
	)

Returns column structure for given table and column number.

Parameters

table	pointer to dbTable
idx	column index (starting with '0')

Returns: pointer to dbColumn; NULL if not found

Definition at line 309 of file dbmi_base/table.c.

References _db_table::columns, NULL, and _db_table::numColumns.

Referenced by db__recv_table_data(), db__send_table_data(), db_column_sqltype(), db_get_column(), db_get_table_column_by_name(), db_print_table_definition(), db_select_CatValArray(), db_select_int(), db_select_value(), db_table_to_sql(), NetA_init_distinct(), NetA_init_timetable_from_db(), P_Aux_to_Vector(), P_Create_Aux2_Table(), P_Create_Aux4_Table(), Vect_get_column_names(), Vect_get_column_names_types(), Vect_get_column_types(), and Vect_write_ascii().

◆ db_get_table_column_by_name()

dbColumn * db_get_table_column_by_name	(	dbTable *	table,
		const char *	name
	)

Returns column structure for given table and column name.

Parameters

table	pointer to dbTable
name	the name of the column

Returns: pointer to dbColumn; NULL if not found

Definition at line 325 of file dbmi_base/table.c.

References _db_column::columnName, columns, db_get_string(), db_get_table_column(), name, NULL, and _db_table::numColumns.

◆ db_get_table_delete_priv()

int db_get_table_delete_priv ( dbTable * table )

Get table delete privileges.

Parameters

table pointer to dbTable

Returns: privileges

Definition at line 295 of file dbmi_base/table.c.

References _db_table::priv_delete.

Referenced by db_print_table_definition().

◆ db_get_table_description()

const char * db_get_table_description ( dbTable * table )

Get the description of the table.

Parameters

table pointer to dbTable

Returns: description of the table

Definition at line 126 of file dbmi_base/table.c.

References db_get_string(), and _db_table::description.

Referenced by db_print_table_definition().

◆ db_get_table_insert_priv()

int db_get_table_insert_priv ( dbTable * table )

Get table insert privileges.

Parameters

table pointer to dbTable

Returns: prilileges

Definition at line 263 of file dbmi_base/table.c.

References _db_table::priv_insert.

Referenced by db_print_table_definition().

◆ db_get_table_name()

const char * db_get_table_name ( dbTable * table )

Get the name of the table.

Parameters

table pointer to dbTable

Returns: name of the table

Definition at line 101 of file dbmi_base/table.c.

References db_get_string(), and _db_table::tableName.

Referenced by db_print_table_definition(), and db_table_to_sql().

◆ db_get_table_number_of_columns()

int db_get_table_number_of_columns ( dbTable * table )

Return the number of columns of the table.

Parameters

table pointer to dbTable

Returns: number of columns

Definition at line 138 of file dbmi_base/table.c.

References _db_table::numColumns.

Referenced by db_clone_table(), db_column_sqltype(), db_get_column(), db_get_cursor_number_of_columns(), db_print_table_definition(), db_table_to_sql(), Vect_get_column_names(), Vect_get_column_names_types(), Vect_get_column_types(), and Vect_write_ascii().

◆ db_get_table_select_priv()

int db_get_table_select_priv ( dbTable * table )

Get table select privileges.

Parameters

table pointer to dbTable

Returns: privileges

Definition at line 199 of file dbmi_base/table.c.

References db_get_column_select_priv().

◆ db_get_table_update_priv()

int db_get_table_update_priv ( dbTable * table )

Get table update privileges.

Parameters

table pointer to dbTable

Returns: privileges

Definition at line 231 of file dbmi_base/table.c.

References db_get_column_update_priv().

◆ db_init_table()

void db_init_table ( dbTable * table )

Initialize the table to zero.

Parameters

table pointer to dbTable

Definition at line 56 of file dbmi_base/table.c.

References db_init_string(), db_zero(), _db_table::description, and _db_table::tableName.

Referenced by db_alloc_table().

◆ db_set_table_column()

int db_set_table_column	(	dbTable *	table,
		int	idx,
		dbColumn *	column
	)

Set a specific column for given table and column number.

Parameters

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.

Returns: DB_OK on success; DB_FAILURE on error

Definition at line 356 of file dbmi_base/table.c.

References _db_table::columns, db_copy_column(), DB_FAILED, DB_OK, and _db_table::numColumns.

◆ db_set_table_delete_priv_granted()

void db_set_table_delete_priv_granted ( dbTable * table )

Grant delete privileges for table.

Parameters

table pointer to dbTable

Definition at line 273 of file dbmi_base/table.c.

References DB_GRANTED, and _db_table::priv_delete.

◆ db_set_table_delete_priv_not_granted()

void db_set_table_delete_priv_not_granted ( dbTable * table )

Set delete privileges not granted for table.

Parameters

table pointer to dbTable

Definition at line 283 of file dbmi_base/table.c.

References DB_NOT_GRANTED, and _db_table::priv_delete.

◆ db_set_table_description()

int db_set_table_description	(	dbTable *	table,
		const char *	description
	)

Set the description of the table.

Parameters

table	pointer to dbTable
description	description of the table

Returns: DB_OK

Definition at line 114 of file dbmi_base/table.c.

References db_set_string(), and _db_table::description.

Referenced by P_Create_Aux2_Table(), and P_Create_Aux4_Table().

◆ db_set_table_insert_priv_granted()

void db_set_table_insert_priv_granted ( dbTable * table )

Grant insert privileges for table.

Parameters

table pointer to dbTable

Definition at line 241 of file dbmi_base/table.c.

References DB_GRANTED, and _db_table::priv_insert.

◆ db_set_table_insert_priv_not_granted()

void db_set_table_insert_priv_not_granted ( dbTable * table )

Set insert privileges not granted for table.

Parameters

table pointer to dbTable

Definition at line 251 of file dbmi_base/table.c.

References DB_NOT_GRANTED, and _db_table::priv_insert.

◆ db_set_table_name()

int db_set_table_name	(	dbTable *	table,
		const char *	name
	)

Set the name of the table.

Parameters

table	pointer to dbTable
name	The name of the table

Returns: DB_OK on success

Definition at line 89 of file dbmi_base/table.c.

References db_set_string(), name, and _db_table::tableName.

Referenced by db_d_describe_table(), P_Create_Aux2_Table(), and P_Create_Aux4_Table().

◆ db_set_table_select_priv_granted()

void db_set_table_select_priv_granted ( dbTable * table )

Grant selection privileges for all columns.

Parameters

table pointer to dbTable

Definition at line 177 of file dbmi_base/table.c.

References db_set_column_select_priv_granted().

◆ db_set_table_select_priv_not_granted()

void db_set_table_select_priv_not_granted ( dbTable * table )

Set selection privileges not granted for all columns.

Parameters

table pointer to dbTable

Definition at line 187 of file dbmi_base/table.c.

References db_set_column_select_priv_not_granted().

◆ db_set_table_update_priv_granted()

void db_set_table_update_priv_granted ( dbTable * table )

Grant update privileges for all columns.

Parameters

table pointer to dbTable

Definition at line 209 of file dbmi_base/table.c.

References db_set_column_update_priv_granted().

◆ db_set_table_update_priv_not_granted()

void db_set_table_update_priv_not_granted ( dbTable * table )

Set update privileges not granted for all columns.

Parameters

table pointer to dbTable

Definition at line 219 of file dbmi_base/table.c.

References db_set_column_update_priv_not_granted().

◆ db_table_to_sql()

int db_table_to_sql	(	dbTable *	table,
		dbString *	sql
	)

Create SQL CREATE string from table definition.

Parameters

table	pointer to dbTable
sql	dbString to store the SQL CREATE string

Returns: DB_OK on success; DB_FAILED on error

Definition at line 428 of file dbmi_base/table.c.

References db_append_string(), DB_FAILED, db_get_column_length(), db_get_column_name(), db_get_column_sqltype(), db_get_string(), db_get_table_column(), db_get_table_name(), db_get_table_number_of_columns(), DB_OK, db_set_string(), DB_SQL_TYPE_CHARACTER, DB_SQL_TYPE_DATE, DB_SQL_TYPE_DECIMAL, DB_SQL_TYPE_DOUBLE_PRECISION, DB_SQL_TYPE_INTEGER, DB_SQL_TYPE_INTERVAL, DB_SQL_TYPE_NUMERIC, DB_SQL_TYPE_REAL, DB_SQL_TYPE_SMALLINT, DB_SQL_TYPE_TEXT, DB_SQL_TYPE_TIME, DB_SQL_TYPE_TIMESTAMP, db_sqltype_name(), G_debug(), and G_warning().

Functions

Detailed Description

Function Documentation

◆ db_alloc_table()

◆ db_append_table_column()

◆ db_clone_table()

◆ db_free_table()

◆ db_get_table_column()

◆ db_get_table_column_by_name()

◆ db_get_table_delete_priv()

◆ db_get_table_description()

◆ db_get_table_insert_priv()

◆ db_get_table_name()

◆ db_get_table_number_of_columns()

◆ db_get_table_select_priv()

◆ db_get_table_update_priv()

◆ db_init_table()

◆ db_set_table_column()

◆ db_set_table_delete_priv_granted()

◆ db_set_table_delete_priv_not_granted()

◆ db_set_table_description()

◆ db_set_table_insert_priv_granted()

◆ db_set_table_insert_priv_not_granted()

◆ db_set_table_name()

◆ db_set_table_select_priv_granted()

◆ db_set_table_select_priv_not_granted()

◆ db_set_table_update_priv_granted()

◆ db_set_table_update_priv_not_granted()

◆ db_table_to_sql()