view tests/query.ur @ 1697:cb0f05bdc183

Refactor SQL parsing code from Iflow to Sql, add querydml parser.
author Edward Z. Yang <ezyang@mit.edu>
date Mon, 12 Mar 2012 12:00:23 -0700
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>