def get_exp_fills(ExpId=7): cur = dbutil.get_cur() cur.execute('CALL P_GetExpFills(%s,null,null)' % ExpId) for r in cur: sina_uid = r['SiteUid'] filltime = r['LastFill'] ip = r['IPAddr'] filltimes[sina_uid].add(filltime) ips[sina_uid].add(ip) uids = ips._dict.keys() for uid in uids: line = 'IP\t%s\t' % uid for ip in ips[uid]: line += ip + '\t' line += '\n' line += 'TIME\t%s\t' % uid times = sorted(filltimes[uid]) for t in times: str_time = '%02d%02d_%02d%02d%02d' % (t.month, t.day, t.hour, t.minute, t.second) line += str_time + '\t' print line
def load_from_db(): result = OrderedDict() cur = dbutil.get_cur() cur.execute('SELECT * FROM Quiz ORDER BY QuizId') for r in cur: qid = r.pop('QuizId') result[qid] = r return result
def load_from_db(): result = OrderedDict() cur = dbutil.get_cur() cur.execute("SELECT * FROM Quiz ORDER BY QuizId") for r in cur: qid = r.pop("QuizId") result[qid] = r return result