From 585ad90d3cc59ad7d4fd306170b710699e48efda Mon Sep 17 00:00:00 2001 From: raylu Date: Sun, 20 Oct 2013 00:42:11 -0700 Subject: show more data --- db/__init__.py | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'db/__init__.py') diff --git a/db/__init__.py b/db/__init__.py index 92837a2..66566d5 100644 --- a/db/__init__.py +++ b/db/__init__.py @@ -13,3 +13,12 @@ def execute(cursor, sql, *values): def query(cursor, sql, *values): execute(cursor, sql, *values) return cursor.fetchall() + +def get(cursor, sql, *values): + execute(cursor, sql, *values) + result = cursor.fetchone() + if result is None: + raise Exception('no rows returned for query: {} with values {}'.format(sql, values)) + if cursor.fetchone() is not None: + raise Exception('multiple results returned for query'.format(sql, values)) + return result -- cgit v1.2.3