def get_users(request) : limit, offset = get_paginate_info(request.GET) session = get_session() users = session.query(UserInfo).limit(limit).offset(offset).all() session.close() data = dict( user_list = to_dict(users), ) result = dict(success=True, message=u'users.views.get_users: user list from {start} to {end}'.format(start=offset, end=limit+offset), data=data, start=offset, end=limit+offset) return HttpResponse(dumps(result, True))
def get_images(request): limit, offset = get_paginate_info(request.GET) session = get_session() image_id_list = session.query(Image.image_id).limit(limit).offset(offset).all() session.close() image_id_list = [ y for x in image_id_list for y in x ] data = dict( image_list = image_id_list ) result = dict(success=True, message=u'images.views.get_images: images from {start} to {end}'.format(start=offset, end=offset+limit), data=data) return HttpResponse(dumps(result))
def get_spot_snaps(request, spot_id=None): limit, offset = get_paginate_info(request.GET) session = get_session() snaps = session.query(Snap).filter_by(spot_id=spot_id).limit(limit).offset(offset).all() data = dict(snap_list=to_dict(snaps)) session.close() result = dict( success=True, message=u"spots.views.get_spot_snaps: snaps from {start} to {end}".format(start=offset, end=offset + limit), data=data, ) return HttpResponse(dumps(result))
def get_spot_users(request, spot_id=None): limit, offset = get_paginate_info(request.GET) session = get_session() SpotUserAssociation.relations.append("userinfo") spot_user_list = session.query(SpotUserAssociation).filter_by(spot_id=spot_id).limit(limit).offset(offset).all() data = dict(spot_user_list=to_dict(spot_user_list)) session.close() result = dict( success=True, message=u"spots.views.get_spot_users: spot {spot_id} user list".format(spot_id=spot_id), data=data ) return HttpResponse(dumps(result))
def get_spot_list(request): limit, offset = get_paginate_info(request.GET) session = get_session() spot_list = session.query(Spot).limit(limit).offset(offset).all() data = dict(spot_list=to_dict(spot_list)) session.close() result = dict( success=True, message=u"spots.views.get_spot_list: the list of spots from {start} to {end}".format( start=offset, end=offset + limit ), data=data, ) return HttpResponse(dumps(result, True))
def get_snap_comments(request, snap_id=None): limit, offset = get_paginate_info(request.GET) session = get_session() snap = session.query(Snap).get(snap_id) if not snap : result = dict(success=False, message=u'snaps.views.get_snap_comments: no snap with snap id {snap_id}'.format(snap_id=snap_id)) return HttpResponse(dumps(result)) comments = session.query(SnapComment).filter_by(snap_id=snap_id).limit(limit).offset(offset).all() data = dict( comment_list = to_dict(comments), ) session.close() result = dict(success=True, message=u'snaps.views.get_snap_comments: comment of Snap {snap_id} from {start} to {end}'.format(snap_id=snap_id, start=offset, end=offset+limit), data=data) return HttpResponse(dumps(result))