summaryrefslogtreecommitdiffstats
path: root/db/__init__.py
blob: ead523208458138c0547cf6270d76f31a47bcd85 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
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()