blob: 5e397e4d731369ed4f3224689a2f2f34a0e4c6e3 (
plain)
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
|
import pathlib
from flask import Flask, render_template
import flask
from flask_sqlalchemy import SQLAlchemy
import pandas
__here__ = pathlib.Path(__file__).parent
df = pandas.read_csv(__here__ / "jobs.csv")
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////tmp/test.db'
db = SQLAlchemy(app)
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True)
email = db.Column(db.String(120), unique=True)
def __repr__(self):
return '<User %r>' % self.username
@app.route('/')
@app.route('/jobs')
def jobs():
#return df.to_html()
return render_template("jobs.html", df=df.to_html())
@app.route('/inventory')
def inventory():
#return df.to_html()
return render_template("inventory.html")
app.run(debug=True, port=8000)
|
