Exemple #1
0
def get_tag_post(tag_id, limit=10, offset=0):
    assert_error(offset >= 0, 'ParamError')
    posts = Post.query.join(Tagging,Post.id == Tagging.taggable_id).\
            filter(Tagging.tag_id == tag_id).\
            filter(Post.show == True).\
            order_by(Tagging.date_create.desc()).\
            limit(limit).offset(offset).all()
    return [p.json for p in posts]
Exemple #2
0
def get_post_comment(post_id,limit=50,offset=0,show=True):
    assert_error(type(post_id) == types.IntType,'ParamError')
    _ans = [Comment.show == True,] if show else []
    _ans.append(Comment.post_id == post_id)
    q = reduce(db.and_,_ans)
    comms = Comment.query.filter(q).order_by(Comment.date_create.desc()).\
            limit(limit).offset(offset).all()
    return [c.json for c in comms]
Exemple #3
0
def get_post_comment(post_id, limit=50, offset=0, show=True):
    assert_error(type(post_id) == types.IntType, 'ParamError')
    _ans = [
        Comment.show == True,
    ] if show else []
    _ans.append(Comment.post_id == post_id)
    q = reduce(db.and_, _ans)
    comms = Comment.query.filter(q).order_by(Comment.date_create.desc()).\
            limit(limit).offset(offset).all()
    return [c.json for c in comms]
Exemple #4
0
def follow_user(fid,tid):
    assert_error(all([type(_id) == types.IntType for _id in [fid,tid]]),'ParamError')
    try:
        asso = UserFollowAsso(user_id=fid,user_id_to=tid)
        db.session.add(asso)
        db.session.commit()
    except:
        db.session.rollback()
        raise
    else:
        return asso.id
Exemple #5
0
def add_play(user_id, post_id):
    assert_error(all([type(x) for x in [user_id, post_id]]), 'ParamError')
    ura = UserPlayAsso()
    ura.user_id = user_id
    ura.post_id = post_id

    try:
        db.session.add(ura)
        db.session.commit()
    except:
        db.session.rollback()
        raise BackendError('InternalError', traceback.format_exc())
Exemple #6
0
def get_tag_post(tag_id, limit=10, offset=0):
    assert_error(offset >= 0, "ParamError")
    posts = (
        Post.query.join(Tagging, Post.id == Tagging.taggable_id)
        .filter(Tagging.tag_id == tag_id)
        .filter(Post.show == True)
        .order_by(Tagging.date_create.desc())
        .limit(limit)
        .offset(offset)
        .all()
    )
    return [p.json for p in posts]
Exemple #7
0
def add_play(user_id,post_id):
    assert_error(all([type(x) for x in [user_id,post_id]]),'ParamError')
    ura = UserPlayAsso()
    ura.user_id = user_id
    ura.post_id = post_id

    try:
        db.session.add(ura)
        db.session.commit()
    except:
        db.session.rollback()
        raise BackendError('InternalError',traceback.format_exc())
Exemple #8
0
def set_user(user_id,info_d):
    assert_error(type(user_id) == types.IntType,'ParamError')
    user = User.query.get(user_id)
    try:
        for k,v in info_d.items():
            if v is not None:
                setattr(user,k,v)
        db.session.commit()
    except:
        db.session.rollback()
        raise
    else:
        return user.json
Exemple #9
0
def get_user_post(user_id,offset=0,limit=20):
    assert_error(offset >= 0,'ParamError')
    posts = Post.query.filter(Post.author_id == user_id).\
                order_by(Post.date_create.desc()).\
                limit(limit).offset(offset).all()

    _posts = []
    for p in posts:
        _u = p.user.json
        _p = p.json
        _p.update({'user':_u})
        _posts.append(_p)

    return _posts
Exemple #10
0
def unfollow_user(fid,tid):
    assert_error(all([type(_id) == types.IntType for _id in [fid,tid]]),'ParamError')
    asso = UserFollowAsso.query.filter(db.and_(UserFollowAsso.user_id==fid,UserFollowAsso.user_id_to==tid)).\
            first()
    if asso is None:
        return
    try:
        db.session.delete(asso)
        db.session.commit()
    except:
        db.session.rollback()
        raise
    else:
        return True
Exemple #11
0
def get_user_post(user_id, offset=0, limit=20):
    assert_error(offset >= 0, 'ParamError')
    posts = Post.query.filter(Post.author_id == user_id).\
                order_by(Post.date_create.desc()).\
                limit(limit).offset(offset).all()

    _posts = []
    for p in posts:
        _u = p.user.json
        _p = p.json
        _p.update({'user': _u})
        _posts.append(_p)

    return _posts
Exemple #12
0
def get_user_liked_post(user_id, offset=0, limit=20):
    assert_error(offset >= 0, 'ParamError')
    posts = Post.query.join(UserLikeAsso,Post.id == UserLikeAsso.post_id).\
            filter(UserLikeAsso.user_id == user_id).\
            order_by(UserLikeAsso.date_create.desc()).\
            limit(limit).offset(offset).all()

    _posts = []
    for p in posts:
        _u = p.user.json
        _p = p.json
        _p.update({'user': _u})
        _posts.append(_p)

    return _posts
