def create_user(): if request.method == 'POST': try: first_name = request.form['first_name'] last_name= request.form['last_name'] birth_date = request.form['birth_date'] age = request.form['age'] gender = request.form['gender'] email = request.form['email'] website = request.form['website'] alive = request.form['alive'] created_at = request.form['created_at'] except: first_name = fake.first_name() last_name= fake.last_name() birth_date = fake.date() age = str(random.randint(18,65)) gender = "Male" email = fake.email() website = fake.url() alive = ["true",'false'] alive = alive[random.randint(0,1)] created_at = "2001-09-28 01:00:00" #name='joe' # Check that email does not already exist (not a great query, but works) if not db.session.query(User).filter(User.first_name == first_name).count(): reg = User(first_name,last_name,birth_date,age,gender,email,website,alive,created_at) db.session.add(reg) db.session.commit() return render_template('users/success.html',first_name=first_name) return render_template('users/index.html')
def edit_user(user_id): user = User.query.filter_by(id=user_id).one() if request.method == 'POST': try: first_name = request.form['first_name'] #required in the view last_name = request.form['last_name'] #required in the view birth_date = datetime(2018, 9, 28, 10, 10, 10).date() age = request.form['age'] gender = request.form['gender'] email = request.form['email'] website = request.form['website'] alive = request.form['alive'] created_at = datetime(2018, 9, 28, 10, 10, 10) post.first_name = first_name post.last_name = last_name post.birth_date = birth_date post.age = age post.gender = gender post.email = email post.website = website post.alive = alive post.cretated_at = created_at except: first_name = fake.first_name() #required in the view last_name = fake.last_name() birth_date = datetime(2018, 9, 28, 10, 10, 10).date() age = str(random.randint(18, 65)) gender = "Male" email = fake.email() website = fake.url() alive = ["true", 'false'] alive = alive[random.randint(0, 1)] created_at = datetime(2018, 9, 28, 10, 10, 10) post.first_name = first_name post.last_name = last_name post.birth_date = birth_date post.age = age post.gender = gender post.email = email post.website = website post.alive = alive post.cretated_at = created_at # Check that email does not already exist (not a great query, but works) if db.session.query(User).filter( User.first_name == first_name).count(): db.session.commit() return render_template('users/user_edit_success.html', first_name=first_name) elif request.method == "GET": return render_template('users/edit.html', first_name=user.first_name, user=user) return render_template('users/index.html')
def create_post(): if request.method == 'POST': try: title = request.form['title'] content = request.form['content'] if content == "": content = fake.text() created_at = "2001-09-28 01:00:00" except: title = fake.first_name() content = fake.text() created_at = "2001-09-28 01:00:00" # Check that email does not already exist (not a great query, but works) if not db.session.query(Post).filter(Post.title == title).count(): reg = Post(title, content, created_at) db.session.add(reg) db.session.commit() return render_template('posts/success.html', title=title) return render_template('posts/index.html')
def create_user(): if request.method == 'POST': try: first_name = request.form['first_name'] last_name = request.form['last_name'] #birth_date = request.form['birth_date'] #must be converted to date birth_date = datetime(2018, 9, 28, 10, 10, 10).date() #birth_date = fake.date() #birth_date= datetime(2018,9,28,10,10,10).date() age = request.form['age'] gender = request.form['gender'] email = request.form['email'] website = request.form['website'] alive = request.form['alive'] #created_at = request.form['created_at'] created_at = datetime(2018, 9, 28, 10, 10, 10) #created_at = datetime(2018,9,28,10,10,10).strftime("%Y-%m-%d %H:%M:%S") #created_at = datetime.now() except: first_name = fake.first_name() last_name = fake.last_name() #birth_date = fake.date() #must be converted to date birth_date = datetime(2018, 9, 28, 10, 10, 10).date() age = str(random.randint(18, 65)) gender = "Male" email = fake.email() website = fake.url() alive = ["true", 'false'] alive = alive[random.randint(0, 1)] created_at = datetime(2018, 9, 28, 10, 10, 10) #created_at = datetime(2018,9,28,10,10,10).strftime("%Y-%m-%d %H:%M:%S") #created_at = datetime.now() #name='joe' # Check that email does not already exist (not a great query, but works) if not db.session.query(User).filter( User.first_name == first_name).count(): reg = User(first_name, last_name, birth_date, age, gender, email, website, alive, created_at) db.session.add(reg) db.session.commit() return render_template('users/success.html', first_name=first_name) return render_template('users/index.html')
def edit_post(post_id): post = Post.query.filter_by(id=post_id).one() if request.method == 'POST': try: title = request.form['title'] content = request.form['content'] post.title = title post.content = content if content =="": post.content=fake.text() post.created_at = datetime(2018,9,28,10,10,10) except: post.title = fake.first_name() post.content= fake.text() post.created_at = datetime(2018,9,28,10,10,10) # Check that email does not already exist (not a great query, but works) if db.session.query(Post).filter(Post.title == title).count(): db.session.commit() return render_template('posts/post_edit_success.html',title=title) elif request.method == "GET": return render_template('posts/edit.html',title=post.title,post=post) return render_template('posts/index.html')
def user_index(): users = User.query.all() return render_template('users/index.html', users=users)
def post_index(): posts = Post.query.all() return render_template('posts/index.html', posts=posts)
def show_user(user_id): user = User.query.filter_by(id=user_id).one() return render_template('users/show.html', user=user)
def delete_user(user_id): user = User.query.filter_by(id=user_id).one() user_name = user.first_name + ' ' + user.last_name db.session.delete(user) db.session.commit() return render_template('users/delete.html', user_name=user_name)
def login(): return render_template('components/login.html')
def delete_post(post_id): post = Post.query.filter_by(id=post_id).one() post_title = post.title db.session.delete(post) db.session.commit() return render_template('posts/delete.html',post_title=post_title)
def show_post(post_id): post = Post.query.filter_by(id=post_id).one() return render_template('posts/show.html', post=post)