aboutsummaryrefslogtreecommitdiff
path: root/tests/sqlite/test.c
diff options
context:
space:
mode:
authorAlon Zakai <alonzakai@gmail.com>2011-09-10 22:01:22 -0700
committerAlon Zakai <alonzakai@gmail.com>2011-09-10 22:01:22 -0700
commit2c3ff193882ab6355a39e2fa280e88d3ce3858e4 (patch)
tree74e92ba98910058dedb570cb084a76b82e26c395 /tests/sqlite/test.c
parenta93550e86ff2d9e0dca5bad6f23fea89d5e7210b (diff)
clean up sqlite test
Diffstat (limited to 'tests/sqlite/test.c')
-rw-r--r--tests/sqlite/test.c44
1 files changed, 44 insertions, 0 deletions
diff --git a/tests/sqlite/test.c b/tests/sqlite/test.c
new file mode 100644
index 00000000..7b8cf197
--- /dev/null
+++ b/tests/sqlite/test.c
@@ -0,0 +1,44 @@
+#include <stdio.h>
+#include <sqlite3.h>
+
+static int callback(void *NotUsed, 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");
+ }
+ printf("\n");
+ return 0;
+}
+
+int main(){
+ sqlite3 *db;
+ char *zErrMsg = 0;
+ int rc;
+ int i;
+ const char *commands[] = {
+ "CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100));",
+ "INSERT INTO t1 VALUES(1,13153,'thirteen thousand one hundred fifty three');",
+ "INSERT INTO t1 VALUES(1,987,'some other number');",
+ "SELECT count(*) FROM t1;",
+ "SELECT a, b, c FROM t1;",
+ NULL
+ };
+
+ rc = sqlite3_open(":memory:", &db);
+ if( rc ){
+ fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
+ sqlite3_close(db);
+ exit(1);
+ }
+ for (i = 0; commands[i]; i++) {
+ rc = sqlite3_exec(db, commands[i], callback, 0, &zErrMsg);
+ if( rc!=SQLITE_OK ){
+ fprintf(stderr, "SQL error on %d: %s\n", i, zErrMsg);
+ sqlite3_free(zErrMsg);
+ exit(1);
+ }
+ }
+ sqlite3_close(db);
+ return 0;
+}
+