From a4c3b23d61b85290347cbbcbaf351a10c56880f6 Mon Sep 17 00:00:00 2001
From: Rosyid Haryadi <rosyid_haryadi@protonmail.com>
Date: Sat, 27 Jul 2024 22:10:32 +0700
Subject: upd more logging

---
 util.py | 23 ++++++++++++++++-------
 1 file changed, 16 insertions(+), 7 deletions(-)

(limited to 'util.py')

diff --git a/util.py b/util.py
index 0590c49..58a852b 100644
--- a/util.py
+++ b/util.py
@@ -21,13 +21,22 @@ def setupLogger():
 
 
 def initDb():
-    conn = sqlite3.connect(dbFile)
-    cur = conn.cursor()
-    cur.execute("CREATE TABLE incoming (id, msg_date, msg_from, text, is_read)")
-    conn.commit()
-    conn.close()
+    try:
+        conn = sqlite3.connect(dbFile)
+        cur = conn.cursor()
+        cur.execute("CREATE TABLE incoming (id, msg_date, msg_from, text, is_read)")
+        conn.commit()
+        conn.close()
+    except sqlite3.Error as e:
+        logging.error("Failed to initialize database")
+        logging.error(e)
 
 
 def getDbConn():
-    conn = sqlite3.connect(dbFile)
-    return conn
+    try:
+        conn = sqlite3.connect(dbFile)
+        return conn
+    except sqlite3.Error as e:
+        logging.error("Failed making connection to database")
+        logging.error(e)
+        return None
-- 
cgit v1.2.3-70-g09d2