def getBookContent():
global sessions
sid = request.cookies.get("sessionId")
bid = sessions[sid]['info'][0]
book = db.execute("SELECT * FROM user WHERE id = %s" % str(bid) ) [0][13]
book = json.loads(book)
return jsonify(book)
def bprewview_html():
global sessions
sid = request.cookies.get("sessionId")
bid = sessions[sid]['info'][0]
book = db.execute("SELECT * FROM user WHERE id = %s" % str(bid) ) [0][13]
book = json.loads(book)
return render_template("BPreview.html",context=book)
def index_html():
sid = request.cookies.get("sessionId")
bid = sessions[sid]['info'][0]
book = db.execute("SELECT * FROM user WHERE id = %s" % str(bid) ) [0][13]
if book is None:
book = r"{}"
book = json.loads(book)
return render_template("index.html",context=book)
def register():
dic = request.args
db.insert_into_table("user",dic)
user = request.args['email']
passwd = request.args['pwd']
sql_stmt = "SELECT * FROM `user` WHERE email = \"%s\" AND pwd = \"%s\" " %(user,passwd)
result = db.execute(sql_stmt )
print result
new_ssid = str(sha.sha(str(time.time())).hexdigest())
sessions[new_ssid] = {"info":result[0]}
ret = redirect("/index.html")
ret.set_cookie("sessionId",new_ssid)
return ret
def login():
global sessions
user = request.args.get("user")
passwd = request.args.get("passwd")
session = request.cookies.get("sessionId")
if session in sessions.keys():
#JUMP TO ...
#return render_template("index.html")
return redirect("./index.html")
sql_stmt = "SELECT * FROM `user` WHERE email = \"%s\" AND pwd = \"%s\" " %(user,passwd)
result = db.execute(sql_stmt )
if (len(result)!=0):
new_ssid = str(sha.sha(str(time.time())).hexdigest())
print new_ssid
ret = jsonify({'status':True})
ret.set_cookie("sessionId",new_ssid)
sessions[new_ssid] = {"info":result[0]}
return ret
else:
return jsonify({'status':False})
