Mercurial > urweb

view tests/sql_option.ur @ 2174:ce312cad5ecd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use correct OpenSSL thread safety macros on OS X (closes #209) Create an Autoconf test to determine if pthread_t is a pointer or scalar type, and use the appropriate CRYPTO_THREADID_set macro based on the result.
author Benjamin Barenblat <bbaren at mit.edu>
date Sun, 20 Sep 2015 17:46:07 -0400
parents 4efab85405be
children
line wrap: on
line source
table t : { O : option int }

fun addNull () =
    dml (INSERT INTO t (O) VALUES (NULL));
    return <xml>Done</xml>

fun add3 () =
    dml (INSERT INTO t (O) VALUES ({Some 3}));
    return <xml>Done</xml>

fun addN r =
    dml (INSERT INTO t (O) VALUES ({Some (readError r.N)}));
    return <xml>Done</xml>

fun main () : transaction page =
    xml <- queryX (SELECT * FROM t)
                  (fn r => case r.T.O of
                               None => <xml>Nada<br/></xml>
                             | Some n => <xml>Num: {[n]}<br/></xml>);
    return <xml><body>
      {xml}

      <a link={addNull ()}>Add a null</a><br/>
      <a link={add3 ()}>Add a 3</a><br/>
      <form>
        Add <textbox{#N}/> <submit action={addN}/>
      </form>
    </body></xml>