__init__.py 396 B

123456789101112131415
  1. import oursql
  2. from config import db as dbconfig
  3. conn = oursql.connect(host=dbconfig.host, db=dbconfig.database, user=dbconfig.user, passwd=dbconfig.password, autoreconnect=True)
  4. def ykill_cursor():
  5. return conn.cursor(oursql.DictCursor)
  6. def execute(cursor, sql, *values):
  7. cursor.execute(sql, values)
  8. def query(cursor, sql, *values):
  9. execute(cursor, sql, *values)
  10. return cursor.fetchall()