view tests/each.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 ccf1d445b794
children
line wrap: on
line source
sequence s
table t : { Id : int, S1 : string, S2:string, S3:string, S4:string }

fun each (n : int, (f : unit -> transaction unit)) = if n > 0 then f (); each ((n-1),f) else return ()

fun fill () =
    dml (DELETE FROM t WHERE 1=1);
    each (1,( fn () =>
      (nv <- nextval s;
      (dml (INSERT INTO t (Id, S1, S2, S3, S4) VALUES ({[nv]}, {["S1"]}, {["S2"]}, {["S3"]}, {["S4"]}))))
    ));
    return <xml>done</xml>

fun main () = return <xml><body>
    <form><submit action={fill} value="fill"/></form>
</body></xml>