db_create_device.sql:
Holds the DDL to create 'device' schema, its time series tables, and
its types.
db_create_dashboard_device.sql:
Holds the DDL to create 'dashboard_device' schema, which contains
functions (stored procedures) to be run by read-only user
'dashboard' in Grafana. These functions return restricted data, adjusted
to each Grafana panel. This file also holds the queries used in
Grafana's Devices dashboard.
import_devices.py - The script that populates 'device' tables.
Updated files:
db_create_roles.sql:
Added roles permissions for 'dashboard_device' schema.
tables.txt:
Added serial id field to public.report and public.device_report tables.
New files:
Updated files:
Signed-off-by: Yaarit Hatuka yaarit@redhat.com