queryLog.html #1

{% extends "base.html" %}

{% block content %}

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){

    $('#queryOptions').change(function() {
        $("#sqlQuery").empty();
        query_sql = $("#queryOptions option:selected").val();
        $('#sqlQuery').val(query_sql);
    });

});
</script>

<div id=psla class=analyze>

 <h1>Perforce Server Log Analyzer - Interactive Queries</h1>
    <p>Table schema/example SQL - you can copy this statement showing all columns, and edit it to
    suite your needs (or copy one from <a href='{{ url_for("analyzeLog") }}'>
   <span>analyzeLog</span></a> page.</p>
    <a class=btn href='{{ url_for("schema") }}'>
        <span>Table schema with explanations</span></a>
    <a class=btn href='{{ url_for("chartLog") }}'>
        <span>Single Chart for Log DB</span></a>      
    <p>
        SELECT process.processKey, process.lineNumber, startTime, endTime, computedLapse, completedLapse,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;pid, user, workspace, ip, app, cmd, args,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;uCpu, sCpu, diskIn, diskOut, ipcIn, ipcOut, maxRss, pageFaults,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;rpcMsgsIn, rpcMsgsOut, rpcSizeIn, rpcSizeOut, rpcHimarkFwd, rpcHimarkRev,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;rpcSnd, rpcRcv, running, error,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;pagesIn, pagesOut, pagesCached,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;pagesSplitInternal, pagesSplitLeaf,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;readLocks, writeLocks,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;getRows, posRows, scanRows, putRows, delRows,<br>
    &nbsp;&nbsp;&nbsp;&nbsp;totalReadWait, totalReadHeld, totalWriteWait, totalWriteHeld, <br>
    &nbsp;&nbsp;&nbsp;&nbsp;maxReadWait, maxReadHeld, maxWriteWait, maxWriteHeld, <br>
    &nbsp;&nbsp;&nbsp;&nbsp;peekCount, totalPeekWait, totalPeekHeld, maxPeekWait, maxPeekHeld, triggerLapse<br>
FROM tableUse JOIN process USING (processKey)<br>
LIMIT 10<br>
    </p>

     {% from "_formhelpers.html" import render_field %}
     <form action="{{ url_for('queryLog') }}" method="post" role="form">
         {{ form.csrf_token }}
         {{ render_field(form.logFile) }}
         {{ render_field(form.queryOptions) }}
         {{ render_field(form.sqlQuery, rows=20, cols=80) }}
         <p>{{ form.submit() }}</p>
    </form>

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

    <h2>Query results</h2>
    <p>{{ data.sql }}</p>
    <p>Time to run query: {{ data.time_taken }}</p>
    {{ data.data|safe }}

 {% endif %}

</div>

{% endblock %}