From 3db9a2eb7a7d14ce935f5902b0c21ce4fd5eb729 Mon Sep 17 00:00:00 2001 From: Logan Hunt Date: Tue, 24 May 2022 09:57:15 -0700 Subject: None of the original commit messages would actually help anyone --- database/run.lisp | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 database/run.lisp (limited to 'database/run.lisp') diff --git a/database/run.lisp b/database/run.lisp new file mode 100644 index 0000000..30b8342 --- /dev/null +++ b/database/run.lisp @@ -0,0 +1,17 @@ +(mito:deftable run () + ((category :col-type category)) + (:record-timestamps nil) + (:conc-name run-)) + +(mito:deftable run-split () + ((run :col-type run) + (category-split :col-type category-split) + (start-time :col-type (or :datetime :null)) + (end-time :col-type (or :datetime :null))) + (:record-timestamps nil) + (:conc-name run-split-)) + +(defun run-splits (run) + (mito:select-dao 'run-split + (sxql:order-by :category_split_id) + (sxql:where (:= :run run)))) -- cgit v1.2.3-70-g09d2