def askfunc():
options=\
{
"login": False,
"username": "",
"status": 0
}
error = None
if session.has_key('username'):
options["login"]=True
options["username"]=session["username"]
else:
return render_template('errorpage.html', error = error)
if request.method=='POST':
op=request.form['op']
print ("enter the post")
if op == "submit":
newpic = request.files['photo']
picAdded = True;
cur=mysql.connection.cursor()
cur.execute("select userid from user where username = "******"'" + session["username"] + "'")
useridresult = [];
useridresult=cur.fetchall()
userid = useridresult[0][0]
userid = str(userid)
currentuserid = userid;
currentuserid = str(currentuserid)
pic_location = "static/pictures/" + currentuserid + "/" +newpic.filename
newpic.save(pic_location)
title = request.form['title']
ori = request.form['ori']
ori = str(ori)
print ori
if ori == "I dont know": #TODO: update with proper default value
print ("classifier entered")
cc = Classifier(pic_location)
ori = cc.classify_text()
ori = ori.title()
tar = request.form['tar']
#if tar == 'NA'
des = request.form['des']
cur=mysql.connection.cursor()
cur.execute("insert into post (title, description, origin, target, pathtophoto, userid) values ('" + title + "', '" + des + "', '" + ori + "', '" + tar + "', '" + newpic.filename +"', "+ currentuserid +");")
print ("insert into post (title, description, origin, target, pathtophoto, userid) values ('" + title + "', '" + des + "', '" + ori + "', '" + tar + "', '" + newpic.filename +"', "+ currentuserid +");")
cur.execute("commit")
return render_template('redirect.html', error=error)
return render_template('ask.html', error=error, **options)