summaryrefslogtreecommitdiffstats
path: root/db/__init__.py
diff options
context:
space:
mode:
Diffstat (limited to 'db/__init__.py')
-rw-r--r--db/__init__.py15
1 files changed, 15 insertions, 0 deletions
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()