summaryrefslogtreecommitdiff
path: root/database/run.lisp
blob: 30b834288ed2cc5522076c8b78d627a584fa344f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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))))