1 files changed, 42 insertions, 0 deletions
diff --git a/shopdb/app/__init__.py b/shopdb/app/__init__.py
new file mode 100644
index 0000000..5e397e4
--- /dev/null
+++ b/shopdb/app/__init__.py
@@ -0,0 +1,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)