-
Notifications
You must be signed in to change notification settings - Fork 0
/
app.py
56 lines (41 loc) · 1.58 KB
/
app.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
from flask import Flask, render_template, request, redirect, url_for
from flask_sqlalchemy import SQLAlchemy
from flask import flash
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///students.sqlite3'
app.config['SECRET_KEY'] = "secretkeey"
db = SQLAlchemy(app)
class students(db.Model):
id = db.Column('student_id', db.Integer, primary_key = True)
name = db.Column(db.String(100))
grade = db.Column(db.String(3))
def __init__(self, name, grade):
self.name = name
self.grade = grade
@app.route('/', methods=['GET', 'POST'])
def addstudent():
if request.method == 'POST':
if not request.form['name'] or not request.form['grade']:
flash('Check both fields and try again', 'error')
else:
student = students(name=request.form['name'], grade=request.form['grade'])
db.session.add(student)
db.session.commit()
return redirect(url_for('results', students=students.query.all()))
return render_template('home.html')
@app.route('/results', methods=['GET', 'POST'])
def results():
return render_template("results.html", students=students.query.all())
@app.route('/passed', methods=['GET', 'POST'])
def passed():
return render_template("results.html", students=students.query.filter(students.grade>=85))
@app.route('/deleted', methods=['GET', 'POST'])
def deleteStudent():
studentID = students(id=request.form['id'])
deletedstudent = students.query.get(studentID)
db.session.delete(deletedstudent)
db.session.commit()
return render_template("results.html", students=students.query.all())
if __name__ == '__main__':
db.create_all()
app.run(debug = True)