GRASS GIS 8 Programmer's Manual  8.2.2dev(2023)-3d2c704037
defs/dbmi.h
Go to the documentation of this file.
1 #ifndef GRASS_DBMIDEFS_H
2 #define GRASS_DBMIDEFS_H
3 
4 void db_Cstring_to_lowercase(char *);
5 void db_Cstring_to_uppercase(char *);
6 int db_add_column(dbDriver *, dbString *, dbColumn *);
7 void db__add_cursor_to_driver_state(dbCursor *);
8 int db_alloc_cursor_column_flags(dbCursor *);
9 int db_alloc_cursor_table(dbCursor *, int);
10 int db_append_table_column(dbTable * , dbColumn *);
11 dbDirent *db_alloc_dirent_array(int);
12 dbHandle *db_alloc_handle_array(int);
13 dbIndex *db_alloc_index_array(int);
14 int db_alloc_index_columns(dbIndex *, int);
15 dbString *db_alloc_string_array(int);
16 dbTable *db_alloc_table(int);
17 int db_append_string(dbString *, const char *);
18 void db_auto_print_errors(int);
19 void db_auto_print_protocol_errors(int);
20 int db_bind_update(dbCursor *);
21 void *db_calloc(int, int);
22 int db_CatValArray_alloc(dbCatValArray *, int);
23 int db_CatValArray_realloc(dbCatValArray *, int);
24 void db_CatValArray_free(dbCatValArray *);
25 void db_CatValArray_init(dbCatValArray *);
26 void db_CatValArray_sort(dbCatValArray *);
27 int db_CatValArray_sort_by_value(dbCatValArray *);
28 int db_CatValArray_get_value(dbCatValArray *, int, dbCatVal **);
29 int db_CatValArray_get_value_int(dbCatValArray *, int, int *);
30 int db_CatValArray_get_value_double(dbCatValArray *, int,
31  double *);
32 void db_char_to_lowercase(char *);
33 void db_char_to_uppercase(char *);
34 void db_clear_error(void);
35 dbTable *db_clone_table(dbTable *);
36 void db__close_all_cursors(void);
37 int db_close_cursor(dbCursor *);
38 int db_close_database(dbDriver *);
39 int db_close_database_shutdown_driver(dbDriver *);
40 int db_column_sqltype(dbDriver *, const char *, const char *);
41 int db_column_Ctype(dbDriver *, const char *, const char *);
42 int db_convert_Cstring_to_column_default_value(const char *,
43  dbColumn *);
44 int db_convert_Cstring_to_column_value(const char *,
45  dbColumn *);
46 int db_convert_Cstring_to_value(const char *, int,
47  dbValue *);
48 int db_convert_Cstring_to_value_datetime(const char *, int,
49  dbValue *);
50 int db_convert_column_default_value_to_string(dbColumn *,
51  dbString *);
52 int db_convert_column_value_to_string(dbColumn *, dbString *);
53 int db_convert_value_datetime_into_string(dbValue *, int,
54  dbString *);
55 int db_convert_value_to_string(dbValue *, int,
56  dbString *);
57 dbColumn *db_copy_column(dbColumn *, dbColumn *);
58 void db_copy_dbmscap_entry(dbDbmscap *, dbDbmscap *);
59 int db_copy_string(dbString *, const dbString *);
60 int db_table_to_sql(dbTable *, dbString *);
61 int db_copy_table(const char *, const char *, const char *, const char *,
62  const char *, const char *);
63 int db_copy_table_where(const char *, const char *, const char *,
64  const char *, const char *, const char *,
65  const char *);
66 int db_copy_table_select(const char *, const char *, const char *,
67  const char *, const char *, const char *,
68  const char *);
69 int db_copy_table_by_ints(const char *, const char *, const char *,
70  const char *, const char *, const char *,
71  const char *, int *, int);
72 void db_copy_value(dbValue *, dbValue *);
73 int db_create_database(dbDriver *, dbHandle *);
74 int db_create_index(dbDriver *, dbIndex *);
75 int db_create_index2(dbDriver *, const char *,
76  const char *);
77 int db_create_table(dbDriver *, dbTable *);
78 int db_d_add_column(void);
79 int db_d_bind_update(void);
80 const char *db_dbmscap_filename(void);
81 int db_d_close_cursor(void);
82 int db_d_close_database(void);
83 int db_d_create_database(void);
84 int db_d_create_index(void);
85 int db_d_create_table(void);
86 int db_d_delete(void);
87 int db_d_delete_database(void);
88 int db_d_describe_table(void);
89 int db_d_drop_column(void);
90 int db_d_drop_index(void);
91 int db_d_drop_table(void);
92 void db_debug(const char *);
93 void db_debug_off(void);
94 void db_debug_on(void);
95 int db_delete(dbCursor *);
96 int db_delete_database(dbDriver *, dbHandle *);
97 int db_delete_table(const char *, const char *, const char *);
98 int db_describe_table(dbDriver *, dbString *, dbTable **);
99 int db_d_execute_immediate(void);
100 int db_d_begin_transaction(void);
101 int db_d_commit_transaction(void);
102 int db_d_fetch(void);
103 int db_d_find_database(void);
104 int db_d_get_num_rows(void);
105 int db_d_grant_on_table(void);
106 int db_d_insert(void);
107 void db_d_init_error(const char *);
108 void db_d_append_error(const char *, ...)
109  __attribute__ ((format(printf, 1, 2)));
110 void db_d_report_error(void);
111 dbDirent *db_dirent(const char *, int *);
112 int db_d_list_databases(void);
113 int db_d_list_indexes(void);
114 int db_d_list_tables(void);
115 int db_d_open_database(void);
116 int db_d_open_insert_cursor(void);
117 int db_d_open_select_cursor(void);
118 int db_d_open_update_cursor(void);
119 void db_double_quote_string(dbString *);
120 int db_driver(int, char **);
121 
122 int db_driver_mkdir(const char *, int, int);
123 int db_drop_column(dbDriver *, dbString *,
124  dbString *);
125 void db__drop_cursor_from_driver_state(dbCursor *);
126 int db_drop_index(dbDriver *, dbString *);
127 int db_drop_table(dbDriver *, dbString *);
128 void db_drop_token(dbToken);
129 int db_d_update(void);
130 int db_d_version(void);
131 int db_enlarge_string(dbString *, int);
132 void db_error(const char *);
133 int db_execute_immediate(dbDriver *, dbString *);
134 int db_begin_transaction(dbDriver *);
135 int db_commit_transaction(dbDriver *);
136 int db_fetch(dbCursor *, int, int *);
137 int db_find_database(dbDriver *, dbHandle *, int *);
138 dbAddress db_find_token(dbToken);
139 void db_free(void *);
140 void db_free_column(dbColumn *);
141 void db_free_cursor(dbCursor *);
142 void db_free_cursor_column_flags(dbCursor *);
143 void db_free_dbmscap(dbDbmscap *);
144 void db_free_dirent_array(dbDirent *, int);
145 void db_free_handle(dbHandle *);
146 void db_free_handle_array(dbHandle *, int);
147 void db_free_index(dbIndex *);
148 void db_free_index_array(dbIndex *, int);
149 void db_free_string(dbString *);
150 void db_free_string_array(dbString *, int);
151 void db_free_table(dbTable *);
152 int db_get_column(dbDriver *, const char *, const char *,
153  dbColumn **);
154 dbValue *db_get_column_default_value(dbColumn *);
155 const char *db_get_column_description(dbColumn *);
156 int db_get_column_host_type(dbColumn *);
157 int db_get_column_length(dbColumn *);
158 const char *db_get_column_name(dbColumn *);
159 int db_get_column_precision(dbColumn *);
160 int db_get_column_scale(dbColumn *);
161 int db_get_column_select_priv(dbColumn *);
162 int db_get_column_sqltype(dbColumn *);
163 int db_get_column_update_priv(dbColumn *);
164 dbValue *db_get_column_value(dbColumn *);
165 int db_get_connection(dbConnection *);
166 int db_get_cursor_number_of_columns(dbCursor *);
167 dbTable *db_get_cursor_table(dbCursor *);
168 dbToken db_get_cursor_token(dbCursor *);
169 const char *db_get_default_driver_name(void);
170 const char *db_get_default_database_name(void);
171 const char *db_get_default_schema_name(void);
172 const char *db_get_default_group_name(void);
173 dbDriverState *db__get_driver_state(void);
174 int db_get_error_code(void);
175 const char *db_get_error_msg(void);
176 const char *db_get_error_who(void);
177 const char *db_get_handle_dbname(dbHandle *);
178 const char *db_get_handle_dbschema(dbHandle *);
179 const char *db_get_index_column_name(dbIndex *, int);
180 const char *db_get_index_name(dbIndex *);
181 int db_get_index_number_of_columns(dbIndex *);
182 const char *db_get_index_table_name(dbIndex *);
183 int db_get_num_rows(dbCursor *);
184 char *db_get_string(const dbString *);
185 dbColumn *db_get_table_column(dbTable *, int);
186 dbColumn *db_get_table_column_by_name(dbTable *, const char*);
187 int db_get_table_delete_priv(dbTable *);
188 const char *db_get_table_description(dbTable *);
189 int db_get_table_insert_priv(dbTable *);
190 const char *db_get_table_name(dbTable *);
191 int db_get_table_number_of_columns(dbTable *);
192 int db_get_table_number_of_rows(dbDriver *, dbString *);
193 int db_get_table_select_priv(dbTable *);
194 int db_get_table_update_priv(dbTable *);
195 double db_get_value_as_double(dbValue *, int);
196 int db_get_value_day(dbValue *);
197 double db_get_value_double(dbValue *);
198 int db_get_value_hour(dbValue *);
199 int db_get_value_int(dbValue *);
200 int db_get_value_minute(dbValue *);
201 int db_get_value_month(dbValue *);
202 double db_get_value_seconds(dbValue *);
203 const char *db_get_value_string(dbValue *);
204 int db_get_value_year(dbValue *);
205 int db_grant_on_table(dbDriver *, const char *, int,
206  int);
207 int db_has_dbms(void);
208 void db_init_column(dbColumn *);
209 void db_init_cursor(dbCursor *);
210 void db__init_driver_state(void);
211 void db_init_handle(dbHandle *);
212 void db_init_index(dbIndex *);
213 void db_init_string(dbString *);
214 void db_init_table(dbTable *);
215 int db_insert(dbCursor *);
216 void db_interval_range(int, int *, int *);
217 int db_isdir(const char *);
218 int db_legal_tablename(const char *);
219 int db_list_databases(dbDriver *, dbString *, int,
220  dbHandle **, int *);
221 const char *db_list_drivers(void);
222 int db_list_indexes(dbDriver *, dbString *, dbIndex **,
223  int *);
224 int db_list_tables(dbDriver *, dbString **, int *,
225  int);
226 void *db_malloc(int);
227 void db__mark_database_closed(void);
228 void db__mark_database_open(const char *, const char *);
229 void db_memory_error(void);
230 dbToken db_new_token(dbAddress);
231 int db_nocase_compare(const char *, const char *);
232 void db_noproc_error(int);
233 int db_open_database(dbDriver *, dbHandle *);
234 int db_open_insert_cursor(dbDriver *, dbCursor *);
235 int db_open_select_cursor(dbDriver *, dbString *,
236  dbCursor *, int);
237 int db_open_update_cursor(dbDriver *, dbString *_name,
238  dbString *, dbCursor *, int);
239 void db_print_column_definition(FILE *, dbColumn *);
240 void db_print_error(void);
241 void db_print_index(FILE *, dbIndex *);
242 void db_print_table_definition(FILE *, dbTable *);
243 void db_procedure_not_implemented(const char *);
244 void db_protocol_error(void);
245 dbDbmscap *db_read_dbmscap(void);
246 void *db_realloc(void *, int);
247 int db__recv_char(char *);
248 int db__recv_column_default_value(dbColumn *);
249 int db__recv_column_definition(dbColumn *);
250 int db__recv_column_value(dbColumn *);
251 int db__recv_datetime(dbDateTime *);
252 int db__recv_double(double *);
253 int db__recv_double_array(double **, int *);
254 int db__recv_float(float *);
255 int db__recv_float_array(float **, int *);
256 int db__recv_handle(dbHandle *);
257 int db__recv_index(dbIndex *);
258 int db__recv_index_array(dbIndex **, int *);
259 int db__recv_int(int *);
260 int db__recv_int_array(int **, int *);
261 int db__recv_procnum(int *);
262 int db__recv_return_code(int *);
263 int db__recv_short(short *);
264 int db__recv_short_array(short **, int *);
265 int db__recv_string(dbString *);
266 int db__recv_string_array(dbString **, int *);
267 int db__recv_table_data(dbTable *);
268 int db__recv_table_definition(dbTable **);
269 int db__recv_token(dbToken *);
270 int db__recv_value(dbValue *, int);
271 int db__send_Cstring(const char *);
272 int db__send_char(int);
273 int db__send_column_default_value(dbColumn *);
274 int db__send_column_definition(dbColumn *);
275 int db__send_column_value(dbColumn *);
276 int db__send_datetime(dbDateTime *);
277 int db__send_double(double);
278 int db__send_double_array(const double *, int);
279 int db__send_failure(void);
280 int db__send_float(float);
281 int db__send_float_array(const float *, int);
282 int db__send_handle(dbHandle *);
283 int db__send_index(dbIndex *);
284 int db__send_index_array(dbIndex *, int);
285 int db__send_int(int);
286 int db__send_int_array(const int *, int);
287 int db__send_procedure_not_implemented(int);
288 int db__send_procedure_ok(int);
289 int db__send_short(int);
290 int db__send_short_array(const short *, int);
291 int db__send_string(dbString *);
292 int db__send_string_array(dbString *, int);
293 int db__send_success(void);
294 int db__send_table_data(dbTable *);
295 int db__send_table_definition(dbTable *);
296 int db__send_token(dbToken *);
297 int db__send_value(dbValue *, int);
298 int db_select_CatValArray(dbDriver *, const char *, const char *,
299  const char *, const char *,
300  dbCatValArray *);
301 int db_select_int(dbDriver *, const char *, const char *,
302  const char *, int **);
303 int db_select_value(dbDriver *, const char *, const char *,
304  int, const char *, dbValue *);
305 int db_set_column_description(dbColumn *, const char *);
306 void db_set_column_has_defined_default_value(dbColumn *);
307 void db_set_column_has_undefined_default_value(dbColumn *);
308 void db_set_column_host_type(dbColumn *, int);
309 void db_set_column_length(dbColumn *, int);
310 int db_set_column_name(dbColumn *, const char *);
311 void db_set_column_null_allowed(dbColumn *);
312 void db_set_column_precision(dbColumn *, int);
313 void db_set_column_scale(dbColumn *, int);
314 void db_set_column_select_priv_granted(dbColumn *);
315 void db_set_column_select_priv_not_granted(dbColumn *);
316 void db_set_column_sqltype(dbColumn *, int);
317 void db_set_column_update_priv_granted(dbColumn *);
318 void db_set_column_update_priv_not_granted(dbColumn *);
319 void db_set_column_use_default_value(dbColumn *);
320 int db_set_connection(dbConnection *);
321 void db_set_cursor_column_flag(dbCursor *, int);
322 void db_set_cursor_column_for_update(dbCursor *, int);
323 void db_set_cursor_mode(dbCursor *, int);
324 void db_set_cursor_mode_insensitive(dbCursor *);
325 void db_set_cursor_mode_scroll(dbCursor *);
326 void db_set_cursor_table(dbCursor *, dbTable *);
327 void db_set_cursor_token(dbCursor *, dbToken);
328 void db_set_cursor_type_insert(dbCursor *);
329 void db_set_cursor_type_readonly(dbCursor *);
330 void db_set_cursor_type_update(dbCursor *);
331 int db_set_default_connection(void);
332 void db_set_error_who(const char *);
333 int db_set_handle(dbHandle *, const char *, const char *);
334 void db_set_error_handler_driver(dbDriver *);
335 void db_unset_error_handler_driver(dbDriver *);
336 int db_set_index_column_name(dbIndex *, int,
337  const char *);
338 int db_set_index_name(dbIndex *, const char *);
339 int db_set_index_table_name(dbIndex *, const char *);
340 int db_set_index_type_non_unique(dbIndex *);
341 int db_set_index_type_unique(dbIndex *);
342 void db__set_protocol_fds(FILE *, FILE *);
343 int db_set_string(dbString *, const char *);
344 int db_set_string_no_copy(dbString *, char *);
345 int db_set_table_column(dbTable *, int, dbColumn *);
346 void db_set_table_delete_priv_granted(dbTable *);
347 void db_set_table_delete_priv_not_granted(dbTable *);
348 int db_set_table_description(dbTable *, const char *);
349 void db_set_table_insert_priv_granted(dbTable *);
350 void db_set_table_insert_priv_not_granted(dbTable *);
351 int db_set_table_name(dbTable *, const char *);
352 void db_set_table_select_priv_granted(dbTable *);
353 void db_set_table_select_priv_not_granted(dbTable *);
354 void db_set_table_update_priv_granted(dbTable *);
355 void db_set_table_update_priv_not_granted(dbTable *);
356 void db_set_value_datetime_current(dbValue *);
357 void db_set_value_datetime_not_current(dbValue *);
358 void db_set_value_day(dbValue *, int);
359 void db_set_value_double(dbValue *, double);
360 void db_set_value_hour(dbValue *, int);
361 void db_set_value_int(dbValue *, int);
362 void db_set_value_minute(dbValue *, int);
363 void db_set_value_month(dbValue *, int);
364 void db_set_value_not_null(dbValue *);
365 void db_set_value_null(dbValue *);
366 void db_set_value_seconds(dbValue *, double);
367 int db_set_value_string(dbValue *, const char *);
368 void db_set_value_year(dbValue *, int);
369 int db_shutdown_driver(dbDriver *);
370 const char *db_sqltype_name(int);
371 int db_sqltype_to_Ctype(int);
372 dbDriver *db_start_driver(const char *);
373 dbDriver *db_start_driver_open_database(const char *, const char *);
374 int db__start_procedure_call(int);
375 char *db_store(const char *);
376 void db_strip(char *);
377 void db_syserror(const char *);
378 int db_table_exists(const char *, const char *,
379  const char *);
380 int db_test_column_has_default_value(dbColumn *);
381 int db_test_column_has_defined_default_value(dbColumn *);
382 int db_test_column_has_undefined_default_value(dbColumn *);
383 int db_test_column_null_allowed(dbColumn *);
384 int db_test_column_use_default_value(dbColumn *);
385 int db_test_cursor_any_column_flag(dbCursor *);
386 int db_test_cursor_any_column_for_update(dbCursor *);
387 int db_test_cursor_column_flag(dbCursor *, int);
388 int db_test_cursor_column_for_update(dbCursor *, int);
389 int db_test_cursor_mode_insensitive(dbCursor *);
390 int db_test_cursor_mode_scroll(dbCursor *);
391 int db_test_cursor_type_fetch(dbCursor *);
392 int db_test_cursor_type_insert(dbCursor *);
393 int db_test_cursor_type_update(dbCursor *);
394 int db__test_database_open(void);
395 int db_test_index_type_unique(dbIndex *);
396 int db_test_value_datetime_current(dbValue *);
397 int db_test_value_isnull(dbValue *);
398 void db_unset_column_has_default_value(dbColumn *);
399 void db_unset_column_null_allowed(dbColumn *);
400 void db_unset_column_use_default_value(dbColumn *);
401 void db_unset_cursor_column_flag(dbCursor *, int);
402 void db_unset_cursor_column_for_update(dbCursor *, int);
403 void db_unset_cursor_mode(dbCursor *);
404 void db_unset_cursor_mode_insensitive(dbCursor *);
405 void db_unset_cursor_mode_scroll(dbCursor *);
406 int db_update(dbCursor *);
407 int db_gversion(dbDriver *, dbString *,
408  dbString *);
409 const char *db_whoami(void);
410 void db_zero(void *, int);
411 void db_zero_string(dbString *);
412 unsigned int db_sizeof_string(const dbString *);
413 int db_set_login(const char *, const char *, const char *, const char *);
414 int db_set_login2(const char *, const char *, const char *, const char *,
415  const char *, const char *, int);
416 int db_get_login(const char *, const char *, const char **, const char **);
417 int db_get_login2(const char *, const char *, const char **, const char **,
418  const char **, const char **);
419 int db_get_login_dump(FILE *);
420 
421 #endif
db_realloc
void * db_realloc(void *, int)
Reallocate memory.
Definition: db/dbmi_base/alloc.c:93
db__send_int_array
int db__send_int_array(const int *, int)
Send integer array.
Definition: xdrint.c:65
db__get_driver_state
dbDriverState * db__get_driver_state(void)
Get driver state.
Definition: driver_state.c:35
db_get_column_default_value
dbValue * db_get_column_default_value(dbColumn *)
Returns column default value for given column structure.
Definition: dbmi_base/column.c:39
db_store
char * db_store(const char *)
Make a copy of string buffer.
Definition: db/dbmi_base/alloc.c:28
db_set_index_type_unique
int db_set_index_type_unique(dbIndex *)
Set index type to unique.
Definition: db/dbmi_base/index.c:212
db_describe_table
int db_describe_table(dbDriver *, dbString *, dbTable **)
Describe table.
Definition: c_desc_table.c:28
db_get_handle_dbname
const char * db_get_handle_dbname(dbHandle *)
Get handle database name.
Definition: handle.c:57
db_d_get_num_rows
int db_d_get_num_rows(void)
Get number of selected rows.
Definition: d_rows.c:25
db__recv_double
int db__recv_double(double *)
Receive double.
Definition: xdrdouble.c:42
db_begin_transaction
int db_begin_transaction(dbDriver *)
Begin transaction.
Definition: c_execute.c:56
db_set_table_select_priv_granted
void db_set_table_select_priv_granted(dbTable *)
Grant selection privileges for all columns.
Definition: dbmi_base/table.c:175
db_free_index_array
void db_free_index_array(dbIndex *, int)
Free index array.
Definition: db/dbmi_base/index.c:92
db_whoami
const char * db_whoami(void)
Who am i?
Definition: db/dbmi_base/whoami.c:26
db_free_dirent_array
void db_free_dirent_array(dbDirent *, int)
Free dbDirent.
Definition: dirent.c:123
db_d_begin_transaction
int db_d_begin_transaction(void)
Begin transaction.
Definition: d_execute.c:56
db_get_column_value
dbValue * db_get_column_value(dbColumn *)
Returns column value for given column structure.
Definition: dbmi_base/column.c:27
db_create_table
int db_create_table(dbDriver *, dbTable *)
Create table.
Definition: c_create_tab.c:27
db_CatValArray_init
void db_CatValArray_init(dbCatValArray *)
Initialize dbCatValArray.
Definition: value.c:361
db_alloc_cursor_column_flags
int db_alloc_cursor_column_flags(dbCursor *)
Allocate columns' flags for cursor.
Definition: cursor.c:276
db_CatValArray_get_value_int
int db_CatValArray_get_value_int(dbCatValArray *, int, int *)
Find value (integer) by key.
Definition: db/dbmi_client/select.c:492
db_d_close_cursor
int db_d_close_cursor(void)
Close cursor.
Definition: d_close_cur.c:26
db_test_cursor_column_for_update
int db_test_cursor_column_for_update(dbCursor *, int)
Check if column flag is 'update'.
Definition: cursor.c:333
db_d_open_insert_cursor
int db_d_open_insert_cursor(void)
Open insert cursor.
Definition: d_openinsert.c:25
db_auto_print_protocol_errors
void db_auto_print_protocol_errors(int)
Set auto print protocol error.
Definition: db/dbmi_base/error.c:260
db_bind_update
int db_bind_update(dbCursor *)
?
Definition: c_bindupdate.c:26
db_get_connection
int db_get_connection(dbConnection *)
Get default DB connection settings for the current mapset.
Definition: db/dbmi_base/connect.c:73
db_test_cursor_type_fetch
int db_test_cursor_type_fetch(dbCursor *)
Check cursor type.
Definition: cursor.c:144
db_start_driver
dbDriver * db_start_driver(const char *)
Initialize a new dbDriver for db transaction.
Definition: start.c:50
db_column_sqltype
int db_column_sqltype(dbDriver *, const char *, const char *)
Get column sqltype.
Definition: dbmi_client/column.c:51
db_set_column_null_allowed
void db_set_column_null_allowed(dbColumn *)
Set null value to be allowed.
Definition: dbmi_base/column.c:268
_dbmscap
Definition: dbmi.h:153
db_char_to_lowercase
void db_char_to_lowercase(char *)
Convert character to lowercase.
Definition: case.c:22
db_set_index_name
int db_set_index_name(dbIndex *, const char *)
Set index name.
Definition: db/dbmi_base/index.c:112
db__send_procedure_not_implemented
int db__send_procedure_not_implemented(int)
?
Definition: xdrprocedure.c:81
db_list_tables
int db_list_tables(dbDriver *, dbString **, int *, int)
List available tables for given connection.
Definition: c_list_tabs.c:39
db_copy_table_where
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)
Definition: copy_tab.c:469
db__recv_float
int db__recv_float(float *)
Receive float.
Definition: xdrfloat.c:44
db__send_column_value
int db__send_column_value(dbColumn *)
Send column value.
Definition: xdrcolumn.c:81
db_d_commit_transaction
int db_d_commit_transaction(void)
Commit transaction.
Definition: d_execute.c:80
db_set_column_sqltype
void db_set_column_sqltype(dbColumn *, int)
Define column sqltype for column.
Definition: dbmi_base/column.c:71
db_add_column
int db_add_column(dbDriver *, dbString *, dbColumn *)
Add column to table.
Definition: c_add_col.c:28
db_get_column_length
int db_get_column_length(dbColumn *)
Get column's length.
Definition: dbmi_base/column.c:303
db_strip
void db_strip(char *)
Strip given string.
Definition: strip.c:25
db_driver
int db_driver(int, char **)
db_get_column_name
const char * db_get_column_name(dbColumn *)
Returns column name for given column.
Definition: dbmi_base/column.c:418
db_copy_value
void db_copy_value(dbValue *, dbValue *)
Copy value.
Definition: value.c:340
db_unset_cursor_mode_scroll
void db_unset_cursor_mode_scroll(dbCursor *)
Unset 'scroll' cursor mode.
Definition: cursor.c:207
db_d_report_error
void void db_d_report_error(void)
Report error message for DB driver.
Definition: d_error.c:90
db_d_version
int db_d_version(void)
Get version info.
Definition: d_version.c:24
db_legal_tablename
int db_legal_tablename(const char *)
Check if output is legal table name.
Definition: legal_dbname.c:31
db_set_value_hour
void db_set_value_hour(dbValue *, int)
Set hour value.
Definition: value.c:267
db_isdir
int db_isdir(const char *)
Test if path is a directory.
Definition: isdir.c:29
db_enlarge_string
int db_enlarge_string(dbString *, int)
Enlarge dbString.
Definition: string.c:120
db_init_string
void db_init_string(dbString *)
Initialize dbString.
Definition: string.c:25
db_set_column_use_default_value
void db_set_column_use_default_value(dbColumn *)
Set default value to be used.
Definition: dbmi_base/column.c:235
db_d_delete
int db_d_delete(void)
Delete record (?)
Definition: d_delete.c:25
db_set_table_delete_priv_not_granted
void db_set_table_delete_priv_not_granted(dbTable *)
Set delete privileges not granted for table.
Definition: dbmi_base/table.c:281
db_test_index_type_unique
int db_test_index_type_unique(dbIndex *)
Test if type is unique.
Definition: db/dbmi_base/index.c:243
db_char_to_uppercase
void db_char_to_uppercase(char *)
Convert character to uppercase.
Definition: case.c:33
db_d_grant_on_table
int db_d_grant_on_table(void)
Grant privileges on table.
Definition: d_priv.c:26
_db_date_time
Definition: dbmi.h:182
db_get_table_name
const char * db_get_table_name(dbTable *)
Get the name of the table.
Definition: dbmi_base/table.c:101
db__send_failure
int db__send_failure(void)
Send failure code.
Definition: ret_codes.c:37
db_fetch
int db_fetch(dbCursor *, int, int *)
Fetch data from open cursor.
Definition: c_fetch.c:28
db_dbmscap_filename
const char * db_dbmscap_filename(void)
Get dbmscap file name.
Definition: dbmscap.c:59
db_d_create_database
int db_d_create_database(void)
Create database.
Definition: d_createdb.c:26
db_get_default_group_name
const char * db_get_default_group_name(void)
Get group name from current DB connection settings.
Definition: db/dbmi_base/default_name.c:75
db_zero
void db_zero(void *, int)
Zero allocated space.
Definition: db/dbmi_base/zero.c:23
db_open_select_cursor
int db_open_select_cursor(dbDriver *, dbString *, dbCursor *, int)
Open select cursor.
Definition: c_openselect.c:37
db_set_value_day
void db_set_value_day(dbValue *, int)
Set day value.
Definition: value.c:255
db_set_cursor_type_insert
void db_set_cursor_type_insert(dbCursor *)
Set cursor to be writable (insert)
Definition: cursor.c:131
db_alloc_dirent_array
dbDirent * db_alloc_dirent_array(int)
Allocate dirent array.
Definition: dirent.c:172
db_set_cursor_column_for_update
void db_set_cursor_column_for_update(dbCursor *, int)
Set Column flag to 'update'.
Definition: cursor.c:308
db__recv_index_array
int db__recv_index_array(dbIndex **, int *)
Receive index array.
Definition: xdrindex.c:96
db__recv_string
int db__recv_string(dbString *)
Reads a string from transport.
Definition: xdrstring.c:117
db_find_database
int db_find_database(dbDriver *, dbHandle *, int *)
Find database.
Definition: c_finddb.c:29
db__recv_short
int db__recv_short(short *)
Receive short.
Definition: xdrshort.c:46
_db_connection
Definition: dbmi.h:293
db_get_column_select_priv
int db_get_column_select_priv(dbColumn *)
Get select privileges.
Definition: dbmi_base/column.c:346
db_get_string
char * db_get_string(const dbString *)
Get string.
Definition: string.c:140
db__send_table_data
int db__send_table_data(dbTable *)
Send table data.
Definition: xdrtable.c:81
db_free_table
void db_free_table(dbTable *)
Free the table.
Definition: dbmi_base/table.c:68
db_Cstring_to_lowercase
void db_Cstring_to_lowercase(char *)
Convert string to lowercase.
Definition: case.c:44
db_d_list_indexes
int db_d_list_indexes(void)
List indexes.
Definition: d_list_idx.c:26
db_driver_mkdir
int db_driver_mkdir(const char *, int, int)
Create db directory.
Definition: d_mkdir.c:38
db_copy_string
int db_copy_string(dbString *, const dbString *)
Copy dbString.
Definition: string.c:230
db_update
int db_update(dbCursor *)
?
Definition: c_update.c:26
db__send_short_array
int db__send_short_array(const short *, int)
Send short array.
Definition: xdrshort.c:67
db_get_value_int
int db_get_value_int(dbValue *)
Get integer value.
Definition: value.c:38
db__send_success
int db__send_success(void)
Send success code.
Definition: ret_codes.c:26
db_CatValArray_realloc
int db_CatValArray_realloc(dbCatValArray *, int)
Realloc dbCatValArray.
Definition: value.c:420
db__send_float_array
int db__send_float_array(const float *, int)
Send float array.
Definition: xdrfloat.c:65
db_get_table_select_priv
int db_get_table_select_priv(dbTable *)
Get table select privileges.
Definition: dbmi_base/table.c:197
db_drop_index
int db_drop_index(dbDriver *, dbString *)
Drop index.
Definition: c_drop_index.c:27
db_d_drop_column
int db_d_drop_column(void)
Drop column.
Definition: d_drop_col.c:26
db_d_open_select_cursor
int db_d_open_select_cursor(void)
Open select cursor.
Definition: d_openselect.c:26
db_unset_cursor_mode_insensitive
void db_unset_cursor_mode_insensitive(dbCursor *)
Unset 'intensive' cursor mode.
Definition: cursor.c:237
db_test_column_has_default_value
int db_test_column_has_default_value(dbColumn *)
Check if column has defined default value.
Definition: dbmi_base/column.c:199
db_get_value_hour
int db_get_value_hour(dbValue *)
Get hour value.
Definition: value.c:140
db_get_login_dump
int db_get_login_dump(FILE *)
Print all connection settings to file.
Definition: login.c:394
db_d_close_database
int db_d_close_database(void)
Close database connection.
Definition: d_closedb.c:25
db_d_add_column
int db_d_add_column(void)
Add column to table.
Definition: d_add_col.c:26
db_free_cursor
void db_free_cursor(dbCursor *)
Free allocated dbCursor.
Definition: cursor.c:51
db_start_driver_open_database
dbDriver * db_start_driver_open_database(const char *, const char *)
Open driver/database connection.
Definition: db.c:28
db_delete_table
int db_delete_table(const char *, const char *, const char *)
Delete table.
Definition: delete_tab.c:29
db_set_handle
int db_set_handle(dbHandle *, const char *, const char *)
Set handle (database and schema name)
Definition: handle.c:39
db_d_update
int db_d_update(void)
?
Definition: d_update.c:25
db_unset_cursor_mode
void db_unset_cursor_mode(dbCursor *)
Unset cursor mode.
Definition: cursor.c:217
db_d_list_tables
int db_d_list_tables(void)
List available tables for given connection.
Definition: d_list_tabs.c:25
db_alloc_cursor_table
int db_alloc_cursor_table(dbCursor *, int)
Allocate table for cursor.
Definition: cursor.c:38
_db_cursor
Definition: dbmi.h:230
db_CatValArray_sort
void db_CatValArray_sort(dbCatValArray *)
Sort key/value array by key.
Definition: db/dbmi_client/select.c:417
db_free
void db_free(void *)
Free allocated memory.
Definition: db/dbmi_base/alloc.c:111
db_set_table_column
int db_set_table_column(dbTable *, int, dbColumn *)
Set a specific column for given table and column number.
Definition: dbmi_base/table.c:354
db_get_table_column_by_name
dbColumn * db_get_table_column_by_name(dbTable *, const char *)
Returns column structure for given table and column name.
Definition: dbmi_base/table.c:323
db_get_error_who
const char * db_get_error_who(void)
Definition: db/dbmi_base/error.c:59
dbToken
int dbToken
Definition: dbmi.h:145
db_syserror
void db_syserror(const char *)
Report system error.
Definition: db/dbmi_base/error.c:101
db_d_open_database
int db_d_open_database(void)
Open database connection.
Definition: d_opendb.c:26
db_get_column
int db_get_column(dbDriver *, const char *, const char *, dbColumn **)
Get column structure by table and column name.
Definition: dbmi_client/column.c:124
db_free_index
void db_free_index(dbIndex *)
Free allocated dbIndex.
Definition: db/dbmi_base/index.c:39
db_get_column_precision
int db_get_column_precision(dbColumn *)
Get column precision.
Definition: dbmi_base/column.c:117
db__send_procedure_ok
int db__send_procedure_ok(int)
?
Definition: xdrprocedure.c:69
db_get_value_minute
int db_get_value_minute(dbValue *)
Get minute value.
Definition: value.c:152
db_test_cursor_type_insert
int db_test_cursor_type_insert(dbCursor *)
Check if cursor type is 'insert'.
Definition: cursor.c:172
db_list_drivers
const char * db_list_drivers(void)
Return comma separated list of existing DB drivers, used for driver parameter options.
Definition: c_list_drivers.c:22
db_CatValArray_alloc
int db_CatValArray_alloc(dbCatValArray *, int)
Allocate dbCatValArray.
Definition: value.c:401
db_alloc_index_array
dbIndex * db_alloc_index_array(int)
Allocate index array.
Definition: db/dbmi_base/index.c:73
db__recv_column_value
int db__recv_column_value(dbColumn *)
Receive column value.
Definition: xdrcolumn.c:94
_db_driver_state
Definition: dbmi.h:249
db_convert_Cstring_to_value
int db_convert_Cstring_to_value(const char *, int, dbValue *)
Convert string to value.
Definition: valuefmt.c:31
db_copy_dbmscap_entry
void db_copy_dbmscap_entry(dbDbmscap *, dbDbmscap *)
Copy dbmscap entry.
Definition: dbmscap.c:81
db_set_string
int db_set_string(dbString *, const char *)
Inserts string to dbString (enlarge string)
Definition: string.c:41
db_debug_off
void db_debug_off(void)
Turn off debugging.
Definition: db/dbmi_base/error.c:218
db_dirent
dbDirent * db_dirent(const char *, int *)
Read directory and build an array of dbDirent's.
Definition: dirent.c:57
db_new_token
dbToken db_new_token(dbAddress)
Add new token.
Definition: db/dbmi_base/token.c:55
db_set_login
int db_set_login(const char *, const char *, const char *, const char *)
Set login parameters for driver/database.
Definition: login.c:263
db_get_column_update_priv
int db_get_column_update_priv(dbColumn *)
Get update privileges.
Definition: dbmi_base/column.c:378
db_close_database_shutdown_driver
int db_close_database_shutdown_driver(dbDriver *)
Close driver/database connection.
Definition: db.c:62
db_debug_on
void db_debug_on(void)
Turn on debugging.
Definition: db/dbmi_base/error.c:210
db_CatValArray_sort_by_value
int db_CatValArray_sort_by_value(dbCatValArray *)
Sort key/value array by value.
Definition: db/dbmi_client/select.c:430
db__send_index
int db__send_index(dbIndex *)
Send index.
Definition: xdrindex.c:26
db__recv_int_array
int db__recv_int_array(int **, int *)
Receive integer array.
Definition: xdrint.c:92
db__drop_cursor_from_driver_state
void db__drop_cursor_from_driver_state(dbCursor *)
Drop cursor from driver state.
Definition: driver_state.c:110
db_set_error_handler_driver
void db_set_error_handler_driver(dbDriver *)
Define standard error handler for open database connection.
Definition: db/dbmi_client/handler.c:38
db_convert_column_value_to_string
int db_convert_column_value_to_string(dbColumn *, dbString *)
?
Definition: columnfmt.c:61
db__recv_short_array
int db__recv_short_array(short **, int *)
Receive short array.
Definition: xdrshort.c:94
db__send_float
int db__send_float(float)
Send float.
Definition: xdrfloat.c:24
db_d_bind_update
int db_d_bind_update(void)
ADD.
Definition: d_bindupdate.c:25
db__send_datetime
int db__send_datetime(dbDateTime *)
Send datetime.
Definition: xdrdatetime.c:25
db_d_create_table
int db_d_create_table(void)
Create table.
Definition: d_create_tab.c:26
db_set_cursor_mode_scroll
void db_set_cursor_mode_scroll(dbCursor *)
Set 'scroll' cursor mode.
Definition: cursor.c:197
db_clone_table
dbTable * db_clone_table(dbTable *)
Make a new exact copy of an existing table.
Definition: dbmi_base/table.c:392
db_get_cursor_token
dbToken db_get_cursor_token(dbCursor *)
Get cursor token.
Definition: cursor.c:90
db_convert_Cstring_to_column_value
int db_convert_Cstring_to_column_value(const char *, dbColumn *)
?
Definition: columnfmt.c:25
db_d_describe_table
int db_d_describe_table(void)
Describe table.
Definition: d_desc_table.c:26
db__recv_table_definition
int db__recv_table_definition(dbTable **)
Receive table definition.
Definition: xdrtable.c:51
db_procedure_not_implemented
void db_procedure_not_implemented(const char *)
Report 'not implemented' error.
Definition: db/dbmi_base/error.c:145
db__add_cursor_to_driver_state
void db__add_cursor_to_driver_state(dbCursor *)
Add cursor do driver state.
Definition: driver_state.c:79
db_drop_token
void db_drop_token(dbToken)
Drop token.
Definition: db/dbmi_base/token.c:42
db_test_column_has_undefined_default_value
int db_test_column_has_undefined_default_value(dbColumn *)
Check if column has defined default value.
Definition: dbmi_base/column.c:225
db_test_value_datetime_current
int db_test_value_datetime_current(dbValue *)
Check if datatime is current.
Definition: value.c:305
db__mark_database_open
void db__mark_database_open(const char *, const char *)
Mark database as opened.
Definition: driver_state.c:57
db_d_append_error
void db_d_append_error(const char *,...) __attribute__((format(printf
db__recv_string_array
int db__recv_string_array(dbString **, int *)
Receive string array.
Definition: xdrstring.c:46
db__recv_return_code
int db__recv_return_code(int *)
Receive return code.
Definition: ret_codes.c:51
db_set_column_name
int db_set_column_name(dbColumn *, const char *)
Set column name.
Definition: dbmi_base/column.c:406
db_test_cursor_column_flag
int db_test_cursor_column_flag(dbCursor *, int)
Checks column's flag.
Definition: cursor.c:384
db_get_default_database_name
const char * db_get_default_database_name(void)
Get database name from current DB connection settings.
Definition: db/dbmi_base/default_name.c:43
db_grant_on_table
int db_grant_on_table(dbDriver *, const char *, int, int)
Grant privileges on table.
Definition: c_priv.c:29
db__recv_char
int db__recv_char(char *)
?
Definition: xdrchar.c:45
db_set_value_datetime_current
void db_set_value_datetime_current(dbValue *)
Set datetime to current.
Definition: value.c:315
db_unset_column_null_allowed
void db_unset_column_null_allowed(dbColumn *)
Unset null value to be allowed.
Definition: dbmi_base/column.c:278
db_set_value_minute
void db_set_value_minute(dbValue *, int)
Set minute value.
Definition: value.c:279
db_get_column_sqltype
int db_get_column_sqltype(dbColumn *)
Returns column sqltype for column.
Definition: dbmi_base/column.c:142
db__start_procedure_call
int db__start_procedure_call(int)
? (client only)
Definition: xdrprocedure.c:25
db_auto_print_errors
void db_auto_print_errors(int)
Toggles printing of DBMI error messages.
Definition: db/dbmi_base/error.c:249
db_test_value_isnull
int db_test_value_isnull(dbValue *)
Check of value is null.
Definition: value.c:26
db_alloc_index_columns
int db_alloc_index_columns(dbIndex *, int)
Allocate index columns.
Definition: db/dbmi_base/index.c:56
db_set_cursor_type_update
void db_set_cursor_type_update(dbCursor *)
Set cursor to be writable (update)
Definition: cursor.c:121
db_alloc_handle_array
dbHandle * db_alloc_handle_array(int)
Allocate array of handles.
Definition: handle.c:109
db_sqltype_name
const char * db_sqltype_name(int)
Get SQL data type description.
Definition: sqltype.c:25
db_debug
void db_debug(const char *)
Print debug message.
Definition: db/dbmi_base/error.c:228
db_append_string
int db_append_string(dbString *, const char *)
Append string to dbString.
Definition: string.c:205
db_d_drop_table
int db_d_drop_table(void)
Drop table.
Definition: d_drop_tab.c:26
db__recv_column_definition
int db__recv_column_definition(dbColumn *)
Receive column definition.
Definition: xdrcolumn.c:53
dbAddress
void * dbAddress
Definition: dbmi.h:144
db__send_short
int db__send_short(int)
Send short.
Definition: xdrshort.c:25
db_create_database
int db_create_database(dbDriver *, dbHandle *)
Create database.
Definition: c_createdb.c:27
db__recv_datetime
int db__recv_datetime(dbDateTime *)
Receive datetime.
Definition: xdrdatetime.c:47
db_test_cursor_any_column_flag
int db_test_cursor_any_column_flag(dbCursor *)
Checks columns' flag.
Definition: cursor.c:414
db_get_table_update_priv
int db_get_table_update_priv(dbTable *)
Get table update privileges.
Definition: dbmi_base/table.c:229
db__test_database_open
int db__test_database_open(void)
Test database connection.
Definition: driver_state.c:46
db_delete
int db_delete(dbCursor *)
Delete record (?)
Definition: c_delete.c:26
db_set_table_insert_priv_not_granted
void db_set_table_insert_priv_not_granted(dbTable *)
Set insert privileges not granted for table.
Definition: dbmi_base/table.c:249
db_get_column_host_type
int db_get_column_host_type(dbColumn *)
Get column host type.
Definition: dbmi_base/column.c:154
db_free_handle
void db_free_handle(dbHandle *)
Free dbHandle structure.
Definition: handle.c:79
db_set_value_datetime_not_current
void db_set_value_datetime_not_current(dbValue *)
Set value to non-current.
Definition: value.c:326
db__send_column_definition
int db__send_column_definition(dbColumn *)
Send column definition.
Definition: xdrcolumn.c:25
db_list_indexes
int db_list_indexes(dbDriver *, dbString *, dbIndex **, int *)
List indexes.
Definition: c_list_idx.c:29
dbCatVal
Definition: dbmi.h:266
db_select_value
int db_select_value(dbDriver *, const char *, const char *, int, const char *, dbValue *)
Select one (first) value from table/column for key/id.
Definition: db/dbmi_client/select.c:204
db_convert_value_to_string
int db_convert_value_to_string(dbValue *, int, dbString *)
Convert value to string.
Definition: valuefmt.c:67
db_set_table_description
int db_set_table_description(dbTable *, const char *)
Set the description of the table.
Definition: dbmi_base/table.c:114
db_get_error_code
int db_get_error_code(void)
Get error code.
Definition: db/dbmi_base/error.c:126
db_init_column
void db_init_column(dbColumn *)
Initialize dbColumn.
Definition: dbmi_base/column.c:388
db_set_cursor_token
void db_set_cursor_token(dbCursor *, dbToken)
Set cursor token.
Definition: cursor.c:101
db_CatValArray_get_value
int db_CatValArray_get_value(dbCatValArray *, int, dbCatVal **)
Find value by key.
Definition: db/dbmi_client/select.c:466
db_close_database
int db_close_database(dbDriver *)
Close database connection.
Definition: c_closedb.c:26
db_execute_immediate
int db_execute_immediate(dbDriver *, dbString *)
Execute SQL statements.
Definition: c_execute.c:27
db_d_open_update_cursor
int db_d_open_update_cursor(void)
Open update cursor.
Definition: d_openupdate.c:26
db_get_num_rows
int db_get_num_rows(dbCursor *)
Get number of selected rows.
Definition: c_rows.c:26
_db_value
Definition: dbmi.h:193
_db_handle
Definition: dbmi.h:175
db_alloc_string_array
dbString * db_alloc_string_array(int)
Allocate dbString array.
Definition: string.c:181
db__send_string
int db__send_string(dbString *)
Send string.
Definition: xdrstring.c:86
db_d_init_error
void db_d_init_error(const char *)
Init error message for DB driver.
Definition: d_error.c:47
db_set_value_month
void db_set_value_month(dbValue *, int)
Set month value.
Definition: value.c:243
db__recv_table_data
int db__recv_table_data(dbTable *)
Receive table data.
Definition: xdrtable.c:101
db_d_create_index
int db_d_create_index(void)
Create index.
Definition: d_create_idx.c:26
db_set_column_has_undefined_default_value
void db_set_column_has_undefined_default_value(dbColumn *)
Unset default value identificator.
Definition: dbmi_base/column.c:176
db_set_value_string
int db_set_value_string(dbValue *, const char *)
Set string value.
Definition: value.c:219
db_gversion
int db_gversion(dbDriver *, dbString *, dbString *)
Get version info.
Definition: c_version.c:31
db_set_value_seconds
void db_set_value_seconds(dbValue *, double)
Set seconds value.
Definition: value.c:291
db_set_cursor_table
void db_set_cursor_table(dbCursor *, dbTable *)
Set table for given cursor.
Definition: cursor.c:78
db_set_column_scale
void db_set_column_scale(dbColumn *, int)
Set column scale.
Definition: dbmi_base/column.c:105
db__send_column_default_value
int db__send_column_default_value(dbColumn *)
Send column default value.
Definition: xdrcolumn.c:107
db_sqltype_to_Ctype
int db_sqltype_to_Ctype(int)
Get C data type based on given SQL data type.
Definition: sqlCtype.c:24
db_create_index
int db_create_index(dbDriver *, dbIndex *)
Create index.
Definition: c_create_idx.c:28
_db_column
Definition: dbmi.h:202
db_sizeof_string
unsigned int db_sizeof_string(const dbString *)
Get string size.
Definition: string.c:67
db_memory_error
void db_memory_error(void)
Report memory error.
Definition: db/dbmi_base/error.c:134
db_get_value_seconds
double db_get_value_seconds(dbValue *)
Get seconds value.
Definition: value.c:164
db_shutdown_driver
int db_shutdown_driver(dbDriver *)
Closedown the driver, and free the driver structure.
Definition: shutdown.c:36
db_init_cursor
void db_init_cursor(dbCursor *)
Initialize dbCursor.
Definition: cursor.c:23
db_unset_error_handler_driver
void db_unset_error_handler_driver(dbDriver *)
Remove error handler before closing the driver.
Definition: db/dbmi_client/handler.c:48
db__recv_handle
int db__recv_handle(dbHandle *)
Receive handle.
Definition: xdrhandle.c:40
db_zero_string
void db_zero_string(dbString *)
Zero string.
Definition: string.c:79
db__recv_float_array
int db__recv_float_array(float **, int *)
Receive float array.
Definition: xdrfloat.c:92
db__recv_token
int db__recv_token(dbToken *)
Receive token.
Definition: xdrtoken.c:36
db_get_default_schema_name
const char * db_get_default_schema_name(void)
Get schema name from current DB connection settings.
Definition: db/dbmi_base/default_name.c:59
db_CatValArray_get_value_double
int db_CatValArray_get_value_double(dbCatValArray *, int, double *)
Find value (double) by key.
Definition: db/dbmi_client/select.c:518
db_get_value_year
int db_get_value_year(dbValue *)
Get year value.
Definition: value.c:104
db_has_dbms
int db_has_dbms(void)
Check dbms.
Definition: dbmscap.c:70
db__send_table_definition
int db__send_table_definition(dbTable *)
Send table definition.
Definition: xdrtable.c:26
db__recv_index
int db__recv_index(dbIndex *)
Receive index.
Definition: xdrindex.c:69
db_set_table_select_priv_not_granted
void db_set_table_select_priv_not_granted(dbTable *)
Set selection privileges not granted for all columns.
Definition: dbmi_base/table.c:185
db_clear_error
void db_clear_error(void)
Clear error status.
Definition: db/dbmi_base/error.c:171
db_set_value_double
void db_set_value_double(dbValue *, double)
Set double precision value.
Definition: value.c:207
db_test_column_null_allowed
int db_test_column_null_allowed(dbColumn *)
Checks if null value is allowed.
Definition: dbmi_base/column.c:291
db_calloc
void * db_calloc(int, int)
Allocate memory.
Definition: db/dbmi_base/alloc.c:69
db_get_value_as_double
double db_get_value_as_double(dbValue *, int)
Get value as double.
Definition: value.c:65
db_init_handle
void db_init_handle(dbHandle *)
Initialize handle (i.e database/schema)
Definition: handle.c:23
db_set_table_update_priv_granted
void db_set_table_update_priv_granted(dbTable *)
Grant update privileges for all columns.
Definition: dbmi_base/table.c:207
db_get_error_msg
const char * db_get_error_msg(void)
Get error message.
Definition: db/dbmi_base/error.c:239
db_set_value_null
void db_set_value_null(dbValue *)
Set value to null.
Definition: value.c:174
db_set_column_select_priv_granted
void db_set_column_select_priv_granted(dbColumn *)
Set select privileges to be granted.
Definition: dbmi_base/column.c:324
db_Cstring_to_uppercase
void db_Cstring_to_uppercase(char *)
Convert string to lowercase.
Definition: case.c:55
db_set_table_name
int db_set_table_name(dbTable *, const char *)
Set the name of the table.
Definition: dbmi_base/table.c:89
db_alloc_table
dbTable * db_alloc_table(int)
Allocate a table with a specific number of columns.
Definition: dbmi_base/table.c:28
db_get_table_description
const char * db_get_table_description(dbTable *)
Get the description of the table.
Definition: dbmi_base/table.c:126
db_test_column_use_default_value
int db_test_column_use_default_value(dbColumn *)
Checks if default value is used.
Definition: dbmi_base/column.c:258
db_unset_cursor_column_flag
void db_unset_cursor_column_flag(dbCursor *, int)
Unset column's flag.
Definition: cursor.c:369
db_noproc_error
void db_noproc_error(int)
Report no procedure error.
Definition: db/dbmi_base/error.c:159
db_free_dbmscap
void db_free_dbmscap(dbDbmscap *)
Free dbmscap.
Definition: dbmscap.c:259
db_set_value_year
void db_set_value_year(dbValue *, int)
Set year value.
Definition: value.c:231
db__send_token
int db__send_token(dbToken *)
Send token.
Definition: xdrtoken.c:24
db_copy_table_select
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)
Definition: copy_tab.c:493
db_set_connection
int db_set_connection(dbConnection *)
Set default DB connection settings.
Definition: db/dbmi_base/connect.c:28
db_create_index2
int db_create_index2(dbDriver *, const char *, const char *)
Create unique index.
Definition: c_create_idx.c:61
db__send_handle
int db__send_handle(dbHandle *)
Send handle.
Definition: xdrhandle.c:25
db_error
void db_error(const char *)
Report error message.
Definition: db/dbmi_base/error.c:69
db_convert_value_datetime_into_string
int db_convert_value_datetime_into_string(dbValue *, int, dbString *)
Convert datetime value into string.
Definition: datetime.c:31
db_get_value_string
const char * db_get_value_string(dbValue *)
Get string value.
Definition: value.c:92
db_set_column_description
int db_set_column_description(dbColumn *, const char *)
Set column description.
Definition: dbmi_base/column.c:432
db_free_string_array
void db_free_string_array(dbString *, int)
Free allocated dbString array.
Definition: string.c:163
db_open_database
int db_open_database(dbDriver *, dbHandle *)
Open database connection.
Definition: c_opendb.c:27
_db_driver
Definition: dbmi.h:168
db_d_drop_index
int db_d_drop_index(void)
Drop index.
Definition: d_drop_index.c:26
db_get_table_delete_priv
int db_get_table_delete_priv(dbTable *)
Get table delete privileges.
Definition: dbmi_base/table.c:293
db_nocase_compare
int db_nocase_compare(const char *, const char *)
Compare strings case-insensitive.
Definition: case.c:69
db_set_table_delete_priv_granted
void db_set_table_delete_priv_granted(dbTable *)
Grant delete privileges for table.
Definition: dbmi_base/table.c:271
db_get_index_name
const char * db_get_index_name(dbIndex *)
Get index name.
Definition: db/dbmi_base/index.c:124
db_unset_column_has_default_value
void db_unset_column_has_default_value(dbColumn *)
Unset default value identificator.
Definition: dbmi_base/column.c:186
db_commit_transaction
int db_commit_transaction(dbDriver *)
Commit transaction.
Definition: c_execute.c:82
db_find_token
dbAddress db_find_token(dbToken)
Find token.
Definition: db/dbmi_base/token.c:30
db_copy_table
int db_copy_table(const char *, const char *, const char *, const char *, const char *, const char *)
Copy a table.
Definition: copy_tab.c:446
db_get_value_double
double db_get_value_double(dbValue *)
Get double precision value.
Definition: value.c:50
db_set_index_column_name
int db_set_index_column_name(dbIndex *, int, const char *)
Set column name.
Definition: db/dbmi_base/index.c:177
db__send_char
int db__send_char(int)
?
Definition: xdrchar.c:24
db_get_login
int db_get_login(const char *, const char *, const char **, const char **)
Get login parameters for driver/database.
Definition: login.c:357
db__send_double_array
int db__send_double_array(const double *, int)
Send double array.
Definition: xdrdouble.c:63
db_get_index_number_of_columns
int db_get_index_number_of_columns(dbIndex *)
Get number of columns.
Definition: db/dbmi_base/index.c:162
db_set_cursor_type_readonly
void db_set_cursor_type_readonly(dbCursor *)
Set cursor to be read-only (select)
Definition: cursor.c:111
_db_dirent
Definition: dbmi.h:161
db_d_fetch
int db_d_fetch(void)
Fetch data.
Definition: d_fetch.c:28
_db_table
Definition: dbmi.h:220
db_interval_range
void db_interval_range(int, int *, int *)
Define range based on SQL data type.
Definition: interval.c:24
db_init_index
void db_init_index(dbIndex *)
Initialize dbIndex.
Definition: db/dbmi_base/index.c:25
db_set_column_host_type
void db_set_column_host_type(dbColumn *, int)
Set column host data type.
Definition: dbmi_base/column.c:82
db_CatValArray_free
void db_CatValArray_free(dbCatValArray *)
Free allocated dbCatValArray.
Definition: value.c:373
db_set_column_update_priv_granted
void db_set_column_update_priv_granted(dbColumn *)
Set update privileges to be granted.
Definition: dbmi_base/column.c:356
db_free_handle_array
void db_free_handle_array(dbHandle *, int)
Free array of handles.
Definition: handle.c:91
db__send_double
int db__send_double(double)
Send double.
Definition: xdrdouble.c:24
db_get_column_description
const char * db_get_column_description(dbColumn *)
Returns column description for given column.
Definition: dbmi_base/column.c:444
db__recv_procnum
int db__recv_procnum(int *)
? (driver only)
Definition: xdrprocedure.c:52
db_set_string_no_copy
int db_set_string_no_copy(dbString *, char *)
Inserts string to dbString (overwrite current value)
Definition: string.c:55
db_get_table_number_of_rows
int db_get_table_number_of_rows(dbDriver *, dbString *)
Get number of rows of table.
Definition: dbmi_client/table.c:104
db_get_handle_dbschema
const char * db_get_handle_dbschema(dbHandle *)
Get handle schema name.
Definition: handle.c:69
db_d_delete_database
int db_d_delete_database(void)
Delete database.
Definition: d_deletedb.c:26
db_unset_column_use_default_value
void db_unset_column_use_default_value(dbColumn *)
Unset default value to be used.
Definition: dbmi_base/column.c:245
db_set_value_int
void db_set_value_int(dbValue *, int)
Set integer value.
Definition: value.c:195
db_get_value_day
int db_get_value_day(dbValue *)
Get day value.
Definition: value.c:128
db__recv_value
int db__recv_value(dbValue *, int)
Receive value.
Definition: xdrvalue.c:62
db_set_column_has_defined_default_value
void db_set_column_has_defined_default_value(dbColumn *)
Set default value identificator.
Definition: dbmi_base/column.c:164
db_get_table_column
dbColumn * db_get_table_column(dbTable *, int)
Returns column structure for given table and column number.
Definition: dbmi_base/table.c:307
db_free_cursor_column_flags
void db_free_cursor_column_flags(dbCursor *)
Free columns' flags of cursor.
Definition: cursor.c:295
db__recv_column_default_value
int db__recv_column_default_value(dbColumn *)
Receive column default value.
Definition: xdrcolumn.c:120
db_d_list_databases
int db_d_list_databases(void)
List databases.
Definition: d_listdb.c:26
db__send_string_array
int db__send_string_array(dbString *, int)
Send string array.
Definition: xdrstring.c:26
db_set_index_table_name
int db_set_index_table_name(dbIndex *, const char *)
Set table name.
Definition: db/dbmi_base/index.c:138
db_test_cursor_mode_scroll
int db_test_cursor_mode_scroll(dbCursor *)
Check if cursor mode is 'scroll'.
Definition: cursor.c:250
db_set_cursor_mode
void db_set_cursor_mode(dbCursor *, int)
Set cursor mode.
Definition: cursor.c:187
db_double_quote_string
void db_double_quote_string(dbString *)
Replace each ' is replaced by ''.
Definition: string.c:240
db_drop_table
int db_drop_table(dbDriver *, dbString *)
Drop table.
Definition: c_drop_tab.c:28
db_column_Ctype
int db_column_Ctype(dbDriver *, const char *, const char *)
Get column ctype.
Definition: dbmi_client/column.c:99
db_append_table_column
int db_append_table_column(dbTable *, dbColumn *)
Append a specific column to given table.
Definition: dbmi_base/table.c:372
db_open_update_cursor
int db_open_update_cursor(dbDriver *, dbString *_name, dbString *, dbCursor *, int)
Open update cursor.
Definition: c_openupdate.c:30
db_set_cursor_column_flag
void db_set_cursor_column_flag(dbCursor *, int)
Set column's flag.
Definition: cursor.c:357
db_read_dbmscap
dbDbmscap * db_read_dbmscap(void)
Read dbmscap.
Definition: dbmscap.c:100
db_delete_database
int db_delete_database(dbDriver *, dbHandle *)
Delete database.
Definition: c_deletedb.c:27
db_init_table
void db_init_table(dbTable *)
Initialize the table to zero.
Definition: dbmi_base/table.c:56
db__recv_double_array
int db__recv_double_array(double **, int *)
Receive double array.
Definition: xdrdouble.c:90
db_get_index_table_name
const char * db_get_index_table_name(dbIndex *)
Get table name.
Definition: db/dbmi_base/index.c:150
db_table_exists
int db_table_exists(const char *, const char *, const char *)
Check if table exists.
Definition: dbmi_client/table.c:32
db_get_login2
int db_get_login2(const char *, const char *, const char **, const char **, const char **, const char **)
Get login parameters for driver/database.
Definition: login.c:379
db_protocol_error
void db_protocol_error(void)
Report protocol error.
Definition: db/dbmi_base/error.c:85
db_set_column_update_priv_not_granted
void db_set_column_update_priv_not_granted(dbColumn *)
Unset update privileges.
Definition: dbmi_base/column.c:366
db_get_table_insert_priv
int db_get_table_insert_priv(dbTable *)
Get table insert privileges.
Definition: dbmi_base/table.c:261
db_d_execute_immediate
int db_d_execute_immediate(void)
Execute SQL statements.
Definition: d_execute.c:26
db_print_index
void db_print_index(FILE *, dbIndex *)
Report index.
Definition: db/dbmi_base/index.c:254
db_test_cursor_type_update
int db_test_cursor_type_update(dbCursor *)
Check if cursor type is 'update'.
Definition: cursor.c:159
db_malloc
void * db_malloc(int)
Allocate memory.
Definition: db/dbmi_base/alloc.c:47
db_set_table_update_priv_not_granted
void db_set_table_update_priv_not_granted(dbTable *)
Set update privileges not granted for all columns.
Definition: dbmi_base/table.c:217
db__recv_int
int db__recv_int(int *)
Receive integer.
Definition: xdrint.c:44
db_convert_Cstring_to_value_datetime
int db_convert_Cstring_to_value_datetime(const char *, int, dbValue *)
Convert datetime string to value.
Definition: datetime.c:197
db_select_CatValArray
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)
Definition: db/dbmi_client/select.c:268
db_set_table_insert_priv_granted
void db_set_table_insert_priv_granted(dbTable *)
Grant insert privileges for table.
Definition: dbmi_base/table.c:239
db__send_index_array
int db__send_index_array(dbIndex *, int)
Send index array.
Definition: xdrindex.c:51
db__init_driver_state
void db__init_driver_state(void)
Initialize driver state.
Definition: driver_state.c:25
db_set_column_precision
void db_set_column_precision(dbColumn *, int)
Set column precision.
Definition: dbmi_base/column.c:128
db_get_cursor_table
dbTable * db_get_cursor_table(dbCursor *)
Get table allocated by cursor.
Definition: cursor.c:67
db_list_databases
int db_list_databases(dbDriver *, dbString *, int, dbHandle **, int *)
List databases.
Definition: c_listdb.c:30
db_test_column_has_defined_default_value
int db_test_column_has_defined_default_value(dbColumn *)
Check if column has defined default value.
Definition: dbmi_base/column.c:212
db_get_index_column_name
const char * db_get_index_column_name(dbIndex *, int)
Get column number.
Definition: db/dbmi_base/index.c:194
_db_string
Definition: dbmi.h:147
db_print_column_definition
void db_print_column_definition(FILE *, dbColumn *)
Print column definition info.
Definition: printtab.c:51
db__set_protocol_fds
void db__set_protocol_fds(FILE *, FILE *)
?
Definition: db/dbmi_base/xdr.c:75
db_print_error
void db_print_error(void)
Print error.
Definition: db/dbmi_base/error.c:183
db_get_table_number_of_columns
int db_get_table_number_of_columns(dbTable *)
Return the number of columns of the table.
Definition: dbmi_base/table.c:138
_db_index
Definition: dbmi.h:240
db_set_column_select_priv_not_granted
void db_set_column_select_priv_not_granted(dbColumn *)
Unset select privileges.
Definition: dbmi_base/column.c:334
db_d_insert
int db_d_insert(void)
Insert new record into table.
Definition: d_insert.c:25
db__mark_database_closed
void db__mark_database_closed(void)
Mark database as closed.
Definition: driver_state.c:67
db_test_cursor_mode_insensitive
int db_test_cursor_mode_insensitive(dbCursor *)
Check if cursor mode is 'intensive'.
Definition: cursor.c:263
db_copy_column
dbColumn * db_copy_column(dbColumn *, dbColumn *)
Copy a db column from source to destination.
Definition: dbmi_base/column.c:473
db__send_value
int db__send_value(dbValue *, int)
Send value.
Definition: xdrvalue.c:28
db_select_int
int db_select_int(dbDriver *, const char *, const char *, const char *, int **)
Select array of ordered integers from table/column.
Definition: db/dbmi_client/select.c:103
db_copy_table_by_ints
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)
Definition: copy_tab.c:519
db_insert
int db_insert(dbCursor *)
Insert new record into table.
Definition: c_insert.c:26
db__close_all_cursors
void db__close_all_cursors(void)
Close all cursors.
Definition: driver_state.c:122
db_set_value_not_null
void db_set_value_not_null(dbValue *)
Set value to not null.
Definition: value.c:184
db_test_cursor_any_column_for_update
int db_test_cursor_any_column_for_update(dbCursor *)
Check if columns' flag is 'update'.
Definition: cursor.c:346
db_get_default_driver_name
const char * db_get_default_driver_name(void)
Get driver name from current DB connection settings.
Definition: db/dbmi_base/default_name.c:27
db_get_value_month
int db_get_value_month(dbValue *)
Get month value.
Definition: value.c:116
db_set_login2
int db_set_login2(const char *, const char *, const char *, const char *, const char *, const char *, int)
Set login parameters for driver/database.
Definition: login.c:284
db_free_string
void db_free_string(dbString *)
Free allocated space for dbString.
Definition: string.c:150
db_get_column_scale
int db_get_column_scale(dbColumn *)
Get column scale.
Definition: dbmi_base/column.c:94
db_set_column_length
void db_set_column_length(dbColumn *, int)
Set column's length.
Definition: dbmi_base/column.c:314
db__send_int
int db__send_int(int)
Send integer.
Definition: xdrint.c:24
db_d_find_database
int db_d_find_database(void)
Find database.
Definition: d_finddb.c:26
db_close_cursor
int db_close_cursor(dbCursor *)
Close cursor.
Definition: c_close_cur.c:27
__attribute__
#define __attribute__(x)
Definition: gis.h:38
db_drop_column
int db_drop_column(dbDriver *, dbString *, dbString *)
Drop column.
Definition: c_drop_col.c:28
db_open_insert_cursor
int db_open_insert_cursor(dbDriver *, dbCursor *)
Open insert cursor.
Definition: c_openinsert.c:27
db_unset_cursor_column_for_update
void db_unset_cursor_column_for_update(dbCursor *, int)
Unset 'update' column flag.
Definition: cursor.c:319
db_convert_Cstring_to_column_default_value
int db_convert_Cstring_to_column_default_value(const char *, dbColumn *)
?
Definition: columnfmt.c:43
db_set_index_type_non_unique
int db_set_index_type_non_unique(dbIndex *)
Set index type to non-unique.
Definition: db/dbmi_base/index.c:228
db__send_Cstring
int db__send_Cstring(const char *)
Send C string.
Definition: xdrstring.c:150
db_set_error_who
void db_set_error_who(const char *)
Set 'who' for error messages.
Definition: db/dbmi_base/error.c:46
db_set_cursor_mode_insensitive
void db_set_cursor_mode_insensitive(dbCursor *)
Set 'intensive' cursor mode.
Definition: cursor.c:227
db_convert_column_default_value_to_string
int db_convert_column_default_value_to_string(dbColumn *, dbString *)
?
Definition: columnfmt.c:79
db_print_table_definition
void db_print_table_definition(FILE *, dbTable *)
Print table definition info.
Definition: printtab.c:26
db_free_column
void db_free_column(dbColumn *)
Frees column structure.
Definition: dbmi_base/column.c:454
db_get_cursor_number_of_columns
int db_get_cursor_number_of_columns(dbCursor *)
Get number of columns.
Definition: cursor.c:394
db_set_default_connection
int db_set_default_connection(void)
Sets up database connection settings using GRASS default from dbmi.h.
Definition: db/dbmi_base/default_name.c:95
db_table_to_sql
int db_table_to_sql(dbTable *, dbString *)
Create SQL CREATE sring from table definition.
Definition: dbmi_base/table.c:424