-
Notifications
You must be signed in to change notification settings - Fork 0
/
app.py
93 lines (73 loc) · 2.68 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
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
83
84
85
86
87
88
89
90
91
92
93
import datetime
from flask import Flask, render_template, request, redirect, url_for, flash
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.secret_key = "keysmithsmakekeys"
# configure database path
app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite:///data/sign_ins.db"
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
DB = SQLAlchemy(app)
# variables for app
TODAY = datetime.datetime.now().strftime("%Y-%m-%d") # change for a diff name
today_id = None
users = None
# database setup
class User(DB.Model):
"Table to hold each member's data."
id = DB.Column(DB.Integer, primary_key=True)
fname = DB.Column(DB.String, nullable=False)
lname = DB.Column(DB.String, nullable=False)
empl = DB.Column(DB.Integer, nullable=False)
email = DB.Column(DB.String, nullable=False)
class Meetings(DB.Model):
"ID should reference a member. Table per meeting date."
id = DB.Column(DB.Integer, primary_key=True)
date = DB.Column(DB.String, nullable=False)
class Signins(DB.Model):
"ID should reference a member. Table per meeting date."
id = DB.Column(DB.Integer, primary_key=True)
user_id = DB.Column(DB.Integer, nullable=False)
meeting_id = DB.Column(DB.Integer, nullable=False)
# add an user to DB
def add_to_db(data):
"Add log in"
c_u = User(fname=data['fname'], lname=data['lname'], empl=int(data['empl']), email=data['email'])
if not (len(data['empl']) == 8 and data['empl'].isdigit()):
flash('Bad empl id.')
else:
if not User.query.filter_by(empl=c_u.empl).first():
DB.session.add(c_u)
DB.session.commit()
c_id = User.query.filter_by(empl=c_u.empl).first().id
DB.session.add(Signins(user_id=c_id, meeting_id=today_id))
DB.session.commit()
DB.session.commit()
def splat_user(u):
"Serialize user object for js arrays."
return {
'fname': u.fname,
'lname': u.lname,
'empl': u.empl,
'email': u.email
}
# routes begin here
@app.route('/')
def root():
"Endpoint to render signin page+sets up meetings DB/ fetches information."
if not Meetings.query.filter_by(date=TODAY).first():
DB.session.add(Meetings(date=TODAY))
DB.session.commit()
global today_id
today_id = Meetings.query.filter_by(date=TODAY).first().id
global users
users = User.query.order_by(User.id).all()
return render_template('index.html', u=list(map(splat_user, users)))
@app.route('/signin', methods=['POST'])
def signin():
"Endpoint to add user data to database."
add_to_db(request.form.to_dict())
return redirect(url_for('root'))
if __name__ == "__main__":
DB.create_all()
app.debug = True
app.run()