From 224f66a77aa3afa5e06daec656ae97f6e31e0592 Mon Sep 17 00:00:00 2001 From: raylu Date: Fri, 3 May 2013 03:41:50 -0700 Subject: start over --- db/__init__.py | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 db/__init__.py (limited to 'db/__init__.py') diff --git a/db/__init__.py b/db/__init__.py new file mode 100644 index 0000000..ead5232 --- /dev/null +++ b/db/__init__.py @@ -0,0 +1,15 @@ +import oursql + +from config import db as dbconfig + +conn = oursql.connect(host=dbconfig.host, db=dbconfig.database, user=dbconfig.user, passwd=dbconfig.password, autoreconnect=True) + +def ykill_cursor(): + return conn.cursor(oursql.DictCursor) + +def execute(cursor, sql, *values): + cursor.execute(sql, values) + +def query(cursor, sql, *values): + execute(cursor, sql, *values) + return cursor.fetchall() -- cgit v1.2.3