def update_index1(db):
FROM = (pd.to_datetime(datetime.datetime.now()) -
timedelta(days=120)).strftime("%Y-%m-%d")
TO = (pd.to_datetime(datetime.datetime.now())).strftime("%Y-%m-%d")
df = db_onnections.taskvsChannel(from_data=FROM, to_data=TO, section=db)
df['created_at'] = pd.to_datetime(df['created_at'])
return df['created_at'].max()
def update_connection_ts01(db):
temp = db_onnections.taskvsChannel(from_data=FROM, to_data=TO, section=db)
temp['created_at'] = pd.to_datetime(temp['created_at'])
temp['created_at'] = temp['created_at'].dt.date
alpha = temp.pivot_table(index='created_at',
columns="Connection",
values='session_id',
aggfunc="count")
alpha = alpha.fillna(0)
data_ = [{
'x': alpha.index,
'y': alpha[col],
'name': col,
'connectgaps': False,
'fill': "tozeroy",
'line': {
"shape": "linear",
"width": 2
}
} for col in alpha.columns]
return {
'data':
data_,
'layout':
go.Layout(title="Basic Template vs Tasks Connections over Time (Days)",
font={
'color': colors['text'],
'family': ' Glacial Indifference'
},
xaxis=dict(tickangle=25, rangeslider=dict(), type='date'),
yaxis={
"title": "Connections per Day",
'type': 'linear'
})
}
def update_index1(select_date, db):
select_date = pd.to_datetime(select_date)
select_date = select_date.strftime('%Y-%m-%d')
dff = db_onnections.taskvsChannel(from_data=FROM, to_data=TO, section=db)
dff["data"] = pd.to_datetime(dff["created_at"])
dff["data"] = dff["data"].astype(str).str[0:10]
dff = dff[dff["data"] == select_date]
available_device = list(dff["device_name"].unique())
available_device = available_device + ["-- all --"]
available_device = sorted(available_device)
return [{'label': i, 'value': i} for i in available_device]
def update_table(db, user, device, select_date):
select_date = pd.to_datetime(select_date)
select_date = select_date.strftime('%Y-%m-%d')
dff = db_onnections.taskvsChannel(from_data=FROM, to_data=TO, section=db)
dff["data"] = pd.to_datetime(dff["created_at"])
dff["data"] = dff["data"].astype(str).str[0:10]
dff = dff[dff["data"] == select_date]
dff["created_at"] = dff["created_at"].astype(str).str[0:19]
dff = dff[[
"created_at", "session_id", "Connection", "template", "user_name",
"device_name", "name"
]]
if user != "-- all --":
dff = dff[dff["user_name"] == user]
if device != "-- all --":
dff = dff[dff["device_name"] == device]
return generate_table(dff.sort_values(by=['created_at']))
######################################
## Initial time references ##
#####################################
FROM = (pd.to_datetime(datetime.datetime.now()) -
timedelta(days=240)).strftime("%Y-%m-%d")
TO = (pd.to_datetime(datetime.datetime.now())).strftime("%Y-%m-%d")
# define list DBs
list_db = db_onnections.list_dbs()
if len(list_db) == 1:
enable_db_selector = True
else:
enable_db_selector = False
df = db_onnections.taskvsChannel(
from_data=FROM,
to_data=TO,
section=general_configurations.Current_active_DB)
df['created_at'] = pd.to_datetime(df['created_at'])
available_users = list(df['user_name'].unique())
available_users = available_users + ["-- all --"]
available_users = sorted(available_users)
available_device = list(df["device_name"].unique())
available_device = available_device + ["-- all --"]
available_device = sorted(available_device)
dataMax = df['created_at'].max()
dataMin = df['created_at'].min()
# Dash Variables