def sql_select(explain=False):
statement, params = load_query(request.args['query'])
engine = LocalProxy(current_app.database.request_get)
if explain:
if engine.driver == 'pysqlite':
statement = 'EXPLAIN QUERY PLAN\n%s' % statement
else:
statement = 'EXPLAIN\n%s' % statement
result = engine.execute(statement, params)
return g.debug_toolbar.render('panels/sqlalchemy_select.html', {
'result': result.fetchall(),
'headers': result.keys(),
'sql': format_sql(statement, params),
'duration': float(request.args['duration']),
})
def insert_record(query, args=()):
local_proxy_db = LocalProxy(get_db)
local_proxy_db.execute(query, args)
local_proxy_db.commit()
return
