X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;ds=sidebyside;f=templates%2Findex.html.ep;h=afa76ee3e81be78fdc75897e927651c47495ca02;hb=1cb01db2f268768f43146bc87ce769b92842c421;hp=0a6072a052b4fe706e876807bfa265a816ae7f29;hpb=816ba38b2ddf68fab653a98fbee6a001a36cd10e;p=APKPM.git

diff --git a/templates/index.html.ep b/templates/index.html.ep
index 0a6072a..afa76ee 100644
--- a/templates/index.html.ep
+++ b/templates/index.html.ep
@@ -2,21 +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' %>
-
+-->