Changeset 10419 for main/waeup.cas/trunk/waeup

Timestamp:

9 Jul 2013, 07:16:32 (11 years ago)

Author:

uli

Message:

Make sure memory-based database is thread-oriented (all connections should share the same memory-DB).

File:

• main/waeup.cas/trunk/waeup/cas/db.py (modified) (2 diffs)

main/waeup.cas/trunk/waeup/cas/db.py

@@ -6 +6 @@
 from sqlalchemy.ext.declarative import declarative_base
 from sqlalchemy.orm import sessionmaker, scoped_session
+from sqlalchemy.pool import StaticPool
 
 
@@ -81 +82 @@
 
     def __init__(self, connection_string):
-        self.engine = create_engine(connection_string)
+        args = {}
+        if connection_string in ('sqlite:///', 'sqlite:///:memory:'):
+            # make sure all threads access the same memory
+            args = dict(connect_args={'check_same_thread': False},
+                        poolclass=StaticPool)
+        self.engine = create_engine(connection_string, **args)
         self.metadata = MetaData()
         Base.metadata.create_all(self.engine)