From a3fcbb3a76e079a5485a0552ea5d35b8d6739116 Mon Sep 17 00:00:00 2001
From: Carl Hetherington <cth@carlh.net>
Date: Sat, 20 May 2023 22:51:49 +0200
Subject: Use sqlite for cinema and DKDM recipient lists.

---
 src/lib/sqlite_table.cc | 79 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 79 insertions(+)
 create mode 100644 src/lib/sqlite_table.cc

(limited to 'src/lib/sqlite_table.cc')

diff --git a/src/lib/sqlite_table.cc b/src/lib/sqlite_table.cc
new file mode 100644
index 000000000..f00fa6b74
--- /dev/null
+++ b/src/lib/sqlite_table.cc
@@ -0,0 +1,79 @@
+/*
+    Copyright (C) 2024 Carl Hetherington <cth@carlh.net>
+
+    This file is part of DCP-o-matic.
+
+    DCP-o-matic is free software; you can redistribute it and/or modify
+    it under the terms of the GNU General Public License as published by
+    the Free Software Foundation; either version 2 of the License, or
+    (at your option) any later version.
+
+    DCP-o-matic is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+    GNU General Public License for more details.
+
+    You should have received a copy of the GNU General Public License
+    along with DCP-o-matic.  If not, see <http://www.gnu.org/licenses/>.
+
+*/
+
+
+#include "dcpomatic_assert.h"
+#include "compose.hpp"
+#include "sqlite_table.h"
+#include "util.h"
+
+
+using std::string;
+using std::vector;
+
+
+void
+SQLiteTable::add_column(string const& name, string const& type)
+{
+	_columns.push_back(name);
+	_types.push_back(type);
+}
+
+
+string
+SQLiteTable::create() const
+{
+	DCPOMATIC_ASSERT(!_columns.empty());
+	DCPOMATIC_ASSERT(_columns.size() == _types.size());
+	vector<string> columns(_columns.size());
+	for (size_t i = 0; i < _columns.size(); ++i) {
+		columns[i] = _columns[i] + " " + _types[i];
+	}
+	return String::compose("CREATE TABLE IF NOT EXISTS %1 (id INTEGER PRIMARY KEY, %2)", _name, join_strings(columns, ", "));
+}
+
+
+string
+SQLiteTable::insert() const
+{
+	DCPOMATIC_ASSERT(!_columns.empty());
+	vector<string> placeholders(_columns.size(), "?");
+	return String::compose("INSERT INTO %1 (%2) VALUES (%3)", _name, join_strings(_columns, ", "), join_strings(placeholders, ", "));
+}
+
+
+string
+SQLiteTable::update(string const& condition) const
+{
+	DCPOMATIC_ASSERT(!_columns.empty());
+	vector<string> placeholders(_columns.size());
+	for (size_t i = 0; i < _columns.size(); ++i) {
+		placeholders[i] = _columns[i] + "=?";
+	}
+
+	return String::compose("UPDATE %1 SET %2 %3", _name, join_strings(placeholders, ", "), condition);
+}
+
+
+string
+SQLiteTable::select(string const& condition) const
+{
+	return String::compose("SELECT id,%1 FROM %2 %3", join_strings(_columns, ","), _name, condition);
+}
-- 
cgit v1.2.3