analyzeLog.html #4

{% extends "base.html" %}

{% block content %}

<div id=psla class=analyze>

 <h1>Perforce Server Log Analyzer - local Docker version</h1>
     {% from "_formhelpers.html" import render_field %}
     <form action="{{ url_for('analyzeLog') }}" method="post" role="form">
        {{ form.csrf_token }}
        {{ render_field(form.logFile) }}
        <p>{{ form.submit() }}</p>
    </form>

 {% if dbName %}
 <h2>Analyze Server Log: '{{ dbName }}'</h2>

     <div class="charts text-center">

     {% for chart in charts %}
        <h2>{{ chart.title }}</h2>
        <p>{{ chart.explanation }}</p>
        <p>{{ chart.sql }}</p>
        <p>Time to run query: {{ chart.time_taken }}</p>
         <div class="row"><div id="{{ chart.id }}"></div></div><hr>
        <!-- Placeholder for the tooltip -->
        <div id="vis-tooltip-{{ chart.id }}" class="vg-tooltip"></div>
         {% endfor %}
    </div>
 {% endif %}

 {% for table in tables %}
    <h2>{{ table.title }}</h2>
    <p>{{ table.explanation }}</p>
    <p>{{ table.sql }}</p>
    <p>Time to run query: {{ table.time_taken }}</p>
    {{ table.data|safe }}
 {% endfor %}

</div>

<!--This is used for Altair graph-->

<footer>

    <script src="https://d3js.org/d3.v3.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/vega@3.2.1"></script>
    <script src="https://cdn.jsdelivr.net/npm/vega-lite@2.3.1"></script>
    <script src="https://cdn.jsdelivr.net/npm/vega-embed@3.2.0"></script>

    <!-- Vega Tooltip -->
    <script src="https://vega.github.io/vega-tooltip/vega-tooltip.min.js"></script>
    <link rel="stylesheet" type="text/css" href="https://vega.github.io/vega-tooltip/vega-tooltip.css">

    <!-- Render Charts -->
    <script type="text/javascript">
        function embed_graph(div, chartJSON) {
            var opt = {
              mode: "vega-lite",
              renderer: "svg",
              actions: {export: true, source: false, editor: false}
            };
            vegaEmbed("#" + div, chartJSON, opt)
                .then(function(result) {
                    // result.view is the Vega View, vlSpec is the original Vega-Lite specification
                    vegaTooltip.vegaLite(result.view, chartJSON);
                  })
                  .catch(console.error);
        }

    </script>

     {% for chart in charts %}
             <script type="text/javascript">
            embed_graph("{{ chart.id }}", {{ chart.data|safe }})
            </script>
        <!-- Placeholder for the tooltip -->
         {% endfor %}

</footer>

{% endblock %}