From 92d2f3f51d4191b079567f251348b316fe35feff Mon Sep 17 00:00:00 2001 From: Pjotr Prins Date: Thu, 23 Jun 2016 11:10:44 +0000 Subject: Add fetchall iterator --- wqflask/db/call.py | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'wqflask/db') diff --git a/wqflask/db/call.py b/wqflask/db/call.py index ac9f7fe5..4cea7e66 100644 --- a/wqflask/db/call.py +++ b/wqflask/db/call.py @@ -40,6 +40,18 @@ original fetchone, but with logging) callername = stack()[2][3] return logger.sql(callername, query, helper) +def fetchall(query): + """Return row iterator by calling SQL directly (the +original fetchall, but with logging) + + """ + with Bench("SQL",LOG_SQL): + def helper(query): + res = g.db.execute(query) + return res.fetchall() + callername = stack()[2][3] + return logger.sql(callername, query, helper) + def gn_server(path): """Return JSON record by calling GN_SERVER -- cgit v1.2.3