diff options
author | 2022-04-25 16:55:01 +0200 | |
---|---|---|
committer | 2022-04-26 08:49:11 +0000 | |
commit | c01befc28450d5c2003d25876dda0201eb827735 (patch) | |
tree | 4bd0eacbe76c605b8950e7b001ef296bbeca277a /resources/tools/dash/app/pal/stats/graphs.py | |
parent | 76def9e0a3404b38c9e7fbd58260700207b17639 (diff) |
feat(uti): Add statistics
Change-Id: I14046fd1050f130d201bbe81a72e48ad4fd10057
Signed-off-by: Tibor Frank <tifrank@cisco.com>
Diffstat (limited to 'resources/tools/dash/app/pal/stats/graphs.py')
-rw-r--r-- | resources/tools/dash/app/pal/stats/graphs.py | 109 |
1 files changed, 109 insertions, 0 deletions
diff --git a/resources/tools/dash/app/pal/stats/graphs.py b/resources/tools/dash/app/pal/stats/graphs.py new file mode 100644 index 0000000000..2fabf8e6ae --- /dev/null +++ b/resources/tools/dash/app/pal/stats/graphs.py @@ -0,0 +1,109 @@ +# Copyright (c) 2022 Cisco and/or its affiliates. +# Licensed under the Apache License, Version 2.0 (the "License"); +# you may not use this file except in compliance with the License. +# You may obtain a copy of the License at: +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, software +# distributed under the License is distributed on an "AS IS" BASIS, +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +# See the License for the specific language governing permissions and +# limitations under the License. + +""" +""" + +import plotly.graph_objects as go +import pandas as pd + +from datetime import datetime, timedelta + +def select_data(data: pd.DataFrame, itm:str) -> pd.DataFrame: + """ + """ + + df = data.loc[(data["job"] == itm)].sort_values( + by="start_time", ignore_index=True) + + return df + + +def graph_statistics(df: pd.DataFrame, job:str, layout: dict, + start: datetime=datetime.utcnow()-timedelta(days=180), + end: datetime=datetime.utcnow()) -> tuple: + """ + """ + + data = select_data(df, job) + data = data.dropna(subset=["duration", ]) + if data.empty: + return None, None + + x_axis = [d for d in data["start_time"] if d >= start and d <= end] + if not x_axis: + return None, None + + hover = list() + for _, row in data.iterrows(): + hover_itm = ( + f"date: {row['start_time'].strftime('%d-%m-%Y %H:%M:%S')}<br>" + f"duration: " + f"{(int(row['duration']) // 3600):02d}:" + f"{((int(row['duration']) % 3600) // 60):02d}<br>" + f"passed: {row['passed']}<br>" + f"failed: {row['failed']}<br>" + f"{row['dut_type']}-ref: {row['dut_version']}<br>" + f"csit-ref: {row['job']}/{row['build']}<br>" + f"hosts: {', '.join(row['hosts'])}" + ) + hover.append(hover_itm) + + # Job durations: + fig_duration = go.Figure( + data=go.Scatter( + x=x_axis, + y=data["duration"], + name=u"Duration", + text=hover, + hoverinfo=u"text" + ) + ) + + tickvals = [0, ] + step = max(data["duration"]) / 5 + for i in range(5): + tickvals.append(int(step * (i + 1))) + layout_duration = layout.get("plot-stats-duration", dict()) + if layout_duration: + layout_duration["yaxis"]["tickvals"] = tickvals + layout_duration["yaxis"]["ticktext"] = [ + f"{(val // 3600):02d}:{((val % 3600) // 60):02d}" \ + for val in tickvals + ] + fig_duration.update_layout(layout_duration) + + # Passed / failed: + fig_passed = go.Figure( + data=[ + go.Bar( + x=x_axis, + y=data["passed"], + name=u"Passed", + hovertext=hover, + hoverinfo=u"text" + ), + go.Bar( + x=x_axis, + y=data["failed"], + name=u"Failed", + hovertext=hover, + hoverinfo=u"text" + ) + ] + ) + layout_pf = layout.get("plot-stats-passed", dict()) + if layout_pf: + fig_passed.update_layout(layout_pf) + + return fig_passed, fig_duration |