view tests/tryDml.ur @ 1866:9fc086e3c95a

Add hex SQL syntax for blobs, such as X'0ABC12343'. Works with sqlite.
author Sergey Mironov <grrwlf@gmail.com>
date Fri, 13 Sep 2013 10:09:15 -0400
parents 929981850d9d
children
line wrap: on
line source
table t : {Id : int}
  PRIMARY KEY Id

fun doStuff () =
    dml (INSERT INTO t (Id) VALUES (0));
    o1 <- tryDml (INSERT INTO t (Id) VALUES (0));
    dml (INSERT INTO t (Id) VALUES (1));
    o2 <- tryDml (INSERT INTO t (Id) VALUES (2));
    dml (INSERT INTO t (Id) VALUES (3));
    o3 <- tryDml (INSERT INTO t (Id) VALUES (3));
    return <xml>{[o1]}; {[o2]}; {[o3]}</xml>

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