{% 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(){ var query_sql = ''; $('#queryOptions').change(function() { $("#sqlQuery").empty(); query_sql = $("#queryOptions option:selected").val(); $('#sqlQuery').val(query_sql); }).change(); }); </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> <p> SELECT process.processKey, process.lineNumber, startTime, endTime, computedLapse, completedLapse,<br> pid, user, workspace, ip, app, cmd, args,<br> uCpu, sCpu, diskIn, diskOut, ipcIn, ipcOut, maxRss, pageFaults,<br> rpcMsgsIn, rpcMsgsOut, rpcSizeIn, rpcSizeOut, rpcHimarkFwd, rpcHimarkRev,<br> rpcSnd, rpcRcv, running, error,<br> pagesIn, pagesOut, pagesCached, readLocks, writeLocks,<br> getRows, posRows, scanRows, putRows, delRows,<br> totalReadWait, totalReadHeld, totalWriteWait, totalWriteHeld, <br> maxReadWait, maxReadHeld, maxWriteWait, maxWriteHeld, <br> 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 %}
# | Change | User | Description | Committed | |
---|---|---|---|---|---|
#7 | 25220 | Robert Cowham |
Moved project files to new location: //guest/perforce_software/log-analyzer/psla/... Required by Swarm project structure for workshop. |
||
#6 | 24989 | Robert Cowham | Expand schema help for tableuse | ||
#5 | 24976 | Robert Cowham | Avoid trigger change event on page load | ||
#4 | 24321 | Robert Cowham | Allow canned queries to be included | ||
#3 | 23896 | Robert Cowham | Nicer formatting of help text | ||
#2 | 23846 | Robert Cowham | Made sql field larger | ||
#1 | 23845 | Robert Cowham | Basic query form working |