#include "sqlite-command.h"
#include "sqlite-connection.h"
#include <cstdlib>
#include <cstring>

SQLite::Command::Command(const Connection * conn, const std::string & sql) :
	DB::Command(sql),
	c(conn),
	stmt(nullptr)
{
	if (sqlite3_prepare_v2(conn->db, sql.c_str(), sql.length(), &stmt, nullptr) != SQLITE_OK) {
		throw Error(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(c->db);
	}
}
void
SQLite::Command::bindParamI(unsigned int n, long int v)
{
	if (sqlite3_bind_int64(stmt, n + 1, v) != SQLITE_OK) {
		throw Error(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(c->db);
	}
}
void
SQLite::Command::bindParamI(unsigned int n, unsigned int v)
{
	if (sqlite3_bind_int64(stmt, n + 1, v) != SQLITE_OK) {
		throw Error(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(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(c->db);
	}
}
void
SQLite::Command::bindParamF(unsigned int n, double v)
{
	if (sqlite3_bind_double(stmt, n + 1, v) != SQLITE_OK) {
		throw Error(c->db);
	}
}
void
SQLite::Command::bindParamF(unsigned int n, float v)
{
	if (sqlite3_bind_double(stmt, n + 1, v) != SQLITE_OK) {
		throw Error(c->db);
	}
}
void
SQLite::Command::bindParamS(unsigned int n, const Glib::ustring & s)
{
	return bindParamS(n, std::string_view(s.raw()));
}
void
SQLite::Command::bindParamS(unsigned int n, const std::string_view & s)
{
	if (sqlite3_bind_text(stmt, n + 1, s.data(), s.length(), SQLITE_STATIC) != SQLITE_OK) {
		throw Error(c->db);
	}
}
void
SQLite::Command::bindParamB(unsigned int, bool)
{
	throw DB::ParameterTypeNotSupported();
}
void
SQLite::Command::bindParamT(unsigned int, const boost::posix_time::time_duration &)
{
	throw DB::ParameterTypeNotSupported();
}
void
SQLite::Command::bindParamT(unsigned int, const boost::posix_time::ptime &)
{
	throw DB::ParameterTypeNotSupported();
}
void
SQLite::Command::bindNull(unsigned int n)
{
	if (sqlite3_bind_null(stmt, n + 1) != SQLITE_OK) {
		throw Error(c->db);
	}
}