From c8ef8843aaaf28bc38b544ae8ac72accf233aead Mon Sep 17 00:00:00 2001 From: Matt Kohls Date: Mon, 4 Sep 2023 15:36:33 -0400 Subject: Revamped project init New repo for larger structural changes from Sensor-Server. Currently doing most all the same stuff but hopefully better. Still have to clean out some of the older templates for the new interface --- snag/dashboard.py | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 snag/dashboard.py (limited to 'snag/dashboard.py') 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()) + -- cgit v1.2.3