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})