def get(): resp_suc = success_dic().dic resp_fail = fail_dic().dic resp_suc['list'] = [] resp_suc = get_province_city(resp_suc) return resp_suc
def get(): """ activity_id: 活动id """ parser = reqparse.RequestParser() parser.add_argument('activity_id', type=str, required=True, help=u'activity_id 必须') parser.add_argument('user_id', type=str, required=True, help=u'user_id 必须') args = parser.parse_args() activity_id = args['activity_id'] user_id = args['user_id'] success = success_dic().dic fail = fail_dic().dic success['activity_picture'] = [] activity = get_activity_by_id(activity_id, user_id) if activity: result = get_activity_picture(activity_id) if type(result) is list: success['activity_picture'] = result else: success['activity_picture'].append(result) success['activity'] = activity return success else: return fail
def get(): """ 参数: user_id:用户登录id """ parser = reqparse.RequestParser() parser.add_argument('user_id', type=str, required=True, help=u'user_id必须.') args = parser.parse_args() user_id = args['user_id'] resp_suc = success_dic().dic resp_fail = fail_dic().dic message_count = Message.query.filter(Message.receiver_id == user_id).count() if message_count > 1: messages = Message.query.filter(Message.receiver_id == user_id).all() for message in messages: db.delete(message) try: db.commit() except: return resp_fail return resp_suc else: message = Message.query.filter(Message.receiver_id == user_id).first() db.delete(message) try: db.commit() except: return resp_fail return resp_suc
def get(): """ 参数 content: 反馈内容 user_id: 登录用户id """ parser = reqparse.RequestParser() parser.add_argument('content', type=str, required=True, help=u'content必须。') parser.add_argument('user_id', type=str, required=True, help=u'user_id必须。') args = parser.parse_args() resp_suc = success_dic().dic resp_fail = fail_dic().dic content = args['content'] user_id = args['user_id'] feed_back = FeedBack(content=content, user_id=user_id) try: db.add(feed_back) db.commit() except: return resp_fail return resp_suc
def get(): """ 参数 receiver_id: 接受用户id sender_id: 发送用户id """ parser = reqparse.RequestParser() parser.add_argument('sender_id', type=str, required=True, help=u'sender_id必须') parser.add_argument('receiver_id', type=str, required=True, help=u'receiver_id必须') args = parser.parse_args() resp_suc = success_dic().dic resp_fail = fail_dic().dic resp_suc['list'] = [] sender_id = args['sender_id'] receiver_id = int(args['receiver_id']) #message_count = db.query(Message).\ # filter((Message.sender_id == sender_id, Message.receiver_id == receiver_id) | (Message.sender_id == receiver_id, Message.receiver_id == sender_id)).count() message_count = Message.query.filter(or_(and_(Message.sender_id == sender_id, Message.receiver_id == receiver_id, Message.delete_id != receiver_id), and_(Message.sender_id == receiver_id, Message.receiver_id == sender_id, Message.delete_id != receiver_id))).count() if message_count > 1: message = Message.query.filter(or_(and_(Message.sender_id == sender_id, Message.receiver_id == receiver_id, Message.delete_id != receiver_id), and_(Message.sender_id == receiver_id, Message.receiver_id == sender_id, Message.delete_id != receiver_id))).order_by(Message.time).all() traverse_user_sender_messages(message, resp_suc, receiver_id) else: message = Message.query.filter(or_(and_(Message.sender_id == sender_id, Message.receiver_id == receiver_id, Message.delete_id != receiver_id), and_(Message.sender_id == receiver_id, Message.receiver_id == sender_id, Message.delete_id != receiver_id))).order_by(Message.time).first() if message: traverse_user_sender_one(message, resp_suc, receiver_id) else: resp_suc['message'] = '没有数据' return resp_suc
def get(): """ 参数 1.pub_id:酒吧id 2.user_id: 登录用户id """ parser = reqparse.RequestParser() parser.add_argument('pub_id', type=str, required=True, help=u'pub_id 必须') parser.add_argument('user_id', type=str, required=True, help=u'user_id 必须') args = parser.parse_args() success = success_dic().dic fail = fail_dic().dic pub_id = args['pub_id'] user_id = args['user_id'] collect = Collect.query.filter(Collect.user_id == user_id, Collect.pub_id == pub_id).first() try: db.delete(collect) db.commit() return success except: return fail
def get(): """ user_id: 登陆id """ parser = reqparse.RequestParser() parser.add_argument('user_id', type=str, required=True, help=u'user_id 必须') parser.add_argument('page', type=str, required=True, help=u'page 必须') args = parser.parse_args() success = success_dic().dic fail = fail_dic().dic success['activity_collect'] = [] user_id = args['user_id'] page = int(args['page']) result = activity_collect_list(user_id, page, success) if result != 0: return success else: success['message'] = '没有数据' return success #class ActivityInfo(restful.Resource): # """ # 活动详情 # """ # @staticmethod # def get(): # """ # 参数 # activity_id: 活动id # """ # parser = reqparse.RequestParser() # parser.add_argument('activity_id', type=str, required=True, help=u'activity_id必须.') # # args = parser.parse_args() # # activity_id = args['activity_id'] # # resp_suc = success_dic().dic # resp_fail = fail_dic().dic # resp_suc['activity_list'] = [] # # activity = Activity.query.filter(Activity.id == activity_id).first() # if activity: # activity_pic = pub_activity(activity) # activity_comment_count = ActivityComment.query.filter(ActivityComment.activity_id == activity.id).count() # activity_pic['comment_count'] = activity_comment_count # resp_suc['activity_list'].append(activity_pic) # return resp_suc # else: # return resp_fail
def get(): """ 参数: sender_id:发送的id receiver_id:接收的id content: 发送内容 """ parser = reqparse.RequestParser() parser.add_argument('sender_id', type=str, required=True, help=u'sender_id必须。') parser.add_argument('receiver_id', type=str, required=True, help=u'receiver_id必须。') parser.add_argument('content', type=str, required=True, help=u'content必须。') # parser.add_argument('date', type=str, required=True, help=u'date必须.') args = parser.parse_args() sender_id = args['sender_id'] receiver_id = args['receiver_id'] content = args['content'] resp_suc = success_dic().dic resp_fail = fail_dic().dic resp_suc['sender_list'] = [] if sender_id == receiver_id: resp_fail['message'] = '您不能发给自己!' return resp_fail message = Message(sender_id=sender_id, receiver_id=receiver_id, content=content, view=0) db.add(message) try: db.commit() result = db.query(Message).\ filter(Message.sender_id == sender_id).\ group_by(Message.sender_id).count() if result == 0: user_info = UserInfo.query.filter(UserInfo.user_id == receiver_id).first() user_info.add_credit('message') db.commit() sender_info = UserInfo.query.filter(UserInfo.user_id == sender_id).first() sender_info.add_reputation('message') db.commit() except: return resp_fail message = Message.query.filter(Message.id == message.id).first() traverse_message_sender(message, resp_suc) return resp_suc
def get(): """ name: city_name 客户端穿过来的城市name """ parser = reqparse.RequestParser() parser.add_argument('name', type=str, required=True, help=u'name 必须') args = parser.parse_args() name = args['name'] success = success_dic().dic fail = fail_dic().dic city = get_province_by_name(name) if city: success['province_id'] = city return success else: fail['message'] = '未查询到数据' return fail
def get(): """ 参数, type: 详细类型 user_id: 用户登录id """ parser = reqparse.RequestParser() parser.add_argument('types', type=str, required=True, help=u'types选择信息类型,0:系统,1私信') parser.add_argument('user_id', type=str, required=True, help=u'user_id。用户登陆id') args = parser.parse_args() types = args['types'] user_id = args['user_id'] resp_suc = success_dic().dic resp_fail = fail_dic().dic resp_suc['sender_list'] = [] system_message = traverse_system_message(user_id, resp_suc) direct_message = traverse_direct_message(user_id, resp_suc) if types == '0': user = User.query.filter(User.id == user_id).first() if type(system_message) is list: for system in system_message: system_message_pickler(system, resp_suc) user.system_message_time = todayfstr() db.commit() else: if system_message: system_message_pickler(system_message, resp_suc) user.system_message_time = todayfstr() db.commit() else: if type(direct_message) is list: traverse_messages_sender(direct_message, resp_suc) else: traverse_message_sender(direct_message, resp_suc) return resp_suc
def get(): """ activity_id: 活动id user_id: 用户id """ parser = reqparse.RequestParser() parser.add_argument('activity_id', type=str, required=True, help=u'activity_id 必须') parser.add_argument('user_id', type=str, required=True, help=u'user_id 必须') args = parser.parse_args() success = success_dic().dic fail = fail_dic().dic activity_id = args['activity_id'] user_id = args['user_id'] result = collect_or_cancel_activity(user_id, activity_id) if result: return success else: success['message'] = '没有数据' return success
def get(): """ 参数 user_id:用户登录id """ parser = reqparse.RequestParser() parser.add_argument('user_id', type=str, required=True, help=u'user_id必须。') args = parser.parse_args() resp_suc = success_dic().dic resp_fail = fail_dic().dic resp_suc['sender_list'] = [] resp_suc['system_message_list'] = [] user_id = args['user_id'] system_message = traverse_system_message(user_id, resp_suc) direct_message = traverse_direct_message(user_id, resp_suc) if system_message or direct_message: message_type(user_id, system_message) direct_message_count(direct_message) return resp_suc else: resp_suc['message'] = '没有数据' return resp_suc
def get(): """ 所需参数: content:搜索酒吧内容 """ parser = reqparse.RequestParser() parser.add_argument('content', type=str, required=True, help=u'content必须,搜索酒吧') parser.add_argument('type_id', type=str, required=False) parser.add_argument('page', type=str, required=True, help=u'分页page必须.') parser.add_argument('user_id', type=str, required=False) args = parser.parse_args() resp_suc = {} resp_suc['pub_list'] = [] resp_fail = fail_dic().dic pub_pic = None page = args['page'] user_id = args.get('user_id', 0) if args['content']: content = str(args['content']) s = "%" + content + "%" if args['type_id']: pub_count = db.query(Pub).\ join(PubTypeMid).\ filter(Pub.name.like(s), PubTypeMid.pub_type_id == int(args['type_id'])).count() temp_page = page page, per_page, max = page_utils(pub_count, page) is_max = max_page(temp_page, max, resp_suc) if is_max: return resp_suc if pub_count == 0: return resp_fail() if pub_count > 1: pubs = db.query(Pub). \ join(PubTypeMid). \ filter(Pub.name.like(s), PubTypeMid.pub_type_id == int(args['type_id']))[per_page*(int(temp_page)-1):per_page*int(temp_page)] is_collect_pub(pubs, user_id, resp_suc) else: pub = db.query(Pub). \ join(PubTypeMid). \ filter(Pub.name.like(s), PubTypeMid.pub_type_id == int(args['type_id'])).first() is_collect_pub(pub, user_id, resp_suc) else: pub_count = Pub.query.filter(Pub.name.like(s)).count() temp_page = page page, per_page, max = page_utils(pub_count, page) is_max = max_page(temp_page, max, resp_suc) if is_max: return resp_suc if pub_count == 0: return resp_fail if pub_count > 1: pubs = Pub.query.filter(Pub.name.like(s))[per_page*(int(temp_page)- 1):per_page*int(temp_page)] is_collect_pub(pubs, user_id, resp_suc) else: pub = Pub.query.filter(Pub.name.like(s)).first() is_collect_pub(pub, user_id, resp_suc) resp_suc['message'] = "success" resp_suc['status'] = 0 return resp_suc else: resp_suc['message'] = "error" resp_suc['status'] = 1 return resp_suc