def join():
try:
username = request.form['username']
passwd1 = request.form['password1']
passwd2 = request.form['password2']
if passwd1 != passwd2:
flash('passwords do not match')
return redirect( url_for('login'))
hashed = bcrypt.hashpw(passwd1.encode('utf-8'), bcrypt.gensalt())
conn = info.getConn('c9')
curs = conn.cursor(MySQLdb.cursors.DictCursor)
# deal with threading races
try:
curs.execute('INSERT into accounts(username,hashed) VALUES(%s,%s)',
[username, hashed])
conn.commit()
except MySQLdb.IntegrityError as err:
flash('That username is taken')
return redirect(url_for('login'))
session['username'] = username
session['logged_in'] = True
return redirect( url_for('userPortal') )
except Exception as err:
flash('form submission error '+str(err))
return redirect( url_for('login') )
def FAQ():
conn = info.getConn('c9')
featuredEvents = info.getFeaturedEvents(conn)
print (featuredEvents)
username = session.get('username')
for event in featuredEvents:
starred = info.isStarred(conn,event['pid'],username)
event["starred"] = "0" if starred is None else "1"
return render_template('FAQ.html', title="FAQ Page", featuredEvents = featuredEvents, logged_in=session.get('logged_in',False))
def pic(pid):
''' url for looking for picture in the file system with given pid '''
conn = info.getConn('c9')
curs = conn.cursor(MySQLdb.cursors.DictCursor)
curs.execute('''select pid,imagefile from posts where pid = %s''', [pid])
pic = curs.fetchone()['imagefile']
if pic is None:
# flash('No picture for {}'.format(pid))
val = ""
else:
val = send_from_directory(app.config['UPLOADS'],pic)
return val
def deleteTag(tid):
if request.method == "POST":
isAdmin = session.get('admin',False)
if not isAdmin:
flash("please log in as ADMIN")
print("please log in as ADMIN")
return redirect(url_for("tagsList"))
conn = info.getConn('c9')
info.deleteTag(conn,tid)
flash("tag {} successfully deleted".format(tid))
print("tag {} successfully deleted".format(tid))
return redirect(url_for("tagsList"))
def searchResults():
# if keyword is not None or tags is not None:
keyword = session.get('keyword','')
tags = session.get('tags','')
conn = info.getConn('c9')
posts = info.searchPosts(conn,keyword,tags)
print(keyword)
tagHolder = "enter tags separated by comma: e.g. cs, club" if (tags != '') else tags
return render_template('search_results.html',keyword=keyword,tags=tagHolder ,posts=posts)
def displayPost(pid):
''' Allow users who are not logged_in to see the posts, with the star function disabled '''
logged_in = session.get('logged_in', False)
conn = info.getConn('c9')
postInfo = info.readOnePost(conn,pid)
if logged_in:
username = session.get('username')
starred = info.isStarred(conn,pid,username)
isAuthor = info.isAuthor(conn,pid,username)
postInfo["starred"] = "0" if starred is None else "1"
authorEmail = info.getAuthorEmail(conn, postInfo['author'])
return render_template('post.html',isAdmin=session.get('admin',False), authorEmail = authorEmail, isAuthor=isAuthor, post=postInfo,logged_in=logged_in)
else:
return render_template('post.html',post=postInfo,logged_in=logged_in)
def tagsList(tag):
logged_in = session.get('logged_in', False)
if not logged_in: # the link is only available after the user is logged in
flash("Please log in!")
return redirect(url_for("login"))
conn = info.getConn('c9')
tags = info.getTags(conn, tag) # return all tags that contain the keyword `tag`
# update each tag dictionary with info indicating 1) whether it is followed by
# this user, 2) how many posts that use this tag and 3) how many followers
# in total
for tag in tags:
followed = info.isFollowed(conn, tag['tid'], session.get('username'))
followed = "0" if followed is None else "1"
tag['followed'] = followed
return render_template('tagsList.html', isAdmin = session.get('admin',False), title = "Tags List", tags=tags, logged_in=logged_in)
def createPost():
conn = info.getConn('c9')
error = False
if request.method == 'GET':
#blank form rendered when page is first visited
return render_template('createPost.html',
title="Create a Post!",post=session.get('newpost',None))
else:
#flash warning messages if form is filled out incorrectly
title = request.form.get('post-title','')
content = request.form.get('post-content','')
location = request.form.get('post-location','')
event_time = request.form.get('post-eventtime','') check
event_date = request.form.get('post-eventdate','')
newpost = {"title":title,"content":content,"location":location,"event_time":event_time,"event_date":event_date}
session['newpost'] = newpost
if title == "":
flash('Missing value: Please enter a title for your event!')
error = True
if location == "":
flash('Missing value: Please enter a location for your event!')
error = True
if event_date == "":
flash('Missing value: Please enter a date for your event!')
error = True
if event_time == "":
flash('Missing value: Please enter a time for your event!')
error = True
#test if any errors occured then take user back to insert page
if error == True:
return render_template('createPost.html', title="Create a Post!",post=session.get('newpost'))
post = info.insertPost(conn, title, content, location, event_time, event_date)
print(post)
pid = post["
"]
session.pop('newpost',None)
return redirect(url_for('createPost.html', pid=pid))
def generalFeed():
''' Allows users who are not logged_in to see the general feed, with star function disabled '''
logged_in = session.get('logged_in', False)
keyword = session.pop('keyword','')
tags = session.pop('tags','')
conn = info.getConn('c9')
posts = info.searchPosts(conn,keyword,tags)
tagHolder = "enter tags separated by comma: e.g. cs, club" if (tags != '') else tags
if logged_in:
for post in posts:
isStarred = info.isStarred(conn,post['pid'],session.get('username'))
print(isStarred)
post['starred'] = "0" if isStarred is None else "1"
print(post)
isTomorrow = info.isEventDayTomorrow(conn, post['pid'])
post['tomorrow'] = "0" if isTomorrow is False else "1"
print(isTomorrow)
return render_template('generalFeed.html',title = "General Feed", keyword=keyword,tags=tagHolder,posts=posts,logged_in=session.get('logged_in',False))
def followAjax():
if request.method == 'POST':
conn = info.getConn('c9')
usr = session.get('username')
tid = request.form.get('tid')
followed = request.form.get('followed')
print(followed)
usrPhone = info.getUserPhone(conn, usr)
usrEmail = info.getUserEmail(conn, usr)
# Users cannot see the follow feature if they are not logged in, so it is redundant to add an additional if condition here.
if followed == "0":
print(tid)
print(usr)
numFollows = info.followTag(conn,tid,usr)['num_followers']
print("post {} is followed by user {}".format(tid,usr))
return jsonify( {'error':False, 'tid': tid, 'followed': "1", 'numFollows': numFollows} )
else:
numFollows = info.unfollowTag(conn,tid,usr)['num_followers']
print("post {} is unfollowed by user {}".format(tid,usr))
return jsonify( {'error':False, 'tid': tid, 'followed': "0", 'numFollows': numFollows} )
def userPortal():
logged_in = session.get('logged_in', False)
if not logged_in: # the link is only available after the user is logged in
flash("Please log in!")
return redirect(url_for("login"))
conn = info.getConn('c9')
usr=session.get('username')
stars = info.displayStarredEvents(conn,usr)
posts = info.displayPostsByUser(conn,usr)
follows = info.displayFollowedTags(conn,usr)
# update each star with explicit string indicating whether the post is starred by the user
for star in stars:
star['starred'] = "1"
# update each tag with explicit string indicating whether the tag is followed by the user
for follow in follows:
follow['followed'] = "1"
return render_template('userPortal.html', isAdmin=session.get('admin',False),title = "User Portal", stars=stars,
posts=posts, follows=follows, username=usr,logged_in=logged_in)
def loginAction():
try:
username = request.form['username']
passwd = request.form['password']
conn = info.getConn('c9')
curs = conn.cursor(MySQLdb.cursors.DictCursor)
curs.execute('SELECT hashed FROM accounts WHERE username = %s',
[username])
row = curs.fetchone()
if row is None:
flash('login incorrect. Try again or join')
return redirect( url_for('index'))
hashed = row['hashed']
# strings always come out of the database as unicode objects
if bcrypt.hashpw(passwd.encode('utf-8'),hashed.encode('utf-8')) == hashed:
if request.form.get('login-btn') == 'Login as User':
flash('successfully logged in as '+username)
session['username'] = username
session['logged_in'] = True
return redirect( url_for('userPortal') )
else:
curs.execute("""select isAdmin from accounts where username = %s""",
[username])
isAdmin = curs.fetchone().get('isAdmin')
if isAdmin:
flash('successfully logged in as ADMIN '+username)
session['username'] = username
session['logged_in'] = True
session['admin'] = True
return redirect( url_for('userPortal') )
else:
flash('login as ADMIN incorrect. Try again or join')
return redirect( url_for('login'))
else:
flash('login incorrect. Try again or join')
return redirect( url_for('login'))
except Exception as err:
flash('form submission error '+str(err))
return redirect( url_for('login') )
def updateProfile():
''' Collects contact information from users '''
logged_in = session.get('logged_in', False)
if not logged_in: # the link is only available after the user is logged in
flash("Please log in!")
return redirect(url_for("login"))
# information from database
conn = info.getConn('c9')
usr=session.get('username')
oldNum = info.getUserPhone(conn,usr)
oldEmail = info.getUserEmail(conn,usr)
if request.method == "GET":
# set up the page and pre-fill the form using info from database
num = "" if oldNum is None else oldNum
email = "" if oldEmail is None else oldEmail
return render_template('updateProfile.html', num=num, email=email, logged_in=session.get('logged_in',False))
else:
# the update function, grab info filled in by the user
newNum = request.form.get("phoneNum")
newEmail = request.form.get("email")
if len(newNum) != 10:
flash("Please provide a valid US phone number with exactly 10 digits.")
return redirect(url_for('updateProfile'))
try:
numericForm = int(newNum)
info.updateUserPhone(conn, usr, newNum)
print("Phone number of ({}) was updated successfully.".format(usr))
info.updateUserEmail(conn, usr, newEmail)
print("Email of ({}) was updated successfully.".format(usr))
return redirect(url_for('updateProfile'))
except Exception as err:
flash("Invalid phone number:{why}".format(why=err))
return redirect(url_for('updateProfile'))
def starAjax():
if request.method == 'POST':
conn = info.getConn('c9')
usr = session.get('username')
pid = request.form.get('pid')
starred = request.form.get('starred')
usrPhone = info.getUserPhone(conn, usr)
print(usrPhone)
usrEmail = info.getUserEmail(conn, usr)
print(usrEmail)
# Users cannot see the starring feature if they are not logged in, so it is redundant to add an additional if condition here.
print(starred)
print(type(starred))
if starred == "0":
info.starPost(conn,pid,usr)
print("post {} is starred by user {}".format(pid,usr))
return jsonify( {'error':False, 'pid': pid, 'starred': "1"} )
else:
info.unstarPost(conn,pid,usr)
print("post {} is unstarred by user {}".format(pid,usr))
return jsonify( {'error':False, 'pid': pid, 'starred': "0"} )
def createPost():
logged_in = session.get('logged_in', False)
if not logged_in: # the link is only available after the user is logged in
flash("Please log in!")
return redirect(url_for("login"))
conn = info.getConn('c9')
if request.method == 'GET':
#blank form rendered when page is first visited
return render_template('createPost.html',
title="Create a Post!",post=None, logged_in=logged_in)
else:
#flash warning messages if form is filled out incorrectly
title = request.form.get('post-title','')
content = request.form.get('post-content','')
location = request.form.get('post-location','')
event_time = request.form.get('post-eventtime','')
event_date = request.form.get('post-eventdate','')
tags = request.form.get('post-tags','')
picture = request.files.get('post-picture',None)
print type(picture)
print picture
newpost = {"title":title,"content":content,"location":location,
"event_time":event_time,"event_date":event_date, "tags":tags,'picture':picture}
error = checkRequiredInfo(title,location,event_date,event_time)
# test if any errors occured then take user back to insert page, with
# the info that they already provided prefilled
if error:
return render_template('createPost.html', title="Create a Post!",post=newpost, logged_in=logged_in)
else:
# first insert the post without picture, because we need the pid
tags_stripped = [tag.strip() for tag in tags.split(",")]
pid = info.insertPost(conn, title, content, location, event_time, event_date, tags_stripped, session.get('username'))
# picture is optional
if picture is None:
return redirect(url_for('displayPost', pid=pid))
else:
# if picture is provided, try uploading
try: #Handing the image uploading
fsize = os.fstat(picture.stream.fileno()).st_size
if fsize > app.config['MAX_UPLOAD']:
raise Exception('File is too big')
mime_type = imghdr.what(picture)
if mime_type.lower() not in ['jpeg','gif','png']:
raise Exception('Not a JPEG, GIF or PNG: {}'.format(mime_type))
filename = secure_filename("{}.{}".format(pid,mime_type))
pathname = os.path.join(app.config['UPLOADS'],filename)
picture.save(pathname)
conn = info.getConn('c9')
curs = conn.cursor()
# upload existing record with the provided picture
curs.execute('''UPDATE posts
SET imagefile = %s
WHERE pid = %s''',
[filename, pid])
#test if any errors occured then take user back to insert page
conn.commit()
return redirect(url_for('displayPost', pid=pid))
except Exception as err:
flash('Redirecting to update page: Picture upload failed {why}'.format(why=err))
# redirect to the update page to re-upload the picture
return redirect(url_for('updatePost',pid=pid))
def updatePost(pid):
logged_in = session.get('logged_in', False)
if not logged_in: # the link is only available after the user is logged in
flash("Please log in!")
return redirect(url_for("login"))
conn = info.getConn('c9')
# information from database
post = info.readOnePost(conn,pid)
time_obj = datetime.datetime.strptime(str(post['event_time']),'%H:%M:%S').time()
post['event_time'] = str(time_obj)[:5] # hh:mm in 12-hour format
oldtags = post.get('tags')
if request.method == "GET":
post['tags'] = ",".join(oldtags)
return render_template('updatePost.html', post=post,logged_in=session.get('logged_in',False))
else:
curs = conn.cursor(MySQLdb.cursors.DictCursor)
curs.execute("""select * from twilio_info""")
twilio_info = curs.fetchone()
account_sid = twilio_info['account_sid']
auth_token = twilio_info['auth_token']
client = Client(account_sid, auth_token) # text msg client
starredBy = info.getSubscriberPhoneNums(conn,pid)
# the delete function, flash message and redirect to home page
if request.form.get('submit') == 'delete':
filename = post['imagefile']
if filename is not None:
os.remove(os.path.join(app.config['UPLOADS'], filename))
info.deletePost(conn,pid)
isAdmin = session.get('admin',False)
if isAdmin:
flash("Post ({}) was deleted successfully by ADMIN.".format(pid))
print("Post ({}) was deleted successfully by ADMIN.".format(pid))
else:
flash("Post ({}) was deleted successfully.".format(pid))
print("Post ({}) was deleted successfully.".format(pid))
for user in starredBy:
phoneNum = user['phoneNum']
if phoneNum:
try:
message = client.messages.create(
to="+1"+phoneNum,
from_="+18572675446",
body="The event you starred: {event}, has been deleted.".format(event=post['title']))
except Exception as err:
print("SMS sent failed to {phoneNum}: {why}".format(phoneNum=phoneNum,why=err))
return redirect(url_for('userPortal'))
# the update function, grab info filled in by the user
else:
title = request.form.get('post-title')
content = request.form.get('post-content')
location = request.form.get('post-location')
date = request.form.get('post-eventdate')
time = request.form.get('post-eventtime')
newtags = request.form.get('post-tags','')
picture = request.files.get('post-picture',None)
error = checkRequiredInfo(title,location,date,time)
if error:
return render_template('updatePost.html', title="Update a Post!",post=post, logged_in=logged_in)
if picture is None: # no new pic uploaded by user, use the existing pic (if any) by default
conn = info.getConn('c9')
curs = conn.cursor(MySQLdb.cursors.DictCursor)
curs.execute('''select pid,imagefile from posts where pid = %s''', [pid])
filename = curs.fetchone()['imagefile']
else: # user uploaded a new pic
try: #Handing the image uploading
fsize = os.fstat(picture.stream.fileno()).st_size
if fsize > app.config['MAX_UPLOAD']:
raise Exception('File is too big')
mime_type = imghdr.what(picture)
if mime_type.lower() not in ['jpeg','gif','png']:
raise Exception('Not a JPEG, GIF or PNG: {}'.format(mime_type))
filename = secure_filename("{}.{}".format(pid,mime_type))
print(filename)
pathname = os.path.join(app.config['UPLOADS'],filename)
picture.save(pathname)
except Exception as err:
flash('Upload failed {why}'.format(why=err))
# should make the code cleaner later
if len(oldtags) == 0:
post['tags'] = ''
else:
post['tags'] = ",".join(oldtags)
return render_template('updatePost.html',
title="Update a Post!",post=post, logged_in=logged_in)
tags_stripped = [tag.strip() for tag in newtags.split(",")]
info.updatePost(conn,pid, title, content, location, filename,time,date,session.get('username'),oldtags,tags_stripped)
print("Post ({}) was updated successfully.".format(pid))
for user in starredBy:
phoneNum = user['phoneNum']
if phoneNum:
try:
message = client.messages.create(
to="+1"+phoneNum,
from_="+18572675446",
body="The event you starred: {event}, has been updated.".format(event=post['title']))
except Exception as err:
print("SMS sent failed to {phoneNum}: {why}".format(phoneNum=phoneNum,why=err))
return redirect(url_for('displayPost', pid=pid))
def displayPost(pid):
conn = info.getConn('c9')
postInfo = info.readOnePost(conn,pid)
return render_template('post.html',post=postInfo)
