From c96d1c12f1fd2a34105305cb560792936c246259 Mon Sep 17 00:00:00 2001
From: Louie S <louie@example.com>
Date: Tue, 12 Mar 2024 18:37:06 -0400
Subject: Implement editEntryForm

---
 src/backend/db_sqlite.cpp | 30 ++++++++++++++++++++++++++++++
 src/backend/db_sqlite.h   |  2 +-
 2 files changed, 31 insertions(+), 1 deletion(-)

(limited to 'src/backend')

diff --git a/src/backend/db_sqlite.cpp b/src/backend/db_sqlite.cpp
index 763fba5..0d21a05 100644
--- a/src/backend/db_sqlite.cpp
+++ b/src/backend/db_sqlite.cpp
@@ -218,6 +218,36 @@ void BackendDB::updateGroup(const Group &group) {
 	QSqlDatabase::removeDatabase("qt_sql_default_connection");
 }
 
+void BackendDB::updateEntry(const Entry &entry) {
+	{
+		QSqlDatabase database(this->openDB());
+		QSqlQuery query;
+
+		query.prepare("UPDATE entries SET "
+				"description = :desc, "
+				"due_date = :due, "
+				"alt_due_date = :alt_due, "
+				"link = :link, "
+				"color = :color, "
+				"highlight = :highlight, "
+				"done = :done, "
+				"hidden = :hidden "
+				"WHERE id = :id");
+		query.bindValue(":desc", entry.desc);
+		query.bindValue(":due", entry.due.toString("yyyy-MM-dd"));
+		query.bindValue(":alt_due", entry.due_alt);
+		query.bindValue(":link", entry.link);
+		query.bindValue(":color", entry.color);
+		query.bindValue(":highlight", entry.highlight);
+		query.bindValue(":done", entry.done);
+		query.bindValue(":hidden", entry.hidden);
+		query.bindValue(":id", entry.id);
+		query.exec();
+	}
+
+	QSqlDatabase::removeDatabase("qt_sql_default_connection");
+}
+
 // hide group and entries belonging to group
 // return value: number of affected rows
 int BackendDB::removeGroup(const Group &group) {
diff --git a/src/backend/db_sqlite.h b/src/backend/db_sqlite.h
index c2e8ac7..83b36f9 100644
--- a/src/backend/db_sqlite.h
+++ b/src/backend/db_sqlite.h
@@ -20,7 +20,7 @@ class BackendDB : QSqlDatabase {
 		int insertEntry(const Entry &new_entry);
 		int insertRule(int new_rule); // param datatype TBD
 		void updateGroup(const Group &group);
-		void updateEntry(int entry); // param datatype TBD
+		void updateEntry(const Entry &entry); // param datatype TBD
 		void updateRule(int rule); // param datatype TBD
 		int removeGroup(const Group &group);
 		void removeEntry(int entry); // param datatype TBD
-- 
cgit