This graph shows which files directly or indirectly include this file:

Functions
void	db_Cstring_to_lowercase (char *)
	Convert string to lowercase. More...

void	db_Cstring_to_uppercase (char *)
	Convert string to lowercase. More...

int	db_add_column (dbDriver , dbString , dbColumn *)
	Add column to table. More...

void	db__add_cursor_to_driver_state (dbCursor *)
	Add cursor do driver state. More...

int	db_alloc_cursor_column_flags (dbCursor *)
	Allocate columns' flags for cursor. More...

int	db_alloc_cursor_table (dbCursor *, int)
	Allocate table for cursor. More...

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

dbDirent *	db_alloc_dirent_array (int)
	Allocate dirent array. More...

dbHandle *	db_alloc_handle_array (int)
	Allocate array of handles. More...

dbIndex *	db_alloc_index_array (int)
	Allocate index array. More...

int	db_alloc_index_columns (dbIndex *, int)
	Allocate index columns. More...

dbString *	db_alloc_string_array (int)
	Allocate dbString array. More...

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

int	db_append_string (dbString , const char )
	Append string to dbString. More...

void	db_auto_print_errors (int)
	Toggles printing of DBMI error messages. More...

void	db_auto_print_protocol_errors (int)
	Set auto print protocol error. More...

int	db_bind_update (dbCursor *)
	? More...

void *	db_calloc (int, int)
	Allocate memory. More...

int	db_CatValArray_alloc (dbCatValArray *, int)
	Allocate dbCatValArray. More...

int	db_CatValArray_realloc (dbCatValArray *, int)
	Realloc dbCatValArray. More...

void	db_CatValArray_free (dbCatValArray *)
	Free allocated dbCatValArray. More...

void	db_CatValArray_init (dbCatValArray *)
	Initialize dbCatValArray. More...

void	db_CatValArray_sort (dbCatValArray *)
	Sort key/value array by key. More...

int	db_CatValArray_sort_by_value (dbCatValArray *)
	Sort key/value array by value. More...

int	db_CatValArray_get_value (dbCatValArray , int, dbCatVal *)
	Find value by key. More...

int	db_CatValArray_get_value_int (dbCatValArray , int, int )
	Find value (integer) by key. More...

int	db_CatValArray_get_value_double (dbCatValArray , int, double )
	Find value (double) by key. More...

void	db_char_to_lowercase (char *)
	Convert character to lowercase. More...

void	db_char_to_uppercase (char *)
	Convert character to uppercase. More...

void	db_clear_error (void)
	Clear error status. More...

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

void	db__close_all_cursors (void)
	Close all cursors. More...

int	db_close_cursor (dbCursor *)
	Close cursor. More...

int	db_close_database (dbDriver *)
	Close database connection. More...

int	db_close_database_shutdown_driver (dbDriver *)
	Close driver/database connection. More...

int	db_column_sqltype (dbDriver , const char , const char *)
	Get column sqltype. More...

int	db_column_Ctype (dbDriver , const char , const char *)
	Get column ctype. More...

int	db_convert_Cstring_to_column_default_value (const char , dbColumn )
	? More...

int	db_convert_Cstring_to_column_value (const char , dbColumn )
	? More...

int	db_convert_Cstring_to_value (const char , int, dbValue )
	Convert string to value. More...

int	db_convert_Cstring_to_value_datetime (const char , int, dbValue )
	Convert datetime string to value. More...

int	db_convert_column_default_value_to_string (dbColumn , dbString )
	? More...

int	db_convert_column_value_to_string (dbColumn , dbString )
	? More...

int	db_convert_value_datetime_into_string (dbValue , int, dbString )
	Convert datetime value into string. More...

int	db_convert_value_to_string (dbValue , int, dbString )
	Convert value to string. More...

dbColumn *	db_copy_column (dbColumn , dbColumn )
	Copy a db column from source to destination. More...

void	db_copy_dbmscap_entry (dbDbmscap , dbDbmscap )
	Copy dbmscap entry. More...

int	db_copy_string (dbString , const dbString )
	Copy dbString. More...

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

int	db_copy_table (const char , const char , const char , const char , const char , const char )
	Copy a table. More...

int	db_copy_table_where (const char , const char , const char , const char , const char , const char , const char *)
	Copy a table (by where statement) More...

int	db_copy_table_select (const char , const char , const char , const char , const char , const char , const char *)
	Copy a table (by select statement) More...

int	db_copy_table_by_ints (const char , const char , const char , const char , const char , const char , const char , int , int)
	Copy a table (by keys) More...

void	db_copy_value (dbValue , dbValue )
	Copy value. More...

int	db_create_database (dbDriver , dbHandle )
	Create database. More...

int	db_create_index (dbDriver , dbIndex )
	Create index. More...

int	db_create_index2 (dbDriver , const char , const char *)
	Create unique index. More...

int	db_create_table (dbDriver , dbTable )
	Create table. More...

int	db_d_add_column (void)
	Add column to table. More...

int	db_d_bind_update (void)
	ADD. More...

const char *	db_dbmscap_filename (void)
	Get dbmscap file name. More...

int	db_d_close_cursor (void)
	Close cursor. More...

int	db_d_close_database (void)
	Close database connection. More...

int	db_d_create_database (void)
	Create database. More...

int	db_d_create_index (void)
	Create index. More...

int	db_d_create_table (void)
	Create table. More...

int	db_d_delete (void)
	Delete record (?) More...

int	db_d_delete_database (void)
	Delete database. More...

int	db_d_describe_table (void)
	Describe table. More...

int	db_d_drop_column (void)
	Drop column. More...

int	db_d_drop_index (void)
	Drop index. More...

int	db_d_drop_table (void)
	Drop table. More...

void	db_debug (const char *)
	Print debug message. More...

void	db_debug_off (void)
	Turn off debugging. More...

void	db_debug_on (void)
	Turn on debugging. More...

int	db_delete (dbCursor *)
	Delete record (?) More...

int	db_delete_database (dbDriver , dbHandle )
	Delete database. More...

int	db_delete_table (const char , const char , const char *)
	Delete table. More...

int	db_describe_table (dbDriver , dbString , dbTable **)
	Describe table. More...

int	db_d_execute_immediate (void)
	Execute SQL statements. More...

int	db_d_begin_transaction (void)
	Begin transaction. More...

int	db_d_commit_transaction (void)
	Commit transaction. More...

int	db_d_fetch (void)
	Fetch data. More...

int	db_d_find_database (void)
	Find database. More...

int	db_d_get_num_rows (void)
	Get number of selected rows. More...

int	db_d_grant_on_table (void)
	Grant privileges on table. More...

int	db_d_insert (void)
	Insert new record into table. More...

void	db_d_init_error (const char *)
	Init error message for DB driver. More...

