From dce050aac5ceee19e6af598d844b4335e18b763a Mon Sep 17 00:00:00 2001
From: jesopo
Date: Tue, 27 Nov 2018 11:38:13 +0000
Subject: Convert BOOLEAN sqlite3 types to bool objects when retrieving them

---
 src/Database.py | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'src/Database.py')

diff --git a/src/Database.py b/src/Database.py
index 8dcac9af..555f717a 100644
--- a/src/Database.py
+++ b/src/Database.py
@@ -1,6 +1,8 @@
 import json, os, sqlite3, threading, time, typing
 from src import Logging
 
+sqlite3.register_converter("BOOLEAN", lambda v: bool(int(v)))
+
 class Table(object):
     def __init__(self, database):
         self.database = database
@@ -275,7 +277,8 @@ class Database(object):
         self.log = log
         self.location = location
         self.database = sqlite3.connect(self.location,
-            check_same_thread=False, isolation_level=None)
+            check_same_thread=False, isolation_level=None,
+            detect_types=sqlite3.PARSE_DECLTYPES)
         self.database.execute("PRAGMA foreign_keys = ON")
         self._cursor = None
         self._lock = threading.Lock()
-- 
cgit v1.3.1-10-gc9f91