def index():
"""Index of Psst site"""
db = COMP249Db()
username = session_user(db)
loginString = ""
content = ""
http = ""
str = ""
avatar = ""
list = interface.post_list(db, usernick=None, limit=50)
# if user not logged in
if not username:
# display input field for username and password if the user not logged in
loginString = "<h3>member login</h3><br><form id='loginform' method='POST' action ='/login'><input type='text' name='nick' placeholder='username' class='focus' onKeyPress='return submitenter(this,event)'><input type='password' name='password' placeholder='password' class='focus' onKeyPress='return submitenter(this,event)'></form>"
# if user logged in
if username:
avatar = interface.user_avatar(db,username)
# display the input field for adding posts instead of the title
str = str + "<form action='/post' id='postform' method='POST'><input type='postfield' name='post' placeholder='post content, formats: [i]image urls[/i][t]title[/t][p]contents[/p]#tags #tags2' value='[i]image urls[/i][t]title[/t][p]contents[/p]#tags #tags2' class='focus' onKeyPress='return submitenter(this,event)'></form>"
loginString = "<a href='/users/" + username + "'><img src='" + avatar + "'><h3 style='text-align:center; margin-left:0px;'>" + username + "</h3></a><br><form action= '/logout' id='logoutform' name='logoutform' method='POST' ><input type='submit' value='logout' class='sun-flower-button'></form>"
for item in list:
content = interface.post_to_html(item[3])
http = interface.post_to_html(content)
dt = datetime.datetime.strptime(item[1],"%Y-%m-%d %H:%M:%S")
dt_string = dt.strftime("%b %d, %Y %I:%M%p").upper()
str = str + "<div class='entry'><a href='/users/" + item[2] + "'><div class='item'><img src='" + item[4] + "'> <p>" + item[2].upper() + "</p></div></a><div class='date'><p>" + dt_string + "</p></div>" + http + "<hr></div>" # contents display
return template('base.tpl', base=str, validate='', login=loginString)
def search():
"""Search feature, can search user name and / or contents"""
db = COMP249Db()
username = session_user(db) # retrieve user session information from the database
loginString = ""
content = ""
http = ""
avatar = ""
if 'search' in request.forms:
search = request.forms['search'] # get user inputs from the search field
str = "<h2>Search results for '" + search + "':</h2>" # title
list = interface.post_list(db, usernick=None, limit=50)
if not username: # display the things below only if user not logged in
# display input field for username and password if the user not logged in
loginString = "<h3>member login</h3></br><form id='loginform' method='POST' action ='/login'><input type='text' name='nick' placeholder='username' class='focus' onKeyPress='return submitenter(this,event)'><input type='password' name='password' placeholder='password' class='focus' onKeyPress='return submitenter(this,event)'></form>"
if username: # display the things below only if user logged in
avatar = interface.user_avatar(db,username)
loginString = "<a href='/users/" + username + "'><img src='" + avatar + "'><h3 style='text-align:center; margin-left:0px;'>" + username + "</h3></a><br><form action= '/logout' id='logoutform' name='logoutform' method='POST' ><input type='submit' value='logout' class='sun-flower-button'></form>"
for item in list:
content = interface.post_to_html(item[3])
http = interface.post_to_html(content)
dt = datetime.datetime.strptime(item[1],"%Y-%m-%d %H:%M:%S")
dt_string = dt.strftime("%b %d, %Y %I:%M%p").upper()
if ((bool(search.lower() in item[2].lower())) | (bool(search.lower() in http.lower()))):
str = str + "<div class='entry'><a href='/users/" + item[2] + "'><div class='item'><img src='" + item[4] + "'> <p>" + item[2].upper() + "</p></div></a><div class='date'><p>" + dt_string + "</p></div>" + http + "<hr></div>" # contents display
return template('base.tpl', base=str, validate='', login=loginString)
def test_post_html_mentions(self):
"""Test conversion of @mentions in posts to HTML"""
# mentions
text = "<p>Hello World @Bobolooba</p>"
html = interface.post_to_html(text)
self.assertEqual(
"<p>Hello World <a href='/users/Bobolooba'>@Bobolooba</a></p>",
html)
# word internal period is allowed
text = "<p>Hello World @steve.cassidy</p>"
html = interface.post_to_html(text)
self.assertEqual(
"<p>Hello World <a href='/users/steve.cassidy'>@steve.cassidy</a></p>",
html)
# word final period is not part of the name
text = "Hello World @Cat."
html = interface.post_to_html(text)
self.assertEqual("Hello World <a href='/users/Cat'>@Cat</a>.", html)
# word final period followed by space is not part of the name
text = "Hello World @Cat. Hi!"
html = interface.post_to_html(text)
self.assertEqual("Hello World <a href='/users/Cat'>@Cat</a>. Hi!",
html)
def login():
"""Display this page if any invalid user identification"""
db = COMP249Db()
list = interface.post_list(db, usernick=None, limit=50)
content = ""
http = ""
str = ""
# display previous posts
for item in list:
content = interface.post_to_html(item[3])
http = interface.post_to_html(content)
dt = datetime.datetime.strptime(item[1],"%Y-%m-%d %H:%M:%S")
dt_string = dt.strftime("%b %d, %Y %I:%M%p").upper()
str = str + "<div class='entry'><a href='/users/" + item[2] + "'><div class='item'><img src='" + item[4] + "'> <p>" + item[2].upper() + "</p></div></a><div class='date'><p>" + dt_string + "</p></div>" + http + "<hr></div>" # contents display
# if there are something within the login field...
if 'nick' in request.forms:
username = request.forms['nick'] # get username from the 'nick' field
password = request.forms['password'] # get password from the 'password' field
str2 = "<p style='color:red;font-size:small;'>Invaild username or password</p>"
loginString = "<h3>member login</h3></br><form id='loginform' method='POST' action ='/login'><input type='text' name='nick' placeholder='username' class='focus' onKeyPress='return submitenter(this,event)'><input type='password' name='password' placeholder='password' class='focus' onKeyPress='return submitenter(this,event)'></form>"
if not check_login(db, username, password):
return template('base.tpl', base=str, validate=str2, login=loginString) # display 'Failed' if invaild user identification
generate_session(db, username) # generate the user session
response.set_header('Location', '/')
response.status = 303
return "Redirect to /" # redirect to /
def mentions(username):
"""Generate the webpage that displays @users"""
db = COMP249Db()
uname = session_user(db) # retrieve user session information from the database
loginString = ""
content = ""
http = ""
list = interface.post_list_mentions(db, usernick=username, limit=50)
str = ""
avatar = ""
str = "<h2>Posts mentioned " + username + ":</h2>" # title
if not uname:
# display input field for username and password if the user not logged in
loginString = "<h3>member login</h3></br><form id='loginform' method='POST' action ='/login'><input type='text' name='nick' placeholder='username' class='focus' onKeyPress='return submitenter(this,event)'><input type='password' name='password' placeholder='password' class='focus' onKeyPress='return submitenter(this,event)'></form>"
if uname:
avatar = interface.user_avatar(db,uname)
loginString = "<a href='/users/" + uname + "'><img src='" + avatar + "'><h3 style='text-align:center; margin-left:0px;'>" + uname + "</h3></a><br><form action= '/logout' id='logoutform' name='logoutform' method='POST' ><input type='submit' value='logout' class='sun-flower-button'></form>"
for item in list:
content = interface.post_to_html(item[3])
http = interface.post_to_html(content)
dt = datetime.datetime.strptime(item[1],"%Y-%m-%d %H:%M:%S")
dt_string = dt.strftime("%b %d, %Y %I:%M%p").upper()
str = str + "<div class='entry'><a href='/users/" + item[2] + "'><div class='item'><img src='" + item[4] + "'> <p>" + item[2].upper() + "</p></div></a><div class='date'><p>" + dt_string + "</p></div>" + http + "<hr></div>" # contents display
return template('base.tpl', base=str, validate='', login=loginString)
def index():
"""Index of Psst site"""
db = COMP249Db()
username = session_user(db)
loginString = ""
private = "#private" # string that makes the post private
content = ""
http = ""
list = interface.post_list(db, usernick=None, limit=50)
# if user not logged in
if not username:
str = "<h2><b>Welcome to Psst.</b> Latest pssts:</h2>" # title
# display input field for username and password if the user not logged in
loginString = "<form id='loginform' method='POST' action ='/login'><input type='text' name='nick' placeholder='username' class='focus' onKeyPress='return submitenter(this,event)'><input type='password' name='password' placeholder='password' class='focus' onKeyPress='return submitenter(this,event)'></form>"
str = str + "<table>"
for item in list:
content = interface.post_to_html(item[3])
http = interface.post_to_html(content)
# not display the posts with the '#private' tag
if(bool(private.lower() in http.lower())==False):
str = str + "<tr>"
str = str + "<td valign='top'><img src='" + item[4] + "' width='45'></td>" # user avatar
str = str + "<td valign='bottom'><a href='/users/" + item[2] + "'>@" + item[2] + ": </a>" + http + " - <i>posted on " + item[
1] + "</i></br></br></td></tr>" # username and contents
users(item[2]) # generate /users/username page by users() function
mentions(item[2]) # generate /mentions/username page by mentions function
# if user logged in
if username:
# display the input field for adding posts instead of the title
str = "<form action='/post' id='postform' method='POST'><input type='postfield' name='post' placeholder='post pssts (you can add #private tag to make the psst privately)' class='focus' onKeyPress='return submitenter(this,event)'></form>"
for item in list:
if(username==item[2]): # if user logged in, display his/her avatar, name, previous posts, the post mention, and logout option
loginString = "<form action= '/logout' id='logoutform' name='logoutform' method='POST' ><table><tr><td><img src='" + item[4] + "' width='85'></td><td><h3>Logged in as " + username + "</h3><p><a href='/users/" + username + "'>Posted pssts</a></p><p><a href='/mentions/" + username + "'>@me pssts</a></p><p><a href='javascript: document.logoutform.submit();'>Logout</a></p></td></tr></table></form>"
str = str + "<table>"
at_user = "******" + username
for item in list:
content = interface.post_to_html(item[3])
http = interface.post_to_html(content)
# this if situation is for private message feature
if((bool(private.lower() in http.lower()) == False) | (bool(at_user.lower() in http.lower())) | (bool(private.lower() in http.lower()) & bool(username.lower() in item[2].lower()))):
str = str + "<tr>"
str = str + "<td valign='top'><img src='" + item[4] + "' width='45'></td>" # user avatar
str = str + "<td valign='bottom'><a href='/users/" + item[2] + "'>@" + item[2] + ": </a>" + http + " - <i>posted on " + item[
1] + "</i></br></br></td></tr>" # username and contents
users(item[2]) # generate /users/username page by users() function
mentions(item[2]) # generate /mentions/username page by mentions function
str = str + "</table>"
return template('base.tpl', base=str, validate='', login=loginString)
def test_post_html_hashtag(self):
"""Test conversion of #hashtags in posts to HTML"""
text = "Hello World #whatever"
html = interface.post_to_html(text)
self.assertEqual(
"Hello World <strong class='hashtag'>#whatever</strong>", html)
text = "#whatever you #want"
html = interface.post_to_html(text)
self.assertEqual(
"<strong class='hashtag'>#whatever</strong> you <strong class='hashtag'>#want</strong>",
html)
def search():
"""Search feature, can search user name and / or contents"""
db = COMP249Db()
username = session_user(db) # retrieve user session information from the database
private = "#private" # string that makes the post private
loginString = ""
content = ""
http = ""
if 'search' in request.forms:
search = request.forms['search'] # get user inputs from the search field
str = "<h2>Search results for '" + search + "':</h2>" # title
list = interface.post_list(db, usernick=None, limit=50)
if not username: # display the things below only if user not logged in
# display input field for username and password if the user not logged in
loginString = "<form id='loginform' method='POST' action ='/login'><input type='text' name='nick' placeholder='username' class='focus' onKeyPress='return submitenter(this,event)'><input type='password' name='password' placeholder='password' class='focus' onKeyPress='return submitenter(this,event)'></form>"
str = str + "<table>"
for item in list:
content = interface.post_to_html(item[3])
http = interface.post_to_html(content)
# this if situation is for private message feature
if ((bool(private.lower() in http.lower())==False) & ((bool(search.lower() in item[2].lower())) | (bool(search.lower() in http.lower())))):
str = str + "<tr>"
str = str + "<td valign='top'><img src='" + item[4] + "' width='45'></td>" # user avatar
str = str + "<td valign='bottom'><a href='/users/" + item[2] + "'>@" + item[2] + ": </a>" + http + " - <i>posted on " + \
item[1] + "</i></br></br></td></tr>" # username and contents
users(item[2]) # generate /users/username page by users() function
mentions(item[2]) # generate /mentions/username page by mentions() function
str = str + "</table>"
if username: # display the things below only if user logged in
at_user = "******" + username
for item in list:
if(username==item[2]): # if user logged in, display his/her avatar, name, previous posts, the post mention, and logout option
loginString = "<form action= '/logout' id='logoutform' name='logoutform' method='POST' ><table><tr><td><img src='" + item[4] + "' width='85'></td><td><h3>Logged in as " + username + "</h3><p><a href='/users/" + username + "'>Posted pssts</a></p><p><a href='/mentions/" + username + "'>@me pssts</a></p><p><a href='javascript: document.logoutform.submit();'>Logout</a></p></td></tr></table></form>"
str = str + "<table>"
for item in list:
content = interface.post_to_html(item[3])
http = interface.post_to_html(content)
# this if situation is for private message feature
if (((bool(private.lower() in http.lower()) == False) | (bool(at_user.lower() in http.lower())) | (bool(private.lower() in http.lower()) & bool(username.lower() in item[2].lower()))) & ((bool(search.lower() in item[2].lower())) | (bool(search.lower() in http.lower())))):
str = str + "<tr>"
str = str + "<td valign='top'><img src='" + item[4] + "' width='45'></td>" # user avatar
str = str + "<td valign='bottom'><a href='/users/" + item[2] + "'>@" + item[2] + ": </a>" + http + " - <i>posted on " + \
item[1] + "</i></br></br></td></tr>" # username and contents
users(item[2]) # generate /users/username page by users() function
mentions(item[2]) # generate /mentions/username page by mentions() function
str = str + "</table>"
return template('base.tpl', base=str, validate='', login=loginString)
def test_post_html_links(self):
"""More tests on conversion of posts: links"""
# links
text = "<p>Hello World http://example.org/ is it</p>"
html = interface.post_to_html(text)
self.assertEqual(
"<p>Hello World <a href='http://example.org/'>http://example.org/</a> is it</p>",
html)
# links with stuff
text = "<p>Hello World http://example.org/home_page.html is it</p>"
html = interface.post_to_html(text)
self.assertEqual(
"<p>Hello World <a href='http://example.org/home_page.html'>http://example.org/home_page.html</a> is it</p>",
html)
def users(username):
"""Generate the webpage that displays the user posts"""
db = COMP249Db()
uname = session_user(db) # retrieve user session information from the database
loginString = ""
private = "#private" # string that makes the post private
list = interface.post_list(db, usernick=username, limit=50)
list2 = interface.post_list(db, usernick=None, limit=50)
str = ""
for item in list:
str = "<h2><b>" + item[2] + "</b> posted pssts:</h2>" # title
if not uname:
# display input field for username and password if the user not logged in
loginString = "<form id='loginform' method='POST' action ='/login'><input type='text' name='nick' placeholder='username' class='focus' onKeyPress='return submitenter(this,event)'><input type='password' name='password' placeholder='password' class='focus' onKeyPress='return submitenter(this,event)'></form>"
str = str + "<table>"
content = ""
http = ""
for item in list2:
if (username == item[2]):
content = interface.post_to_html(item[3])
http = interface.post_to_html(content)
# not display the posts with the #private tag
if(bool(private.lower() in http.lower())==False):
str = str + "<tr>"
str = str + "<td valign='top'><img src='" + item[4] + "' width='45'></td>" # user avatar
str = str + "<td valign='bottom'><a href='/users/" + item[2] + "'>@" + item[2] + ": </a>" + http + " - <i>posted on " + \
item[1] + "</i></br></br></td></tr>" # username and contents
str = str + "</table>"
if uname:
for item in list2:
if(uname==item[2]): # if user logged in, display his/her avatar, name, previous posts, the post mention, and logout option
loginString = "<form action= '/logout' id='logoutform' name='logoutform' method='POST' ><table><tr><td><img src='" + item[4] + "' width='85'></td><td><h3>Logged in as " + uname + "</h3><p><a href='/users/" + uname + "'>Posted pssts</a></p><p><a href='/mentions/" + uname + "'>@me pssts</a></p><p><a href='javascript: document.logoutform.submit();'>Logout</a></p></td></tr></table></form>"
str = str + "<table>"
content = ""
http = ""
for item in list2:
if (username == item[2]): # display the post only if the username and the author is the same person
content = interface.post_to_html(item[3])
http = interface.post_to_html(content)
str = str + "<tr>"
str = str + "<td valign='top'><img src='" + item[4] + "' width='45'></td>" # user avatar
str = str + "<td valign='bottom'><a href='/users/" + item[2] + "'>@" + item[2] + ": </a>" + http + " - <i>posted on " + \
item[1] + "</i></br></br></td></tr>" # username and contents
str = str + "</table>"
return template('base.tpl', base=str, validate='', login=loginString)
def get_recent_posts(posts):
""" Append user information to each post
:param posts: The most current posts
:return: List of posts with user data
"""
new_posts = []
for post in posts:
pic = interface.user_get(db, post[2])[2]
new_posts.append(
(post[1], post[2], interface.post_to_html(post[3]), pic))
return new_posts
def format_post(post):
# id, timestamp, usernick, users.avatar, content
html = "<article>\n"
html += "<a href='/users/" + post[2] + "'><b>" + post[2] + "</b></a>" + "<br>\n" # Username
content = interface.post_to_html(post[4])
html += content + "<br>\n" # content
html += "<i>" + post[1] + "</i>" + "<br>\n" # timestamp
html += "</article>\n"
return html
def format_post(post):
# id, timestamp, usernick, users.avatar, content
html = "<article>\n"
html += "<a href='/users/" + post[2] + "'><b>" + post[
2] + "</b></a>" + "<br>\n" # Username
content = interface.post_to_html(post[4])
html += content + "<br>\n" # content
html += "<i>" + post[1] + "</i>" + "<br>\n" # timestamp
html += "</article>\n"
return html
def test_post_html(self):
"""Test conversion of posts to HTML: tags and &"""
# plain text doesn't change
text = "Hello World!"
self.assertEqual(text, interface.post_to_html(text))
# quoting HTML
text = "<p>Hello World</p>"
html = interface.post_to_html(text)
self.assertEqual("<p>Hello World</p>", html)
# quoting HTML with attributes
text = "<p class='foo'>Hello World</p>"
html = interface.post_to_html(text)
self.assertEqual("<p class='foo'>Hello World</p>", html)
# quoting HTML entities
text = "Fish & Chips"
html = interface.post_to_html(text)
self.assertEqual("Fish & Chips", html)
def test_post_html(self):
"""Test conversion of posts to HTML"""
# plain text doesn't change
text = "Hello World!"
self.assertEqual(text, interface.post_to_html(text))
# quoting HTML
text = "<p>Hello World</p>"
html = interface.post_to_html(text)
self.assertEqual("<p>Hello World</p>", html)
# quoting HTML with attributes
text = "<p class='foo'>Hello World</p>"
html = interface.post_to_html(text)
self.assertEqual("<p class='foo'>Hello World</p>", html)
# quoting HTML entities
text = "Fish & Chips"
html = interface.post_to_html(text)
self.assertEqual("Fish & Chips", html)
# links
text = "<p>Hello World http://example.org/ is it</p>"
html = interface.post_to_html(text)
self.assertEqual(
"<p>Hello World <a href='http://example.org/'>http://example.org/</a> is it</p>",
html)
# links with stuff
text = "<p>Hello World http://example.org/home_page.html is it</p>"
html = interface.post_to_html(text)
self.assertEqual(
"<p>Hello World <a href='http://example.org/home_page.html'>http://example.org/home_page.html</a> is it</p>",
html)
def test_post_html(self):
"""Test conversion of posts to HTML"""
# plain text doesn't change
text = "Hello World!"
self.assertEqual(text, interface.post_to_html(text))
# quoting HTML
text = "<p>Hello World</p>"
html = interface.post_to_html(text)
self.assertEqual("<p>Hello World</p>", html)
# quoting HTML with attributes
text = "<p class='foo'>Hello World</p>"
html = interface.post_to_html(text)
self.assertEqual("<p class='foo'>Hello World</p>", html)
# quoting HTML entities
text = "Fish & Chips"
html = interface.post_to_html(text)
self.assertEqual("Fish & Chips", html)
# links
text = "<p>Hello World http://example.org/ is it</p>"
html = interface.post_to_html(text)
self.assertEqual("<p>Hello World <a href='http://example.org/'>http://example.org/</a> is it</p>", html)
# links with stuff
text = "<p>Hello World http://example.org/home_page.html is it</p>"
html = interface.post_to_html(text)
self.assertEqual("<p>Hello World <a href='http://example.org/home_page.html'>http://example.org/home_page.html</a> is it</p>", html)
def test_post_html_mentions(self):
"""Test conversion of @mentions in posts to HTML"""
# mentions
text = "<p>Hello World @Bobolooba</p>"
html = interface.post_to_html(text)
self.assertEqual("<p>Hello World <a href='/users/Bobolooba'>@Bobolooba</a></p>", html)
# word internal period is allowed
text = "<p>Hello World @steve.cassidy</p>"
html = interface.post_to_html(text)
self.assertEqual("<p>Hello World <a href='/users/steve.cassidy'>@steve.cassidy</a></p>", html)
# word final period is not part of the name
text = "Hello World @Cat."
html = interface.post_to_html(text)
self.assertEqual("Hello World <a href='/users/Cat'>@Cat</a>.", html)
# word final period followed by space is not part of the name
text = "Hello World @Cat. Hi!"
html = interface.post_to_html(text)
self.assertEqual("Hello World <a href='/users/Cat'>@Cat</a>. Hi!", html)
def login():
"""Display this page if any invalid user identification"""
db = COMP249Db()
list = interface.post_list(db, usernick=None, limit=50)
private = "#private" # string that makes the post private
content = ""
http = ""
str = "<h2><b>Welcome to Psst.</b> Latest pssts:</h2>" # title
str = str + "<table>"
# display previous posts
for item in list:
content = interface.post_to_html(item[3])
http = interface.post_to_html(content)
# not display the posts with the '#private' tag
if(bool(private.lower() in http.lower())==False): # only display the messages without '#private'
str = str + "<tr>"
str = str + "<td valign='top'><img src='" + item[4] + "' width='45'></td>" # user avatar
str = str + "<td valign='bottom'><a href='/users/" + item[2] + "'>@" + item[2] + ": </a>" + http + " - <i>posted on " + item[
1] + "</i></br></br></td></tr>" # username and contents
users(item[2]) # generate /users/username page by users() function
mentions(item[2]) # generate /mentions/username page by mentions function
str = str + "</table>"
# if there are something within the login field...
if 'nick' in request.forms:
username = request.forms['nick'] # get username from the 'nick' field
password = request.forms['password'] # get password from the 'password' field
str2 = "<p style='color:red'>Failed.</p>"
loginString = "<form id='loginform' method='POST' action ='/login'><input type='text' name='nick' placeholder='username' class='focus' onKeyPress='return submitenter(this,event)'><input type='password' name='password' placeholder='password' class='focus' onKeyPress='return submitenter(this,event)'></form>"
if not check_login(db, username, password):
return template('base.tpl', base=str, validate=str2, login=loginString) # display 'Failed' if invaild user identification
generate_session(db, username) # generate the user session
response.set_header('Location', '/')
response.status = 303
return "Redirect to /" # redirect to /
def posts(user):
db = COMP249Db()
cont = interface.post_list_mentions(
db, user, 50
) # grab the posts from the database which mention the user specified
posts = []
for row in cont:
li = list(row) #converting each tuple into a list
print(li[4])
li[4] = interface.post_to_html(
li[4]) #converting the post message into suitable html
posts.append(
li) #populating a list with data ready to display in the template
print(li)
print('posts below')
print(posts)
return template(os.path.join('views', 'general'),
title="Welcome to Psst!",
content=posts)