Exemple #13
0
def del_like(user_id,post_id):
    assert_error(all([type(x) == types.IntType for x in [user_id,post_id]]),
                    'ParamError')
    ula = UserLikeAsso.query.filter(UserLikeAsso.user_id == user_id).\
            filter(UserLikeAsso.post_id == post_id).first()
    if ula is None:
        return
    try:
        db.session.delete(ula)
        db.session.commit()
    except:
        db.session.rollback()
        raise BackendError('InternalError',traceback.format_exc())
    else:
        return True
Exemple #14
0
def get_user_liked_post(user_id,offset=0,limit=20):
    assert_error(offset >= 0,'ParamError')
    posts = Post.query.join(UserLikeAsso,Post.id == UserLikeAsso.post_id).\
            filter(UserLikeAsso.user_id == user_id).\
            order_by(UserLikeAsso.date_create.desc()).\
            limit(limit).offset(offset).all()

    _posts = []
    for p in posts:
        _u = p.user.json
        _p = p.json
        _p.update({'user':_u})
        _posts.append(_p)

    return _posts
Exemple #15
0
def del_like(user_id, post_id):
    assert_error(all([type(x) == types.IntType for x in [user_id, post_id]]),
                 'ParamError')
    ula = UserLikeAsso.query.filter(UserLikeAsso.user_id == user_id).\
            filter(UserLikeAsso.post_id == post_id).first()
    if ula is None:
        return
    try:
        db.session.delete(ula)
        db.session.commit()
    except:
        db.session.rollback()
        raise BackendError('InternalError', traceback.format_exc())
    else:
        return True
Exemple #16
0
def new_insall(user_id,device_token,version='',device_type=''):
    assert_error(type(user_id) == types.IntType,'ParamError')
    assert_error(type(device_token) == types.StringType,'ParamError')
    
    install = Install(user_id=user_id,
                    device_token=device_token,
                    version=version,
                    device_type=device_type)

    try:
        db.session.add(install)
        db.session.commit()
    except:
        db.session.rollback()
        raise
    return install.json
Exemple #17
0
def new_insall(user_id, device_token, version='', device_type=''):
    assert_error(type(user_id) == types.IntType, 'ParamError')
    assert_error(type(device_token) == types.StringType, 'ParamError')

    install = Install(user_id=user_id,
                      device_token=device_token,
                      version=version,
                      device_type=device_type)

    try:
        db.session.add(install)
        db.session.commit()
    except:
        db.session.rollback()
        raise
    return install.json
Exemple #18
0
def get_user_by_uid(uid):
    assert_error(type(uid) in (types.StringType,types.ListType),'ParamError')
    multi = False
    if type(uid) == types.ListType:
        multi = True
    else:
        uid = uid,

    users = User.query.filter(User.uid.in_(uid)).all()
    if len(users) == 0:
        raise BackendError('EmptyError','用户不存在')

    if multi:
        return [u.json for u in users]
    else:
        return users[0].json
Exemple #19
0
def get_user(user_id):
    multi = False
    if type(user_id) == types.ListType:
        assert_error(all([type(u) == types.IntType for u in user_id]),'ParamError')
        multi = True
    else:
        assert_error(type(user_id) == types.IntType,'ParamError')
        user_id = user_id,

    users = User.query.filter(User.id.in_(user_id)).all()
    if not users:
        raise BackendError('EmptyError','用户不存在')

    if multi:
        return [u.json for u in users]
    else:
        return users[0].json
Exemple #20
0
def add_post(title,
             author_id,
             video_url,
             pic_small='',
             pic_big='',
             show=True,
             recommended=False):
    assert_error(type(title) == types.StringType, 'ParamError')
    assert_error(type(author_id) == types.IntType, 'ParamError')
    assert_error(type(video_url) == types.StringType, 'ParamError')

    qd = {
        'title': title,
        'author_id': author_id,
        'video_url': video_url,
        'pic_small': pic_small,
        'pic_big': pic_big,
        'show': show,
        'recommended': recommended,
    }
    try:
        p = Post(**qd)
        db.session.add(p)
        db.session.commit()
    except:
        db.session.rollback()
        raise BackendError('InternalError', traceback.format_exc())
    return p.json
Exemple #21
0
def add_comment(post_id, content, author_id):
    assert_error(type(post_id) == types.IntType, 'ParamError')
    assert_error(type(author_id) == types.IntType, 'ParamError')
    assert_error(type(content) == types.StringType, 'ParamError')

    qd = {'post_id': post_id, 'content': content, 'author_id': author_id}
    co = Comment(**qd)
    try:
        db.session.add(co)
        db.session.commit()
    except:
        db.session.rollback()
        raise BackendError('InternalError', traceback.format_exc())
    return co.json
