def get_forum_notintut_by_code_and_group_num(code, group_num):
return sql_helper.fetchall_to_dict(
"SELECT f.title, f.fid, count(*) as stuNum"
" FROM Forums f JOIN (Tutorials T NATURAL JOIN Attend A)"
"WHERE f.code = %(code)s AND"
" (NOT EXISTS ( "
" SELECT 1 FROM View v "
" WHERE v.f_code=%(code)s AND v.group_num=%(group_num)s AND v.fid = f.fid "
")) "
"GROUP BY f.fid", {
'code': code,
'group_num': group_num
})
def get_forum_by_code_and_uname(code, uname):
return sql_helper.fetchall_to_dict(
"WITH X AS (SELECT * FROM Attend NATURAL JOIN tutorials "
" WHERE uname = %(uname)s AND code=%(code)s) "
"SELECT * FROM Forums F JOIN X "
"ON F.code = X.code "
"WHERE EXISTS("
" SELECT 1 FROM View V "
" WHERE V.f_code = F.code AND V.t_code = X.code "
" AND V.fid = F.fid AND V.group_num = X.group_num)", {
'uname': uname,
'code': code
})
