Python group_user Examples

Example #1

File: groups.py Project: xiaocaipi/python

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)

Example #2

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)

Example #3

File: groups.py Project: xiaocaipi/python

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)

Example #4

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)