new poll example SQL queries

[APKPM.git] / templates / index.html.ep

diff --git a/templates/index.html.ep b/templates/index.html.ep
index a06ee19..afa76ee 100644 (file)
--- a/templates/index.html.ep
+++ b/templates/index.html.ep
@@ -2,20 +2,35 @@
 % title 'Gearman demo';
 
 <ul>
+<li><a href="/user">Search for user</a> and show LDAP and ADSL stats
 <li><a href="/gearman.html#ping/127.0.0.1">Gearman</a> web interface
-<li><%= link_to 'CRM' => 'CRM.html' %> search with tabular output
+<li><a href="/redis.html">last poll stats</a>
+</ul>
+
+Database schema:
+
+<ul>
+% foreach my $table ( qw(cpe_poll ping cpe_Davolink cpe_EasyGateway dslam_poll dslam) ) {
+<li><a href="/psql/_d <%= $table %>"><%= $table %></a>
+% }
 </ul>
 
 Gnuplot graphs:
 
 <ul>
-<li><a href="/gnuplot?sql=select start,ping_error,adsl_ok from poll">poll stats</a>
+<li>poll stats
+<ul>
+<li><a href="/gnuplot?sql=select start,queued,ping_ok,davolink_ok,easygateway_ok from cpe_poll order by start desc limit 200">CPE</a>
+<li><a href="/gnuplot?sql=select start,ok,queued,complete from dslam_poll where variant = 'ZTEDSLAM' order by start desc limit 200">ZTEDSLAM</a>
+<li><a href="/gnuplot?sql=select start,ok,queued,complete from dslam_poll where variant = 'ZTEMSAN' order by start desc limit 200">ZTEMSAN</a>
+</ul>
 <li><a href="/gnuplot?sql=select timestamp,snrtx,attntx,pwrtx,pwrrx,attnrx,snrrx from adsl where username='test36zg@h1snc'">adsl stat for single user</a>
 <li><a href="/gnuplot?sql=select timestamp,rtt from ping where ip << inet '10.17/16' order by timestamp desc limit 1000">ttl from 10.17 network</a>
 </ul>
 
+<!--
 Low-level API tests:
 
 <%= link_to 'HTTP ping' => 'ping_http' %>
 <%= link_to 'Gearman ping' => 'ping_g' %>
-
+-->