def f_search():
f_name = request.args.get('f_name')
print('收到输入：', f_name)
# 1.查询数据库存在记录
fictions = Fiction().query.all()
fiction = None
for x in fictions:
if f_name in x.fiction_name:
fiction = x
break
if fiction:
fiction_lst = Fiction_Lst().query.filter_by(
fiction_id=fiction.fiction_id).all()
if len(fiction_lst) == 0:
down_fiction_lst(f_name)
fictions = Fiction().query.all()
print('fictions=', fictions)
for fiction in fictions:
if f_name in fiction.fiction_name:
break
if f_name not in fiction.fiction_name:
return render_template('fiction_error.html', message='暂无此小说信息')
fiction_lst = Fiction_Lst().query.filter_by(
fiction_id=fiction.fiction_id).all()
return render_template(
'fiction_lst.html',
fictions=fictions,
fiction=fiction,
fiction_lst=fiction_lst,
fiction_name=fiction.fiction_name)
else:
fiction_name = fiction_lst[0].fiction_name
return render_template(
'fiction_lst.html',
fictions=fictions,
fiction=fiction,
fiction_lst=fiction_lst,
fiction_name=fiction_name)
else:
down_fiction_lst(f_name)
fictions = Fiction().query.all()
print('fictions=', fictions)
for fiction in fictions:
if f_name in fiction.fiction_name:
break
if f_name not in fiction.fiction_name:
return render_template('fiction_error.html', message='暂无此小说信息')
fiction_lst = Fiction_Lst().query.filter_by(
fiction_id=fiction.fiction_id).all()
return render_template(
'fiction_lst.html',
fictions=fictions,
fiction=fiction,
fiction_lst=fiction_lst,
fiction_name=fiction.fiction_name)
def update_fiction(fiction_id, update_time, new_content, new_url):
fiction = Fiction().query.filter_by(fiction_id=fiction_id).first()
fiction.update = update_time
fiction.new_content = new_content
fiction.new_url = new_url
db.session.add(fiction)
db.session.commit()
def insert_fiction(fiction_name, fiction_id, fiction_real_url, fiction_img,
fiction_author, fiction_comment):
fiction = Fiction().query.filter_by(fiction_id=fiction_id).first()
if fiction is None:
fiction = Fiction(fiction_name=fiction_name,
fiction_id=fiction_id,
fiction_real_url=fiction_real_url,
fiction_img=fiction_img,
fiction_author=fiction_author,
fiction_comment=fiction_comment)
db.session.add(fiction)
db.session.commit()
else:
print('记录已存在，无需下载')
def book_lst(f_id):
# 1.获取全部小说
fictions = Fiction().query.all()
for fiction in fictions:
if fiction.fiction_id == f_id:
break
print(fiction)
# 2.获取小说章节列表
fiction_lst = Fiction_Lst().query.filter_by(fiction_id=f_id).all()
if len(fiction_lst) == 0:
print(fiction.fiction_name)
down_fiction_lst(fiction.fiction_name)
fiction_lst = Fiction_Lst().query.filter_by(fiction_id=f_id).all()
if len(fiction_lst) == 0:
return render_template(
'fiction_error.html', message='暂无此章节信息，请重新刷新下')
fiction_name = fiction_lst[0].fiction_name
return render_template(
'fiction_lst.html',
fictions=fictions,
fiction=fiction,
fiction_lst=fiction_lst,
fiction_name=fiction_name)
def save_fiction_lst(fiction_lst):
total = len(fiction_lst)
if Fiction().query.filter_by(fiction_id=fiction_lst[0][1]) == total:
print('此小说已存在！！，无需下载')
return 1
for item in fiction_lst:
insert_fiction_lst(*item)
def insert_Fiction(author, fic_name, fic_id, fic_img, fic_comment, fic_source_url, new_content, new_url, update_time):
fiction = Fiction(author=author,
fic_name=fic_name,
fic_id=fic_id,
fic_img=fic_img,
fic_comment=fic_comment,
fic_source_url=fic_source_url,
new_content=new_content,
new_url=new_url,
update_time=update_time
)
db.session.add(fiction)
db.session.commit()
def book_index():
fictions = Fiction().query.all()
print(fictions)
return render_template('fiction_index.html', fictions=fictions)
def edit_submission(obj_id):
submission = Submission.query.filter_by(id=obj_id).first()
form = SubmissionEditForm()
if form.validate_on_submit():
for field in form:
current_app.logger.debug(f'{field.name}: {field.data}')
comment = Comment(
user_id=current_user.id,
submission_id=submission.id,
text=form.comment.data,
)
if form.approve.data == True:
fiction = Fiction(
title=submission.title,
subtitle=submission.subtitle,
synopsis=submission.synopsis,
cover_img=submission.cover_img,
banner_img=submission.banner_img,
genres=submission.genres,
tags=submission.tags,
rating=submission.rating,
words=submission.words,
author_id=submission.author_id,
status=submission.status,
frequency=submission.frequency,
approver_id=current_user.id,
approval_date=datetime.utcnow(),
updater_id=submission.updater_id,
)
submission.approval = True
submission.approval_date = datetime.utcnow()
submission.approver_id = current_user.id
comment.text += " *Submission approved!*"
flash("Submission approved!", "success")
db.session.add(fiction)
db.session.commit()
submission.fiction_id = fiction.id
for link in submission.links:
new_link = Link(
url=link.url,
fiction_id=fiction.id,
)
db.session.add(new_link)
else:
submission.approval = False
submission.approval_date = datetime.utcnow()
submission.approver_id = current_user.id
comment.text += " *Your submission was rejected.*"
flash("Submission rejected. :(", "success")
db.session.add(comment)
db.session.commit()
return redirect(url_for('admin.submissions'))
form.comment.data = "Thanks for the submission!"
return render_template(
'admin/edit-submission.html',
submission=submission,
form=form,
)