From a179db1b829b47c6858fddcd8f9d457637fa06bd Mon Sep 17 00:00:00 2001 From: Sofia Papagiannaki Date: Mon, 12 Sep 2011 13:29:34 +0300 Subject: [PATCH] Fix connection parameters for sqlite through sqlalchemy. --- pithos/backends/lib/sqlalchemy/dbwrapper.py | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/pithos/backends/lib/sqlalchemy/dbwrapper.py b/pithos/backends/lib/sqlalchemy/dbwrapper.py index a4465b2..2ac0e35 100644 --- a/pithos/backends/lib/sqlalchemy/dbwrapper.py +++ b/pithos/backends/lib/sqlalchemy/dbwrapper.py @@ -32,12 +32,16 @@ # or implied, of GRNET S.A. from sqlalchemy import create_engine +from sqlalchemy.pool import NullPool class DBWrapper(object): """Database connection wrapper.""" def __init__(self, db): - self.engine = create_engine(db) + if db.startswith('sqlite://'): + self.engine = create_engine(db, connect_args={'check_same_thread': False}, poolclass=NullPool) + else: + self.engine = create_engine(db) self.conn = self.engine.connect() self.trans = None -- 1.7.10.4