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()