def configure_sqlalchemy_log(options):
debug = config.get_option(options, 'debug', type='bool', default=False)
verbose = config.get_option(options, 'verbose', type='bool', default=False)
logger = logging.getLogger('sqlalchemy.engine')
if debug:
logger.setLevel(logging.DEBUG)
elif verbose:
logger.setLevel(logging.INFO)
def _create_engine(options):
engine_args = {
"pool_recycle":
config.get_option(options,
'sql_idle_timeout',
type='int',
default=3600),
"echo":
config.get_option(options, 'sql_query_log', type='bool',
default=False),
}
LOG.info("Creating SQLAlchemy engine with args: %s" % engine_args)
return create_engine(options['sql_connection'], **engine_args)
def _create_engine(options):
connection_dict = sql.engine.url.make_url(options['sql_connection'])
engine_args = {
'pool_recycle':
config.get_option(options,
'sql_idle_timeout',
type='int',
default=3600),
'echo':
config.get_option(options, 'sql_query_log', type='bool',
default=False),
'convert_unicode':
True,
}
if 'mysql' in connection_dict.drivername:
engine_args['listeners'] = [MySQLPingListener()]
LOG.info("Creating SQLAlchemy engine with args: %s" % engine_args)
return create_engine(options['sql_connection'], **engine_args)
