summaryrefslogtreecommitdiff
path: root/megapixels/app
diff options
context:
space:
mode:
Diffstat (limited to 'megapixels/app')
-rw-r--r--megapixels/app/models/sql_factory.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/megapixels/app/models/sql_factory.py b/megapixels/app/models/sql_factory.py
index da95b539..b270afd2 100644
--- a/megapixels/app/models/sql_factory.py
+++ b/megapixels/app/models/sql_factory.py
@@ -35,7 +35,7 @@ def load_sql_datasets(replace=False, base_model=None):
global datasets, loaded, Session
if loaded:
return datasets
- engine = create_engine(connection_url, encoding="utf-8")
+ engine = create_engine(connection_url, encoding="utf-8", pool_recycle=3600)
# db.set_character_set('utf8')
# dbc = db.cursor()
# dbc.execute('SET NAMES utf8;')
@@ -76,7 +76,7 @@ class SqlDataset:
self.name = name
self.tables = {}
if base_model is None:
- self.engine = create_engine(connection_url)
+ self.engine = create_engine(connection_url, encoding="utf-8", pool_recycle=3600)
base_model = declarative_base(engine)
self.base_model = base_model