Exemple #22
0
def add_comment(post_id,content,author_id):
    assert_error(type(post_id) == types.IntType,'ParamError')
    assert_error(type(author_id) == types.IntType,'ParamError')
    assert_error(type(content) == types.StringType,'ParamError')

    qd = {
            'post_id':post_id,
            'content':content,
            'author_id':author_id
            }
    co = Comment(**qd)
    try:
        db.session.add(co)
        db.session.commit()
    except:
        db.session.rollback()
        raise BackendError('InternalError',traceback.format_exc())
    return co.json
Exemple #23
0
def add_post(title,author_id,video_url,pic_small='',pic_big='',show=True,recommended=False):
    assert_error(type(title) == types.StringType,'ParamError')
    assert_error(type(author_id) == types.IntType,'ParamError')
    assert_error(type(video_url) == types.StringType,'ParamError')

    qd = {
            'title':title,
            'author_id':author_id,
            'video_url':video_url,
            'pic_small':pic_small,
            'pic_big':pic_big,
            'show':show,
            'recommended':recommended,
            }
    try:
        p = Post(**qd)
        db.session.add(p)
        db.session.commit()
    except:
        db.session.rollback()
        raise BackendError('InternalError',traceback.format_exc())
    return p.json
Exemple #24
0
def add_user(username,photo_url,uid,signature='',access_token=''):
    assert_error(type(username)==types.StringType,'ParamError','用户昵称应该为字符串')
    assert_error(photo_url == None or type(photo_url) == types.StringType,'ParamError')
    assert_error(type(uid) == types.StringType,'ParamError')

    qd = {
            'username':username,
            'photo_url':photo_url or '',
            'uid':uid,
            'signature':signature,
            'access_token':access_token
            }

    try:
        user = User(**qd)
        db.session.add(user)
        db.session.commit()
    except:
        db.session.rollback()
        raise BackendError('InternalError',traceback.format_exc())

    return user.json
Exemple #25
0
def get_activity_by_user(user_id,limit=30,offset=0):
    assert_error(type(user_id) == types.IntType,'ParamError')
    activitys = Activity.query.filter(Activity.to_id == user_id).\
            order_by(db.desc(Activity.date_create)).limit(limit).offset(offset).all()
    return [a.json for a in activitys]
Exemple #26
0
def get_new_activity_count(user_id, last_update_time):
    assert_error(type(user_id) == types.IntType, 'ParamError')
    count = Activity.query.filter(Activity.to_id == user_id).\
            filter(Activity.date_create > last_update_time).count()
    return count
Exemple #27
0
def is_email_exist(email):
    assert_error(type(email) == types.StringType,'ParamError')
    return True if _check_email(email) else False
Exemple #28
0
def is_username_exist(username):
    assert_error(type(username) == types.StringType,'ParamError')
    return True if _check_username(username) else False
Exemple #29
0
def get_user_follower(user_id,limit=50,offset=0):
    assert_error(type(user_id) == types.IntType,'ParamError')
    follows = User.query.join(UserFollowAsso,User.id == UserFollowAsso.user_id).\
            filter(UserFollowAsso.user_id_to == user_id).limit(limit).offset(offset).all()
    return [u.json for u in follows]
Exemple #30
0
def get_new_activity_count(user_id,last_update_time):
    assert_error(type(user_id) == types.IntType,'ParamError')
    count = Activity.query.filter(Activity.to_id == user_id).\
            filter(Activity.date_create > last_update_time).count()
    return count
Exemple #31
0
def get_activity_by_user(user_id, limit=30, offset=0):
    assert_error(type(user_id) == types.IntType, 'ParamError')
    activitys = Activity.query.filter(Activity.to_id == user_id).\
            order_by(db.desc(Activity.date_create)).limit(limit).offset(offset).all()
    return [a.json for a in activitys]
Exemple #32
0
def get_tag(tag_id):
    assert_error(type(tag_id) == types.IntType, 'ParamError')
    tag = Tag.query.get(tag_id)
    return tag.json
Exemple #33
0
def get_comment(comment_id):
    assert_error(type(comment_id) == types.IntType,'ParamError')
    comm = Comment.query.get(comment_id)
    return comm.json
Exemple #34
0
def get_tag_post_count(tag_id):
    assert_error(type(tag_id) == types.IntType, 'ParamError')
    count = Tagging.query.filter(Tagging.tag_id == tag_id).count()
    return count
Exemple #35
0
def get_comment(comment_id):
    assert_error(type(comment_id) == types.IntType, 'ParamError')
    comm = Comment.query.get(comment_id)
    return comm.json
Exemple #36
0
def get_tag(tag_id):
    assert_error(type(tag_id) == types.IntType, "ParamError")
    tag = Tag.query.get(tag_id)
    return tag.json
Exemple #37
0
def get_tag_post_count(tag_id):
    assert_error(type(tag_id) == types.IntType, "ParamError")
    count = Tagging.query.filter(Tagging.tag_id == tag_id).count()
    return count