Mercurial > urweb

view tests/sql_if.ur @ 2204:01c8aceac480

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Finishes initial prototype, caching parameterless pages with table-match-based invalidation. Still has problems parsing non-Postgres SQL dialects properly.
author Ziv Scully <ziv@mit.edu>
date Tue, 27 May 2014 21:14:13 -0400
parents 34364e383bed
children
line wrap: on
line source
table t : { A : int, B : int }

fun main () =
    x <- queryX (SELECT * FROM t WHERE IF t.A = 6 THEN t.B < 2 ELSE t.B > 5)
                (fn r => <xml><li>{[r.T.A]}, {[r.T.B]}</li></xml>);
    return <xml><body>{x}</body></xml>