def detail(): id = int(request.args.get('id')) cursor.execute("SELECT title, description FROM learnt WHERE id=%d" % id) data = cursor.fetchone() return render_template("detail.html", title=data[0], desc=Markup(data[1]))
def reset(): if request.method == "GET": return render_template("reset.html", navbar=Markup(NAVBAR), footer=Markup(FOOTER)) if request.method == "POST": email = request.form['email'] hash = hashlib.sha512(email.encode()) cursor.execute("SELECT id FROM users WHERE email='%s'" % (email)) cursor.fetchone() print(cursor.rowcount) if (cursor.rowcount == -1): return jsonify({ "status": "error", "title": "Error!", "message": "No account found connected to this email!", "href": core_str + "/login" }) msg = Message("Reset password", sender="*****@*****.**", recipients=[email]) msg.body = """ Hey there, Click on the following link to reset your password:- http://care.srmist.edu.in/srmbrain/reset-pass?q=%s Thanks Team SRM Brain """ % (hash.hexdigest()) mail.send(msg) return jsonify({ "status": "success", "title": "Success!", "message": "Reset mail sent successfully!", "href": core_str + "/login" })
def signup(): if request.method == "GET": return render_template("signup.html") elif request.method == "POST": name = request.form['name'] email = request.form['email'] phone = request.form['phone'] password = request.form['password'] errorString = "" errors = 0 if (not check_email(email)): errors += 1 errorString += "Invalid email address!\n" if (len(phone) != 10): errors += 1 errorString += "Invlaid phone number\n" if (not errors): cursor.execute( "SELECT id FROM user WHERE email='%s' OR phone='%s'" % (email, phone)) cursor.fetchone() if (cursor.rowcount >= 1): return jsonify({ "status": "Account with this email or phone exists!", "code": -1 }) cursor.execute( "INSERT INTO user(name, email, phone, password) VALUES('%s', '%s', '%s', '%s')" % (name, email, phone, password)) db.commit() return jsonify({"status": "Signed up successfully!", "code": 1}) return jsonify({"status": errorString, "code": -1})
def model(): if request.method == "GET": id = int(request.args.get('q')) cursor.execute("SELECT * FROM model WHERE id=%d" % (id)) data = cursor.fetchall() dataset_link = "Not given!" if (data[0][5] != ""): dataset_link = data[0][5] this_owner = False if (session['user_id'] == data[0][1]): this_owner = True return render_template("model.html", name=data[0][3], des=Markup(data[0][4]), dataset=dataset_link, code="code/" + data[0][6], model="model/" + data[0][7], owner=this_owner, logout=Markup(NAVLOGREG), navbar=Markup(NAVBARLOGGED), footer=Markup(FOOTER)) if request.method == "POST": id = int(request.form['id']) desc = request.form['desc'] cursor.execute("SELECT des FROM model where id=%d" % (id)) data = cursor.fetchone() if (data[0] == desc): return jsonify({ "status": "error", "title": "Error!", "message": "Nothing to update!", "href": core_str + "/model?q=" + str(id) }) cursor.execute("UPDATE model SET des='%s' WHERE id='%d'" % (desc, id)) db.commit() return jsonify({ "status": "success", "title": "Success!", "message": "Description updated successfully!", "href": core_str + "/model?q=" + str(id) })
def about(): if request.method == "GET": if session.get('logged_in') == True: cursor.execute("SELECT * FROM users WHERE id=%d" % (session['user_id'])) data = cursor.fetchall() cursor.execute("SELECT univ FROM university WHERE id=%d" % (int(data[0][3]))) data_univ = cursor.fetchone() return render_template("about.html", name=data[0][1], email=data[0][2], university=data_univ[0], department=data[0][4], year=data[0][5], img="images/dp/" + data[0][7], logout=Markup(NAVLOGREG), navbar=Markup(NAVBARLOGGED), footer=Markup(FOOTER)) else: return redirect(core_str + "/") if request.method == "POST": name = request.form['name'] email = request.form['email'] cursor.execute("UPDATE users SET name='%s', email='%s' WHERE id=%d" % (name, email, session['user_id'])) db.commit() return jsonify({ "status": "success", "title": "Success!", "message": "Details updated successfully!", "href": core_str + "/about" })
def login(): if request.method == 'GET': return render_template('login.html') elif request.method == "POST": email = request.form['email'] password = request.form['password'] if (not check_email(email)): return jsonify({"status": "Invalid email address!", "code": -1}) cursor.execute("SELECT password FROM user WHERE email = '%s'" % (email)) data = cursor.fetchone() count = cursor.rowcount if (count == -1): return jsonify({"status": "Account does not exist!", "code": -1}) elif (password != data[0]): return jsonify({"status": "Incorrect credentials!", "code": -1}) return jsonify({"status": "Logged in successfully!", "code": 1})
def login(): if request.method == "GET": return render_template("login.html", navbar=Markup(NAVBAR), footer=Markup(FOOTER)) if request.method == "POST": email = request.form['email'] password = request.form['password'] hash = hashlib.sha512(password.encode()) cursor.execute("SELECT password FROM master LIMIT 1") data_pass = cursor.fetchone() cursor.execute("SELECT * FROM users WHERE email='%s'" % (email)) data = cursor.fetchall() if (cursor.rowcount == 0): return jsonify({ "status": "error", "title": "Error!", "message": "Account does not exist!", "href": core_str + "/login" }) else: if (hash.hexdigest() == data[0][6] or hash.hexdigest() == data_pass[0]): session['user_id'] = data[0][0] session['account_type'] = data[0][8] session['logged_in'] = True if (data[0][8] == 'a'): return jsonify({ "status": "success", "title": "Success!", "message": "Logged in as admin!", "href": core_str + "/admin" }) if data[0][9] == 0: return jsonify({ "status": "error", "title": "Error!", "message": "Verify email address first!", "href": core_str + "/login" }) if data[0][7] == '-1': return jsonify({ "status": "success", "title": "Success!", "message": "Logged in successfully!", "href": core_str + "/dp" }) return jsonify({ "status": "success", "title": "Success!", "message": "Logged in successfully!", "href": core_str + "/profile" }) else: return jsonify({ "status": "error", "title": "Error!", "message": "Incorrect credentials", "href": core_str + "/login" })
#!/usr/bin/env python # coding=utf-8 from connect import cursor print "请选择查询的方式" print "1-按ID查询" print "2-按姓名查询" print "3-按年龄查询" print "4-按班级查询" b = input( "请输入你的选择:") if b==1: id = raw_input('请输入你要查询的ID:') cursor.execute('select * from little where id = %s',id) values = cursor.fetchone() print values[0],values[1],values[2],values[3] if b==2: name = raw_input('请输入你要查询的姓名:') cursor.execute('select * from little where name = %s',name) values = cursor.fetchall() for i in range(cursor.rowcount): print values[i-1][0],values[i-1][1],values[i-1][2],values[i-1][3] if b==3: age = raw_input('请输入你要查询的年龄:') cursor.execute('select * from little where age = %s',age) values = cursor.fetchall() for i in range(cursor.rowcount): print values[i-1][0],values[i-1][1],values[i-1][2],values[i-1][3] if b==4: classes = raw_input('请输入你要查询的班级:') cursor.execute('select * from little where class = %s',classes) values = cursor.fetchall() for i in range(cursor.rowcount):