diff options
author | Alon Zakai <alonzakai@gmail.com> | 2011-10-09 07:27:06 -0700 |
---|---|---|
committer | Alon Zakai <alonzakai@gmail.com> | 2011-10-09 07:27:06 -0700 |
commit | 8c35202927a7cd8f14b219e4949195e1e6bc6946 (patch) | |
tree | 2cc79d36f916c220b3bc449cba4d3ab602f534c4 /tests/sqlite/test.c | |
parent | efaf3590ac33702eeff423e31e85f690b1fc7eb2 (diff) | |
parent | 06354eda6092add55034c692bd65734a61083e8b (diff) |
Merge branch 'llvm-svn'
Conflicts:
src/dlmalloc.c
tests/dlmalloc.c
tests/runner.py
tools/shared.py
Diffstat (limited to 'tests/sqlite/test.c')
-rw-r--r-- | tests/sqlite/test.c | 44 |
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; +} + |