def get_user_profile(conn_func):
conn = conn_func()
sql = "select id, grade_id, exam from user_profile"
A = pd.read_sql_query(sql, conn)
A.columns = ["uid", "grade_id", "exam_type"]
res = {}
for _, row in A.iterrows():
uid, grade_id, exam_type = row
exam_kind = EXAM_KIND_MAP.get(grade_id, {}).get(exam_type, EXAM_KIND_DEFAULT)
res[uid] = exam_kind
return res
def get_user_profile(conn_func):
conn = conn_func()
sql = 'select id, grade_id, exam from user_profile'
A = pd.read_sql_query(sql, conn)
A.columns = ['uid', 'grade_id', 'exam_type']
res = {}
for _, row in A.iterrows():
uid, grade_id, exam_type = row
exam_kind = EXAM_KIND_MAP.get(grade_id,
{}).get(exam_type, EXAM_KIND_DEFAULT)
res[uid] = exam_kind
return res
def get_origin(conn_func):
conn = conn_func()
cursor = conn.cursor()
cursor.execute('select target_kind, target_id, '
'grade_id, exam_type from origin')
origin = {}
for qtype, qid, grade_id, etype in cursor.fetchall():
ekind = EXAM_KIND_MAP.get(grade_id, EXAM_KIND_DEFAULT)
if qtype not in origin:
origin[qtype] = {}
# 每道题目可能有多个 origin 来源
origin[qtype].setdefault(qid, []).append((grade_id, etype, ekind))
cursor.close()
conn.close()
return origin
def get_origin(conn_func):
conn = conn_func()
cursor = conn.cursor()
cursor.execute('select target_kind, target_id, '
'grade_id, exam_type from origin')
origin = {}
for qtype, qid, grade_id, etype in cursor.fetchall():
ekind = EXAM_KIND_MAP.get(grade_id, {}).get(etype, EXAM_KIND_DEFAULT)
if qtype not in origin:
origin[qtype] = {}
# 每道题目可能有多个 origin 来源
origin[qtype].setdefault(qid, []).append((grade_id, etype, ekind))
cursor.close()
conn.close()
return origin