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)
