diff options
Diffstat (limited to 'snag/dashboard.py')
| -rw-r--r-- | snag/dashboard.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/snag/dashboard.py b/snag/dashboard.py index 7e77124..1eca82c 100644 --- a/snag/dashboard.py +++ b/snag/dashboard.py @@ -16,11 +16,11 @@ def dashboard(): db = get_db() rows = db.execute( - 'SELECT de.deviceId, de.environment, d.deviceName' + 'SELECT de.deviceId, de.environment, de.environmentDescription, d.deviceName, d.deviceLocation' ' 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] + deviceList = [dict(deviceId=row['deviceId'], environment=row['environment'], environmentDesc=row['environmentDescription'], name=row['deviceName'], location=row['deviceLocation']) for row in rows] return render_template('dashboard/dashboard.html', deviceList=deviceList, generatedAt=datetime.now()) |