From 681349db67bb828ab926b53734b44c50249d5f65 Mon Sep 17 00:00:00 2001
From: stilbruch <stilbruch@protonail.com>
Date: Mon, 21 Mar 2022 18:09:50 -0500
Subject: Setup basic database connections

---
 app/app.py      |  9 +++++----
 app/database.py | 19 +++++++++++++++++++
 app/login.py    |  0
 app/routes.py   |  8 ++++++++
 4 files changed, 32 insertions(+), 4 deletions(-)
 create mode 100644 app/database.py
 create mode 100644 app/login.py
 create mode 100644 app/routes.py

(limited to 'app')

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
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')
-- 
cgit v1.2.3