def _connectToDb(self):
""" Opens a db connection
"""
self.con = sqlite.connect(self.db_path, detect_types=sqlite.PARSE_DECLTYPES)
sqlite.register_adapter(bool, int)
sqlite.register_converter("BOOLEAN", lambda v: bool(int(v)))
self.con.row_factory = self._dictFactory
# Use PRAGMA key to encrypt / decrypt database.
cur = self.con.cursor()
cur.execute("PRAGMA key = 'passphrase';") # TODO: Get passphrase from user.
def _connectToDb(self):
""" Opens a db connection
"""
self.con = sqlite.connect(self.db_path, detect_types=sqlite.PARSE_DECLTYPES)
sqlite.register_adapter(bool, int)
sqlite.register_converter("bool", lambda v: bool(int(v)))
self.con.row_factory = self._dictFactory
# Use PRAGMA key to encrypt / decrypt database.
cur = self.con.cursor()
cur.execute("PRAGMA key = 'passphrase';")
def _connectToDb(self):
""" Opens a db connection
"""
self.con = sqlite.connect(self.db_path, detect_types=sqlite.PARSE_DECLTYPES, timeout=10)
sqlite.register_adapter(bool, int)
sqlite.register_converter("bool", lambda v: bool(int(v)))
self.con.row_factory = self._dictFactory
if not self.disable_sqlite_crypt:
# Use PRAGMA key to encrypt / decrypt database.
cur = self.con.cursor()
cur.execute("PRAGMA key = 'passphrase';")
def _connectToDb(self):
""" Opens a db connection
"""
self.lock.acquire()
self.con = sqlite.connect(self.db_path,
detect_types=sqlite.PARSE_DECLTYPES,
timeout=10)
sqlite.register_adapter(bool, int)
sqlite.register_converter("bool", lambda v: bool(int(v)))
self.con.row_factory = self._dictFactory
if not self.disable_sqlite_crypt:
# Use PRAGMA key to encrypt / decrypt database.
with self.con:
cur = self.con.cursor()
cur.execute("PRAGMA key = 'passphrase';")
def setUp(self):
self.con = sqlite.connect(":memory:",
detect_types=sqlite.PARSE_COLNAMES)
sqlite.register_converter("bin", BinaryConverterTests.convert)
def setUp(self):
self.con = sqlite.connect(":memory:", detect_types=sqlite.PARSE_COLNAMES)
sqlite.register_converter("bin", BinaryConverterTests.convert)
