1 files changed, 26 insertions, 0 deletions
diff --git a/snag/dashboard.py b/snag/dashboard.py
new file mode 100644
index 0000000..7e77124
--- /dev/null
+++ b/snag/dashboard.py
@@ -0,0 +1,26 @@
+# snag
+# Matt Kohls
+# (c) 2023
+
+from flask import (
+    Blueprint, flash, g, redirect, render_template, request, url_for
+)
+from werkzeug.exceptions import abort
+from datetime import datetime
+from snag.db import get_db
+
+bp = Blueprint('dashboard', __name__)
+
+@bp.route('/')
+def dashboard():
+    db = get_db()
+
+    rows = db.execute(
+        'SELECT de.deviceId, de.environment, d.deviceName'
+        ' FROM device_env de JOIN devices d ON de.deviceId = d.deviceId'
+        ' ORDER BY entry DESC'
+    ).fetchall()
+
+    deviceList = [dict(deviceId=row['deviceId'], location=row['environment'], name=row['deviceName']) for row in rows]
+    return render_template('dashboard/dashboard.html', deviceList=deviceList, generatedAt=datetime.now())
+