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