Mercurial > urweb

view tests/query.ur @ 2209:0ca11d57c175

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Cleans up interface (it's now a command line option) and renames project to "sqlcache" in the all-one-word style. Still has issues to do with concurrency, retrying transactions, and foreign function calls that either rely on state or have side effects.
author Ziv Scully <ziv@mit.edu>
date Sat, 31 May 2014 03:08:16 -0400
parents 5f9b9972e6b8
children
line wrap: on
line source
table t1 : {A : int, B : string, C : float, D : bool}
table t2 : {A : float, D : int}

datatype list a = Nil | Cons of a * list a

val q1 = (SELECT * FROM t1)

val r1 : transaction (list {A : int, B : string, C : float, D : bool}) =
    query q1
          (fn fs acc => return (Cons (fs.T1, acc)))
          Nil

val r2 : transaction string =
    ls <- r1;
    return (case ls of
                Nil => "Problem"
              | Cons ({B = b, ...}, _) => b)

fun main () : transaction page =
    s <- r2;
    return <xml><body>
      {cdata s}
    </body></xml>