From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Sat, 9 Jul 2011 15:29:13 +0000 (+0000)
Subject: new poll example SQL queries
X-Git-Url: http://git.rot13.org/?p=APKPM.git;a=commitdiff_plain;h=aeae7df3e27f70fe7d78cb094ad2e92a3fc93368

new poll example SQL queries
---

diff --git a/templates/index.html.ep b/templates/index.html.ep
index 6a6bb96..afa76ee 100644
--- a/templates/index.html.ep
+++ b/templates/index.html.ep
@@ -18,7 +18,12 @@ Database schema:
 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>