def delete():
'''deletes blog and all info within'''
blog_id = request.form['blog_id']
users = populateDB.findInfo('users', 0, "UserID", notEqual =True)
if populateDB.findInfo('posts', blog_id, 'blogID'):
for user in users:
user_id = user[0]
postsLiked = user[4][:-1]
print(postsLiked)
listLikedPosts = postsLiked.split(',')
postsLiked = ""
print(listLikedPosts)
for p in listLikedPosts:
if len(p) > 0:
print('inloop')
print(p)
if populateDB.findInfo('posts', p, 'postID', fetchOne=True)[1]:
blog_origin = populateDB.findInfo('posts', p, 'postID', fetchOne=True)[1]
if str(blog_id) != str(blog_origin):
postsLiked += p + ','
print('postsliked: ' + postsLiked)
populateDB.modify('users', 'LikedPosts', postsLiked,'UserId', user_id)
populateDB.delete('posts', 'BlogID', blog_id)
populateDB.delete('blogs', 'BlogID', blog_id)
return redirect(url_for('profile'))
def add_post():
'''allows the user to add more posts'''
if 'user' in session:
user = session['user']
blog_id = request.form['add_post']
blog = populateDB.findInfo('blogs', blog_id, 'BlogID')
posts = populateDB.findInfo('posts', blog_id, 'blogId')
return render_template('add_post.html',user = user, blog = blog[0], posts=posts[::-1])
else:
return redirect(url_for('home'))
def look():
'''locates post, user, or blog with certain value'''
name = request.form['search_value']
type = request.form['searchtype']
if type == "Blog":
results = populateDB.findInfo('blogs',name, 'BlogTitle', asSubstring = True)
print ('results here')
print (results)
elif type == "Post":
results = populateDB.findInfo('posts',name, 'Heading', asSubstring = True)
else:
results = populateDB.findInfo('users', name, 'Username', asSubstring = True)
return render_template("search.html", typer = type + 's', results = results)
def blog():
'''displays each blog for user'''
user = session['user']
blog_id = request.form['blog_id']
blog = populateDB.findInfo('blogs', blog_id, 'blogID',fetchOne=True)
user_id = blog[1]
userInfo = populateDB.findInfo('users', user_id, 'UserID', fetchOne = True)
viewer = populateDB.findInfo('users', user, 'username', fetchOne = True)
viewerID = viewer[0]
posts = populateDB.findInfo('posts', blog_id, 'blogId')
is_owner = viewerID == blog[1]
print ('blog')
print (blog[3])
print(posts[::-1])
return render_template('blog.html', username = userInfo[2], viewerPostLiked = viewer[4], blog = blog, posts=posts[::-1], owner=is_owner)
def profile():
'''displays home page for user, which includes all the blogs the user made'''
print ('profile')
try:
request.form['user_id']
id = request.form['user_id']
user = populateDB.findInfo('users', id, 'UserID', fetchOne = True)[2]
is_owner = False
print (user)
except:
user = session['user']
id = populateDB.findInfo('users', user, 'username', fetchOne = True)[0]
is_owner = True
print(id)
blogs = populateDB.findInfo('blogs', id, 'ownerID')
print(blogs)
return render_template('profile.html', username = user, blogs=blogs[::-1], owner = is_owner)
def edit():
'''edits a post'''
print ('edit called...')
user = session['user']
viewer = populateDB.findInfo('users', user, 'username', fetchOne = True)
posts_liked = viewer[4]
text = functions.checkApos(request.form['text'])
print(text)
post_id = request.form['post_id']
populateDB.modify('posts', 'Content', text, 'PostID', post_id)
populateDB.modify('posts', 'Timestamp', str(time.asctime( time.localtime(time.time()))), 'PostID', post_id)
blog_id = populateDB.findInfo('posts', post_id, 'postID', fetchOne =True)[1]
blog = populateDB.findInfo('blogs', blog_id, 'blogID', fetchOne =True)
posts = populateDB.findInfo('posts', blog_id, 'blogID')
viewerID = viewer[0]
is_owner = viewerID in blog
return render_template('blog.html', username = viewer[2], viewerPostLiked = posts_liked, blog = blog, posts=posts[::-1], owner=is_owner)
def post():
'''adds a post'''
print ('submit called...')
head = functions.checkApos(request.form['heading'])
text = functions.checkApos(request.form['text'])
blog_id = request.form['blog_id']
user = session['user']
user_all = populateDB.findInfo('users', user, 'username', fetchOne = True)
user_id = user_all[0]
posts_liked = user_all[4]
poststuff = [blog_id, user_id, text, str(time.asctime( time.localtime(time.time()))), 0, head]
populateDB.insert('posts', poststuff)
blog = populateDB.findInfo('blogs', blog_id, 'blogID', fetchOne =True)
posts = populateDB.findInfo('posts', blog_id, 'blogID')
is_owner = user_id in blog
return render_template('blog.html', username = user_all[2], viewerPostLiked = posts_liked, blog = blog, posts=posts[::-1], owner=is_owner)
def make():
'''adds blog based on input from user to db'''
user = session['user']
head = functions.checkApos(request.form['blogTitle'])
des = functions.checkApos(request.form['blogDes'])
cat = request.form['blogCat']
print(head)
print(des)
print(cat)
user_id = populateDB.findInfo('users', user, 'username', fetchOne = True)[0]
blogstuff = [user_id, str(user_id), head, des, cat]
populateDB.insert('blogs',blogstuff)
return redirect(url_for('profile'))
def login():
'''logs the user in by checking if their login info matches with registered user'''
username = request.form['usr'].strip()
password = request.form['pwd'].strip()
user_exists = populateDB.findInfo('users', functions.checkApos(username), 'username', fetchOne = True)
if user_exists:
print (sha256_crypt.verify(password, user_exists[3]))
if sha256_crypt.verify(password, user_exists[3]):
session['user'] = username
return redirect(url_for('home'))
else:
flash("password wrong")
return render_template('home.html')
flash("username wrong")
return redirect(url_for('home'))
def miscellaneous():
'''displays miscellaneous category'''
blogs = populateDB.findInfo('blogs','Miscellaneous','Category')
return render_template('miscellaneous.html', blogs=blogs)
def music():
'''displays music category'''
blogs = populateDB.findInfo('blogs','Music','Category')
return render_template('music.html', blogs=blogs)
def life():
'''displays life category'''
blogs = populateDB.findInfo('blogs','Life','Category')
return render_template('life.html', blogs=blogs)
def news():
'''displays news category'''
blogs = populateDB.findInfo('blogs','News','Category')
return render_template('news.html', blogs=blogs)
def sports():
'''displays sports category'''
blogs = populateDB.findInfo('blogs','Sports','Category')
return render_template('sports.html', blogs=blogs)
def tech():
'''displays tech category'''
blogs = populateDB.findInfo('blogs','Tech','Category')
return render_template('tech.html', blogs=blogs)
def users():
'''displays every user with their blogs'''
user = session['user']
users = populateDB.findInfo('users',user,'Username', notEqual = True)
return render_template('users.html', users=users)
def edit_post():
'''allows the user to edit existing posts, delete them, like them, unlike them if owner, like/unlike if viewer'''
if 'user' in session:
user = session['user']
user = populateDB.findInfo('users', user, 'Username', fetchOne = True)
user_id = user[0]
#edits existing post
if request.form.get('edit_id'):
post_id = request.form['edit_id']
post = populateDB.findInfo('posts', post_id, 'postId')
return render_template('edit_post.html',user = user, post=post[0])
#likes the post
elif request.form.get('like_id'):
post_id = request.form['like_id']
postRec = populateDB.findInfo('posts', post_id, 'postID', fetchOne = True)
votes = postRec[5]
postsLiked = populateDB.findInfo('users', user_id, 'UserID', fetchOne=True)[4]
listLikedPosts = postsLiked.split(',')
hasLiked = post_id in listLikedPosts
#unlikes the post
if hasLiked:
votes -= 1
populateDB.modify('posts', 'VOTES', votes, 'PostID', post_id)
listLikedPosts = postsLiked.split(',')
listLikedPosts.remove(post_id)
postsLiked = ""
for p in listLikedPosts:
if len(p)> 0:
postsLiked += p + ','
populateDB.modify('users', 'LikedPosts', postsLiked,'UserId', user_id)
else:
votes += 1
populateDB.modify('posts', 'VOTES', votes, 'PostID', post_id)
postsLiked += str(post_id) + ','
populateDB.modify('users', 'LikedPosts', postsLiked,'UserId', user_id)
blog = populateDB.findInfo('blogs', postRec[1], 'blogID', fetchOne =True)
print(blog)
posts = populateDB.findInfo('posts', postRec[1], 'blogID')
print(posts)
owner = populateDB.findInfo('users', blog[1], 'UserID', fetchOne = True)
is_owner = user_id == blog[1]
print(owner)
return render_template('blog.html', username = owner[2], viewerPostLiked = postsLiked, blog = blog, posts=posts[::-1], owner=is_owner)
else:
#deletes post
post_id = request.form['delete_id']
postRec = populateDB.findInfo('posts', post_id, 'postID', fetchOne = True)
blog = populateDB.findInfo('blogs', postRec[1], 'blogID', fetchOne =True)
owner = populateDB.findInfo('users', blog[1], 'UserID', fetchOne = True)
is_owner = user_id == blog[1]
users = populateDB.findInfo('users', 0, "UserID", notEqual =True)
for user in users:
user_id = user[0]
postsLiked = user[4]
listLikedPosts = postsLiked.split(',')
if post_id in listLikedPosts:
listLikedPosts.remove(post_id)
postsLiked = ""
for p in listLikedPosts:
if (len(p) > 0):
postsLiked += p + ','
populateDB.modify('users', 'LikedPosts', postsLiked, 'UserId', user_id)
populateDB.delete('posts', 'PostID', post_id)
posts = populateDB.findInfo('posts', postRec[1], 'blogID')
postsLiked = populateDB.findInfo('users', user_id, 'UserID', fetchOne=True)[4]
populateDB.modify('users', 'LikedPosts', postsLiked,'UserId', user_id)
return render_template('blog.html', username = owner[2], viewerPostLiked = postsLiked, blog = blog, posts=posts[::-1], owner=is_owner)
else:
return redirect(url_for('home'))
def food():
'''displays food category'''
blogs = populateDB.findInfo('blogs','Food','Category')
return render_template('food.html', blogs=blogs)