def email_registerable(email): sql = 'select * from user where email = "%s"' % email cur = database.execute(sql) data = cur.fetchone() database.clear_execute(cur) if data: return False return True
def uname_registerable(uname): sql = 'select * from user where uname = "%s"' % uname cur = database.execute(sql) data = cur.fetchone() database.clear_execute(cur) if data: return False return True
def get_rname(uname): sql = "select rname from user where uname = '%s'" % uname cur = database.execute(sql) res = cur.fetchone() database.clear_execute(cur) if res: return res[0] return None
def get_uname(sessionid, sessionkey): sql = 'select uname from session where sessionid = "%s" and sessionkey = "%s"' % (sessionid, sessionkey) cur = database.execute(sql) res = cur.fetchone() #关闭游标 database.clear_execute(cur) if res: return res[0] return None
def get_last_one(type_id): sql = 'select value from physical where type_id = %d order by collect_time desc limit 1' % type_id cur = database.execute(sql) if not cur: return None res = cur.fetchone() database.clear_execute(cur) if res: return res[0] return None
def get_all_id(type_id): sql = 'select id from physical where type_id = %d' % type_id cur = database.execute(sql) if not cur: return None res = cur.fetchall() database.clear_execute(cur) if res: res = list(res) for i in range(len(res)): res[i] = res[i][0] return res return None
def get_someday_values(type_id, day): min = day + ' 00:00:00' max = day + ' 23:59:59' sql = 'select collect_time, value from physical where collect_time >= "%s" and collect_time <= "%s" and type_id = %d' % (min, max, type_id) cur = database.execute(sql) res = cur.fetchall() database.clear_execute(cur) if res: res = list(res) for i in range(len(res)): tm = '%s' % res[i][0] value = res[i][1] res[i] = (tm, value) return res return None
def get_values(type_id, begin, num, desc = True): if desc: order = 'desc' else: order = '' sql = 'select value from physical where type_id = %d order by collect_time %s limit %d, %d' % (type_id, order, begin, num) cur = database.execute(sql) if not cur: return None res = cur.fetchall() database.clear_execute(cur) if res: res = list(res) for i in range(len(res)): res[i] = res[i][0] return res return None