def new_recap():
form = RecapForm()
if form.validate_on_submit():
videoinput = form.video.data
title_str = f"{form.category.data} Div {', '.join(form.division.data)} - Week {form.week.data}"
post = Post(
title=title_str,
category=form.category.data,
content=form.content.data,
shortdesc=form.shortdesc.data,
video=form.video.data,
videoimg=parse_video_img(videoinput),
videourl=parse_video_url(videoinput),
division=", ".join(form.division.data),
week=form.week.data,
author=current_user,
post_type="recap",
published=False,
sidebar=True,
)
db.session.add(post)
db.session.commit()
post.slug = slugify(str(title_str), max_length=35).lower() + "-" + str(
post.id)
db.session.commit()
flash("Your Recap Video has been added!", "success")
return redirect(url_for("posts.postslug", post_slug=post.slug))
return render_template(
"create_recap.html",
title="New Video Recap",
form=form,
legend="New Video Recap",
)
def new_video():
form = VideoForm()
if form.validate_on_submit():
# Insert logic to parse out video unique identifier to store as video
videoinput = form.video.data
post = Post(
title=form.title.data,
category=form.category.data,
shortdesc=form.shortdesc.data,
content=form.content.data,
video=form.video.data,
# post.videotype = form.videotype.data,
videoimg=parse_video_img(videoinput),
videourl=parse_video_url(videoinput),
author=current_user,
post_type="video",
published=False,
sidebar=True,
)
db.session.add(post)
db.session.commit()
post.slug = slugify(form.title.data,
max_length=35).lower() + "-" + str(post.id)
db.session.commit()
flash("Your video has been added!", "success")
return redirect(url_for("posts.postslug", post_slug=post.slug))
return render_template("create_video.html",
title="New Video Post",
form=form,
legend="New Video Post")
def new_post():
form = PostForm()
if form.validate_on_submit():
# Working on adding Cover Photos
"""if form.picture.data:
picture_file = save_picture(form.picture.data)
post.image_file = picture_file"""
post = Post(
title=form.title.data,
category=form.category.data,
shortdesc=form.shortdesc.data,
content=form.content.data,
author=current_user,
published=False,
sidebar=True,
post_type="text",
)
# cover_image=post.image_file)
db.session.add(post)
db.session.commit()
post.slug = slugify(form.title.data,
max_length=35).lower() + "-" + str(post.id)
db.session.commit()
flash("Your comment has been added!", "success")
return redirect(url_for("posts.postslug", post_slug=post.slug))
return render_template("create_post.html",
title="New Post",
form=form,
legend="New Post")
def new_post():
form = PostForm()
if form.validate_on_submit():
post = Post(title=form.title.data, content=form.content.data, author=current_user)
post.slug = slugify(form.title.data)
post.like_post = 0
post.dislike_post = 0
# Send email notification to all users
users = User.query.all()
emailsender = current_app.config['EMAIL_SENDER']
username = current_user.username
send_newpostnotif_email(username,users,post,emailsender)
db.session.add(post)
try:
db.session.commit()
flash('Your post has been created!', 'success')
except:
db.session.rollback()
raise
finally:
db.session.close()
return redirect(url_for('main.home'))
return render_template('create_post.html', title='New Post',
form=form, legend='New Story')
def new_post():
form = PostForm()
if form.validate_on_submit():
post = Post(title=form.title.data,
content=form.content.data,
author=current_user)
post.slug = slugify(form.title.data)
post.like_post = 0
post.dislike_post = 0
db.session.add(post)
try:
db.session.commit()
flash('Your post has been created!', 'success')
current_app.logger.info(
"New Story - %s",
(current_user.username, current_user.email, post.slug))
except:
db.session.rollback()
raise
finally:
db.session.close()
return redirect(url_for('main.home'))
return render_template('create_post.html',
title='New Post',
form=form,
legend='New Story')
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()
