Changeset 21 for vtcross

Timestamp:

10/22/08 13:11:34 (16 years ago)

Author:

ahe

Message:

use callback return search results

Files:

• vtcross/trunk/src/cbr.c (modified) (6 diffs)

vtcross/trunk/src/cbr.c

@@ -39 +39 @@
 
 
-//int cbr_callback(void *notUsed, int argc, char **argv, char **azColName)
+//int cbr_callback(float *retvals, int argc, char **argv, char **azColName)
 int callback(void *notUsed, int argc, char **argv, char **azColName){
     int i;
@@ -48 +48 @@
     return 0;
 }
+
+
+int SearchCallback(float *_retvals, int argc, char **argv, char **azColName){
+    int i;
+    for(i=0; i<argc; i++){
+        printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
+        sscanf((argv[i] ? argv[i] : "NULL"), "%f", _retvals+i);
+    }
+    printf("\n");
+    return 0;
+}
+
 
 
@@ -66 +78 @@
 
 
+int ExecuteSearchCommand(cbr _cbr, float *_retvals){
+    int rc;
+    char *zErrMsg = 0;
+
+    printf("command: %s\n", _cbr->command);
+    rc = sqlite3_exec(_cbr->db, _cbr->command, SearchCallback, _retvals, &zErrMsg);
+    //rc = sqlite3_exec(_cbr->db, _cbr->command, SearchCallback, 0, &zErrMsg);
+    if( rc!=SQLITE_OK){
+        fprintf(stderr, "SQL error: %s\n", zErrMsg);
+        sqlite3_free(zErrMsg);
+    } else{
+        printf("command executed.\n");
+    }
+    return rc;
+}
+
+
+
 cbr cbr_create(char * _filename, char * _tablename, char * _cols[], unsigned int _len)
 {
@@ -154 +184 @@
     "==", "!=", ">", ">=", "<", "<="};
 
+
+// cbr search
 int cbr_search(
     cbr _cbr,
@@ -163 +195 @@
 {
     // set up statement
-
-    /*char* zErrMsg = NULL;
-    //sqlite3_exec(_cbr->db, argv[2], callback, NULL, &zErrMsg);
-    sqlite3_exec(_cbr->db, _cbr->command, cbr_callback, NULL, &zErrMsg);*/
 
     // generate command
@@ -198 +226 @@
     //printf("command: %s\n", _cbr->command);
     ExecuteCommand(_cbr);
+    ExecuteSearchCommand(_cbr, _retvals);
+    printf("search result: ");
+    for (i=0; i<_cbr->num_columns; i++)
+        printf("%f, ",_retvals[i]);
+    printf("\n");
 
     return 0;