Mercurial > urweb

view tests/ascdesc.ur @ 1887:2e6795cc992f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
A fancier test for the new SQL constraints subtyping
author Adam Chlipala <adam@chlipala.net>
date Mon, 04 Nov 2013 16:00:48 -0500
parents 6f046b4bad24
children
line wrap: on
line source
table t : { A : int }

fun sortEm b =
    queryX1 (SELECT * FROM t ORDER BY t.A {if b then sql_asc else sql_desc})
    (fn r => <xml>{[r.A]}; </xml>)

fun main () : transaction page = return <xml><body>
  <a link={sortEm True}>Ascending</a><br/>
  <a link={sortEm False}>Descending</a>
</body></xml>