-
Notifications
You must be signed in to change notification settings - Fork 1
/
app.py
85 lines (57 loc) · 2.29 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
import sqlite3
from datetime import datetime
from flask import Flask, render_template, g, request
app = Flask(__name__)
def connect_db():
sql = sqlite3.connect('food_log.db')
sql.row_factory = sqlite3.Row
return sql
def get_db():
if not hasattr(g, 'sqlite3_db'):
g.sqlite_db = connect_db()
return g.sqlite_db
@app.teardown_appcontext
def close_db(error):
if hasattr(g, 'sqliter_db'):
g.sqliter_db.close()
@app.route('/', methods=['POST', 'GET'])
def index():
db = get_db()
if request.method == 'POST':
date = request.form['date']
dt = datetime.strptime(date, '%Y-%m-%d')
database_date = datetime.strftime(dt, '%Y%m%d')
db.execute('insert into log_date (entry_date) values (?)', [database_date])
db.commit()
cur = db.execute('select entry_date from log_date order by entry_date desc')
results = cur.fetchall()
pretty_results = []
for i in results:
single_date = {}
d = datetime.strptime(str(i['entry_date']), '%Y%m%d')
single_date['entry_date'] = datetime.strftime(d, '%B %d, %Y')
pretty_results.append(single_date)
return render_template('home.html', results = pretty_results)
@app.route('/view/<date>') #format date stored in db looks like 20210119
def view():
db = get_db()
return render_template('day.html')
@app.route('/food', methods=['GET', 'POST'])
def food():
db = get_db()
if request.method == 'POST':
name = request.form['food-name']
protein = int(request.form['protein'])
carbohydrates = int(request.form['carbohydrates'])
fat = int(request.form['fat'])
calories = protein * 4 + carbohydrates * 4 + fat * 9
db.execute('insert into food (name, protein, carbohydrates, fat, calories) values (?, ?, ?, ?, ?)',
[name, protein, carbohydrates, fat, calories])
db.commit()
cur = db.execute('select name, protein, carbohydrates, fat, calories from food')
results = cur.fetchall()
# return '<h1>Name: {} Proteint: {} Carbs: {} Fat:{}</h1>'.format(request.form['food-name'], \
# request.form['protein'], request.form['carbohydrates'], request.form['fat'])
return render_template('add_food.html', results=results)
if __name__ == '__main__':
app.run(debug=True)