#include <stdlib.h>
#include <string.h>
#include <grass/dbmi.h>
#include "macros.h"
Go to the source code of this file.
Functions | |
int | db__copy_table (char *from_drvname, char *from_dbname, char *from_tblname, char *to_drvname, char *to_dbname, char *to_tblname, char *where, char *select, char *selcol, int *ivals, int nvals) |
int | db_copy_table (char *from_drvname, char *from_dbname, char *from_tblname, char *to_drvname, char *to_dbname, char *to_tblname) |
Copy a table. | |
int | db_copy_table_where (char *from_drvname, char *from_dbname, char *from_tblname, char *to_drvname, char *to_dbname, char *to_tblname, char *where) |
Copy a table. | |
int | db_copy_table_select (char *from_drvname, char *from_dbname, char *from_tblname, char *to_drvname, char *to_dbname, char *to_tblname, char *select) |
Copy a table. | |
int | db_copy_table_by_ints (char *from_drvname, char *from_dbname, char *from_tblname, char *to_drvname, char *to_dbname, char *to_tblname, char *selcol, int *ivals, int nvals) |
Copy a table, but only records where value of column 'selcol' is in 'ivals'. |
int db__copy_table | ( | char * | from_drvname, | |
char * | from_dbname, | |||
char * | from_tblname, | |||
char * | to_drvname, | |||
char * | to_dbname, | |||
char * | to_tblname, | |||
char * | where, | |||
char * | select, | |||
char * | selcol, | |||
int * | ivals, | |||
int | nvals | |||
) |
Definition at line 30 of file copy_tab.c.
References db_alloc_table(), db_append_string(), db_begin_transaction(), db_close_cursor(), db_close_database_shutdown_driver(), db_commit_transaction(), db_convert_value_to_string(), db_create_table(), db_double_quote_string(), db_execute_immediate(), db_fetch(), 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_column_value(), db_get_cursor_table(), db_get_string(), db_get_table_column(), db_get_table_number_of_columns(), db_init_handle(), db_init_string(), db_list_tables(), db_open_database(), db_open_select_cursor(), db_set_column_description(), db_set_column_length(), db_set_column_name(), db_set_column_precision(), db_set_column_scale(), db_set_column_sqltype(), db_set_handle(), db_set_string(), db_set_table_name(), db_sqltype_name(), db_sqltype_to_Ctype(), db_start_driver(), and db_test_value_isnull().
Referenced by db_copy_table(), db_copy_table_by_ints(), db_copy_table_select(), and db_copy_table_where().
int db_copy_table | ( | char * | from_drvname, | |
char * | from_dbname, | |||
char * | from_tblname, | |||
char * | to_drvname, | |||
char * | to_dbname, | |||
char * | to_tblname | |||
) |
Copy a table.
Definition at line 354 of file copy_tab.c.
References db__copy_table().
int db_copy_table_by_ints | ( | char * | from_drvname, | |
char * | from_dbname, | |||
char * | from_tblname, | |||
char * | to_drvname, | |||
char * | to_dbname, | |||
char * | to_tblname, | |||
char * | selcol, | |||
int * | ivals, | |||
int | nvals | |||
) |
Copy a table, but only records where value of column 'selcol' is in 'ivals'.
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 |
Definition at line 409 of file copy_tab.c.
References db__copy_table().
int db_copy_table_select | ( | char * | from_drvname, | |
char * | from_dbname, | |||
char * | from_tblname, | |||
char * | to_drvname, | |||
char * | to_dbname, | |||
char * | to_tblname, | |||
char * | select | |||
) |
Copy a table.
select | is full select statement or NULL |
Definition at line 388 of file copy_tab.c.
References db__copy_table().
int db_copy_table_where | ( | char * | from_drvname, | |
char * | from_dbname, | |||
char * | from_tblname, | |||
char * | to_drvname, | |||
char * | to_dbname, | |||
char * | to_tblname, | |||
char * | where | |||
) |
Copy a table.
where | WHERE SQL condition (without where key word) or NULL |
Definition at line 371 of file copy_tab.c.
References db__copy_table().