def fetch_widget_data(self):
"""
Get widget data via query manager
returns: {Dict} A dictionary of the pandas dataframe data from the query manager
"""
# Create the widget name for the QueryManager
cur_user = User.get_instance()
user_id = cur_user.get_user_id()
time_stamp_from = cur_user.get_time_stamp_from()
time_stamp_to = cur_user.get_time_stamp_to()
database_id = cur_user.get_user_database_id()
widget_name = '%s-widget-%s-%s-%s-%s-user-%s' % (
self.widget_type, self.config['title']['text'], time_stamp_from,
time_stamp_to, database_id, user_id)
# Define the MySQL query to run
sql_query = "SELECT t_stamp, value, name FROM data WHERE name=\'" + self.config[
'metric'] + "\' AND t_stamp BETWEEN \'%s 00:00:00\' AND \'%s 00:00:00\' order by t_stamp" % (
time_stamp_from, time_stamp_to)
# Fetch the data from the query manager
self.widget_data = self.queryManager.getWidgetDataFromQueryManager(
widget_name, time_stamp_from, time_stamp_to, database_id,
sql_query, user_id, True)
# return the fetched data
return self.widget_data
import dash
import dash_bootstrap_components as dbc
from classes.User import User
# get the current user instance
current_user = User.get_instance()
external_stylesheets = [
dbc.themes.BOOTSTRAP,
# '/assets/css/jquery.dataTables.min.css',
# '/assets/css/scroller.dataTables.min.css',
]
external_scripts = [
'/assets/js/jquery-3.3.1.min.js',
'/assets/js/popper.min.js',
# '/assets/js/jquery.dataTables.min.js',
# '/assets/js/dataTables.scroller.min.js',
]
# Create dash app
app = dash.Dash(
__name__,
external_stylesheets=external_stylesheets,
external_scripts=external_scripts,
suppress_callback_exceptions=True,
meta_tags=[{
'name': 'viewport',
'content': 'width=device-width, initial-scale=1.0'
}]
)