Mercurial > urweb

view tests/sql_ops.ur @ 2291:50ad02829abd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Make cache flushes happen immediately instead of at end of transaction.
author Ziv Scully <ziv@mit.edu>
date Tue, 17 Nov 2015 02:44:37 -0500
parents 5d494183ca89
children
line wrap: on
line source
table t : { A : int, B : float }

val q = (SELECT t.A + t.A AS X, t.B * t.B AS Y FROM t)

fun main () : transaction page =
    xml <- queryX q (fn r => <xml>{[r.X]}, {[r.Y]}<br/></xml>);
    return <xml><body>{xml}</body></xml>