def group_info(gid): tableObj = model.groups() ##获取数据表对象 g_info = tableObj.getOne('id,name,description', {'id':gid}) ##进行表查询 tableObj = model.query() ##获取数据表对象 f_list = tableObj.fetchAll('select forum.id,forum.title from forum,group_forum gf where gf.gid=%s and gf.fid=forum.id' % gid) ##进行表查询 tableObj = model.group_user() ##获取数据表对象 user_info = web.ctx.session.user_info uid = user_info['id'] u_info = tableObj.getOne('id', {'uid':uid,'gid':gid}) return g_info,f_list,len(u_info)
def gourp_user(gid): tableObj = model.group_user() ##获取数据表对象 condition = {'gid': gid} user_info = web.ctx.session.user_info if user_info: condition['uid'] = user_info['id'] else: return -1 print condition return tableObj.insert(condition)
def gourp_user(gid): tableObj = model.group_user() ##获取数据表对象 condition = {'gid':gid} user_info = web.ctx.session.user_info if user_info: condition['uid'] = user_info['id'] else: return -1 print condition return tableObj.insert(condition)
def group_info(gid): tableObj = model.groups() ##获取数据表对象 g_info = tableObj.getOne('id,name,description', {'id': gid}) ##进行表查询 tableObj = model.query() ##获取数据表对象 f_list = tableObj.fetchAll( 'select forum.id,forum.title from forum,group_forum gf where gf.gid=%s and gf.fid=forum.id' % gid) ##进行表查询 tableObj = model.group_user() ##获取数据表对象 user_info = web.ctx.session.user_info uid = user_info['id'] u_info = tableObj.getOne('id', {'uid': uid, 'gid': gid}) return g_info, f_list, len(u_info)