summaryrefslogtreecommitdiff
path: root/libsqlite3/test/driver.c
diff options
context:
space:
mode:
Diffstat (limited to 'libsqlite3/test/driver.c')
-rw-r--r--libsqlite3/test/driver.c56
1 files changed, 56 insertions, 0 deletions
diff --git a/libsqlite3/test/driver.c b/libsqlite3/test/driver.c
new file mode 100644
index 0000000..2eabb06
--- /dev/null
+++ b/libsqlite3/test/driver.c
@@ -0,0 +1,56 @@
+/* file : test/driver.c
+ * copyright : not copyrighted - public domain
+ */
+
+/*
+ * Basic test to make sure the library is usable.
+ */
+
+#ifdef NDEBUG
+# undef NDEBUG
+#endif
+
+#include <sqlite3.h>
+
+#include <stddef.h> /* NULL */
+#include <assert.h>
+
+static int
+sql (sqlite3* db, const char* stmt)
+{
+ return sqlite3_exec (db, stmt, NULL, NULL, NULL) == SQLITE_OK;
+}
+
+int
+main ()
+{
+ sqlite3* db;
+ int r;
+
+ r = sqlite3_open_v2 (":memory:",
+ &db,
+ SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE,
+ NULL);
+ assert (r == SQLITE_OK);
+
+ assert (sql (db, "BEGIN"));
+ assert (sql (db, "CREATE TABLE test (id INTEGER PRIMARY KEY, str TEXT)"));
+ assert (sql (db, "COMMIT"));
+
+ assert (sql (db, "BEGIN"));
+ assert (sql (db, "INSERT INTO test VALUES (123, 'abc')"));
+ assert (sql (db, "COMMIT"));
+
+ assert (sql (db, "BEGIN"));
+ assert (!sql (db, "INSERT INTO test VALUES (123, 'ABC')"));
+ assert (sql (db, "ROLLBACK"));
+
+ assert (sql (db, "BEGIN"));
+ assert (sql (db, "DROP TABLE test"));
+ assert (sql (db, "COMMIT"));
+
+ r = sqlite3_close (db);
+ assert (r == SQLITE_OK);
+
+ return 0;
+}