From e5b6ef658e936c32d9500ff7f781171d9785315a Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Tue, 18 Dec 2018 01:34:36 +0100 Subject: pool_recycle 3600 --- megapixels/app/models/sql_factory.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'megapixels/app') 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 -- cgit v1.2.3-70-g09d2