From f634bafc38bb948e41f829b16f03e2f0b8ee8f93 Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Thu, 30 Apr 2015 00:27:27 +0100
Subject: Adds support for SQLite, SQLite mocking and some basic tests

---
 libsqlitepp/command.cpp | 100 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 100 insertions(+)
 create mode 100644 libsqlitepp/command.cpp

(limited to 'libsqlitepp/command.cpp')

diff --git a/libsqlitepp/command.cpp b/libsqlitepp/command.cpp
new file mode 100644
index 0000000..ce2758b
--- /dev/null
+++ b/libsqlitepp/command.cpp
@@ -0,0 +1,100 @@
+#include "command.h"
+#include "connection.h"
+#include <stdlib.h>
+#include <string.h>
+
+SQLite::Command::Command(const Connection * conn, const std::string & sql) :
+	DB::Command(sql),
+	c(conn)
+{
+	if (sqlite3_prepare_v2(conn->db, sql.c_str(), sql.length(), &stmt, NULL) != SQLITE_OK) {
+		throw Error(sqlite3_errmsg(conn->db));
+	}
+}
+
+SQLite::Command::~Command()
+{
+	sqlite3_finalize(stmt);
+}
+
+void
+SQLite::Command::bindParamI(unsigned int n, int v)
+{
+	if (sqlite3_bind_int(stmt, n + 1, v) != SQLITE_OK) {
+		throw Error(sqlite3_errmsg(c->db));
+	}
+}
+void
+SQLite::Command::bindParamI(unsigned int n, long int v)
+{
+	if (sqlite3_bind_int64(stmt, n + 1, v) != SQLITE_OK) {
+		throw Error(sqlite3_errmsg(c->db));
+	}
+}
+void
+SQLite::Command::bindParamI(unsigned int n, long long int v)
+{
+	if (sqlite3_bind_int64(stmt, n + 1, v) != SQLITE_OK) {
+		throw Error(sqlite3_errmsg(c->db));
+	}
+}
+void
+SQLite::Command::bindParamI(unsigned int n, unsigned int v)
+{
+	if (sqlite3_bind_int64(stmt, n + 1, v) != SQLITE_OK) {
+		throw Error(sqlite3_errmsg(c->db));
+	}
+}
+void
+SQLite::Command::bindParamI(unsigned int n, long unsigned int v)
+{
+	if (sqlite3_bind_int64(stmt, n + 1, v) != SQLITE_OK) {
+		throw Error(sqlite3_errmsg(c->db));
+	}
+}
+void
+SQLite::Command::bindParamI(unsigned int n, long long unsigned int v)
+{
+	if (sqlite3_bind_int64(stmt, n + 1, v) != SQLITE_OK) {
+		throw Error(sqlite3_errmsg(c->db));
+	}
+}
+void
+SQLite::Command::bindParamF(unsigned int n, double v)
+{
+	if (sqlite3_bind_double(stmt, n + 1, v) != SQLITE_OK) {
+		throw Error(sqlite3_errmsg(c->db));
+	}
+}
+void
+SQLite::Command::bindParamF(unsigned int n, float v)
+{
+	if (sqlite3_bind_double(stmt, n + 1, v) != SQLITE_OK) {
+		throw Error(sqlite3_errmsg(c->db));
+	}
+}
+void
+SQLite::Command::bindParamS(unsigned int n, const Glib::ustring & s)
+{
+	if (sqlite3_bind_text(stmt, n + 1, s.c_str(), s.length(), SQLITE_STATIC) != SQLITE_OK) {
+		throw Error(sqlite3_errmsg(c->db));
+	}
+}
+void
+SQLite::Command::bindParamT(unsigned int, const boost::posix_time::time_duration &)
+{
+	throw Error("Not supported");
+}
+void
+SQLite::Command::bindParamT(unsigned int, const boost::posix_time::ptime &)
+{
+	throw Error("Not supported");
+}
+void
+SQLite::Command::bindNull(unsigned int n)
+{
+	if (sqlite3_bind_null(stmt, n + 1) != SQLITE_OK) {
+		throw Error(sqlite3_errmsg(c->db));
+	}
+}
+
-- 
cgit v1.2.3