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)