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