forked from abstructs/psykick
-
Notifications
You must be signed in to change notification settings - Fork 0
/
application.py
84 lines (64 loc) · 2.12 KB
/
application.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
from flask import Flask, request, render_template, g, jsonify, redirect, url_for
import sqlite3
DATABASE = 'psykick.db'
app = Flask(__name__)
def get_db():
db = getattr(g, '_database', None)
if db is None:
db = g._database = sqlite3.connect(DATABASE)
return db
def query_db(query, args=(), one=False):
cur = get_db().execute(query, args)
rv = cur.fetchall()
cur.close()
return (rv[0] if rv else None) if one else rv
@app.route("/", methods=['GET', 'POST'])
def index():
if request.method == 'POST':
db = get_db()
r = query_db("select * from student")
return jsonify(students = r)
return render_template('index.html')
@app.route("/about", methods=['GET'])
def about():
return render_template('about.html')
@app.route("/signup", methods=['GET', 'POST'])
def signup():
if request.method == 'POST':
# db = get_db()
# r = query_db("select * from student")
# return jsonify(students = r)
student_id = request.form.get('student_id')
password = request.form.get('password')
students = query_db("SELECT student_id FROM student WHERE student_id=?", [student_id])
if len(students) != 0:
return "Bad request"
else:
return redirect(url_for("index"))
return render_template('signup.html')
@app.route('/contact', methods=['GET'])
def contact():
return render_template('contact.html')
# @appl.route("login", methods=['GET', "POST"])
# def login():
# if request.method == 'POST':
# # LOGIN
# print("POST")
# else:
# return render_template('login.html')
@app.route('/loginprof')
def loginprof():
return render_template('loginprof.html')
@app.route('/data')
def data():
return render_template('data.html')
@app.route('/calender')
def calender():
return render_template('calender.html')
@app.route('/loginstudent', methods=['GET', 'POST'])
def loginstudent():
if request.method == 'POST':
return redirect(url_for('data'))
return render_template('loginstudent.html')
if __name__ == "__main__":
app.run(debug=True, port=8080)