Mercurial > lbo > hg > analyrics

changeset 14:195d92c0e106

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add example query and add plots to template
author Lewin Bormann <lbo@spheniscida.de>
date Mon, 11 Jul 2022 12:44:26 -0700
parents b538f811931e
children d5724ebeefd3
files assets/index.html.hbs queries.sql
diffstat 2 files changed, 13 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/assets/index.html.hbs	Sun Jul 10 19:05:01 2022 -0700
+++ b/assets/index.html.hbs	Mon Jul 11 12:44:26 2022 -0700
@@ -10,6 +10,9 @@
             #logout { float: right; padding: 3pt; }
             #flashtext {  }
             #flash { text-align: center; border-style: solid; border-color: #22aa22; margin-left: 30%; margin-right: 30%; }
+
+            .plotrow { border-style: solid; border-color: blue; }
+            .plotframe { border-style: solid; border-color: green; height: 10em; display: inline-block; margin: 5pt; }
         </style>
 
     </head>
@@ -27,5 +30,11 @@
     </div>
     {{#if flash}}<div id="flash"><span id="flashtext">{{flash}}<span></div>{{/if}}
 
+    <!-- Plots -->
+    <div class="plotrow">
+        <div class="plotframe"> </div>
+        <div class="plotframe"> </div>
+    </div>
+
     </body>
 </html>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/queries.sql	Mon Jul 11 12:44:26 2022 -0700
@@ -0,0 +1,4 @@
+
+-- Find all sessions and sort by request count
+select sessions.id, start, count(*) from sessions join requestlog on
+(sessions.id = requestlog.session) group by sessions.id order by 3;