summaryrefslogtreecommitdiff
path: root/database/run.lisp
diff options
context:
space:
mode:
authorLogan Hunt <loganhunt@simponic.xyz>2022-05-29 21:31:48 -0700
committerLogan Hunt <loganhunt@simponic.xyz>2022-05-29 21:31:48 -0700
commitedeab2d09444e02a2eeb3adb2bf7933a2851c5b3 (patch)
tree774027b0b7f31f457a4f01eb977ed8922bcfaf6a /database/run.lisp
parent088a03c2e788127c5b8606d0a6a1956ff58e4ec1 (diff)
downloadlispruns-edeab2d09444e02a2eeb3adb2bf7933a2851c5b3.tar.gz
lispruns-edeab2d09444e02a2eeb3adb2bf7933a2851c5b3.zip
Get a timer on the screen finally
Diffstat (limited to 'database/run.lisp')
-rw-r--r--database/run.lisp6
1 files changed, 6 insertions, 0 deletions
diff --git a/database/run.lisp b/database/run.lisp
index 30b8342..21d278a 100644
--- a/database/run.lisp
+++ b/database/run.lisp
@@ -15,3 +15,9 @@
(mito:select-dao 'run-split
(sxql:order-by :category_split_id)
(sxql:where (:= :run run))))
+
+;; Returns stuff like PB, best of each split, etc.
+(defun run-statistics (category)
+ `((asdf . 1)))
+
+;; select *, sum(julianday(end_time)-julianday(start_time))*24*60*60 as total_time from run_split group by run_id order by total_time;