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)