| 39 | struct cbr_s { |
| 40 | char filename[64]; |
| 41 | char tablename[64]; |
| 42 | char command[2048]; |
| 43 | sqlite3 *db; |
| 44 | unsigned int num_columns; |
| 45 | }; |
| 46 | |
| 47 | |
| 48 | // open a database or create a database if it does not exist |
| 49 | int OpenDatabase(cbr _cbr); |
| 50 | |
| 51 | |
| 52 | // simple callback function, display result |
| 53 | int callback(void *notUsed, int argc, char **argv, char **azColName); |
| 54 | |
| 55 | |
| 56 | // execute command |
| 57 | int ExecuteCommand(cbr _cbr); |
| 58 | |
| 59 | |
| 60 | // execute search command |
| 61 | int ExecuteSearchCommand(cbr _cbr, float *_retvals); |
| 62 | |
| 63 | |
| 64 | // create database |
| 65 | cbr cbr_create(char * _filename, char * _tablename, char * _cols[], unsigned int _len); |
| 66 | |
| 67 | |
| 68 | // free space |
| 69 | void cbr_free(cbr _cbr); |
| 70 | |
| 71 | |
| 72 | // print |
| 73 | void cbr_print(cbr _cbr); |
| 74 | |
| 75 | |
| 76 | // cbr search |
| 77 | int cbr_search( |
| 78 | cbr _cbr, |
| 79 | char *_names[], |
| 80 | int * _ops, |
| 81 | float *_vals, |
| 82 | unsigned int _n, |
| 83 | float *_retvals); |
| 84 | |
| 85 | |
| 86 | // update a row |
| 87 | int cbr_update(cbr _cbr, char *_where[], char*_set[], float *_wherevals, float *_setvals, |
| 88 | unsigned int _wherelen, unsigned int _setlen); |
| 89 | |
| 90 | // cbr add a row |
| 91 | int cbr_add_row(cbr _cbr, char *_cols[], float *_vals, unsigned int _len); |
| 92 | |