X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=templates%2Findex.html.ep;h=afa76ee3e81be78fdc75897e927651c47495ca02;hb=aeae7df3e27f70fe7d78cb094ad2e92a3fc93368;hp=a06ee196e0280f7856f18e00a2546e9ce80b797c;hpb=39ee36edba71bb839b848a007f1469ebf8f8ecc4;p=APKPM.git

diff --git a/templates/index.html.ep b/templates/index.html.ep
index a06ee19..afa76ee 100644
--- 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' %>
-
+-->