Setup basic database connections

4 files changed, 32 insertions, 4 deletions

diff --git a/app/app.py b/app/app.py
index 2ea9126..7f105fd 100644
--- a/app/app.py
+++ b/app/app.py
@@ -1,7 +1,8 @@
-from flask import Flask, render_template
+from flask import Flask
 
+# Setup app before doing imports
 app = Flask(__name__)
+app.config['TEMPLATES_AUTO_RELOAD'] = True
 
-@app.route("/", methods=["GET"])
-def index():
-    return render_template('base/index.html')
+# Load routes
+import routes
diff --git a/app/database.py b/app/database.py
new file mode 100644
index 0000000..e23aa5d
--- /dev/null
+++ b/app/database.py
@@ -0,0 +1,19 @@
+import sqlite3
+from app import app
+from flask import g
+
+# constants
+DATABASE_FILE = "../strengthy.db"
+
+# Called when an "appcontext" is closed, usually a request is finished
+@app.teardown_appcontext
+def close_db_conn(exception):
+    db = getattr(g, '_database', None)
+    if db is not None:
+        db.close()
+
+def database_get():
+    db = getattr(g, '_database', None)
+    if db is None:
+        db = g._database = sqlite3.connect(DATABASE_FILE)
+    return db
diff --git a/app/login.py b/app/login.py
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/app/login.py
diff --git a/app/routes.py b/app/routes.py
new file mode 100644
index 0000000..c162b8d
--- /dev/null
+++ b/app/routes.py
@@ -0,0 +1,8 @@
+from app import app
+from database import database_get
+from flask import render_template
+
+@app.route("/", methods=["GET"])
+def index():
+    db = database_get()
+    return render_template('base/index.html')