Mercurial > urweb
annotate tests/time.ur @ 455:d4a81273d4b1
Nested demo
author | Adam Chlipala <adamc@hcoop.net> |
---|---|
date | Tue, 04 Nov 2008 09:33:35 -0500 |
parents | c5335613f31e |
children |
rev | line source |
---|---|
adamc@438 | 1 table t : { Id : int, Time : time } |
adamc@438 | 2 |
adamc@436 | 3 val now : time = readError "10/30/08 14:35:42" |
adamc@437 | 4 val later : time = readError "10/30/08 14:37:42" |
adamc@436 | 5 |
adamc@438 | 6 fun main () = |
adamc@439 | 7 dml (INSERT INTO t (Id, Time) VALUES (42, {now})); |
adamc@438 | 8 xml <- queryX (SELECT * FROM t) |
adamc@438 | 9 (fn r => <xml>{[r.T.Id]}: {[r.T.Time]}<br/></xml>); |
adamc@441 | 10 minMax <- oneRow (SELECT CURRENT_TIMESTAMP AS Cur, MIN(t.Time) AS Min, MAX(t.Time) AS Max FROM t); |
adamc@438 | 11 return <xml><body> |
adamc@438 | 12 {xml} |
adamc@440 | 13 {[now]}, {[now = now]}, {[now = later]}, {[later < now]}, {[now < later]}<br/> |
adamc@441 | 14 {[minMax.Cur]}, {[minMax.Min]}, {[minMax.Max]} |
adamc@438 | 15 </body></xml> |