1 files changed, 18 insertions, 0 deletions
diff --git a/external/glim/test_sqlite.cc b/external/glim/test_sqlite.cc
new file mode 100644
index 000000000..726244875
--- /dev/null
+++ b/external/glim/test_sqlite.cc
@@ -0,0 +1,18 @@
+
+#include "sqlite.hpp"
+#define S(cstr) (std::pair<char const*, int> (cstr, sizeof (cstr) - 1))
+#include <assert.h>
+#include <iostream>
+using namespace glim;
+
+int main () {
+  std::cout << "Testing sqlite.hpp ... " << std::flush;
+  Sqlite sqlite (":memory:");
+  SqliteSession sqs (&sqlite);
+  assert (sqs.query ("CREATE TABLE test (t TEXT, i INTEGER)") .ustep() == 0);
+  assert (sqs.query ("INSERT INTO test VALUES (?, ?)") .bind (1, S("foo")) .bind (2, 27) .ustep() == 1);
+  assert (sqs.query ("SELECT t FROM test") .qstep() .stringAt (1) == "foo");
+  assert (sqs.query ("SELECT i FROM test") .qstep() .intAt (1) == 27);
+  std::cout << "pass." << std::endl;
+  return 0;
+}