void	db_d_append_error (const char *,...) __attribute__((format(printf

void void	db_d_report_error (void)
	Report error message for DB driver. More...

dbDirent *	db_dirent (const char , int )
	Read directory and build an array of dbDirent's. More...

int	db_d_list_databases (void)
	List databases. More...

int	db_d_list_indexes (void)
	List indexes. More...

int	db_d_list_tables (void)
	List available tables for given connection. More...

int	db_d_open_database (void)
	Open database connection. More...

int	db_d_open_insert_cursor (void)
	Open insert cursor. More...

int	db_d_open_select_cursor (void)
	Open select cursor. More...

int	db_d_open_update_cursor (void)
	Open update cursor. More...

void	db_double_quote_string (dbString *)
	Replace each ' is replaced by ''. More...

int	db_driver (int, char **)

int	db_driver_mkdir (const char *, int, int)
	Create db directory. More...

int	db_drop_column (dbDriver , dbString , dbString *)
	Drop column. More...

void	db__drop_cursor_from_driver_state (dbCursor *)
	Drop cursor from driver state. More...

int	db_drop_index (dbDriver , dbString )
	Drop index. More...

int	db_drop_table (dbDriver , dbString )
	Drop table. More...

void	db_drop_token (dbToken)
	Drop token. More...

int	db_d_update (void)
	? More...

int	db_d_version (void)
	Get version info. More...

int	db_enlarge_string (dbString *, int)
	Enlarge dbString. More...

void	db_error (const char *)
	Report error message. More...

int	db_execute_immediate (dbDriver , dbString )
	Execute SQL statements. More...

int	db_begin_transaction (dbDriver *)
	Begin transaction. More...

int	db_commit_transaction (dbDriver *)
	Commit transaction. More...

int	db_fetch (dbCursor , int, int )
	Fetch data from open cursor. More...

int	db_find_database (dbDriver , dbHandle , int *)
	Find database. More...

dbAddress	db_find_token (dbToken)
	Find token. More...

void	db_free (void *)
	Free allocated memory. More...

void	db_free_column (dbColumn *)
	Frees column structure. More...

void	db_free_cursor (dbCursor *)
	Free allocated dbCursor. More...

void	db_free_cursor_column_flags (dbCursor *)
	Free columns' flags of cursor. More...

void	db_free_dbmscap (dbDbmscap *)
	Free dbmscap. More...

void	db_free_dirent_array (dbDirent *, int)
	Free dbDirent. More...

void	db_free_handle (dbHandle *)
	Free dbHandle structure. More...

void	db_free_handle_array (dbHandle *, int)
	Free array of handles. More...

void	db_free_index (dbIndex *)
	Free allocated dbIndex. More...

void	db_free_index_array (dbIndex *, int)
	Free index array. More...

void	db_free_string (dbString *)
	Free allocated space for dbString. More...

void	db_free_string_array (dbString *, int)
	Free allocated dbString array. More...

void	db_free_table (dbTable *)
	Free the table. More...

int	db_get_column (dbDriver , const char , const char , dbColumn *)
	Get column structure by table and column name. More...

dbValue *	db_get_column_default_value (dbColumn *)
	Returns column default value for given column structure. More...

const char *	db_get_column_description (dbColumn *)
	Returns column description for given column. More...

int	db_get_column_host_type (dbColumn *)
	Get column host type. More...

int	db_get_column_length (dbColumn *)
	Get column's length. More...

const char *	db_get_column_name (dbColumn *)
	Returns column name for given column. More...

int	db_get_column_precision (dbColumn *)
	Get column precision. More...

int	db_get_column_scale (dbColumn *)
	Get column scale. More...

int	db_get_column_select_priv (dbColumn *)
	Get select privileges. More...

int	db_get_column_sqltype (dbColumn *)
	Returns column sqltype for column. More...

int	db_get_column_update_priv (dbColumn *)
	Get update privileges. More...

dbValue *	db_get_column_value (dbColumn *)
	Returns column value for given column structure. More...

int	db_get_connection (dbConnection *)
	Get default DB connection settings for the current mapset. More...

int	db_get_cursor_number_of_columns (dbCursor *)
	Get number of columns. More...

dbTable *	db_get_cursor_table (dbCursor *)
	Get table allocated by cursor. More...

dbToken	db_get_cursor_token (dbCursor *)
	Get cursor token. More...

const char *	db_get_default_driver_name (void)
	Get driver name from current DB connection settings. More...

const char *	db_get_default_database_name (void)
	Get database name from current DB connection settings. More...

const char *	db_get_default_schema_name (void)
	Get schema name from current DB connection settings. More...

const char *	db_get_default_group_name (void)
	Get group name from current DB connection settings. More...

dbDriverState *	db__get_driver_state (void)
	Get driver state. More...

int	db_get_error_code (void)
	Get error code. More...

const char *	db_get_error_msg (void)
	Get error message. More...

const char *	db_get_error_who (void)

const char *	db_get_handle_dbname (dbHandle *)
	Get handle database name. More...

const char *	db_get_handle_dbschema (dbHandle *)
	Get handle schema name. More...

const char *	db_get_index_column_name (dbIndex *, int)
	Get column number. More...

const char *	db_get_index_name (dbIndex *)
	Get index name. More...

int	db_get_index_number_of_columns (dbIndex *)
	Get number of columns. More...

const char *	db_get_index_table_name (dbIndex *)
	Get table name. More...

int	db_get_num_rows (dbCursor *)
	Get number of selected rows. More...

char *	db_get_string (const dbString *)
	Get string. More...

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

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

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

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

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

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

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

int	db_get_table_number_of_rows (dbDriver , dbString )
	Get number of rows of table. More...

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

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

double	db_get_value_as_double (dbValue *, int)
	Get value as double. More...

int	db_get_value_day (dbValue *)
	Get day value. More...

double	db_get_value_double (dbValue *)
	Get double precision value. More...

int	db_get_value_hour (dbValue *)
	Get hour value. More...

int	db_get_value_int (dbValue *)
	Get integer value. More...

int	db_get_value_minute (dbValue *)
	Get minute value. More...

int	db_get_value_month (dbValue *)
	Get month value. More...

double	db_get_value_seconds (dbValue *)
	Get seconds value. More...

const char *	db_get_value_string (dbValue *)
	Get string value. More...

int	db_get_value_year (dbValue *)
	Get year value. More...

int	db_grant_on_table (dbDriver , const char , int, int)
	Grant privileges on table. More...

int	db_has_dbms (void)
	Check dbms. More...

void	db_init_column (dbColumn *)
	Initialize dbColumn. More...

void	db_init_cursor (dbCursor *)
	Initialize dbCursor. More...

void	db__init_driver_state (void)
	Initialize driver state. More...

void	db_init_handle (dbHandle *)
	Initialize handle (i.e database/schema) More...

void	db_init_index (dbIndex *)
	Initialize dbIndex. More...

void	db_init_string (dbString *)
	Initialize dbString. More...

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

int	db_insert (dbCursor *)
	Insert new record into table. More...

void	db_interval_range (int, int , int )
	Define range based on SQL data type. More...

int	db_isdir (const char *)
	Test if path is a directory. More...

int	db_legal_tablename (const char *)
	Check if output is legal table name. More...

int	db_list_databases (dbDriver , dbString , int, dbHandle *, int )
	List databases. More...

const char *	db_list_drivers (void)
	Return comma separated list of existing DB drivers, used for driver parameter options. More...

int	db_list_indexes (dbDriver , dbString , dbIndex *, int )
	List indexes. More...

int	db_list_tables (dbDriver , dbString , int , int)
	List available tables for given connection. More...

void *	db_malloc (int)
	Allocate memory. More...

void	db__mark_database_closed (void)
	Mark database as closed. More...

void	db__mark_database_open (const char , const char )
	Mark database as opened. More...

void	db_memory_error (void)
	Report memory error. More...

dbToken	db_new_token (dbAddress)
	Add new token. More...

int	db_nocase_compare (const char , const char )
	Compare strings case-insensitive. More...

void	db_noproc_error (int)
	Report no procedure error. More...

int	db_open_database (dbDriver , dbHandle )
	Open database connection. More...

int	db_open_insert_cursor (dbDriver , dbCursor )
	Open insert cursor. More...

int	db_open_select_cursor (dbDriver , dbString , dbCursor *, int)
	Open select cursor. More...

int	db_open_update_cursor (dbDriver , dbString _name, dbString , dbCursor , int)
	Open update cursor. More...

void	db_print_column_definition (FILE , dbColumn )
	Print column definition info. More...

void	db_print_error (void)
	Print error. More...

void	db_print_index (FILE , dbIndex )
	Report index. More...

void	db_print_table_definition (FILE , dbTable )
	Print table definition info. More...

void	db_procedure_not_implemented (const char *)
	Report 'not implemented' error. More...

void	db_protocol_error (void)
	Report protocol error. More...

dbDbmscap *	db_read_dbmscap (void)
	Read dbmscap. More...

void *	db_realloc (void *, int)
	Reallocate memory. More...

int	db__recv_char (char *)
	? More...

int	db__recv_column_default_value (dbColumn *)
	Receive column default value. More...

int	db__recv_column_definition (dbColumn *)
	Receive column definition. More...

int	db__recv_column_value (dbColumn *)
	Receive column value. More...

int	db__recv_datetime (dbDateTime *)
	Receive datetime. More...

int	db__recv_double (double *)
	Receive double. More...

int	db__recv_double_array (double *, int )
	Receive double array. More...

int	db__recv_float (float *)
	Receive float. More...

int	db__recv_float_array (float *, int )
	Receive float array. More...

int	db__recv_handle (dbHandle *)
	Receive handle. More...

int	db__recv_index (dbIndex *)
	Receive index. More...

int	db__recv_index_array (dbIndex *, int )
	Receive index array. More...

int	db__recv_int (int *)
	Receive integer. More...

int	db__recv_int_array (int *, int )
	Receive integer array. More...

int	db__recv_procnum (int *)
	? (driver only) More...

int	db__recv_return_code (int *)
	Receive return code. More...

int	db__recv_short (short *)
	Receive short. More...

int	db__recv_short_array (short *, int )
	Receive short array. More...

int	db__recv_string (dbString *)
	Reads a string from transport. More...

int	db__recv_string_array (dbString *, int )
	Receive string array. More...

int	db__recv_table_data (dbTable *)
	Receive table data. More...

int	db__recv_table_definition (dbTable **)
	Receive table definition. More...

int	db__recv_token (dbToken *)
	Receive token. More...

int	db__recv_value (dbValue *, int)
	Receive value. More...

int	db__send_Cstring (const char *)
	Send C string. More...

int	db__send_char (int)
	? More...

int	db__send_column_default_value (dbColumn *)
	Send column default value. More...

int	db__send_column_definition (dbColumn *)
	Send column definition. More...

int	db__send_column_value (dbColumn *)
	Send column value. More...

int	db__send_datetime (dbDateTime *)
	Send datetime. More...

int	db__send_double (double)
	Send double. More...

int	db__send_double_array (const double *, int)
	Send double array. More...

int	db__send_failure (void)
	Send failure code. More...

int	db__send_float (float)
	Send float. More...

int	db__send_float_array (const float *, int)
	Send float array. More...

int	db__send_handle (dbHandle *)
	Send handle. More...

int	db__send_index (dbIndex *)
	Send index. More...

int	db__send_index_array (dbIndex *, int)
	Send index array. More...

int	db__send_int (int)
	Send integer. More...

int	db__send_int_array (const int *, int)
	Send integer array. More...

int	db__send_procedure_not_implemented (int)
	? More...

int	db__send_procedure_ok (int)
	? More...

int	db__send_short (int)
	Send short. More...

int	db__send_short_array (const short *, int)
	Send short array. More...

int	db__send_string (dbString *)
	Send string. More...

int	db__send_string_array (dbString *, int)
	Send string array. More...

int	db__send_success (void)
	Send success code. More...

int	db__send_table_data (dbTable *)
	Send table data. More...

int	db__send_table_definition (dbTable *)
	Send table definition. More...

int	db__send_token (dbToken *)
	Send token. More...

int	db__send_value (dbValue *, int)
	Send value. More...

int	db_select_CatValArray (dbDriver , const char , const char , const char , const char , dbCatValArray )
	Select pairs key/value to array, values are sorted by key (must be integer) More...

int	db_select_int (dbDriver , const char , const char , const char , int **)
	Select array of ordered integers from table/column. More...

int	db_select_value (dbDriver , const char , const char , int, const char , dbValue *)
	Select one (first) value from table/column for key/id. More...

int	db_set_column_description (dbColumn , const char )
	Set column description. More...

void	db_set_column_has_defined_default_value (dbColumn *)
	Set default value identificator. More...

void	db_set_column_has_undefined_default_value (dbColumn *)
	Unset default value identificator. More...

void	db_set_column_host_type (dbColumn *, int)
	Set column host data type. More...

void	db_set_column_length (dbColumn *, int)
	Set column's length. More...

int	db_set_column_name (dbColumn , const char )
	Set column name. More...

void	db_set_column_null_allowed (dbColumn *)
	Set null value to be allowed. More...

void	db_set_column_precision (dbColumn *, int)
	Set column precision. More...

void	db_set_column_scale (dbColumn *, int)
	Set column scale. More...

void	db_set_column_select_priv_granted (dbColumn *)
	Set select privileges to be granted. More...

void	db_set_column_select_priv_not_granted (dbColumn *)
	Unset select privileges. More...

void	db_set_column_sqltype (dbColumn *, int)
	Define column sqltype for column. More...

void	db_set_column_update_priv_granted (dbColumn *)
	Set update privileges to be granted. More...

void	db_set_column_update_priv_not_granted (dbColumn *)
	Unset update privileges. More...

void	db_set_column_use_default_value (dbColumn *)
	Set default value to be used. More...

int	db_set_connection (dbConnection *)
	Set default DB connection settings. More...

void	db_set_cursor_column_flag (dbCursor *, int)
	Set column's flag. More...

void	db_set_cursor_column_for_update (dbCursor *, int)
	Set Column flag to 'update'. More...

void	db_set_cursor_mode (dbCursor *, int)
	Set cursor mode. More...

void	db_set_cursor_mode_insensitive (dbCursor *)
	Set 'intensive' cursor mode. More...

void	db_set_cursor_mode_scroll (dbCursor *)
	Set 'scroll' cursor mode. More...

void	db_set_cursor_table (dbCursor , dbTable )
	Set table for given cursor. More...

void	db_set_cursor_token (dbCursor *, dbToken)
	Set cursor token. More...

void	db_set_cursor_type_insert (dbCursor *)
	Set cursor to be writable (insert) More...

void	db_set_cursor_type_readonly (dbCursor *)
	Set cursor to be read-only (select) More...

void	db_set_cursor_type_update (dbCursor *)
	Set cursor to be writable (update) More...

int	db_set_default_connection (void)
	Sets up database connection settings using GRASS default from dbmi.h. More...

void	db_set_error_who (const char *)
	Set 'who' for error messages. More...

int	db_set_handle (dbHandle , const char , const char *)
	Set handle (database and schema name) More...

void	db_set_error_handler_driver (dbDriver *)
	Define standard error handler for open database connection. More...

void	db_unset_error_handler_driver (dbDriver *)
	Remove error handler before closing the driver. More...

int	db_set_index_column_name (dbIndex , int, const char )
	Set column name. More...

int	db_set_index_name (dbIndex , const char )
	Set index name. More...

int	db_set_index_table_name (dbIndex , const char )
	Set table name. More...

int	db_set_index_type_non_unique (dbIndex *)
	Set index type to non-unique. More...

int	db_set_index_type_unique (dbIndex *)
	Set index type to unique. More...

void	db__set_protocol_fds (FILE , FILE )
	? More...

int	db_set_string (dbString , const char )
	Inserts string to dbString (enlarge string) More...

int	db_set_string_no_copy (dbString , char )
	Inserts string to dbString (overwrite current value) More...

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

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

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

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

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

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

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

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

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

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

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

void	db_set_value_datetime_current (dbValue *)
	Set datetime to current. More...

void	db_set_value_datetime_not_current (dbValue *)
	Set value to non-current. More...

void	db_set_value_day (dbValue *, int)
	Set day value. More...

void	db_set_value_double (dbValue *, double)
	Set double precision value. More...

void	db_set_value_hour (dbValue *, int)
	Set hour value. More...

void	db_set_value_int (dbValue *, int)
	Set integer value. More...

void	db_set_value_minute (dbValue *, int)
	Set minute value. More...

void	db_set_value_month (dbValue *, int)
	Set month value. More...

void	db_set_value_not_null (dbValue *)
	Set value to not null. More...

void	db_set_value_null (dbValue *)
	Set value to null. More...

void	db_set_value_seconds (dbValue *, double)
	Set seconds value. More...

int	db_set_value_string (dbValue , const char )
	Set string value. More...

void	db_set_value_year (dbValue *, int)
	Set year value. More...

int	db_shutdown_driver (dbDriver *)
	Closedown the driver, and free the driver structure. More...

const char *	db_sqltype_name (int)
	Get SQL data type description. More...

int	db_sqltype_to_Ctype (int)
	Get C data type based on given SQL data type. More...

dbDriver *	db_start_driver (const char *)
	Initialize a new dbDriver for db transaction. More...

dbDriver *	db_start_driver_open_database (const char , const char )
	Open driver/database connection. More...

int	db__start_procedure_call (int)
	? (client only) More...

char *	db_store (const char *)
	Make a copy of string buffer. More...

void	db_strip (char *)
	Strip given string. More...

void	db_syserror (const char *)
	Report system error. More...

int	db_table_exists (const char , const char , const char *)
	Check if table exists. More...

int	db_test_column_has_default_value (dbColumn *)
	Check if column has defined default value. More...

int	db_test_column_has_defined_default_value (dbColumn *)
	Check if column has defined default value. More...

int	db_test_column_has_undefined_default_value (dbColumn *)
	Check if column has defined default value. More...

int	db_test_column_null_allowed (dbColumn *)
	Checks if null value is allowed. More...

int	db_test_column_use_default_value (dbColumn *)
	Checks if default value is used. More...

int	db_test_cursor_any_column_flag (dbCursor *)
	Checks columns' flag. More...

int	db_test_cursor_any_column_for_update (dbCursor *)
	Check if columns' flag is 'update'. More...

int	db_test_cursor_column_flag (dbCursor *, int)
	Checks column's flag. More...

int	db_test_cursor_column_for_update (dbCursor *, int)
	Check if column flag is 'update'. More...

int	db_test_cursor_mode_insensitive (dbCursor *)
	Check if cursor mode is 'intensive'. More...

int	db_test_cursor_mode_scroll (dbCursor *)
	Check if cursor mode is 'scroll'. More...

int	db_test_cursor_type_fetch (dbCursor *)
	Check cursor type. More...

int	db_test_cursor_type_insert (dbCursor *)
	Check if cursor type is 'insert'. More...

int	db_test_cursor_type_update (dbCursor *)
	Check if cursor type is 'update'. More...

int	db__test_database_open (void)
	Test database connection. More...

int	db_test_index_type_unique (dbIndex *)
	Test if type is unique. More...

int	db_test_value_datetime_current (dbValue *)
	Check if datatime is current. More...

int	db_test_value_isnull (dbValue *)
	Check of value is null. More...

void	db_unset_column_has_default_value (dbColumn *)
	Unset default value identificator. More...

void	db_unset_column_null_allowed (dbColumn *)
	Unset null value to be allowed. More...

void	db_unset_column_use_default_value (dbColumn *)
	Unset default value to be used. More...

void	db_unset_cursor_column_flag (dbCursor *, int)
	Unset column's flag. More...

void	db_unset_cursor_column_for_update (dbCursor *, int)
	Unset 'update' column flag. More...

void	db_unset_cursor_mode (dbCursor *)
	Unset cursor mode. More...

void	db_unset_cursor_mode_insensitive (dbCursor *)
	Unset 'intensive' cursor mode. More...

void	db_unset_cursor_mode_scroll (dbCursor *)
	Unset 'scroll' cursor mode. More...

int	db_update (dbCursor *)
	? More...

int	db_gversion (dbDriver , dbString , dbString *)
	Get version info. More...

const char *	db_whoami (void)
	Who am i? More...

void	db_zero (void *, int)
	Zero allocated space. More...

void	db_zero_string (dbString *)
	Zero string. More...

unsigned int	db_sizeof_string (const dbString *)
	Get string size. More...

int	db_set_login (const char , const char , const char , const char )
	Set login parameters for driver/database. More...

int	db_set_login2 (const char , const char , const char , const char , const char , const char , int)
	Set login parameters for driver/database. More...

int	db_get_login (const char , const char , const char , const char )
	Get login parameters for driver/database. More...

int	db_get_login2 (const char , const char , const char , const char , const char , const char )
	Get login parameters for driver/database. More...

int	db_get_login_dump (FILE *)
	Print all connection settings to file. More...

Function Documentation

◆ db__add_cursor_to_driver_state()

void db__add_cursor_to_driver_state ( dbCursor * cursor )

Add cursor do driver state.

Parameters

cursor db cursor to be added

Definition at line 78 of file driver_state.c.

References db_realloc(), list, NULL, and state.

◆ db__close_all_cursors()

void db__close_all_cursors ( void )

Close all cursors.

Definition at line 120 of file driver_state.c.

References db_driver_close_cursor, db_free(), NULL, and state.

Referenced by db_d_close_database().

◆ db__drop_cursor_from_driver_state()

void db__drop_cursor_from_driver_state ( dbCursor * cursor )

Drop cursor from driver state.

Parameters

cursor db cursor to be dropped

Definition at line 108 of file driver_state.c.

References NULL, and state.

Referenced by db_d_close_cursor().

◆ db__get_driver_state()

dbDriverState* db__get_driver_state ( void )

Get driver state.

Returns: pointer to dbDriverState

Definition at line 34 of file driver_state.c.

References state.

◆ db__init_driver_state()

void db__init_driver_state ( void )

Initialize driver state.

Definition at line 24 of file driver_state.c.

References db_zero(), and state.

Referenced by db_d_close_database().

◆ db__mark_database_closed()

void db__mark_database_closed ( void )

Mark database as closed.

Definition at line 66 of file driver_state.c.

References db_free(), and state.

Referenced by db_d_close_database().

◆ db__mark_database_open()

void db__mark_database_open	(	const char *	dbname,
		const char *	dbschema
	)

Mark database as opened.

Parameters

dbname	database name
dbschema	database schema name

Definition at line 56 of file driver_state.c.

References db_store(), and state.

Referenced by db_d_open_database().

◆ db__recv_char()

int db__recv_char ( char * d )

?

Parameters

d

Returns

Definition at line 45 of file xdrchar.c.

◆ db__recv_column_default_value()

int db__recv_column_default_value ( dbColumn * column )

Receive column default value.

Parameters

column pointer to dbColumn

Returns

Definition at line 120 of file xdrcolumn.c.

References db__recv_value(), db_get_column_default_value(), db_get_column_sqltype(), and db_sqltype_to_Ctype().

◆ db__recv_column_definition()

int db__recv_column_definition ( dbColumn * column )

Receive column definition.

Parameters

column pointer to dbColumn

Returns: DB_OK

Definition at line 53 of file xdrcolumn.c.

References _db_column::columnName, _db_column::dataLen, DB_OK, DB_RECV_CHAR, DB_RECV_COLUMN_DEFAULT_VALUE, DB_RECV_INT, DB_RECV_STRING, _db_column::description, _db_column::hasDefaultValue, _db_column::hostDataType, _db_column::nullAllowed, _db_column::precision, _db_column::scale, _db_column::select, _db_column::sqlDataType, _db_column::update, and _db_column::useDefaultValue.

◆ db__recv_column_value()

int db__recv_column_value ( dbColumn * column )

Receive column value.

Parameters

column pointer to dbColumn

Returns

Definition at line 94 of file xdrcolumn.c.

References db__recv_value(), db_get_column_sqltype(), db_get_column_value(), and db_sqltype_to_Ctype().

◆ db__recv_datetime()

int db__recv_datetime ( dbDateTime * t )

Receive datetime.

Parameters

t	pointer to dbDateTime

Returns: DB_OK

Definition at line 47 of file xdrdatetime.c.

References DB_OK, DB_RECV_CHAR, DB_RECV_DOUBLE, DB_RECV_INT, and t.

◆ db__recv_double()

int db__recv_double ( double * d )

Receive double.

Parameters

d

Definition at line 42 of file xdrdouble.c.

◆ db__recv_double_array()

int db__recv_double_array	(	double **	x,
		int *	n
	)

Receive double array.

Returns an allocated array of doubles Caller is responsible for free()

Parameters

x
n

Returns

Definition at line 90 of file xdrdouble.c.

References count, and DB_OK.

◆ db__recv_float()

int db__recv_float ( float * d )

Receive float.

Parameters

d

Returns

Definition at line 44 of file xdrfloat.c.

◆ db__recv_float_array()

int db__recv_float_array	(	float **	x,
		int *	n
	)

Receive float array.

Returns an allocated array of floats Caller is responsible for free()

Parameters

x
n

Returns

Definition at line 92 of file xdrfloat.c.

References count, and DB_OK.

◆ db__recv_handle()

int db__recv_handle ( dbHandle * handle )

Receive handle.

Parameters

handle

Returns

Definition at line 40 of file xdrhandle.c.

References DB_OK, DB_RECV_STRING, _db_handle::dbName, and _db_handle::dbSchema.

◆ db__recv_index()

int db__recv_index ( dbIndex * index )

Receive index.

Parameters

index

Returns

Definition at line 68 of file xdrindex.c.

◆ db__recv_index_array()

int db__recv_index_array	(	dbIndex **	list,
		int *	count
	)

Receive index array.

Parameters

list
count

Definition at line 95 of file xdrindex.c.

References count, db_alloc_index_array(), db_get_error_code(), DB_OK, DB_RECV_INDEX, DB_RECV_INT, and NULL.

◆ db__recv_int()

int db__recv_int ( int * n )

Receive integer.

Parameters

n

Returns

Definition at line 44 of file xdrint.c.

References db__recv(), DB_OK, DB_PROTOCOL_ERR, and db_protocol_error().

Referenced by db__recv_token().

◆ db__recv_int_array()

int db__recv_int_array	(	int **	x,
		int *	n
	)

Receive integer array.

Returns an allocated array of ints Caller is responsible for free()

Parameters

x
n

Returns

Definition at line 92 of file xdrint.c.

References count, and DB_OK.

◆ db__recv_procnum()

int db__recv_procnum ( int * n )

? (driver only)

Parameters

n

Returns: DB_OK ok; DB_EOF eof from client

Definition at line 52 of file xdrprocedure.c.

References db__recv(), DB_EOF, and DB_OK.

◆ db__recv_return_code()

int db__recv_return_code ( int * ret_code )

Receive return code.

Parameters

[out] ret_code return code

Returns: DB_OK on success

Definition at line 51 of file ret_codes.c.

◆ db__recv_short()

int db__recv_short ( short * n )

Receive short.

Parameters

n

Returns

Definition at line 46 of file xdrshort.c.

References db__recv(), DB_OK, DB_PROTOCOL_ERR, and db_protocol_error().

◆ db__recv_short_array()

int db__recv_short_array	(	short **	x,
		int *	n
	)

Receive short array.

Returns an allocated array of ints Caller is responsible for free()

Parameters

x
n

Returns

Definition at line 94 of file xdrshort.c.

References count, and DB_OK.

◆ db__recv_string()

int db__recv_string ( dbString * x )

Reads a string from transport.

Note: caller MUST initialize x by calling db_init_string()

Parameters

x

Returns: DB_OK, DB_MEMORY_ERR, or DB_PROTOCOL_ERR; NULL if error

Definition at line 117 of file xdrstring.c.

References DB_OK.

◆ db__recv_string_array()

int db__recv_string_array	(	dbString **	a,
		int *	n
	)

Receive string array.

Parameters

a
n

Returns

Definition at line 46 of file xdrstring.c.

◆ db__recv_table_data()

int db__recv_table_data ( dbTable * table )

Receive table data.

Parameters

table

Returns

Definition at line 101 of file xdrtable.c.

◆ db__recv_table_definition()

int db__recv_table_definition ( dbTable ** table )

Receive table definition.

Parameters

[out] table

Returns

Definition at line 51 of file xdrtable.c.

◆ db__recv_token()

int db__recv_token ( dbToken * token )

Receive token.

Parameters

token

Returns

Definition at line 36 of file xdrtoken.c.

References db__recv_int().

◆ db__recv_value()

int db__recv_value	(	dbValue *	value,
		int	Ctype
	)

Receive value.

Parameters

value
Ctype

Returns

Definition at line 62 of file xdrvalue.c.

References _, _db_value::d, DB_C_TYPE_DATETIME, DB_C_TYPE_DOUBLE, DB_C_TYPE_INT, DB_C_TYPE_STRING, db_error(), DB_FAILED, DB_OK, DB_RECV_CHAR, DB_RECV_DATETIME, DB_RECV_DOUBLE, DB_RECV_INT, DB_RECV_STRING, _db_value::i, _db_value::isNull, _db_value::s, and _db_value::t.

Referenced by db__recv_column_default_value(), and db__recv_column_value().

◆ db__send_char()

int db__send_char ( int d )

?

Parameters

d

Returns

Definition at line 24 of file xdrchar.c.

◆ db__send_column_default_value()

int db__send_column_default_value ( dbColumn * column )

Send column default value.

Parameters

column pointer to dbColumn

Returns

Definition at line 107 of file xdrcolumn.c.

References db__send_value(), db_get_column_default_value(), db_get_column_sqltype(), and db_sqltype_to_Ctype().

◆ db__send_column_definition()

int db__send_column_definition ( dbColumn * column )

Send column definition.

Parameters

column pointer to dbColumn

Returns: DB_OK

Definition at line 25 of file xdrcolumn.c.

References _db_column::columnName, _db_column::dataLen, DB_OK, DB_SEND_CHAR, DB_SEND_COLUMN_DEFAULT_VALUE, DB_SEND_INT, DB_SEND_STRING, _db_column::description, _db_column::hasDefaultValue, _db_column::hostDataType, _db_column::nullAllowed, _db_column::precision, _db_column::scale, _db_column::select, _db_column::sqlDataType, _db_column::update, and _db_column::useDefaultValue.

◆ db__send_column_value()

int db__send_column_value ( dbColumn * column )

Send column value.

Parameters

column pointer to dbColumn

Returns

Definition at line 81 of file xdrcolumn.c.

References db__send_value(), db_get_column_sqltype(), db_get_column_value(), and db_sqltype_to_Ctype().

◆ db__send_Cstring()

int db__send_Cstring ( const char * s )

Send C string.

Parameters

s

Returns

Definition at line 150 of file xdrstring.c.

◆ db__send_datetime()

int db__send_datetime ( dbDateTime * t )

Send datetime.

Parameters

t	pointer to dbDateTime

Returns: DB_OK

Definition at line 25 of file xdrdatetime.c.

References DB_OK, DB_SEND_CHAR, DB_SEND_DOUBLE, DB_SEND_INT, and t.

◆ db__send_double()

int db__send_double ( double d )

Send double.

Parameters

d

Returns

Definition at line 24 of file xdrdouble.c.

◆ db__send_double_array()

int db__send_double_array	(	const double *	x,
		int	n
	)

Send double array.

Parameters

x
n

Returns

Definition at line 63 of file xdrdouble.c.

References db__send(), DB_OK, DB_PROTOCOL_ERR, db_protocol_error(), and x.

◆ db__send_failure()

int db__send_failure ( void )

Send failure code.

Returns: DB_OK

Definition at line 37 of file ret_codes.c.

References DB_FAILED, db_get_error_msg(), DB_OK, DB_SEND_C_STRING, and DB_SEND_INT.

◆ db__send_float()

int db__send_float ( float d )

Send float.

Parameters

d

Returns

Definition at line 24 of file xdrfloat.c.

◆ db__send_float_array()

int db__send_float_array	(	const float *	x,
		int	n
	)

Send float array.

Parameters

x
n

Returns

Definition at line 65 of file xdrfloat.c.

References db__send(), DB_OK, DB_PROTOCOL_ERR, db_protocol_error(), and x.

◆ db__send_handle()

int db__send_handle ( dbHandle * handle )

Send handle.

Parameters

handle

Returns

Definition at line 25 of file xdrhandle.c.

References DB_OK, DB_SEND_STRING, _db_handle::dbName, and _db_handle::dbSchema.

◆ db__send_index()

int db__send_index ( dbIndex * index )

Send index.

Parameters

index

Returns

Definition at line 25 of file xdrindex.c.

References _db_index::columnNames, DB_OK, DB_SEND_CHAR, DB_SEND_INT, DB_SEND_STRING, _db_index::indexName, _db_index::numColumns, _db_index::tableName, and _db_index::unique.

◆ db__send_index_array()

int db__send_index_array	(	dbIndex *	list,
		int	count
	)

Send index array.

Parameters

list
count

Returns

Definition at line 50 of file xdrindex.c.

References count, DB_OK, DB_SEND_INDEX, and DB_SEND_INT.

◆ db__send_int()

int db__send_int ( int n )

Send integer.

Parameters

n

Returns

Definition at line 24 of file xdrint.c.

References db__send(), DB_OK, DB_PROTOCOL_ERR, and db_protocol_error().

Referenced by db__send_procedure_not_implemented(), db__send_procedure_ok(), and db__send_token().

◆ db__send_int_array()

int db__send_int_array	(	const int *	x,
		int	n
	)

Send integer array.

Parameters

x
n

Returns

Definition at line 65 of file xdrint.c.

References db__send(), DB_OK, DB_PROTOCOL_ERR, db_protocol_error(), and x.

◆ db__send_procedure_not_implemented()

int db__send_procedure_not_implemented ( int n )

?

Parameters

n

Returns

Definition at line 81 of file xdrprocedure.c.

References db__send_int().

◆ db__send_procedure_ok()

int db__send_procedure_ok ( int n )

?

Parameters

n

Returns

Definition at line 69 of file xdrprocedure.c.

References db__send_int().

◆ db__send_short()

int db__send_short ( int n )

Send short.

Parameters

n

Returns

Definition at line 25 of file xdrshort.c.

References DB_OK.

◆ db__send_short_array()

int db__send_short_array	(	const short *	x,
		int	n
	)

Send short array.

Parameters

x
n

Returns

Definition at line 67 of file xdrshort.c.

References db__send(), DB_OK, DB_PROTOCOL_ERR, db_protocol_error(), and x.

◆ db__send_string()

int db__send_string ( dbString * x )

Send string.

Parameters

x

Returns

Definition at line 86 of file xdrstring.c.

References DB_OK.

◆ db__send_string_array()

int db__send_string_array	(	dbString *	a,
		int	count
	)

Send string array.

Parameters

a
count

Returns

Definition at line 26 of file xdrstring.c.

◆ db__send_success()

int db__send_success ( void )

Send success code.

Returns: DB_OK

Definition at line 26 of file ret_codes.c.

References DB_OK, and DB_SEND_INT.

◆ db__send_table_data()

int db__send_table_data ( dbTable * table )

Send table data.

Parameters

table

Returns

Definition at line 81 of file xdrtable.c.

◆ db__send_table_definition()

int db__send_table_definition ( dbTable * table )

Send table definition.

Parameters

table pointer to dbTable

Returns

Definition at line 26 of file xdrtable.c.

◆ db__send_token()

int db__send_token ( dbToken * token )

Send token.

Parameters

token

Returns

Definition at line 24 of file xdrtoken.c.

References db__send_int().

◆ db__send_value()

int db__send_value	(	dbValue *	value,
		int	Ctype
	)

Send value.

Parameters

value
Ctype

Returns

Definition at line 28 of file xdrvalue.c.

References _db_value::d, DB_C_TYPE_DATETIME, DB_C_TYPE_DOUBLE, DB_C_TYPE_INT, DB_C_TYPE_STRING, db_error(), DB_FAILED, DB_OK, DB_SEND_CHAR, DB_SEND_DATETIME, DB_SEND_DOUBLE, DB_SEND_INT, DB_SEND_STRING, _db_value::i, _db_value::isNull, _db_value::s, and _db_value::t.

Referenced by db__send_column_default_value(), and db__send_column_value().

◆ db__set_protocol_fds()

void db__set_protocol_fds	(	FILE *	send,
		FILE *	recv
	)

?

Parameters

send
recv

Definition at line 75 of file db/dbmi_base/xdr.c.

Referenced by db_add_column(), db_begin_transaction(), db_bind_update(), db_close_cursor(), db_close_database(), db_commit_transaction(), db_create_database(), db_create_index(), db_delete(), db_delete_database(), db_drop_column(), db_drop_index(), db_drop_table(), db_execute_immediate(), db_find_database(), db_get_num_rows(), db_grant_on_table(), db_gversion(), db_insert(), db_list_indexes(), db_list_tables(), db_open_database(), db_open_insert_cursor(), db_shutdown_driver(), and db_update().

◆ db__start_procedure_call()

int db__start_procedure_call ( int procnum )

? (client only)

Parameters

procnum

Returns

Definition at line 25 of file xdrprocedure.c.

References db_noproc_error(), DB_OK, DB_PROTOCOL_ERR, db_protocol_error(), DB_RECV_INT, DB_SEND_INT, and procnum.

◆ db__test_database_open()

int db__test_database_open ( void )

Test database connection.

Returns: 1 opened; 0 closed

Definition at line 45 of file driver_state.c.

References state.

Referenced by db_d_close_database(), and db_d_open_database().

◆ db_add_column()

int db_add_column	(	dbDriver *	driver,
		dbString *	tableName,
		dbColumn *	column
	)

Add column to table.

Parameters

driver	db driver
tableName	table name
column	new column description (dbColumn structure)

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 28 of file c_add_col.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_ADD_COLUMN, DB_RECV_RETURN_CODE, DB_SEND_COLUMN_DEFINITION, DB_SEND_STRING, and DB_START_PROCEDURE_CALL.

◆ db_alloc_cursor_column_flags()

int db_alloc_cursor_column_flags ( dbCursor * cursor )

Allocate columns' flags for cursor.

Parameters

cursor pointer to dbCursor

Returns: DB_OK on success; error code on failure

Definition at line 275 of file cursor.c.

◆ db_alloc_cursor_table()

int db_alloc_cursor_table	(	dbCursor *	cursor,
		int	ncols
	)

Allocate table for cursor.

Parameters

cursor	pointer to dbCursor
ncols	number of column in table

Returns: DB_OK on success; error code on error

Definition at line 38 of file cursor.c.

◆ db_alloc_dirent_array()

dbDirent* db_alloc_dirent_array ( int count )

Allocate dirent array.

Parameters

count number of entities in the array

Returns: pointer to dbDirent array; NULL on failure

Definition at line 163 of file dirent.c.

References count, db_calloc(), db_dirent(), db_init_string(), name, and NULL.

◆ db_alloc_handle_array()

dbHandle* db_alloc_handle_array ( int count )

Allocate array of handles.

Parameters

count number of handles in the array

Returns: pointer to first dbHandle in the array

Definition at line 109 of file handle.c.

References count, db_calloc(), and db_init_handle().

◆ db_alloc_index_array()

dbIndex* db_alloc_index_array ( int count )

Allocate index array.

Parameters

count number of items

Returns: pointer to allocated dbIndex array

Definition at line 73 of file db/dbmi_base/index.c.

References count, db_calloc(), db_init_index(), and list.

Referenced by db__recv_index_array().

◆ db_alloc_index_columns()

int db_alloc_index_columns	(	dbIndex *	index,
		int	ncols
	)

Allocate index columns.

Parameters

index	pointer to dbIndex
ncols	number of columns to be allocated

Returns: DB_OK

Definition at line 56 of file db/dbmi_base/index.c.

Referenced by db_create_index2().

◆ db_alloc_string_array()

dbString* db_alloc_string_array ( int count )

Allocate dbString array.

Parameters

count number of items to be allocated

Returns: pointer to 1st dbString in the array

Definition at line 181 of file string.c.

◆ 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.

Referenced by P_Create_Aux2_Table(), and P_Create_Aux4_Table().

◆ db_append_string()

int db_append_string	(	dbString *	x,
		const char *	s
	)

Append string to dbString.

Parameters

x	pointer to dbString
s	string to be appended

Returns: DB_OK on success; otherwise error code is returned

Definition at line 205 of file string.c.

Referenced by db_d_append_error(), db_d_report_error(), db_delete_table(), and P_Drop_Aux_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.

◆ db_auto_print_errors()

void db_auto_print_errors ( int flag )

Toggles printing of DBMI error messages.

Parameters

flag ?

Definition at line 247 of file db/dbmi_base/error.c.

◆ db_auto_print_protocol_errors()

void db_auto_print_protocol_errors ( int flag )

Set auto print protocol error.

Parameters

flag ?

Definition at line 258 of file db/dbmi_base/error.c.

◆ db_begin_transaction()

int db_begin_transaction ( dbDriver * driver )

Begin transaction.

Parameters

driver db driver

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 56 of file c_execute.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_BEGIN_TRANSACTION, DB_RECV_RETURN_CODE, and DB_START_PROCEDURE_CALL.

◆ db_bind_update()

int db_bind_update ( dbCursor * cursor )

?

Parameters

cursor db cursor

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file c_bindupdate.c.

References _db_cursor::column_flags, db__set_protocol_fds(), db_get_cursor_number_of_columns(), DB_OK, DB_PROC_BIND_UPDATE, DB_RECV_RETURN_CODE, DB_SEND_SHORT_ARRAY, DB_SEND_TOKEN, DB_START_PROCEDURE_CALL, _db_cursor::driver, _db_driver::recv, _db_driver::send, and _db_cursor::token.

◆ db_calloc()

void* db_calloc	(	int	n,
		int	m
	)

Allocate memory.

On failure is called db_memory_error().

Parameters

n	number of entities
m	entity size

Returns: pointer to allocated memory

Definition at line 69 of file db/dbmi_base/alloc.c.

Referenced by db_alloc_dirent_array(), db_alloc_handle_array(), and db_alloc_index_array().

◆ db_CatValArray_alloc()

int db_CatValArray_alloc	(	dbCatValArray *	arr,
		int	n
	)

Allocate dbCatValArray.

Todo:: return type void?

Parameters

arr	pointer to dbCatValArray
n	number of items

Returns: DB_OK

Definition at line 401 of file value.c.

References dbCatValArray::alloc, DB_OK, G_calloc, and dbCatValArray::value.

◆ db_CatValArray_free()

void db_CatValArray_free ( dbCatValArray * arr )

Free allocated dbCatValArray.

Parameters

arr	pointer to dbCatValArray

Definition at line 373 of file value.c.

References dbCatValArray::ctype, DB_C_TYPE_DATETIME, DB_C_TYPE_STRING, db_free(), db_free_string(), G_free(), dbCatValArray::n_values, dbCatVal::s, dbCatVal::t, dbCatVal::val, and dbCatValArray::value.

◆ db_CatValArray_get_value()

int db_CatValArray_get_value	(	dbCatValArray *	arr,
		int	key,
		dbCatVal **	cv
	)

Find value by key.

Parameters

	arr	dbCatValArray (key/value array)
	key	key value
[out]	cv	dbCatVal structure (key/value) to store within

Returns: DB_OK on success; DB_FAILED on error

Definition at line 465 of file db/dbmi_client/select.c.

◆ db_CatValArray_get_value_double()

int db_CatValArray_get_value_double	(	dbCatValArray *	arr,
		int	key,
		double *	val
	)

Find value (double) by key.

Parameters

	arr	dbCatValArray (key/value array)
	key	key value
[out]	val	found value (double)

Returns: DB_OK on success; DB_FAILED on error

Definition at line 515 of file db/dbmi_client/select.c.

◆ db_CatValArray_get_value_int()

int db_CatValArray_get_value_int	(	dbCatValArray *	arr,
		int	key,
		int *	val
	)

Find value (integer) by key.

Parameters

	arr	dbCatValArray (key/value array)
	key	key value
[out]	val	found value (integer)

Returns: DB_OK on success; DB_FAILED on error

Definition at line 490 of file db/dbmi_client/select.c.

◆ db_CatValArray_init()

void db_CatValArray_init ( dbCatValArray * arr )

Initialize dbCatValArray.

Parameters

arr	pointer to dbCatValArray to be initialized

Definition at line 361 of file value.c.

References dbCatValArray::alloc, dbCatValArray::n_values, NULL, and dbCatValArray::value.

◆ db_CatValArray_realloc()

int db_CatValArray_realloc	(	dbCatValArray *	arr,
		int	n
	)

Realloc dbCatValArray.

Todo:: return code void?

Parameters

arr	pointer to dbCatValArray
n	number of items

Returns: DB_OK

Definition at line 420 of file value.c.

References dbCatValArray::alloc, DB_OK, G_realloc, and dbCatValArray::value.

◆ db_CatValArray_sort()

void db_CatValArray_sort ( dbCatValArray * arr )

Sort key/value array by key.

Parameters

[in,out] arr dbCatValArray (key/value array)

Definition at line 417 of file db/dbmi_client/select.c.

References dbCatValArray::n_values, and dbCatValArray::value.

◆ db_CatValArray_sort_by_value()

int db_CatValArray_sort_by_value ( dbCatValArray * arr )

Sort key/value array by value.

Parameters

[in,out] arr dbCatValArray (key/value array)

Returns: DB_OK on success; DB_FAILED on error

Definition at line 430 of file db/dbmi_client/select.c.

References dbCatValArray::ctype, DB_C_TYPE_INT, dbCatValArray::n_values, and dbCatValArray::value.

◆ db_char_to_lowercase()

void db_char_to_lowercase ( char * s )

Convert character to lowercase.

Parameters

s	character to be modified

Definition at line 22 of file case.c.

◆ db_char_to_uppercase()

void db_char_to_uppercase ( char * s )

Convert character to uppercase.

Parameters

s	character to be modified

Definition at line 33 of file case.c.

◆ db_clear_error()

void db_clear_error ( void )

Clear error status.

Definition at line 170 of file db/dbmi_base/error.c.

◆ 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.

◆ db_close_cursor()

int db_close_cursor ( dbCursor * cursor )

Close cursor.

Parameters

cursor cursor to be close

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 27 of file c_close_cur.c.

References db__set_protocol_fds(), db_free_cursor(), DB_OK, DB_PROC_CLOSE_CURSOR, DB_RECV_RETURN_CODE, DB_SEND_TOKEN, DB_START_PROCEDURE_CALL, _db_cursor::driver, _db_driver::recv, _db_driver::send, and _db_cursor::token.

Referenced by db_get_table_number_of_rows().

◆ db_close_database()

int db_close_database ( dbDriver * driver )

Close database connection.

Parameters

driver db driver

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file c_closedb.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_CLOSE_DATABASE, DB_RECV_RETURN_CODE, and DB_START_PROCEDURE_CALL.

Referenced by db_close_database_shutdown_driver().

◆ db_close_database_shutdown_driver()

int db_close_database_shutdown_driver ( dbDriver * driver )

Close driver/database connection.

Parameters

driver db driver

Returns: DB_OK or DB_FAILED

Definition at line 61 of file db.c.

References db_close_database(), DB_FAILED, DB_OK, db_shutdown_driver(), and G_debug().

Referenced by db_delete_table(), db_get_table_number_of_rows(), V1_close_ogr(), V1_close_pg(), and Vect_cats_set_constraint().

◆ db_column_Ctype()

int db_column_Ctype	(	dbDriver *	driver,
		const char *	tab,
		const char *	col
	)

Get column ctype.

See db_sqltype_to_Ctype().

Supported types:

DB_C_TYPE_STRING
DB_C_TYPE_INT
DB_C_TYPE_DOUBLE
DB_C_TYPE_DATETIME

Parameters

driver	DB driver
tab	table name
col	column name

Returns: column Ctype; -1 on error

Definition at line 99 of file dbmi_client/column.c.

◆ db_column_sqltype()

int db_column_sqltype	(	dbDriver *	driver,
		const char *	tab,
		const char *	col
	)

Get column sqltype.

See db_sqltype_name().

Supported types:

DB_SQL_TYPE_UNKNOWN
DB_SQL_TYPE_CHARACTER
DB_SQL_TYPE_SMALLINT
DB_SQL_TYPE_INTEGER
DB_SQL_TYPE_REAL
DB_SQL_TYPE_DOUBLE_PRECISION
DB_SQL_TYPE_DECIMAL
DB_SQL_TYPE_NUMERIC
DB_SQL_TYPE_DATE
DB_SQL_TYPE_TIME
DB_SQL_TYPE_TIMESTAMP
DB_SQL_TYPE_INTERVAL
DB_SQL_TYPE_TEXT
DB_SQL_TYPE_SERIAL

Parameters

driver	DB driver
tab	table name
col	column name

Returns: column sqltype; -1 on error

Definition at line 51 of file dbmi_client/column.c.

◆ db_commit_transaction()

int db_commit_transaction ( dbDriver * driver )

Commit transaction.

Parameters

driver db driver

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 82 of file c_execute.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_COMMIT_TRANSACTION, DB_RECV_RETURN_CODE, and DB_START_PROCEDURE_CALL.

◆ db_convert_column_default_value_to_string()

int db_convert_column_default_value_to_string	(	dbColumn *	column,
		dbString *	string
	)

?

Parameters

column	pointer to dbColumn
string	pointer to dbString

Returns: ?

Definition at line 80 of file columnfmt.c.

References db_convert_value_to_string(), db_get_column_default_value(), and db_get_column_sqltype().

Referenced by db_print_column_definition().

◆ db_convert_column_value_to_string()

int db_convert_column_value_to_string	(	dbColumn *	column,
		dbString *	string
	)

?

Parameters

column	pointer to dbColumn
string	pointer to dbString

Returns: ?

Definition at line 62 of file columnfmt.c.

References db_convert_value_to_string(), db_get_column_sqltype(), and db_get_column_value().

◆ db_convert_Cstring_to_column_default_value()

int db_convert_Cstring_to_column_default_value	(	const char *	Cstring,
		dbColumn *	column
	)

?

Parameters

Cstring	string buffer
column	pointer to dbColumn

Returns: ?

Definition at line 43 of file columnfmt.c.

References db_convert_Cstring_to_value(), db_get_column_default_value(), and db_get_column_sqltype().

◆ db_convert_Cstring_to_column_value()

int db_convert_Cstring_to_column_value	(	const char *	Cstring,
		dbColumn *	column
	)

?

Parameters

Cstring	string buffer
column	pointer to dbColumn

Returns: ?

Definition at line 25 of file columnfmt.c.

References db_convert_Cstring_to_value(), db_get_column_sqltype(), and db_get_column_value().

◆ db_convert_Cstring_to_value()

int db_convert_Cstring_to_value	(	const char *	Cstring,
		int	sqltype,
		dbValue *	value
	)

Convert string to value.

Parameters

	Cstring	string buffer
	sqltype	SQL data type
[out]	value	pointer to dbValue

Returns: DB_OK on success; DB_FAILED on error

Definition at line 31 of file valuefmt.c.

Referenced by db_convert_Cstring_to_column_default_value(), and db_convert_Cstring_to_column_value().

◆ db_convert_Cstring_to_value_datetime()

int db_convert_Cstring_to_value_datetime	(	const char *	buf,
		int	sqltype,
		dbValue *	value
	)

Convert datetime string to value.

The format of buf must be as follows

buf == "CURRENT" in a case-insignificant fashion value is marked as current
sqltype == DB_SQL_TYPE_DATE "year*month*day"
sqltype == DB_SQL_TYPE_TIME "hour*minute*second"
sqltype == DB_SQL_TYPE_TIMESTAMP "year*month*day hour*minute*second"
otherwise the to and from markings in sqltype are used, where "*" represents any non-whitespace character

Parameters

	buf	input string buffer
	sqltype	SQL data type
[out]	value	pointer to dbValue to be set

Returns: DB_OK

Definition at line 196 of file datetime.c.

References DB_DAY, DB_FRACTION, DB_HOUR, db_interval_range(), DB_MINUTE, DB_MONTH, db_nocase_compare(), DB_OK, DB_SECOND, db_set_value_datetime_current(), db_set_value_day(), db_set_value_hour(), db_set_value_minute(), db_set_value_month(), db_set_value_seconds(), db_set_value_year(), DB_SQL_TYPE_DATE, DB_SQL_TYPE_TIME, DB_SQL_TYPE_TIMESTAMP, and DB_YEAR.

◆ db_convert_value_datetime_into_string()

int db_convert_value_datetime_into_string	(	dbValue *	value,
		int	sqltype,
		dbString *	string
	)

Convert datetime value into string.

Parameters

	value	pointer to dbValue
	sqltype	SQL data type
[out]	string	pointer to dbString

Returns: DB_OK on success

Definition at line 31 of file datetime.c.

References db_get_value_day(), db_get_value_hour(), db_get_value_minute(), db_get_value_month(), db_get_value_seconds(), db_get_value_year(), db_interval_range(), DB_MONTH, db_set_string(), db_test_value_datetime_current(), and DB_YEAR.

Referenced by db_convert_value_to_string().

◆ db_convert_value_to_string()

int db_convert_value_to_string	(	dbValue *	value,
		int	sqltype,
		dbString *	string
	)

Convert value to string.

Parameters

	value	pointer to dbValue
	sqltype	SQL data type
[out]	string	pointer to dbString

Returns: DB_OK on success

Definition at line 68 of file valuefmt.c.

References _, DB_C_TYPE_DATETIME, DB_C_TYPE_DOUBLE, DB_C_TYPE_INT, DB_C_TYPE_STRING, db_convert_value_datetime_into_string(), db_error(), DB_FAILED, db_get_value_double(), db_get_value_int(), db_get_value_string(), db_set_string(), db_sqltype_to_Ctype(), db_test_value_isnull(), and G_trim_decimal().

Referenced by db_convert_column_default_value_to_string(), and db_convert_column_value_to_string().

◆ db_copy_column()

dbColumn* db_copy_column	(	dbColumn *	dest,
		dbColumn *	src
	)

Copy a db column from source to destination.

Parameters

src	The column to copy from
dest	An allocated column to copy to which will be initialized. In case dest is NULL a new column will be allocated and returned

Returns: The pointer of copied/allocated column

Definition at line 472 of file dbmi_base/column.c.

◆ db_copy_dbmscap_entry()

void db_copy_dbmscap_entry	(	dbDbmscap *	dst,
		dbDbmscap *	src
	)

Copy dbmscap entry.

Parameters

dst	destination
src	source

Definition at line 79 of file dbmscap.c.

◆ db_copy_string()

int db_copy_string	(	dbString *	dst,
		const dbString *	src
	)

Copy dbString.

Parameters

dst	destination dbString
src	source dbString

Returns: DB_OK on success; DB_ERR code on error

Definition at line 230 of file string.c.

◆ db_copy_table()

int db_copy_table	(	const char *	from_drvname,
		const char *	from_dbname,
		const char *	from_tblname,
		const char *	to_drvname,
		const char *	to_dbname,
		const char *	to_tblname
	)

Copy a table.

Parameters

from_drvname	name of driver from table is copied
from_dbname	name of database from table is copied
from_tblname	name of table to be copied
to_drvname	name of driver to - where table is copied to
to_dbname	name of database to - where table is copied to
to_tblname	name of copied table

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 443 of file copy_tab.c.

◆ db_copy_table_by_ints()

int db_copy_table_by_ints	(	const char *	from_drvname,
		const char *	from_dbname,
		const char *	from_tblname,
		const char *	to_drvname,
		const char *	to_dbname,
		const char *	to_tblname,
		const char *	selcol,
		int *	ivals,
		int	nvals
	)

Copy a table (by keys)

Parameters

from_drvname	name of driver from table is copied
from_dbname	name of database from table is copied
from_tblname	name of table to be copied
to_drvname	name of driver to - where table is copied to
to_dbname	name of database to - where table is copied to
to_tblname	name of copied table
selcol	name of column used to select records by values in ivals or NULL
ivals	pointer to array of integer values or NULL
nvals	number of values in ivals

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 513 of file copy_tab.c.

◆ db_copy_table_select()

int db_copy_table_select	(	const char *	from_drvname,
		const char *	from_dbname,
		const char *	from_tblname,
		const char *	to_drvname,
		const char *	to_dbname,
		const char *	to_tblname,
		const char *	select
	)

Copy a table (by select statement)

Parameters

from_drvname	name of driver from table is copied
from_dbname	name of database from table is copied
from_dbname	name of table to be copied
to_drvname	name of driver to - where table is copied to
to_dbname	name of database to - where table is copied to
to_tblname	name of copied table
select	full select statement

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 488 of file copy_tab.c.

◆ db_copy_table_where()

int db_copy_table_where	(	const char *	from_drvname,
		const char *	from_dbname,
		const char *	from_tblname,
		const char *	to_drvname,
		const char *	to_dbname,
		const char *	to_tblname,
		const char *	where
	)

Copy a table (by where statement)

Parameters

from_drvname	name of driver from table is copied
from_dbname	name of database from table is copied
from_tblname	name of table to be copied
to_drvname	name of driver to - where table is copied to
to_dbname	name of database to - where table is copied to
to_tblname	name of copied table
where	WHERE SQL condition (without where key word)

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 465 of file copy_tab.c.

◆ db_copy_value()

void db_copy_value	(	dbValue *	dst,
		dbValue *	src
	)

Copy value.

Copy value from src to destination

Parameters

dst	destination dbValue
src	source dbValue

Definition at line 340 of file value.c.

◆ db_create_database()

int db_create_database	(	dbDriver *	driver,
		dbHandle *	handle
	)

Create database.

Parameters

driver	db driver
handle	handle

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 27 of file c_createdb.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_CREATE_DATABASE, DB_RECV_RETURN_CODE, DB_SEND_HANDLE, and DB_START_PROCEDURE_CALL.

◆ db_create_index()

int db_create_index	(	dbDriver *	driver,
		dbIndex *	index
	)

Create index.

Parameters

driver	db driver
index	index info (pointer to dbIndex structure)

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 28 of file c_create_idx.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_CREATE_INDEX, DB_RECV_RETURN_CODE, DB_RECV_STRING, DB_SEND_INDEX, DB_START_PROCEDURE_CALL, and _db_index::indexName.

Referenced by db_create_index2().

◆ db_create_index2()

int db_create_index2	(	dbDriver *	driver,
		const char *	table_name,
		const char *	column_name
	)

Create unique index.

Parameters

driver	db driver
table_name	table name
column_name	column name (where to create index)

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 61 of file c_create_idx.c.

References db_alloc_index_columns(), db_create_index(), db_free_index(), db_init_index(), db_set_index_column_name(), db_set_index_name(), db_set_index_table_name(), db_set_index_type_unique(), and NULL.

◆ db_create_table()

int db_create_table	(	dbDriver *	driver,
		dbTable *	table
	)

Create table.

Parameters

driver	db driver
table	table description (pointer to dbTable structure)

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 27 of file c_create_tab.c.

Referenced by P_Create_Aux2_Table(), and P_Create_Aux4_Table().

◆ db_Cstring_to_lowercase()

void db_Cstring_to_lowercase ( char * s )

Convert string to lowercase.

Parameters

s	string buffer to be modified

Definition at line 44 of file case.c.

◆ db_Cstring_to_uppercase()

void db_Cstring_to_uppercase ( char * s )

Convert string to lowercase.

Parameters

s	string buffer to be modified

Definition at line 55 of file case.c.

◆ db_d_add_column()

int db_d_add_column ( void )

Add column to table.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_add_col.c.

References db_driver_add_column, db_free_column(), db_free_string(), db_init_column(), db_init_string(), DB_OK, DB_RECV_COLUMN_DEFINITION, DB_RECV_STRING, DB_SEND_FAILURE, DB_SEND_SUCCESS, and name.

◆ db_d_append_error()

void db_d_append_error	(	const char *	,
			...
	)

◆ db_d_begin_transaction()

int db_d_begin_transaction ( void )

Begin transaction.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 56 of file d_execute.c.

References db_driver_begin_transaction, DB_OK, DB_SEND_FAILURE, and DB_SEND_SUCCESS.

◆ db_d_bind_update()

int db_d_bind_update ( void )

ADD.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 25 of file d_bindupdate.c.

◆ db_d_close_cursor()

int db_d_close_cursor ( void )

Close cursor.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_close_cur.c.

References db__drop_cursor_from_driver_state(), db_driver_close_cursor, db_drop_token(), db_error(), DB_FAILED, db_find_token(), db_free(), db_free_cursor(), DB_OK, DB_RECV_TOKEN, DB_SEND_FAILURE, DB_SEND_SUCCESS, and NULL.

◆ db_d_close_database()

int db_d_close_database ( void )

Close database connection.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 25 of file d_closedb.c.

References db__close_all_cursors(), db__init_driver_state(), db__mark_database_closed(), db__test_database_open(), db_driver_close_database, db_error(), DB_OK, DB_SEND_FAILURE, and DB_SEND_SUCCESS.

◆ db_d_commit_transaction()

int db_d_commit_transaction ( void )

Commit transaction.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 80 of file d_execute.c.

References db_driver_commit_transaction, DB_OK, DB_SEND_FAILURE, and DB_SEND_SUCCESS.

◆ db_d_create_database()

int db_d_create_database ( void )

Create database.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_createdb.c.

References db_driver_create_database, db_free_handle(), db_init_handle(), DB_OK, DB_RECV_HANDLE, DB_SEND_FAILURE, and DB_SEND_SUCCESS.

◆ db_d_create_index()

int db_d_create_index ( void )

Create index.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_create_idx.c.

References db_driver_create_index, db_free_index(), db_init_index(), DB_OK, DB_RECV_INDEX, DB_SEND_FAILURE, DB_SEND_STRING, DB_SEND_SUCCESS, and _db_index::indexName.

◆ db_d_create_table()

int db_d_create_table ( void )

Create table.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_create_tab.c.

◆ db_d_delete()

int db_d_delete ( void )

Delete record (?)

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 25 of file d_delete.c.

References db_driver_delete, db_error(), DB_FAILED, db_find_token(), DB_OK, DB_RECV_TOKEN, DB_SEND_FAILURE, DB_SEND_SUCCESS, db_test_cursor_type_update(), and NULL.

◆ db_d_delete_database()

int db_d_delete_database ( void )

Delete database.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_deletedb.c.

References db_driver_delete_database, db_free_handle(), db_init_handle(), DB_OK, DB_RECV_HANDLE, DB_SEND_FAILURE, and DB_SEND_SUCCESS.

◆ db_d_describe_table()

int db_d_describe_table ( void )

Describe table.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_desc_table.c.

◆ db_d_drop_column()

int db_d_drop_column ( void )

Drop column.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_drop_col.c.

References db_driver_drop_column, db_free_string(), db_init_string(), DB_OK, DB_RECV_STRING, DB_SEND_FAILURE, and DB_SEND_SUCCESS.

◆ db_d_drop_index()

int db_d_drop_index ( void )

Drop index.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_drop_index.c.

References db_driver_drop_index, db_free_string(), db_init_string(), DB_OK, DB_RECV_STRING, DB_SEND_FAILURE, DB_SEND_SUCCESS, and name.

◆ db_d_drop_table()

int db_d_drop_table ( void )

Drop table.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_drop_tab.c.

References db_driver_drop_table, db_free_string(), db_init_string(), DB_OK, DB_RECV_STRING, DB_SEND_FAILURE, DB_SEND_SUCCESS, and name.

◆ db_d_execute_immediate()

int db_d_execute_immediate ( void )

Execute SQL statements.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_execute.c.

References db_driver_execute_immediate, db_free_string(), db_init_string(), DB_OK, DB_RECV_STRING, DB_SEND_FAILURE, and DB_SEND_SUCCESS.

◆ db_d_fetch()

int db_d_fetch ( void )

Fetch data.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 27 of file d_fetch.c.

◆ db_d_find_database()

int db_d_find_database ( void )

Find database.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_finddb.c.

References db_driver_find_database, db_free_handle(), db_init_handle(), DB_OK, DB_RECV_HANDLE, DB_SEND_FAILURE, DB_SEND_HANDLE, DB_SEND_INT, and DB_SEND_SUCCESS.

◆ db_d_get_num_rows()

int db_d_get_num_rows ( void )

Get number of selected rows.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 25 of file d_rows.c.

References db_driver_get_num_rows, db_find_token(), DB_OK, DB_RECV_TOKEN, DB_SEND_FAILURE, DB_SEND_INT, and DB_SEND_SUCCESS.

◆ db_d_grant_on_table()

int db_d_grant_on_table ( void )

Grant privileges on table.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_priv.c.

References db_driver_grant_on_table, db_free_string(), db_init_string(), DB_OK, DB_RECV_INT, DB_RECV_STRING, DB_SEND_FAILURE, and DB_SEND_SUCCESS.

◆ db_d_init_error()

void db_d_init_error ( const char * name )

Init error message for DB driver.

Initialize prefix

Parameters

name	driver name (eg. "SQLite"))

Definition at line 47 of file d_error.c.

References db_init_string(), G_debug(), G_malloc, init(), name, st, and strcpy.

◆ db_d_insert()

int db_d_insert ( void )

Insert new record into table.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 25 of file d_insert.c.

References db_driver_insert, db_error(), DB_FAILED, db_find_token(), DB_OK, DB_RECV_TABLE_DATA, DB_RECV_TOKEN, DB_SEND_FAILURE, DB_SEND_SUCCESS, db_test_cursor_type_insert(), NULL, and _db_cursor::table.

◆ db_d_list_databases()

int db_d_list_databases ( void )

List databases.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_listdb.c.

◆ db_d_list_indexes()

int db_d_list_indexes ( void )

List indexes.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_list_idx.c.

References count, db_driver_list_indexes, db_free_index_array(), db_free_string(), db_init_string(), DB_OK, DB_RECV_STRING, DB_SEND_FAILURE, DB_SEND_INDEX_ARRAY, DB_SEND_SUCCESS, and list.

◆ db_d_list_tables()

int db_d_list_tables ( void )

List available tables for given connection.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 25 of file d_list_tabs.c.

References count, db_driver_list_tables, DB_OK, DB_RECV_INT, DB_SEND_FAILURE, DB_SEND_STRING_ARRAY, and DB_SEND_SUCCESS.

◆ db_d_open_database()

int db_d_open_database ( void )

Open database connection.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_opendb.c.

References db__mark_database_open(), db__test_database_open(), db_driver_open_database, db_error(), db_free_handle(), db_get_handle_dbname(), db_get_handle_dbschema(), db_init_handle(), DB_OK, DB_RECV_HANDLE, DB_SEND_FAILURE, and DB_SEND_SUCCESS.

◆ db_d_open_insert_cursor()

int db_d_open_insert_cursor ( void )

Open insert cursor.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 25 of file d_openinsert.c.

◆ db_d_open_select_cursor()

int db_d_open_select_cursor ( void )

Open select cursor.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_openselect.c.

◆ db_d_open_update_cursor()

int db_d_open_update_cursor ( void )

Open update cursor.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file d_openupdate.c.

◆ db_d_report_error()

void void db_d_report_error ( void )

Report error message for DB driver.

Definition at line 94 of file d_error.c.

References db_append_string(), db_error(), db_get_string(), init(), and st.

◆ db_d_update()

int db_d_update ( void )

?

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 25 of file d_update.c.

References db_driver_update, db_error(), DB_FAILED, db_find_token(), DB_OK, DB_RECV_TABLE_DATA, DB_RECV_TOKEN, DB_SEND_FAILURE, DB_SEND_SUCCESS, db_test_cursor_any_column_flag(), db_test_cursor_type_update(), NULL, and _db_cursor::table.

◆ db_d_version()

int db_d_version ( void )

Get version info.

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 24 of file d_version.c.

References DB_OK, DB_SEND_C_STRING, DB_SEND_SUCCESS, and DB_VERSION.

◆ db_dbmscap_filename()

const char* db_dbmscap_filename ( void )

Get dbmscap file name.

Returns: pointer to string with file name

Definition at line 57 of file dbmscap.c.

Referenced by db_read_dbmscap().

◆ db_debug()

void db_debug ( const char * s )

Print debug message.

Parameters

s	debug message

Definition at line 226 of file db/dbmi_base/error.c.

◆ db_debug_off()

void db_debug_off ( void )

Turn off debugging.

Definition at line 216 of file db/dbmi_base/error.c.

◆ db_debug_on()

void db_debug_on ( void )

Turn on debugging.

Definition at line 208 of file db/dbmi_base/error.c.

◆ db_delete()

int db_delete ( dbCursor * cursor )

Delete record (?)

Parameters

cursor db cursor

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file c_delete.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_DELETE, DB_RECV_RETURN_CODE, DB_SEND_TOKEN, DB_START_PROCEDURE_CALL, _db_cursor::driver, _db_driver::recv, _db_driver::send, and _db_cursor::token.

◆ db_delete_database()

int db_delete_database	(	dbDriver *	driver,
		dbHandle *	handle
	)

Delete database.

Parameters

driver	db driver
handle	handle info

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 27 of file c_deletedb.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_DELETE_DATABASE, DB_RECV_RETURN_CODE, DB_SEND_HANDLE, and DB_START_PROCEDURE_CALL.

◆ db_delete_table()

int db_delete_table	(	const char *	drvname,
		const char *	dbname,
		const char *	tblname
	)

Delete table.

Parameters

drvname	driver name
dbname	database name
tblname	table name

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 29 of file delete_tab.c.

References _, db_append_string(), db_close_database_shutdown_driver(), db_execute_immediate(), DB_FAILED, db_get_string(), db_init_string(), DB_OK, db_set_string(), db_start_driver_open_database(), driver, G_debug(), G_warning(), and NULL.

◆ db_describe_table()

int db_describe_table	(	dbDriver *	driver,
		dbString *	name,
		dbTable **	table
	)

Describe table.

Parameters

	driver	db driver
	name	table name
[out]	table	pointer to dbTable structure

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 28 of file c_desc_table.c.

◆ db_dirent()

dbDirent* db_dirent	(	const char *	dirname,
		int *	n
	)

Read directory and build an array of dbDirent's.

Append one entry with name = NULL to mark end of array

Parameters

	dirname	directory name
[out]	n	number of entities

Returns: pointer to dbDirent; NULL on error

Definition at line 49 of file dirent.c.

References count, and db_dirent().

Referenced by db_alloc_dirent_array(), db_dirent(), and db_free_dirent_array().

◆ db_double_quote_string()

void db_double_quote_string ( dbString * src )

Replace each ' is replaced by ''.

Parameters

src	pointer to dbString

Definition at line 240 of file string.c.

◆ db_driver()

int db_driver	(	int	,
		char **
	)

◆ db_driver_mkdir()

int db_driver_mkdir	(	const char *	path,
		int	mode,
		int	parentdirs
	)

Create db directory.

Parameters

path	full path
mode	mode (unused, defaults to chmod 0777 on non-Windows systems)
parentdirs	parent directories

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 36 of file d_mkdir.c.

◆ db_drop_column()

int db_drop_column	(	dbDriver *	driver,
		dbString *	tableName,
		dbString *	columnName
	)

Drop column.

Parameters

driver	db driver
tableName	table name
columnName	column name to be dropped

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 28 of file c_drop_col.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_DROP_COLUMN, DB_RECV_RETURN_CODE, DB_SEND_STRING, and DB_START_PROCEDURE_CALL.

◆ db_drop_index()

int db_drop_index	(	dbDriver *	driver,
		dbString *	name
	)

Drop index.

Parameters

driver	db driver
name	index name

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 27 of file c_drop_index.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_DROP_INDEX, DB_RECV_RETURN_CODE, DB_SEND_STRING, DB_START_PROCEDURE_CALL, and name.

◆ db_drop_table()

int db_drop_table	(	dbDriver *	driver,
		dbString *	name
	)

Drop table.

Parameters

driver	db driver
name	table name to be dropped

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 28 of file c_drop_tab.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_DROP_TABLE, DB_RECV_RETURN_CODE, DB_SEND_STRING, DB_START_PROCEDURE_CALL, and name.

◆ db_drop_token()

void db_drop_token ( dbToken token )

Drop token.

Parameters

token pointer to dbToken

Definition at line 42 of file db/dbmi_base/token.c.

References count, and NONE.

Referenced by db_d_close_cursor().

◆ db_enlarge_string()

int db_enlarge_string	(	dbString *	x,
		int	len
	)

Enlarge dbString.

Parameters

x	pointer to dbString
len	requested string size

Returns: DB_OK on success; DB_MEMORY_ERR on error

Definition at line 120 of file string.c.

References DB_MEMORY_ERR, DB_OK, db_realloc(), NULL, and x.

◆ db_error()

void db_error ( const char * s )

Report error message.

Parameters

s	error message (can be NULL)

Definition at line 69 of file db/dbmi_base/error.c.

Referenced by db__recv_value(), db__send_value(), db_convert_value_to_string(), db_d_close_cursor(), db_d_close_database(), db_d_delete(), db_d_insert(), db_d_open_database(), db_d_report_error(), db_d_update(), db_get_index_column_name(), db_memory_error(), db_noproc_error(), db_procedure_not_implemented(), and db_set_index_column_name().

◆ db_execute_immediate()

int db_execute_immediate	(	dbDriver *	driver,
		dbString *	SQLstatement
	)

Execute SQL statements.

Parameters

driver	db driver
SQLstatement	SQL statement (alter, update, ...)

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 27 of file c_execute.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_EXECUTE_IMMEDIATE, DB_RECV_RETURN_CODE, DB_SEND_STRING, and DB_START_PROCEDURE_CALL.

Referenced by db_delete_table(), and P_Drop_Aux_Table().

◆ db_fetch()

int db_fetch	(	dbCursor *	cursor,
		int	position,
		int *	more
	)

Fetch data from open cursor.

Parameters

	cursor	pointer to dbCursor
	position	cursor position
[out]	more	get more (0 for no data to be fetched)

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 28 of file c_fetch.c.

◆ db_find_database()

int db_find_database	(	dbDriver *	driver,
		dbHandle *	handle,
		int *	found
	)

Find database.

Parameters

	driver	db driver
	handle	handle info
[out]	found	if non-zero database found

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 29 of file c_finddb.c.

References db__set_protocol_fds(), db_free_handle(), db_get_handle_dbname(), db_get_handle_dbschema(), DB_OK, DB_PROC_FIND_DATABASE, DB_RECV_HANDLE, DB_RECV_INT, DB_RECV_RETURN_CODE, DB_SEND_HANDLE, db_set_handle(), and DB_START_PROCEDURE_CALL.

◆ db_find_token()

dbAddress db_find_token ( dbToken token )

Find token.

Parameters

token pointer to dbToken

Returns: dbAddress; NULL if no token found

Definition at line 30 of file db/dbmi_base/token.c.

References count, and NONE.

Referenced by db_d_close_cursor(), db_d_delete(), db_d_get_num_rows(), db_d_insert(), and db_d_update().

◆ db_free()

void db_free ( void * s )

Free allocated memory.

Parameters

s	pointer to memory to be freed

Definition at line 111 of file db/dbmi_base/alloc.c.

Referenced by db__close_all_cursors(), db__mark_database_closed(), db_CatValArray_free(), db_d_close_cursor(), db_free_cursor_column_flags(), db_free_dirent_array(), db_free_handle_array(), db_free_index_array(), db_free_string(), and db_shutdown_driver().

◆ db_free_column()

void db_free_column ( dbColumn * column )

Frees column structure.

Parameters

column pointer to dbColumn

Definition at line 454 of file dbmi_base/column.c.

References _db_column::columnName, db_free_string(), _db_column::defaultValue, _db_column::description, _db_value::s, and _db_column::value.

Referenced by db_d_add_column().

◆ db_free_cursor()

void db_free_cursor ( dbCursor * cursor )

Free allocated dbCursor.

Parameters

cursor pointer to dbCursor

Definition at line 51 of file cursor.c.

References _db_cursor::column_flags, db_free_cursor_column_flags(), db_free_table(), db_init_cursor(), and _db_cursor::table.

Referenced by db_close_cursor(), and db_d_close_cursor().

◆ db_free_cursor_column_flags()

void db_free_cursor_column_flags ( dbCursor * cursor )

Free columns' flags of cursor.

Parameters

cursor pointer to dbCursor

Definition at line 294 of file cursor.c.

References _db_cursor::column_flags, db_free(), and NULL.

Referenced by db_free_cursor().

◆ db_free_dbmscap()

void db_free_dbmscap ( dbDbmscap * list )

Free dbmscap.

Parameters

list	pointer to dbDbmscap

Definition at line 262 of file dbmscap.c.

◆ db_free_dirent_array()

void db_free_dirent_array	(	dbDirent *	db_dirent,
		int	count
	)

Free dbDirent.

Parameters

db_dirent	pointer to dbDirent
count	number of entities in the array

Definition at line 114 of file dirent.c.

References count, db_dirent(), db_free(), db_free_string(), and name.

◆ db_free_handle()

void db_free_handle ( dbHandle * handle )

Free dbHandle structure.

Parameters

handle pointer to dbHandle

Definition at line 79 of file handle.c.

References db_free_string(), _db_handle::dbName, and _db_handle::dbSchema.

Referenced by db_d_create_database(), db_d_delete_database(), db_d_find_database(), db_d_open_database(), db_find_database(), and db_free_handle_array().

◆ db_free_handle_array()

void db_free_handle_array	(	dbHandle *	handle,
		int	count
	)

Free array of handles.

Parameters

handle	pointer to first dbHandle in the array
count	number of handles in the array

Definition at line 91 of file handle.c.

References count, db_free(), and db_free_handle().

◆ db_free_index()

void db_free_index ( dbIndex * index )

Free allocated dbIndex.

Parameters

index pointer to dbIndex to be freed

Definition at line 39 of file db/dbmi_base/index.c.

References _db_index::columnNames, db_free_string(), db_free_string_array(), db_init_index(), _db_index::indexName, _db_index::numColumns, and _db_index::tableName.

Referenced by db_create_index2(), db_d_create_index(), and db_free_index_array().

◆ db_free_index_array()

void db_free_index_array	(	dbIndex *	list,
		int	count
	)

Free index array.

Parameters

list	dbIndex array
count	number of items in the array

Definition at line 92 of file db/dbmi_base/index.c.

References count, db_free(), and db_free_index().

Referenced by db_d_list_indexes().

◆ db_free_string()

void db_free_string ( dbString * x )

Free allocated space for dbString.

Parameters

x	pointer to dbString

Definition at line 150 of file string.c.

References db_free(), db_init_string(), and x.

Referenced by db_CatValArray_free(), db_d_add_column(), db_d_drop_column(), db_d_drop_index(), db_d_drop_table(), db_d_execute_immediate(), db_d_grant_on_table(), db_d_list_indexes(), db_free_column(), db_free_dirent_array(), db_free_handle(), db_free_index(), and db_grant_on_table().

◆ db_free_string_array()

void db_free_string_array	(	dbString *	a,
		int	n
	)

Free allocated dbString array.

Parameters

a	pointer to 1st dbString in the array
n	number of items in array

Definition at line 163 of file string.c.

Referenced by db_free_index().

◆ 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.

Referenced by db_free_cursor().

◆ db_get_column()

int db_get_column	(	dbDriver *	Driver,
		const char *	tname,
		const char *	cname,
		dbColumn **	Column
	)

Get column structure by table and column name.

Column is set to new dbColumn structure or NULL if column was not found

Parameters

	Driver	DB driver
	tname	table name
	cname	column name
[out]	Column	column structure to store within

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 124 of file dbmi_client/column.c.

◆ db_get_column_default_value()

dbValue* db_get_column_default_value ( dbColumn * column )

Returns column default value for given column structure.

Parameters

column pointer to dbColumn

Returns: pointer to dbValue

Definition at line 39 of file dbmi_base/column.c.

References _db_column::defaultValue.

Referenced by db__recv_column_default_value(), db__send_column_default_value(), db_convert_column_default_value_to_string(), and db_convert_Cstring_to_column_default_value().

◆ db_get_column_description()

const char* db_get_column_description ( dbColumn * column )

Returns column description for given column.

Parameters

column pointer to dbColumn

Returns: pointer to string with column's description

Definition at line 444 of file dbmi_base/column.c.

References db_get_string(), and _db_column::description.

Referenced by db_print_column_definition().

◆ db_get_column_host_type()

int db_get_column_host_type ( dbColumn * column )

Get column host type.

Parameters

column pointer to dbColumn

Returns: data type (see include/dbmi.h)

Definition at line 154 of file dbmi_base/column.c.

References _db_column::hostDataType.

◆ db_get_column_length()

int db_get_column_length ( dbColumn * column )

Get column's length.

Parameters

column pointer to dbColumn

Returns: length

Definition at line 303 of file dbmi_base/column.c.

References _db_column::dataLen.

Referenced by db_print_column_definition().

◆ db_get_column_name()

const char* db_get_column_name ( dbColumn * column )

Returns column name for given column.

Parameters

column pointer to dbColumn

Returns: pointer to string with column name

Definition at line 418 of file dbmi_base/column.c.

References _db_column::columnName, and db_get_string().

Referenced by db_print_column_definition().

◆ db_get_column_precision()

int db_get_column_precision ( dbColumn * column )

Get column precision.

Parameters

column pointer to dbColumn

Returns: precision

Definition at line 117 of file dbmi_base/column.c.

References _db_column::precision.

Referenced by db_print_column_definition().

◆ db_get_column_scale()

int db_get_column_scale ( dbColumn * column )

Get column scale.

Parameters

column pointer to dbColumn

Returns: scale

Definition at line 94 of file dbmi_base/column.c.

References _db_column::scale.

Referenced by db_print_column_definition().

◆ db_get_column_select_priv()

int db_get_column_select_priv ( dbColumn * column )

Get select privileges.

Parameters

column pointer to dbColumn

Returns: privileges

Definition at line 346 of file dbmi_base/column.c.

References _db_column::select.

◆ db_get_column_sqltype()

int db_get_column_sqltype ( dbColumn * column )

Returns column sqltype for column.

The function db_sqltype_name() returns sqltype description.

Parameters

column pointer to dbColumn

Returns: sql data type (see include/dbmi.h)

Definition at line 142 of file dbmi_base/column.c.

References _db_column::sqlDataType.

Referenced by db__recv_column_default_value(), db__recv_column_value(), db__send_column_default_value(), db__send_column_value(), db_convert_column_default_value_to_string(), db_convert_column_value_to_string(), db_convert_Cstring_to_column_default_value(), db_convert_Cstring_to_column_value(), and db_print_column_definition().

◆ db_get_column_update_priv()

int db_get_column_update_priv ( dbColumn * column )

Get update privileges.

Parameters

column pointer to dbColumn

Returns: privileges

Definition at line 378 of file dbmi_base/column.c.

References _db_column::update.

◆ db_get_column_value()

dbValue* db_get_column_value ( dbColumn * column )

Returns column value for given column structure.

Parameters

column pointer to dbColumn

Returns: pointer to dbValue

Definition at line 27 of file dbmi_base/column.c.

References _db_column::value.

Referenced by db__recv_column_value(), db__send_column_value(), db_convert_column_value_to_string(), and db_convert_Cstring_to_column_value().

◆ db_get_connection()

int db_get_connection ( dbConnection * connection )

Get default DB connection settings for the current mapset.

Parameters

[out] connection pointer to dbConnection to be modified

Returns: DB_OK; DB_FAILED

Definition at line 73 of file db/dbmi_base/connect.c.

References _db_connection::databaseName, DB_FAILED, db_get_login2(), DB_OK, _db_connection::driverName, G_getenv_nofatal2(), G_VAR_MAPSET, G_zero(), _db_connection::group, _db_connection::hostName, NULL, _db_connection::password, _db_connection::port, _db_connection::schemaName, and _db_connection::user.

◆ db_get_cursor_number_of_columns()

int db_get_cursor_number_of_columns ( dbCursor * cursor )

Get number of columns.

Parameters

cursor pointer to dbCursor

Definition at line 393 of file cursor.c.

Referenced by db_bind_update().

◆ db_get_cursor_table()

dbTable* db_get_cursor_table ( dbCursor * cursor )

Get table allocated by cursor.

Parameters

cursor pointer to dbCursor

Returns: pointer to dbTable

Definition at line 67 of file cursor.c.

References _db_cursor::table.

Referenced by db_open_insert_cursor().

◆ db_get_cursor_token()

dbToken db_get_cursor_token ( dbCursor * cursor )

Get cursor token.

Parameters

cursor pointer to dbCursor

Returns: pointer to dbToken

Definition at line 90 of file cursor.c.

References _db_cursor::token.

◆ db_get_default_database_name()

const char* db_get_default_database_name ( void )

Get database name from current DB connection settings.

Returns: pointer to database name; NULL if not set

Definition at line 43 of file db/dbmi_base/default_name.c.

References G_getenv_nofatal2(), G_store(), G_VAR_MAPSET, and NULL.

◆ db_get_default_driver_name()

const char* db_get_default_driver_name ( void )

Get driver name from current DB connection settings.

Returns: pointer to driver name; NULL if not set

Definition at line 27 of file db/dbmi_base/default_name.c.

References G_getenv_nofatal2(), G_store(), G_VAR_MAPSET, and NULL.

◆ db_get_default_group_name()

const char* db_get_default_group_name ( void )

Get group name from current DB connection settings.

Returns: pointer to group name; NULL if not set

Definition at line 75 of file db/dbmi_base/default_name.c.

References G_getenv_nofatal2(), G_store(), G_VAR_MAPSET, and NULL.

◆ db_get_default_schema_name()

const char* db_get_default_schema_name ( void )

Get schema name from current DB connection settings.

Returns: pointer to schema name; NULL if not set

Definition at line 59 of file db/dbmi_base/default_name.c.

References G_getenv_nofatal2(), G_store(), G_VAR_MAPSET, and NULL.

◆ db_get_error_code()

int db_get_error_code ( void )

Get error code.

Returns: DB_OK if not defined

Definition at line 125 of file db/dbmi_base/error.c.

Referenced by db__recv_index_array(), and db_set_index_column_name().

◆ db_get_error_msg()

const char* db_get_error_msg ( void )

Get error message.

Returns: pointer to error message string

Definition at line 237 of file db/dbmi_base/error.c.

Referenced by db__send_failure().

◆ db_get_error_who()

const char* db_get_error_who ( void )

brief Get 'who' string

Returns: pointer to string buffer; empty buffer if 'who' is not defined

Definition at line 59 of file db/dbmi_base/error.c.

◆ db_get_handle_dbname()

const char* db_get_handle_dbname ( dbHandle * handle )

Get handle database name.

Parameters

handle pointer to dbHandle

Returns: pointer to string with database name

Definition at line 57 of file handle.c.

References db_get_string(), and _db_handle::dbName.

Referenced by db_d_open_database(), and db_find_database().

◆ db_get_handle_dbschema()

const char* db_get_handle_dbschema ( dbHandle * handle )

Get handle schema name.

Parameters

handle pointer to dbHandle

Returns: pointer to string with schema name

Definition at line 69 of file handle.c.

References db_get_string(), and _db_handle::dbSchema.

Referenced by db_d_open_database(), and db_find_database().

◆ db_get_index_column_name()

const char* db_get_index_column_name	(	dbIndex *	index,
		int	column_num
	)

Get column number.

Parameters

index	pointer to dbIndex
column_num	column number

Returns: string buffer with name

Definition at line 194 of file db/dbmi_base/index.c.

References _, _db_index::columnNames, db_error(), db_get_string(), NULL, and _db_index::numColumns.

Referenced by db_print_index().

◆ db_get_index_name()

const char* db_get_index_name ( dbIndex * index )

Get index name.

Parameters

index pointer to dbIndex

Returns: string buffer with name

Definition at line 124 of file db/dbmi_base/index.c.

References db_get_string(), and _db_index::indexName.

Referenced by db_print_index().

◆ db_get_index_number_of_columns()

int db_get_index_number_of_columns ( dbIndex * index )

Get number of columns.

Parameters

index pointer to dbIndex

Returns: number of columns

Definition at line 162 of file db/dbmi_base/index.c.

References _db_index::numColumns.

Referenced by db_print_index().

◆ db_get_index_table_name()

const char* db_get_index_table_name ( dbIndex * index )

Get table name.

Parameters

index pointer to dbIndex

Returns: string buffer with name

Definition at line 150 of file db/dbmi_base/index.c.

References db_get_string(), and _db_index::tableName.

Referenced by db_print_index().

◆ db_get_login()

int db_get_login	(	const char *	driver,
		const char *	database,
		const char **	user,
		const char **	password
	)

Get login parameters for driver/database.

If driver/database is not found, output arguments are set to NULL.

Deprecated:: Use db_set_login2() instead.

Todo:: : GRASS 8: to be replaced by db_set_login2().

Parameters

	driver	driver name
	database	database name (can be NULL)
[out]	user	name
[out]	password	string

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 361 of file login.c.

◆ db_get_login2()

int db_get_login2	(	const char *	driver,
		const char *	database,
		const char **	user,
		const char **	password,
		const char **	host,
		const char **	port
	)

Get login parameters for driver/database.

If driver/database is not found, output arguments are set to NULL.

Parameters

	driver	driver name
	database	database name (can be NULL)
[out]	user	name
[out]	password	string
[out]	host	name
[out]	port

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 382 of file login.c.

Referenced by db_get_connection().

◆ db_get_login_dump()

int db_get_login_dump ( FILE * fd )

Print all connection settings to file.

Parameters

fd	file where to print settings

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 396 of file login.c.

References G_debug().

◆ db_get_num_rows()

int db_get_num_rows ( dbCursor * cursor )

Get number of selected rows.

Parameters

cursor db select cursor

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file c_rows.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_ROWS, DB_RECV_INT, DB_RECV_RETURN_CODE, DB_SEND_TOKEN, DB_START_PROCEDURE_CALL, _db_cursor::driver, _db_driver::recv, _db_driver::send, and _db_cursor::token.

Referenced by db_get_table_number_of_rows().

◆ db_get_string()

char* db_get_string ( const dbString * x )

Get string.

Parameters

x	pointer to dbString

Returns: pointer to buffer containing string

Definition at line 140 of file string.c.

References x.

Referenced by db_d_report_error(), db_delete_table(), db_get_column_description(), db_get_column_name(), db_get_handle_dbname(), db_get_handle_dbschema(), db_get_index_column_name(), db_get_index_name(), db_get_index_table_name(), db_get_table_number_of_rows(), db_get_value_string(), db_print_column_definition(), and db_zero_string().

◆ 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.

Referenced by P_Create_Aux2_Table(), and P_Create_Aux4_Table().

◆ 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.

◆ 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.

◆ 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.

◆ 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.

◆ 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.

◆ 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.

◆ db_get_table_number_of_rows()

int db_get_table_number_of_rows	(	dbDriver *	driver,
		dbString *	sql
	)

Get number of rows of table.

Parameters

driver	db driver
sql	SQL statement

Returns: number of records; -1

Definition at line 105 of file dbmi_client/table.c.

References _, db_close_cursor(), db_close_database_shutdown_driver(), db_get_num_rows(), db_get_string(), DB_OK, db_open_select_cursor(), DB_SEQUENTIAL, and G_warning().

◆ 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.

◆ 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.

◆ db_get_value_as_double()

double db_get_value_as_double	(	dbValue *	value,
		int	ctype
	)

Get value as double.

For given value and C type of value returns double representation.

Parameters

value	pointer to dbValue
ctype	C data type

Returns: value

Definition at line 65 of file value.c.

References DB_C_TYPE_DOUBLE, DB_C_TYPE_INT, DB_C_TYPE_STRING, db_get_value_double(), db_get_value_int(), and db_get_value_string().

◆ db_get_value_day()

int db_get_value_day ( dbValue * value )

Get day value.

Parameters

value pointer to dbValue

Returns: value

Definition at line 128 of file value.c.

References _db_date_time::day, and _db_value::t.

Referenced by db_convert_value_datetime_into_string().

◆ db_get_value_double()

double db_get_value_double ( dbValue * value )

Get double precision value.

Parameters

value pointer to dbValue

Returns: value

Definition at line 50 of file value.c.

References _db_value::d.

Referenced by db_convert_value_to_string(), and db_get_value_as_double().

◆ db_get_value_hour()

int db_get_value_hour ( dbValue * value )

Get hour value.

Parameters

value pointer to dbValue

Returns: value

Definition at line 140 of file value.c.

References _db_date_time::hour, and _db_value::t.

Referenced by db_convert_value_datetime_into_string().

◆ db_get_value_int()

int db_get_value_int ( dbValue * value )

Get integer value.

Parameters

value pointer to dbValue

Returns: value

Definition at line 38 of file value.c.

References _db_value::i.

Referenced by db_convert_value_to_string(), and db_get_value_as_double().

◆ db_get_value_minute()

int db_get_value_minute ( dbValue * value )

Get minute value.

Parameters

value pointer to dbValue

Returns: value

Definition at line 152 of file value.c.

References _db_date_time::minute, and _db_value::t.

Referenced by db_convert_value_datetime_into_string().

◆ db_get_value_month()

int db_get_value_month ( dbValue * value )

Get month value.

Parameters

value pointer to dbValue

Returns: value

Definition at line 116 of file value.c.

References _db_date_time::month, and _db_value::t.

Referenced by db_convert_value_datetime_into_string().

◆ db_get_value_seconds()

double db_get_value_seconds ( dbValue * value )

Get seconds value.

Parameters

value pointer to dbValue

Returns: value

Definition at line 164 of file value.c.

References _db_date_time::seconds, and _db_value::t.

Referenced by db_convert_value_datetime_into_string().

◆ db_get_value_string()

const char* db_get_value_string ( dbValue * value )

Get string value.

Parameters

value pointer to dbValue

Returns: value

Definition at line 92 of file value.c.

References db_get_string(), and _db_value::s.

Referenced by db_convert_value_to_string(), and db_get_value_as_double().

◆ db_get_value_year()

int db_get_value_year ( dbValue * value )

Get year value.

Parameters

value pointer to dbValue

Returns: value

Definition at line 104 of file value.c.

References _db_value::t, and _db_date_time::year.

Referenced by db_convert_value_datetime_into_string().

◆ db_grant_on_table()

int db_grant_on_table	(	dbDriver *	driver,
		const char *	tableName,
		int	priv,
		int	to
	)

Grant privileges on table.

Parameters

driver	db driver
tableName	table name
priv	privileges DB_PRIV_SELECT
to	grant to DB_GROUP \| DB_PUBLIC

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 29 of file c_priv.c.

References db__set_protocol_fds(), db_free_string(), db_init_string(), DB_OK, DB_PROC_GRANT_ON_TABLE, DB_RECV_RETURN_CODE, DB_SEND_INT, DB_SEND_STRING, db_set_string(), DB_START_PROCEDURE_CALL, and name.

◆ db_gversion()

int db_gversion	(	dbDriver *	driver,
		dbString *	client_version,
		dbString *	driver_version
	)

Get version info.

Note: renamed from db_version to db_gversion to avoid name conflict with Berkeley DB etc.

Parameters

	driver	db driver
[out]	client_version	client version
[out]	driver_version	driver version

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 31 of file c_version.c.

References db__set_protocol_fds(), db_init_string(), DB_OK, DB_PROC_VERSION, DB_RECV_RETURN_CODE, DB_RECV_STRING, db_set_string(), DB_START_PROCEDURE_CALL, and DB_VERSION.

◆ db_has_dbms()

int db_has_dbms ( void )

Check dbms.

Returns: 1 if true; 0 if false

Definition at line 68 of file dbmscap.c.

◆ db_init_column()

void db_init_column ( dbColumn * column )

Initialize dbColumn.

Parameters

column pointer to dbColumn to be initialized

Definition at line 388 of file dbmi_base/column.c.

References _db_column::columnName, db_init_string(), db_zero(), _db_column::defaultValue, _db_column::description, _db_value::s, and _db_column::value.

Referenced by db_d_add_column().

◆ db_init_cursor()

void db_init_cursor ( dbCursor * cursor )

Initialize dbCursor.

Parameters

cursor pointer to dbCursor to be initialized

Definition at line 23 of file cursor.c.

References G_zero(), and _db_cursor::token.

Referenced by db_free_cursor().

◆ db_init_handle()

void db_init_handle ( dbHandle * handle )

Initialize handle (i.e database/schema)

Parameters

handle pointer to dbHandle to be initialized

Definition at line 23 of file handle.c.

References db_init_string(), _db_handle::dbName, and _db_handle::dbSchema.

Referenced by db_alloc_handle_array(), db_d_create_database(), db_d_delete_database(), db_d_find_database(), db_d_open_database(), and db_start_driver_open_database().

◆ db_init_index()

void db_init_index ( dbIndex * index )

Initialize dbIndex.

Parameters

index pointer to dbIndex to be initialized

Definition at line 25 of file db/dbmi_base/index.c.

References _db_index::columnNames, db_init_string(), _db_index::indexName, NULL, _db_index::numColumns, _db_index::tableName, and _db_index::unique.

Referenced by db_alloc_index_array(), db_create_index2(), db_d_create_index(), and db_free_index().

◆ db_init_string()

void db_init_string ( dbString * x )

Initialize dbString.

Parameters

[out] x pointer to dbString

Definition at line 25 of file string.c.

References G_zero(), and x.

Referenced by db_alloc_dirent_array(), db_d_add_column(), db_d_drop_column(), db_d_drop_index(), db_d_drop_table(), db_d_execute_immediate(), db_d_grant_on_table(), db_d_init_error(), db_d_list_indexes(), db_delete_table(), db_free_string(), db_grant_on_table(), db_gversion(), db_init_column(), db_init_handle(), db_init_index(), db_print_column_definition(), and P_Drop_Aux_Table().

◆ 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.

◆ db_insert()

int db_insert ( dbCursor * cursor )

Insert new record into table.

Parameters

cursor db cursor

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file c_insert.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_INSERT, DB_RECV_RETURN_CODE, DB_SEND_TABLE_DATA, DB_SEND_TOKEN, DB_START_PROCEDURE_CALL, _db_cursor::driver, _db_driver::recv, _db_driver::send, _db_cursor::table, and _db_cursor::token.

◆ db_interval_range()

void db_interval_range	(	int	sqltype,
		int *	from,
		int *	to
	)

Define range based on SQL data type.

Parameters

	sqltype	SQL data type
[out]	from
[out]	to

Definition at line 24 of file interval.c.

References DB_DAY, DB_FRACTION, DB_HOUR, DB_MINUTE, DB_MONTH, DB_SECOND, DB_SQL_TYPE_DATE, DB_SQL_TYPE_TIME, and DB_YEAR.

Referenced by db_convert_Cstring_to_value_datetime(), db_convert_value_datetime_into_string(), and db_sqltype_name().

◆ db_isdir()

int db_isdir ( const char * path )

Test if path is a directory.

Parameters

path pathname

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 29 of file isdir.c.

References DB_FAILED, DB_OK, and x.

◆ db_legal_tablename()

int db_legal_tablename ( const char * s )

Check if output is legal table name.

Rule: [A-Za-z][A-Za-z0-9_@]*

Parameters

s	table name to be checked

Returns: 1 OK; -1 if name does not start with letter A..Za..z or if name does not continue with A..Za..z0..9_@

Definition at line 31 of file legal_dbname.c.

◆ db_list_databases()

int db_list_databases	(	dbDriver *	driver,
		dbString *	path,
		int	npaths,
		dbHandle **	handles,
		int *	count
	)

List databases.

Parameters

	driver	db driver
	path	db path
	npaths	number of given paths
[out]	handles	handle infos
[out]	count	number of handle infos

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 30 of file c_listdb.c.

◆ db_list_drivers()

const char* db_list_drivers ( void )

Return comma separated list of existing DB drivers, used for driver parameter options.

Returns: list of db drivers

Definition at line 23 of file c_list_drivers.c.

References list.

◆ db_list_indexes()

int db_list_indexes	(	dbDriver *	driver,
		dbString *	table_name,
		dbIndex **	list,
		int *	count
	)

List indexes.

Parameters

	driver	db driver
	table_name	table name
[out]	list	list of db indexes
[out]	dbDriver	number of items in the list

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 29 of file c_list_idx.c.

References count, db__set_protocol_fds(), DB_OK, DB_PROC_LIST_INDEXES, DB_RECV_INDEX_ARRAY, DB_RECV_RETURN_CODE, DB_SEND_STRING, and DB_START_PROCEDURE_CALL.

◆ db_list_tables()

int db_list_tables	(	dbDriver *	driver,
		dbString **	names,
		int *	count,
		int	system
	)

List available tables for given connection.

Parameters

	driver	db driver
[out]	names	list of table names
[out]	count	number of items in the list
	system	?

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 39 of file c_list_tabs.c.

References count, db__set_protocol_fds(), DB_OK, DB_PROC_LIST_TABLES, DB_RECV_RETURN_CODE, DB_RECV_STRING_ARRAY, DB_SEND_INT, and DB_START_PROCEDURE_CALL.

◆ db_malloc()

void* db_malloc ( int n )

Allocate memory.

On failure is called db_memory_error().

Parameters

n	number of bytes to be allocated

Returns: pointer to allocated memory

Definition at line 47 of file db/dbmi_base/alloc.c.

◆ db_memory_error()

void db_memory_error ( void )

Report memory error.

Definition at line 133 of file db/dbmi_base/error.c.

References _, and db_error().

◆ db_new_token()

dbToken db_new_token ( dbAddress address )

Add new token.

Parameters

address dbAddress of token to be added

Returns: dbToken

Definition at line 55 of file db/dbmi_base/token.c.

References count, db_realloc(), list, NONE, and NULL.

◆ db_nocase_compare()

int db_nocase_compare	(	const char *	a,
		const char *	b
	)

Compare strings case-insensitive.

Parameters

a,b	string buffers to be compared

Returns: 0 strings equal; 1 otherwise

Definition at line 69 of file case.c.

Referenced by db_convert_Cstring_to_value_datetime().

◆ db_noproc_error()

void db_noproc_error ( int procnum )

Report no procedure error.

Parameters

procnum procedure number

Definition at line 158 of file db/dbmi_base/error.c.

References _, db_error(), and procnum.

Referenced by db__start_procedure_call().

◆ db_open_database()

int db_open_database	(	dbDriver *	driver,
		dbHandle *	handle
	)

Open database connection.

Parameters

driver	db driver
handle	handle info (database and schema name)

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 27 of file c_opendb.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_OPEN_DATABASE, DB_RECV_RETURN_CODE, DB_SEND_HANDLE, and DB_START_PROCEDURE_CALL.

Referenced by db_start_driver_open_database().

◆ db_open_insert_cursor()

int db_open_insert_cursor	(	dbDriver *	driver,
		dbCursor *	cursor
	)

Open insert cursor.

Parameters

driver	db driver
cursor	cursor to be opened

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 27 of file c_openinsert.c.

References db__set_protocol_fds(), db_get_cursor_table(), DB_OK, DB_PROC_OPEN_INSERT_CURSOR, DB_RECV_INT, DB_RECV_RETURN_CODE, DB_RECV_TOKEN, DB_SEND_TABLE_DEFINITION, DB_START_PROCEDURE_CALL, _db_cursor::driver, driver, _db_cursor::mode, _db_cursor::token, and _db_cursor::type.

◆ db_open_select_cursor()

int db_open_select_cursor	(	dbDriver *	driver,
		dbString *	select,
		dbCursor *	cursor,
		int	mode
	)

Open select cursor.

Open modes:

DB_SEQUENTIAL

Data can be fetched by db_fetch().

Cursor should be closed by db_close_cursor().

Parameters

driver	pointer to dbDriver
select	SQL select statement (pointer to dbString)
cursor	pointer to dbCursor to be opened
mode	open mode

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 37 of file c_openselect.c.

Referenced by db_get_table_number_of_rows().

◆ db_open_update_cursor()

int db_open_update_cursor	(	dbDriver *	driver,
		dbString *	table_name,
		dbString *	select,
		dbCursor *	cursor,
		int	mode
	)

Open update cursor.

Parameters

driver	db driver
table_name	table name
select	SQL update statement (?)
cursor	db cursor to be opened
mode	open mode (?)

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 30 of file c_openupdate.c.

◆ db_print_column_definition()

void db_print_column_definition	(	FILE *	fd,
		dbColumn *	column
	)

Print column definition info.

Parameters

fd	file descriptor
column	column info

Definition at line 51 of file printtab.c.

References db_convert_column_default_value_to_string(), db_get_column_description(), db_get_column_length(), db_get_column_name(), db_get_column_precision(), db_get_column_scale(), db_get_column_sqltype(), db_get_string(), db_init_string(), db_sqltype_name(), db_test_column_has_default_value(), and db_test_column_null_allowed().

◆ db_print_error()

void db_print_error ( void )

Print error.

If not defined, the error message is printed to stderr.

Definition at line 182 of file db/dbmi_base/error.c.

◆ db_print_index()

void db_print_index	(	FILE *	fd,
		dbIndex *	index
	)

Report index.

Parameters

fd	file where to print index info
index	pointer to dbIndex

Definition at line 254 of file db/dbmi_base/index.c.

References db_get_index_column_name(), db_get_index_name(), db_get_index_number_of_columns(), db_get_index_table_name(), and db_test_index_type_unique().

◆ db_print_table_definition()

void db_print_table_definition	(	FILE *	fd,
		dbTable *	table
	)

Print table definition info.

Parameters

fd	file descriptor
table	table info

Definition at line 26 of file printtab.c.

◆ db_procedure_not_implemented()

void db_procedure_not_implemented ( const char * name )

Report 'not implemented' error.

Parameters

name	name of functionality

Definition at line 144 of file db/dbmi_base/error.c.

References _, db_error(), and name.

Referenced by db__driver_add_column(), db__driver_bind_update(), db__driver_close_cursor(), db__driver_close_database(), db__driver_create_database(), db__driver_delete(), db__driver_delete_database(), db__driver_drop_column(), db__driver_drop_index(), db__driver_drop_table(), db__driver_execute_immediate(), db__driver_find_database(), db__driver_get_num_rows(), db__driver_insert(), db__driver_list_databases(), db__driver_list_indexes(), db__driver_list_tables(), db__driver_open_database(), db__driver_open_insert_cursor(), and db__driver_update().

◆ db_protocol_error()

void db_protocol_error ( void )

Report protocol error.

Definition at line 85 of file db/dbmi_base/error.c.

Referenced by db__recv_int(), db__recv_short(), db__send_double_array(), db__send_float_array(), db__send_int(), db__send_int_array(), db__send_short_array(), and db__start_procedure_call().

◆ db_read_dbmscap()

dbDbmscap* db_read_dbmscap ( void )

Read dbmscap.

dbmscap file was used in grass5.0 but it is not used in grass5.7 until we find it necessary. All code for dbmscap file is commented here.

Instead of in dbmscap file db_read_dbmscap() searches for available dbmi drivers in /driver/db/

Returns: pointer to dbDbmscap

Definition at line 98 of file dbmscap.c.

References db_dbmscap_filename(), db_syserror(), file, and NULL.

◆ db_realloc()

void* db_realloc	(	void *	s,
		int	n
	)

Reallocate memory.

On failure is called db_memory_error().

Parameters

s	pointer to memory
n	number of newly allocated bytes

Returns: pointer to allocated memory

Definition at line 93 of file db/dbmi_base/alloc.c.

Referenced by db__add_cursor_to_driver_state(), db_enlarge_string(), and db_new_token().

◆ db_select_CatValArray()

int db_select_CatValArray	(	dbDriver *	driver,
		const char *	tab,
		const char *	key,
		const char *	col,
		const char *	where,
		dbCatValArray *	cvarr
	)

Select pairs key/value to array, values are sorted by key (must be integer)

Parameters

	driver	DB driver
	tab	table name
	key	key column name
	col	value column name
[out]	cvarr	dbCatValArray to store within

Returns: number of selected values; -1 on error

Definition at line 269 of file db/dbmi_client/select.c.

◆ db_select_int()

int db_select_int	(	dbDriver *	driver,
		const char *	tab,
		const char *	col,
		const char *	where,
		int **	pval
	)

Select array of ordered integers from table/column.

Parameters

	driver	DB driver
	tab	table name
	col	column name
	where	where statement
[out]	pval	array of ordered integer values

Returns: number of selected values; -1 on error

Definition at line 103 of file db/dbmi_client/select.c.

Referenced by Vect_cats_set_constraint().

◆ db_select_value()

int db_select_value	(	dbDriver *	driver,
		const char *	tab,
		const char *	key,
		int	id,
		const char *	col,
		dbValue *	val
	)

Select one (first) value from table/column for key/id.

Parameters

	driver	DB driver
	tab	table name
	key	key column name
	id	identifier in key column
	col	name of column to select the value from
[out]	val	dbValue to store within

Returns: number of selected values; -1 on error

Definition at line 204 of file db/dbmi_client/select.c.

◆ db_set_column_description()

int db_set_column_description	(	dbColumn *	column,
		const char *	description
	)

Set column description.

Parameters

column	pointer to dbColumn
description	column's description

Returns: DB_OK on success; error code on failure

Definition at line 432 of file dbmi_base/column.c.

References db_set_string(), and _db_column::description.

◆ db_set_column_has_defined_default_value()

void db_set_column_has_defined_default_value ( dbColumn * column )

Set default value identificator.

Parameters

column pointer to dbColumn

Definition at line 164 of file dbmi_base/column.c.

References _db_column::hasDefaultValue.

◆ db_set_column_has_undefined_default_value()

void db_set_column_has_undefined_default_value ( dbColumn * column )

Unset default value identificator.

Todo:: Replace by db_unset_column_has_default_value() ?

Parameters

column pointer to dbColumn

Definition at line 176 of file dbmi_base/column.c.

References _db_column::hasDefaultValue.

◆ db_set_column_host_type()

void db_set_column_host_type	(	dbColumn *	column,
		int	type
	)

Set column host data type.

Parameters

column	pointer to dbColumn
type	data type

Definition at line 82 of file dbmi_base/column.c.

◆ db_set_column_length()

void db_set_column_length	(	dbColumn *	column,
		int	length
	)

Set column's length.

Parameters

column	pointer to dbColumn
length	value

Definition at line 314 of file dbmi_base/column.c.

References _db_column::dataLen.

◆ db_set_column_name()

int db_set_column_name	(	dbColumn *	column,
		const char *	name
	)

Set column name.

Parameters

column	pointer to dbColumn
name	column name

Returns: DB_OK on success; error code on failure

Definition at line 406 of file dbmi_base/column.c.

References _db_column::columnName, db_set_string(), and name.

Referenced by P_Create_Aux2_Table(), and P_Create_Aux4_Table().

◆ db_set_column_null_allowed()

void db_set_column_null_allowed ( dbColumn * column )

Set null value to be allowed.

Parameters

column pointer to dbColumn

Definition at line 268 of file dbmi_base/column.c.

References _db_column::nullAllowed.

◆ db_set_column_precision()

void db_set_column_precision	(	dbColumn *	column,
		int	precision
	)

Set column precision.

Parameters

column	pointer to dbColumn
precision	value

Definition at line 128 of file dbmi_base/column.c.

References _db_column::precision.

◆ db_set_column_scale()

void db_set_column_scale	(	dbColumn *	column,
		int	scale
	)

Set column scale.

Parameters

column	pointer to dbColumn
scale	column scale value

Definition at line 105 of file dbmi_base/column.c.

◆ db_set_column_select_priv_granted()

void db_set_column_select_priv_granted ( dbColumn * column )

Set select privileges to be granted.

Parameters

column pointer to dbColumn

Definition at line 324 of file dbmi_base/column.c.

References DB_GRANTED, and _db_column::select.

◆ db_set_column_select_priv_not_granted()

void db_set_column_select_priv_not_granted ( dbColumn * column )

Unset select privileges.

Parameters

column pointer to dbColumn

Definition at line 334 of file dbmi_base/column.c.

References DB_NOT_GRANTED, and _db_column::select.

◆ db_set_column_sqltype()

void db_set_column_sqltype	(	dbColumn *	column,
		int	sqltype
	)

Define column sqltype for column.

The function db_sqltype_name() returns sqltype description.

#define DB_SQL_TYPE_UNKNOWN          0
 
#define DB_SQL_TYPE_CHARACTER        1
#define DB_SQL_TYPE_SMALLINT         2
#define DB_SQL_TYPE_INTEGER          3
#define DB_SQL_TYPE_REAL             4
#define DB_SQL_TYPE_DOUBLE_PRECISION 6
#define DB_SQL_TYPE_DECIMAL          7
#define DB_SQL_TYPE_NUMERIC          8
#define DB_SQL_TYPE_DATE             9
#define DB_SQL_TYPE_TIME            10
#define DB_SQL_TYPE_TIMESTAMP       11
#define DB_SQL_TYPE_INTERVAL        12
#define DB_SQL_TYPE_TEXT            13
 
#define DB_SQL_TYPE_SERIAL          21

Parameters

column	pointer to dbColumn
sqltype	SQL data type (see list)

Definition at line 71 of file dbmi_base/column.c.

References _db_column::sqlDataType.

Referenced by P_Create_Aux2_Table(), and P_Create_Aux4_Table().

◆ db_set_column_update_priv_granted()

void db_set_column_update_priv_granted ( dbColumn * column )

Set update privileges to be granted.

Parameters

column pointer to dbColumn

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

References DB_GRANTED, and _db_column::update.

◆ db_set_column_update_priv_not_granted()

void db_set_column_update_priv_not_granted ( dbColumn * column )

Unset update privileges.

Parameters

column pointer to dbColumn

Definition at line 366 of file dbmi_base/column.c.

References DB_NOT_GRANTED, and _db_column::update.

◆ db_set_column_use_default_value()

void db_set_column_use_default_value ( dbColumn * column )

Set default value to be used.

Parameters

column pointer to dbColumn

Definition at line 235 of file dbmi_base/column.c.

References _db_column::useDefaultValue.

◆ db_set_connection()

int db_set_connection ( dbConnection * connection )

Set default DB connection settings.

This function sets environmental variables as DB_DRIVER, DB_DATABASE, DB_SCHEMA, DB_GROUP.

Parameters

connection pointer to dbConnection with default settings

Returns: DB_OK

Definition at line 28 of file db/dbmi_base/connect.c.

References _db_connection::databaseName, DB_OK, _db_connection::driverName, G_setenv2(), G_unsetenv2(), G_VAR_MAPSET, _db_connection::group, and _db_connection::schemaName.

Referenced by db_set_default_connection().

◆ db_set_cursor_column_flag()

void db_set_cursor_column_flag	(	dbCursor *	cursor,
		int	col
	)

Set column's flag.

Parameters

cursor	pointer to dbCursor
col	column index (starting with '0')

Definition at line 356 of file cursor.c.

References _db_cursor::column_flags.

Referenced by db_set_cursor_column_for_update().

◆ db_set_cursor_column_for_update()

void db_set_cursor_column_for_update	(	dbCursor *	cursor,
		int	col
	)

Set Column flag to 'update'.

Parameters

cursor	pointer to dbCursor
col	column index (starting with '0')

Definition at line 307 of file cursor.c.

References db_set_cursor_column_flag().

◆ db_set_cursor_mode()

void db_set_cursor_mode	(	dbCursor *	cursor,
		int	mode
	)

Set cursor mode.

Modes:

DB_SCROLL
DB_INSENSITIVE

Parameters

cursor	pointer to dbCursor
mode	cursor mode

Definition at line 186 of file cursor.c.

◆ db_set_cursor_mode_insensitive()

void db_set_cursor_mode_insensitive ( dbCursor * cursor )

Set 'intensive' cursor mode.

Parameters

cursor pointer to dbCursor

Definition at line 226 of file cursor.c.

References DB_INSENSITIVE, and _db_cursor::mode.

◆ db_set_cursor_mode_scroll()

void db_set_cursor_mode_scroll ( dbCursor * cursor )

Set 'scroll' cursor mode.

Parameters

cursor pointer to dbCursor

Definition at line 196 of file cursor.c.

References DB_SCROLL, and _db_cursor::mode.

◆ db_set_cursor_table()

void db_set_cursor_table	(	dbCursor *	cursor,
		dbTable *	table
	)

Set table for given cursor.

Parameters

cursor	pointer to dbCursor
table	pointer to dbTable

Definition at line 78 of file cursor.c.

◆ db_set_cursor_token()

void db_set_cursor_token	(	dbCursor *	cursor,
		dbToken	token
	)

Set cursor token.

Parameters

cursor	pointer to dbCursor
token	pointer to dbToken

Definition at line 101 of file cursor.c.

References _db_cursor::token.

◆ db_set_cursor_type_insert()

void db_set_cursor_type_insert ( dbCursor * cursor )

Set cursor to be writable (insert)

Parameters

cursor pointer to dbCursor

Definition at line 131 of file cursor.c.

References DB_INSERT, and _db_cursor::type.

◆ db_set_cursor_type_readonly()

void db_set_cursor_type_readonly ( dbCursor * cursor )

Set cursor to be read-only (select)

Parameters

cursor pointer to dbCursor

Definition at line 111 of file cursor.c.

References DB_READONLY, and _db_cursor::type.

◆ db_set_cursor_type_update()

void db_set_cursor_type_update ( dbCursor * cursor )

Set cursor to be writable (update)

Parameters

cursor pointer to dbCursor

Definition at line 121 of file cursor.c.

References DB_UPDATE, and _db_cursor::type.

◆ db_set_default_connection()

int db_set_default_connection ( void )

Sets up database connection settings using GRASS default from dbmi.h.

This function ignores current DB connection settings and uses GRASS default settings instead.

Todo:: DB_OK on success, DB_* error code on fail

Returns: returns DB_OK

Definition at line 95 of file db/dbmi_base/default_name.c.

References _, _db_connection::databaseName, DB_DEFAULT_DRIVER, DB_OK, db_set_connection(), _db_connection::driverName, G_debug(), G_fatal_error(), G_location_path(), G_make_mapset_object_group(), G_mapset(), G_zero(), and GPATH_MAX.

◆ db_set_error_handler_driver()

void db_set_error_handler_driver ( dbDriver * driver )

Define standard error handler for open database connection.

This handler:

close database connection
shutdown db driver

Note: It's recommended to call this routine after db_start_driver_open_database().

Parameters

driver DB driver

Definition at line 38 of file db/dbmi_client/handler.c.

References G_add_error_handler().

◆ db_set_error_who()

void db_set_error_who ( const char * me )

Set 'who' for error messages.

Parameters

me my name

Definition at line 46 of file db/dbmi_base/error.c.

◆ db_set_handle()

int db_set_handle	(	dbHandle *	handle,
		const char *	dbName,
		const char *	dbSchema
	)

Set handle (database and schema name)

Parameters

handle	pointer to dbHandle
dbName	database name
dbSchema	schema name

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 39 of file handle.c.

References DB_OK, db_set_string(), _db_handle::dbName, and _db_handle::dbSchema.

Referenced by db_find_database(), and db_start_driver_open_database().

◆ db_set_index_column_name()

int db_set_index_column_name	(	dbIndex *	index,
		int	column_num,
		const char *	name
	)

Set column name.

Parameters

index	pointer to dbIndex
column_num	column number
name	name to be set

Returns: DB_OK on success; DB_FAILED on error

Definition at line 177 of file db/dbmi_base/index.c.

References _, _db_index::columnNames, db_error(), db_get_error_code(), db_set_string(), name, and _db_index::numColumns.

Referenced by db_create_index2().

◆ db_set_index_name()

int db_set_index_name	(	dbIndex *	index,
		const char *	name
	)

Set index name.

Parameters

index	pointer to dbIndex
name	name to be set

Returns: DB_OK on success; DB_FAILED on error

Definition at line 112 of file db/dbmi_base/index.c.

References db_set_string(), _db_index::indexName, and name.

Referenced by db_create_index2().

◆ db_set_index_table_name()

int db_set_index_table_name	(	dbIndex *	index,
		const char *	name
	)

Set table name.

Parameters

index	pointer to dbIndex
name	name to be set

Returns: DB_OK on success; DB_FAILED on error

Definition at line 138 of file db/dbmi_base/index.c.

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

Referenced by db_create_index2().

◆ db_set_index_type_non_unique()

int db_set_index_type_non_unique ( dbIndex * index )

Set index type to non-unique.

Todo:: return type void?

Parameters

index pointer to dbIndex

Returns: 0

Definition at line 228 of file db/dbmi_base/index.c.

References _db_index::unique.

◆ db_set_index_type_unique()

int db_set_index_type_unique ( dbIndex * index )

Set index type to unique.

Todo:: return type void?

Parameters

index pointer to dbIndex

Returns: 0

Definition at line 212 of file db/dbmi_base/index.c.

References _db_index::unique.

Referenced by db_create_index2().

◆ db_set_login()

int db_set_login	(	const char *	driver,
		const char *	database,
		const char *	user,
		const char *	password
	)

Set login parameters for driver/database.

Deprecated:: Use db_set_login2() instead.

Todo:: : GRASS 8: to be replaced by db_set_login2().

Parameters

driver	driver name
database	database name
user	user name
password	password string

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 268 of file login.c.

◆ db_set_login2()

int db_set_login2	(	const char *	driver,
		const char *	database,
		const char *	user,
		const char *	password,
		const char *	host,
		const char *	port,
		int	overwrite
	)

Set login parameters for driver/database.

Parameters

driver	driver name
database	database name
user	user name
password	password string
host	host name
port
overwrite	TRUE to overwrite existing connections

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 288 of file login.c.

◆ db_set_string()

int db_set_string	(	dbString *	x,
		const char *	s
	)

Inserts string to dbString (enlarge string)

Parameters

[in,out]	x	pointer to dbString
	s	string to be inserted

Returns: DB_OK on success; DB_MEMORY_ERR on error

Definition at line 41 of file string.c.

Referenced by db_convert_value_datetime_into_string(), db_convert_value_to_string(), db_delete_table(), db_grant_on_table(), db_gversion(), db_set_column_description(), db_set_column_name(), db_set_handle(), db_set_index_column_name(), db_set_index_name(), and db_set_index_table_name().

◆ db_set_string_no_copy()

int db_set_string_no_copy	(	dbString *	x,
		char *	s
	)

Inserts string to dbString (overwrite current value)

Parameters

[in,out]	x	pointer to dbString
	s	string to be inserted

Returns: DB_OK on success; DB_MEMORY_ERR on error

Definition at line 55 of file string.c.

◆ 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.

◆ 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.

◆ 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.

◆ 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
name	description of the table

Returns: DB_OK

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

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.

◆ 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.

◆ 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.

Referenced by 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.

◆ 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.

◆ 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.

◆ 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.

◆ db_set_value_datetime_current()

void db_set_value_datetime_current ( dbValue * value )

Set datetime to current.

Parameters

value pointer to dbValue

Definition at line 315 of file value.c.

References _db_date_time::current, db_set_value_not_null(), and _db_value::t.

Referenced by db_convert_Cstring_to_value_datetime().

◆ db_set_value_datetime_not_current()

void db_set_value_datetime_not_current ( dbValue * value )

Set value to non-current.

Parameters

value pointer to dbValue

Definition at line 326 of file value.c.

References _db_date_time::current, db_set_value_not_null(), and _db_value::t.

Referenced by db_set_value_day(), db_set_value_hour(), db_set_value_minute(), db_set_value_month(), db_set_value_seconds(), and db_set_value_year().

◆ db_set_value_day()

void db_set_value_day	(	dbValue *	value,
		int	day
	)

Set day value.

Parameters

value	pointer to dbValue
day	day value

Definition at line 255 of file value.c.

References _db_date_time::day, db_set_value_datetime_not_current(), and _db_value::t.

Referenced by db_convert_Cstring_to_value_datetime().

◆ db_set_value_double()

void db_set_value_double	(	dbValue *	value,
		double	d
	)

Set double precision value.

Parameters

value	pointer to dbValue
d	double value

Definition at line 207 of file value.c.

◆ db_set_value_hour()

void db_set_value_hour	(	dbValue *	value,
		int	hour
	)

Set hour value.

Parameters

value	pointer to dbValue
hour	hour value

Definition at line 267 of file value.c.

References db_set_value_datetime_not_current(), _db_date_time::hour, and _db_value::t.

Referenced by db_convert_Cstring_to_value_datetime().

◆ db_set_value_int()

void db_set_value_int	(	dbValue *	value,
		int	i
	)

Set integer value.

Parameters

value	pointer to dbValue
i	integer value

Definition at line 195 of file value.c.

References db_set_value_not_null(), and _db_value::i.

◆ db_set_value_minute()

void db_set_value_minute	(	dbValue *	value,
		int	minute
	)

Set minute value.

Parameters

value	pointer to dbValue
minute	minute value

Definition at line 279 of file value.c.

References db_set_value_datetime_not_current(), _db_date_time::minute, and _db_value::t.

Referenced by db_convert_Cstring_to_value_datetime().

◆ db_set_value_month()

void db_set_value_month	(	dbValue *	value,
		int	month
	)

Set month value.

Parameters

value	pointer to dbValue
month	month value

Definition at line 243 of file value.c.

References db_set_value_datetime_not_current(), _db_date_time::month, and _db_value::t.

Referenced by db_convert_Cstring_to_value_datetime().

◆ db_set_value_not_null()

void db_set_value_not_null ( dbValue * value )

Set value to not null.

Parameters

value pointer to dbValue

Definition at line 184 of file value.c.

References _db_value::isNull.

Referenced by db_set_value_datetime_current(), db_set_value_datetime_not_current(), and db_set_value_int().

◆ db_set_value_null()

void db_set_value_null ( dbValue * value )

Set value to null.

Parameters

value pointer to dbValue

Definition at line 174 of file value.c.

References _db_value::isNull.

◆ db_set_value_seconds()

void db_set_value_seconds	(	dbValue *	value,
		double	seconds
	)

Set seconds value.

Parameters

value	pointer to dbValue
seconds	seconds value

Definition at line 291 of file value.c.

References db_set_value_datetime_not_current(), _db_date_time::seconds, and _db_value::t.

Referenced by db_convert_Cstring_to_value_datetime().

◆ db_set_value_string()

int db_set_value_string	(	dbValue *	value,
		const char *	s
	)

Set string value.

Parameters

value	pointer to dbValue
s	string value

Definition at line 219 of file value.c.

◆ db_set_value_year()

void db_set_value_year	(	dbValue *	value,
		int	year
	)

Set year value.

Parameters

value	pointer to dbValue
year	year value

Definition at line 231 of file value.c.

References db_set_value_datetime_not_current(), _db_value::t, and _db_date_time::year.

Referenced by db_convert_Cstring_to_value_datetime().

◆ db_shutdown_driver()

int db_shutdown_driver ( dbDriver * driver )

Closedown the driver, and free the driver structure.

Note: the management of the memory for the driver structure probably should be handled differently.

db_start_driver() could take a pointer to driver structure as an argument, instead of returning the pointer to allocated then there would be no hidden free required

Parameters

driver pointer to dbDriver to be freed

Returns: 0 on success; -1 on error

Definition at line 36 of file shutdown.c.

References db__set_protocol_fds(), db_free(), DB_PROC_SHUTDOWN_DRIVER, DB_START_PROCEDURE_CALL, db_unset_error_handler_driver(), G_wait(), and NULL.

Referenced by db_close_database_shutdown_driver(), and db_start_driver_open_database().

◆ db_sizeof_string()

unsigned int db_sizeof_string ( const dbString * x )

Get string size.

Parameters

x	pointer to dbString

Returns: string size

Definition at line 67 of file string.c.

References x.

◆ db_sqltype_name()

const char* db_sqltype_name ( int sqltype )

Get SQL data type description.

Parameters

sqltype SQL data type

Returns: string buffer with description

Definition at line 25 of file sqltype.c.

References DB_DATETIME_MASK, DB_DAY, DB_FRACTION, DB_HOUR, db_interval_range(), DB_MINUTE, DB_MONTH, DB_SECOND, 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_SERIAL, DB_SQL_TYPE_SMALLINT, DB_SQL_TYPE_TEXT, DB_SQL_TYPE_TIME, DB_SQL_TYPE_TIMESTAMP, DB_YEAR, and strcpy.

Referenced by db_print_column_definition().

◆ db_sqltype_to_Ctype()

int db_sqltype_to_Ctype ( int sqltype )

Get C data type based on given SQL data type.

Parameters

sqltype SQL data type

Returns: related C data type

Definition at line 24 of file sqlCtype.c.

References DB_C_TYPE_DATETIME, DB_C_TYPE_DOUBLE, DB_C_TYPE_INT, DB_C_TYPE_STRING, DB_DATETIME_MASK, DB_SQL_TYPE_DATE, DB_SQL_TYPE_DOUBLE_PRECISION, DB_SQL_TYPE_INTEGER, DB_SQL_TYPE_INTERVAL, DB_SQL_TYPE_REAL, DB_SQL_TYPE_SERIAL, DB_SQL_TYPE_SMALLINT, DB_SQL_TYPE_TIME, and DB_SQL_TYPE_TIMESTAMP.

Referenced by db__recv_column_default_value(), db__recv_column_value(), db__send_column_default_value(), db__send_column_value(), and db_convert_value_to_string().

◆ db_start_driver()

dbDriver* db_start_driver ( const char * name )

Initialize a new dbDriver for db transaction.

If name is NULL, the db name will be assigned connection.driverName.

Parameters

name	driver name

Returns: pointer to dbDriver structure; NULL on error

Definition at line 51 of file start.c.

References driver, and list.

Referenced by db_start_driver_open_database().

◆ db_start_driver_open_database()

dbDriver* db_start_driver_open_database	(	const char *	drvname,
		const char *	dbname
	)

Open driver/database connection.

Parameters

drvname	driver name
dbname	database name

Returns: pointer to dbDriver structure; NULL on failure

Definition at line 28 of file db.c.

References _, db_init_handle(), DB_OK, db_open_database(), db_set_handle(), db_shutdown_driver(), db_start_driver(), driver, G_debug(), G_warning(), and NULL.

Referenced by db_delete_table(), and Vect_cats_set_constraint().

◆ db_store()

char* db_store ( const char * s )

Make a copy of string buffer.

Allocated string buffer should be freed by db_free().

Parameters

s	source string buffer

Returns: allocated string buffer

Definition at line 28 of file db/dbmi_base/alloc.c.

Referenced by db__mark_database_open().

◆ db_strip()

void db_strip ( char * buf )

Strip given string.

'buf' is rewritten in place with leading and trailing white space removed.

Parameters

buf	string buffer

Definition at line 25 of file strip.c.

◆ db_syserror()

void db_syserror ( const char * s )

Report system error.

Parameters

s	error message

Definition at line 101 of file db/dbmi_base/error.c.

Referenced by db_read_dbmscap().

◆ db_table_exists()

int db_table_exists	(	const char *	drvname,
		const char *	dbname,
		const char *	tabname
	)

Check if table exists.

Parameters

drvname	driver name
dbname	database name
tabname	table name

Returns: 1 exist; 0 doesn't exist; -1 error

Definition at line 32 of file dbmi_client/table.c.

References count, driver, and full.

◆ 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.

◆ db_test_column_has_default_value()

int db_test_column_has_default_value ( dbColumn * column )

Check if column has defined default value.

Parameters

column pointer to dbColumn

Returns: 1 if true; 0 if false

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

References _db_column::hasDefaultValue.

Referenced by db_print_column_definition().

◆ db_test_column_has_defined_default_value()

int db_test_column_has_defined_default_value ( dbColumn * column )

Check if column has defined default value.

Parameters

column pointer to dbColumn

Returns: 1 if true; 0 if false

Definition at line 212 of file dbmi_base/column.c.

References _db_column::hasDefaultValue.

◆ db_test_column_has_undefined_default_value()

int db_test_column_has_undefined_default_value ( dbColumn * column )

Check if column has defined default value.

Parameters

column pointer to dbColumn

Returns: 1 if false; 0 if true

Definition at line 225 of file dbmi_base/column.c.

References _db_column::hasDefaultValue.

◆ db_test_column_null_allowed()

int db_test_column_null_allowed ( dbColumn * column )

Checks if null value is allowed.

Parameters

column pointer to dbColumn

Returns: 1 if true; 0 if false

Definition at line 291 of file dbmi_base/column.c.

References _db_column::nullAllowed.

Referenced by db_print_column_definition().

◆ db_test_column_use_default_value()

int db_test_column_use_default_value ( dbColumn * column )

Checks if default value is used.

Parameters

column pointer to dbColumn

Returns: 1 if true; 0 if false

Definition at line 258 of file dbmi_base/column.c.

References _db_column::useDefaultValue.

◆ db_test_cursor_any_column_flag()

int db_test_cursor_any_column_flag ( dbCursor * cursor )

Checks columns' flag.

Is any cursor column flag set?

Parameters

cursor pointer to dbCursor

Returns: 1 if true; 0 if false

Definition at line 413 of file cursor.c.

Referenced by db_d_update(), and db_test_cursor_any_column_for_update().

◆ db_test_cursor_any_column_for_update()

int db_test_cursor_any_column_for_update ( dbCursor * cursor )

Check if columns' flag is 'update'.

Parameters

cursor pointer to dbCursor

Returns: 1 if true; 0 if false

Definition at line 345 of file cursor.c.

References db_test_cursor_any_column_flag().

◆ db_test_cursor_column_flag()

int db_test_cursor_column_flag	(	dbCursor *	cursor,
		int	col
	)

Checks column's flag.

Parameters

cursor	pointer to dbCursor
col	column index (starting with '0')

Returns: 1 if flag is defined; 0 otherwise

Definition at line 383 of file cursor.c.

References _db_cursor::column_flags.

Referenced by db_test_cursor_column_for_update().

◆ db_test_cursor_column_for_update()

int db_test_cursor_column_for_update	(	dbCursor *	cursor,
		int	col
	)

Check if column flag is 'update'.

Parameters

cursor	pointer to dbCursor
col	column index (starting with '0')

Returns: 1 if true; 0 if false

Definition at line 332 of file cursor.c.

References db_test_cursor_column_flag().

◆ db_test_cursor_mode_insensitive()

int db_test_cursor_mode_insensitive ( dbCursor * cursor )

Check if cursor mode is 'intensive'.

Parameters

cursor pointer to dbCursor

Returns: 1 if true; 0 if false

Definition at line 262 of file cursor.c.

References DB_INSENSITIVE, and _db_cursor::mode.

◆ db_test_cursor_mode_scroll()

int db_test_cursor_mode_scroll ( dbCursor * cursor )

Check if cursor mode is 'scroll'.

Parameters

cursor pointer to dbCursor

Returns: 1 if true; 0 if false

Definition at line 249 of file cursor.c.

References DB_SCROLL, and _db_cursor::mode.

◆ db_test_cursor_type_fetch()

int db_test_cursor_type_fetch ( dbCursor * cursor )

Check cursor type.

Parameters

cursor pointer to dbCursor

Returns: 1 for known cursor type; 0 for unknown cursor type

Definition at line 144 of file cursor.c.

References DB_INSERT, DB_READONLY, DB_UPDATE, and _db_cursor::type.

◆ db_test_cursor_type_insert()

int db_test_cursor_type_insert ( dbCursor * cursor )

Check if cursor type is 'insert'.

Parameters

cursor pointer to dbCursor

Returns: 1 if cursor type is 'insert'; 0 otherwise

Definition at line 171 of file cursor.c.

References DB_INSERT, and _db_cursor::type.

Referenced by db_d_insert().

◆ db_test_cursor_type_update()

int db_test_cursor_type_update ( dbCursor * cursor )

Check if cursor type is 'update'.

Parameters

cursor pointer to dbCursor

Returns: 1 if cursor type is 'update'; 0 otherwise

Definition at line 158 of file cursor.c.

References DB_UPDATE, and _db_cursor::type.

Referenced by db_d_delete(), and db_d_update().

◆ db_test_index_type_unique()

int db_test_index_type_unique ( dbIndex * index )

Test if type is unique.

Parameters

index pointer to dbIndex

Returns: non-zero if True; zero if False

Definition at line 243 of file db/dbmi_base/index.c.

References _db_index::unique.

Referenced by db_print_index().

◆ db_test_value_datetime_current()

int db_test_value_datetime_current ( dbValue * value )

Check if datatime is current.

Parameters

value pointer to dbValue

Returns: non-zero for true; zero for false

Definition at line 305 of file value.c.

References _db_date_time::current, and _db_value::t.

Referenced by db_convert_value_datetime_into_string().

◆ db_test_value_isnull()

int db_test_value_isnull ( dbValue * value )

Check of value is null.

Parameters

value pointer to dbValue

Returns: non-zero is null; zero is not null

Definition at line 26 of file value.c.

References _db_value::isNull.

Referenced by db_convert_value_to_string().

◆ db_unset_column_has_default_value()

void db_unset_column_has_default_value ( dbColumn * column )

Unset default value identificator.

Parameters

column pointer to dbColumn

Definition at line 186 of file dbmi_base/column.c.

References _db_column::hasDefaultValue.

◆ db_unset_column_null_allowed()

void db_unset_column_null_allowed ( dbColumn * column )

Unset null value to be allowed.

Parameters

column pointer to dbColumn

Definition at line 278 of file dbmi_base/column.c.

References _db_column::nullAllowed.

◆ db_unset_column_use_default_value()

void db_unset_column_use_default_value ( dbColumn * column )

Unset default value to be used.

Parameters

column pointer to dbColumn

Definition at line 245 of file dbmi_base/column.c.

References _db_column::useDefaultValue.

◆ db_unset_cursor_column_flag()

void db_unset_cursor_column_flag	(	dbCursor *	cursor,
		int	col
	)

Unset column's flag.

Parameters

cursor	pointer to dbCursor
col	column index (starting with '0')

Definition at line 368 of file cursor.c.

References _db_cursor::column_flags.

Referenced by db_unset_cursor_column_for_update().

◆ db_unset_cursor_column_for_update()

void db_unset_cursor_column_for_update	(	dbCursor *	cursor,
		int	col
	)

Unset 'update' column flag.

Parameters

cursor	pointer to dbCursor
col	column index (starting with '0')

Definition at line 318 of file cursor.c.

References db_unset_cursor_column_flag().

◆ db_unset_cursor_mode()

void db_unset_cursor_mode ( dbCursor * cursor )

Unset cursor mode.

Parameters

cursor pointer to dbCursor

Definition at line 216 of file cursor.c.

References _db_cursor::mode.

◆ db_unset_cursor_mode_insensitive()

void db_unset_cursor_mode_insensitive ( dbCursor * cursor )

Unset 'intensive' cursor mode.

Parameters

cursor pointer to dbCursor

Definition at line 236 of file cursor.c.

References DB_INSENSITIVE, and _db_cursor::mode.

◆ db_unset_cursor_mode_scroll()

void db_unset_cursor_mode_scroll ( dbCursor * cursor )

Unset 'scroll' cursor mode.

Parameters

cursor pointer to dbCursor

Definition at line 206 of file cursor.c.

References DB_SCROLL, and _db_cursor::mode.

◆ db_unset_error_handler_driver()

void db_unset_error_handler_driver ( dbDriver * driver )

Remove error handler before closing the driver.

Parameters

driver DB driver

Definition at line 48 of file db/dbmi_client/handler.c.

References G_remove_error_handler().

Referenced by db_shutdown_driver().

◆ db_update()

int db_update ( dbCursor * cursor )

?

Parameters

cursor db cursor

Returns: DB_OK on success; DB_FAILED on failure

Definition at line 26 of file c_update.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_UPDATE, DB_RECV_RETURN_CODE, DB_SEND_TABLE_DATA, DB_SEND_TOKEN, DB_START_PROCEDURE_CALL, _db_cursor::driver, _db_driver::recv, _db_driver::send, _db_cursor::table, and _db_cursor::token.

◆ db_whoami()

const char* db_whoami ( void )

Who am i?

Check environmental variable LOGNAME

Returns: string buffer with logname

Definition at line 26 of file db/dbmi_base/whoami.c.

References G_store().

◆ db_zero()

void db_zero	(	void *	s,
		int	n
	)

Zero allocated space.

Parameters

s	pointer to memory
n	number of bytes

Definition at line 23 of file db/dbmi_base/zero.c.

Referenced by db__init_driver_state(), db_init_column(), and db_zero_string().

◆ db_zero_string()

void db_zero_string ( dbString * x )

Zero string.

Parameters

x	pointer to dbString

Definition at line 79 of file string.c.

References db_get_string(), db_zero(), and x.

Functions

Function Documentation

◆ db__add_cursor_to_driver_state()

◆ db__close_all_cursors()

◆ db__drop_cursor_from_driver_state()

◆ db__get_driver_state()

◆ db__init_driver_state()

◆ db__mark_database_closed()

◆ db__mark_database_open()

◆ db__recv_char()

◆ db__recv_column_default_value()

◆ db__recv_column_definition()

◆ db__recv_column_value()

◆ db__recv_datetime()

◆ db__recv_double()

◆ db__recv_double_array()

◆ db__recv_float()

◆ db__recv_float_array()

◆ db__recv_handle()

◆ db__recv_index()

◆ db__recv_index_array()

◆ db__recv_int()

◆ db__recv_int_array()

◆ db__recv_procnum()

◆ db__recv_return_code()

◆ db__recv_short()

◆ db__recv_short_array()

◆ db__recv_string()

◆ db__recv_string_array()

◆ db__recv_table_data()

◆ db__recv_table_definition()

◆ db__recv_token()

◆ db__recv_value()

◆ db__send_char()

◆ db__send_column_default_value()

◆ db__send_column_definition()

◆ db__send_column_value()

◆ db__send_Cstring()

◆ db__send_datetime()

◆ db__send_double()

◆ db__send_double_array()

◆ db__send_failure()

◆ db__send_float()

◆ db__send_float_array()

◆ db__send_handle()

◆ db__send_index()

◆ db__send_index_array()

◆ db__send_int()

◆ db__send_int_array()

◆ db__send_procedure_not_implemented()

◆ db__send_procedure_ok()

◆ db__send_short()

◆ db__send_short_array()

◆ db__send_string()

◆ db__send_string_array()

◆ db__send_success()

◆ db__send_table_data()

◆ db__send_table_definition()

◆ db__send_token()

◆ db__send_value()

◆ db__set_protocol_fds()

◆ db__start_procedure_call()

◆ db__test_database_open()

◆ db_add_column()

◆ db_alloc_cursor_column_flags()

◆ db_alloc_cursor_table()

◆ db_alloc_dirent_array()

◆ db_alloc_handle_array()

◆ db_alloc_index_array()

◆ db_alloc_index_columns()

◆ db_alloc_string_array()

◆ db_alloc_table()

◆ db_append_string()

◆ db_append_table_column()

◆ db_auto_print_errors()

◆ db_auto_print_protocol_errors()

◆ db_begin_transaction()

◆ db_bind_update()

◆ db_calloc()

◆ db_CatValArray_alloc()