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")


if __name__ == "__main__":
    app.run(debug=True)