% layout 'default';
% title 'Gearman demo';

<ul>
<li><a href="/user.html">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><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>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' %>
-->