From 617bb0662f85f4c6c0f78fe39d5a33a2bd9a8b61 Mon Sep 17 00:00:00 2001
From: jakobst1n <jakob@jakobstendahl.no>
Date: Fri, 8 Sep 2023 19:06:07 +0200
Subject: Add query which sets sql_mode for the version row to be inserted (#2)

---
 src/database.rs | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'src/database.rs')

diff --git a/src/database.rs b/src/database.rs
index cd097eb..83d3fea 100644
--- a/src/database.rs
+++ b/src/database.rs
@@ -75,6 +75,10 @@ fn table_create(conn: &mut Conn) {
         error!("Could not create table! ({:#?}", x);
         process::exit(1);
     }
+    if let Err(x) = tx.query_drop("SET SESSION sql_mode='NO_AUTO_VALUE_ON_ZERO'") {
+        error!("Could not set NO_AUTO_VALUE_ON_ZERO sql_mode for session, you might have to change the id of this row manually from 1 to 0! ({:#?}", x);
+        process::exit(1);
+    }
     q = "INSERT INTO `rss-watcher-feeds` (id,
                                           url,
                                           last_fetch,
-- 
cgit v1.2.3