def query_article(request): id = GetRequestArgsData(request, 'id', None) article = Article.query.filter(Article.id == id).first() if not article: return ReturnCode.paramete_error, '文章不存在或参数有误', '' serialize = Serialize(article, obj='obj', dataprocessing='getarticlelist') return ReturnCode.ok, '', serialize
def getanote(request): id = request.get('id', None) if not id: return 201, '笔记id不能为空', {} o = Note_Content.query.filter(Note_Content.id == id).first() if not o: return 202, '笔记不存在', {} return 200, '', Serialize(o, obj='obj')
def recycler(request): queryPage = PaginatePages(request, None) querys = Note_Content.query.filter( Note_Content.is_delete == True).order_by( Note_Content.create_time.desc()) data_sum, data_item, page_sum = SerializeQuerySet(querys, queryPage) ret = Serialize(data_item, obj='list', dataprocessing='querynotelist') return 200, '成功', { 'result': ret, 'data_sum': data_sum, 'page_sum': page_sum, 'now_page': queryPage }
def category_list(request): table = Note_SubCategory fid = request.get('fid') if not fid: return 201, "父级类目id不能为空", {} if not Note_Category.query.filter(Note_Category.id == fid).first(): return 202, "父级分类不存在", {} querys = table.query.filter(table.categoryid == fid).all() ret = [] for i in querys: ret.append(Serialize(i, obj='obj')) return 200,'',ret
def note_list(request): id = request.get('id', None) if not id: return 201, "获取的类目id不能为空", {} if not Note_SubCategory.query.filter(Note_SubCategory.id == id).first(): return 202, '类目不存在', {} querys = Note_Content.query.filter(Note_Content.subcategoryid == id, Note_Content.is_delete == False).all() ret = [] for i in querys: ret.append(Serialize(i, obj='obj', dataprocessing='querynotelist')) return 200, '', ret
def query_article_list(request): article_type = GetRequestArgsData(request, 'article_type', None) query_pages = PaginatePagesArgs(request, None) if not article_type: return ReturnCode.paramete_error, '获取的文章类型缺乏', '' querys = Article.query.filter(Article.status == 0).order_by( Article.upload_time.desc()) # 作品 if int(article_type) == 1: querys = querys.filter(Article.article_type == article_type) content_type = GetRequestArgsData(request, 'content_type', None) if content_type: querys = querys.filter(Article.content_type == content_type) # 文章 if int(article_type) == 2: querys = querys.filter(Article.article_type == article_type) # 项目 if int(article_type) == 3: querys = querys.filter(Article.article_type == article_type) query_count, query_dataitems, query_datapages = SerializeQuerySet( querys, query_pages, per_page=100) return ReturnCode.ok, '', { 'list': Serialize(query_dataitems, obj='list', dataprocessing='getarticlelist', notreturn=['content']), 'queryCount': query_count, 'dataPges': query_datapages, 'nowPage': query_pages }
def options(request): ret = [] for i in Note_Category.query.all(): ret.append(Serialize(i, obj='obj')) return 200,'',ret
def query_article_list(request): admin = request.get('admin', None) article_type = request.get('article_type', None) query_pages = PaginatePages(request, None) if not article_type: return ReturnCode.paramete_error, '获取的文章类型缺乏', '' if admin == 'admin': # print('管理员模式') querys = Article.query.filter().order_by(Article.upload_time.desc()) # 作品 if int(article_type) == 1: querys = querys.filter(Article.article_type == article_type, Article.is_delete == False) content_type = request.get('content_type', None) if content_type: querys = querys.filter(Article.content_type == content_type) # 文章 if int(article_type) == 2: querys = querys.filter(Article.article_type == article_type, Article.is_delete == False) # 项目 if int(article_type) == 3: querys = querys.filter(Article.article_type == article_type, Article.is_delete == False) if int(article_type) == 4: querys = querys.filter(Article.is_delete == True) else: # print('游客模式') querys = Article.query.filter(Article.status == 0, Article.is_delete == False).order_by( Article.upload_time.desc()) # 作品 if int(article_type) == 1: querys = querys.filter(Article.article_type == article_type) content_type = request.get('content_type', None) if content_type: querys = querys.filter(Article.content_type == content_type) # 文章 if int(article_type) == 2: querys = querys.filter(Article.article_type == article_type) # 项目 if int(article_type) == 3: querys = querys.filter(Article.article_type == article_type) if int(article_type) == 4: querys = querys.filter(Article.is_delete == True) query_count, query_dataitems, query_datapages = SerializeQuerySet( querys, query_pages, per_page=100) return ReturnCode.ok, '', { 'list': Serialize(query_dataitems, obj='list', dataprocessing='getarticlelist', notreturn=['content']), 'queryCount': query_count, 'dataPges': query_datapages, 'nowPage': query_pages }
def category_list(request): querys = Note_Category.query.all() ret = [] for i in querys: ret.append(Serialize(i, obj='obj')) return 0, 0, ret