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)