def new_post():
form = PostForm()
if form.validate_on_submit():
post = Post(title=form.title.data,
content=form.content.data,
author=current_user,
user_tag=form.user_tag.data.name,
theme=form.theme.data)
if form.submit.data:
print("save")
post.published = True
db.session.add(post)
db.session.commit()
flash('Your post has been Published!', 'success')
return redirect(url_for('home'))
elif form.save.data:
db.session.add(post)
db.session.commit()
flash('Your post has been Saved!', 'success')
return redirect(url_for('home'))
return render_template('create_post.html',
title='New Post',
form=form,
legend='New Post',
new=True)
from slugify import slugify
app = create_app()
app.app_context().push()
df = pd.read_excel('flaskblog/Recap_Links.xlsx')
for index, row in df.iterrows():
videoinput = row['Link']
title_str = f'{row["Region"]} - Division {row["Division"]} - Week {row["Week"]}'
user = User.query.filter_by(id=140).first()
post = Post(
title = title_str,
category= row['Region'],
content = "",
shortdesc = row['Short Description'],
video = videoinput,
videoimg = parse_video_img(videoinput),
videourl = parse_video_url(videoinput),
division = row["Division"],
week = row["Week"],
author = user,
)
post.post_type = "recap"
post.published = True
post.sidebar = True
db.session.add(post)
db.session.commit()
post.slug = slugify(title_str, max_length=35).lower() + "-" + str(post.id)
db.session.commit()
