def profile(response, view): if cur.execute("select count(*) from users where username = ?", (view,)).fetchone()[0]: cur.execute("select dp from users where username = ?", (view,)) dp = cur.fetchone()[0] if dp == None: dp = "/static/placeholderdp.png" cur.execute("select bio from users where username = ?", (view,)) bio = cur.fetchone()[0] follower = is_follower(response, view) data = {'message':getmessage(response), 'isloggedin':isloggedin(response), "view":view, "username":currentuser(response).username, "dp":dp, "bio":bio, "is_follower":follower} response.write(template.render_file("templates/user/profiles.html", data)) else: response.redirect("/?message=No+such+user!")
def index(response): arguments = ranker.rankerTime() #rankByAll doubles up all the posts def percentages(argument_id): cur.execute("SELECT COUNT(*) FROM comments WHERE post_id = ?", (str(argument_id),)) no_of_comments=cur.fetchone()[0] cur.execute("SELECT COUNT(*) from comments where post_id = ? and agree = 'False'", (str(argument_id),)) no_of_true = cur.fetchone()[0] no_of_false = no_of_comments - no_of_true try: percentage_false = float(no_of_false)/no_of_comments*100 percentage_true = 100-percentage_false except: percentage_false, percentage_true = 0,0 return percentage_true, percentage_false arguments = [argument + percentages(argument[0]) for argument in arguments] data = {'arguments': arguments, 'message':getmessage(response), 'isloggedin':isloggedin(response), "username": currentuser(response).username, 'fix_date': (lambda old: (datetime.datetime.strptime(old, '%Y-%m-%d %H:%M:%S') + datetime.timedelta(11.0/24.0)).strftime('%Y-%m-%d %H:%M:%S'))} response.write(template.render_file('templates/feed/index.html', data))
def view_argument(response, argument_id): cur.execute('select * from posts where id=?', (argument_id,)) argument = cur.fetchone() cur.execute('select c.post_id, c.description, c.agree, u.username from comments c, users u where post_id=? and c.user_id = u.id', (argument_id,)) comments = cur.fetchall() cur.execute("SELECT COUNT(*) FROM comments WHERE post_id = ?", (argument_id,)) no_of_comments=cur.fetchone()[0] cur.execute("SELECT COUNT(*) from comments where post_id = ? and agree = 'False'", (argument_id,)) no_of_true = cur.fetchone()[0] no_of_false = no_of_comments - no_of_true #percentage_true = round(float(no_of_true)/float(no_of_comments)*100) #percentage_false = 100-percentage_true try: percentage_false = float(no_of_false)/no_of_comments*100 percentage_true = 100-percentage_false except: percentage_false, percentage_true = 0,0 response.write(template.render_file('templates/viewarg.html', { 'argument': argument, 'comments': comments, 'message': getmessage(response), 'isloggedin': isloggedin(response), 'username':currentuser(response).username, 'score':(percentage_true,percentage_false)}))
def login(response): if requirenouser(response): data = {'message':getmessage(response), 'isloggedin':isloggedin(response), "username": currentuser(response).username} response.write(template.render_file('templates/user/login.html', data))
def editprofile(response): data = {'message':getmessage(response), 'isloggedin':isloggedin(response), "username":currentuser(response).username, "bio":currentuser(response).bio[0]} response.write(template.render_file("templates/user/editprofile.html", data))
def search_handler(response): query = response.get_field('query') data = {'isloggedin': isloggedin(response), 'results': search(query), 'query':query, 'username': currentuser(response).username} response.write(template.render_file("templates/search_result.html", data))
def custom404(response, page_name): response.set_status(404) response.write(template.render_file("static/404.html", {'isloggedin': isloggedin(response), "username": currentuser(response).username}))
def create_page(response): requireuser(response) data = {'message':getmessage(response), 'isloggedin':isloggedin(response), "username": currentuser(response).username } response.write(template.render_file('templates/addargument.html', data))
def argument_page(response): id = response.get_field("id") response.write(template.render_file("viewarg.html" ,"rU")) cur.execute("""insert into comments ("post_id","user_id", "description", agree) values( '%s',null,"comment",1)""" % id)
def login(response): name = response.get_field('name') data = {'name': name} output = template.render_file('sample/login.html', data) response.write(output)
def index(response): data = {'name': 'Ben', 'arguments': ['Is banana bread cake or bread?', 'another argument']} output = template.render_file('sample/test.html', data) response.write(output)