annotate demo/batch.ur @ 882:9c1b7e46eed2

MySQL CGI working
author Adam Chlipala <adamc@hcoop.net>
date Fri, 17 Jul 2009 12:58:37 -0400
parents a44daa674810
children ed06e25c70ef
rev   line source
adamc@649 1 datatype list t = Nil | Cons of t * list t
adamc@649 2
adamc@649 3 table t : {Id : int, A : string}
adamc@708 4 PRIMARY KEY Id
adamc@649 5
adamc@649 6 fun allRows () =
adamc@649 7 query (SELECT * FROM t)
adamc@649 8 (fn r acc => return (Cons ((r.T.Id, r.T.A), acc)))
adamc@649 9 Nil
adamc@649 10
adamc@649 11 fun doBatch ls =
adamc@649 12 case ls of
adamc@649 13 Nil => return ()
adamc@649 14 | Cons ((id, a), ls') =>
adamc@649 15 dml (INSERT INTO t (Id, A) VALUES ({[id]}, {[a]}));
adamc@649 16 doBatch ls'
adamc@649 17
adamc@649 18 fun del id =
adamc@649 19 dml (DELETE FROM t WHERE t.Id = {[id]})
adamc@649 20
adamc@649 21 fun show withDel lss =
adamc@649 22 let
adamc@649 23 fun show' ls =
adamc@649 24 case ls of
adamc@649 25 Nil => <xml/>
adamc@649 26 | Cons ((id, a), ls) => <xml>
adamc@649 27 <tr><td>{[id]}</td> <td>{[a]}</td> {if withDel then
adamc@649 28 <xml><td><button value="Delete" onclick={del id}/></td></xml>
adamc@649 29 else
adamc@649 30 <xml/>} </tr>
adamc@649 31 {show' ls}
adamc@649 32 </xml>
adamc@649 33 in
adamc@649 34 <xml><dyn signal={ls <- signal lss; return <xml><table>
adamc@649 35 <tr> <th>Id</th> <th>A</th> </tr>
adamc@649 36 {show' ls}
adamc@649 37 </table></xml>}/></xml>
adamc@649 38 end
adamc@649 39
adamc@782 40 fun main () =
adamc@649 41 lss <- source Nil;
adamc@649 42 batched <- source Nil;
adamc@649 43
adamc@649 44 id <- source "";
adamc@649 45 a <- source "";
adamc@649 46
adamc@649 47 let
adamc@649 48 fun add () =
adamc@649 49 id <- get id;
adamc@649 50 a <- get a;
adamc@649 51 ls <- get batched;
adamc@649 52
adamc@649 53 set batched (Cons ((readError id, a), ls))
adamc@649 54
adamc@649 55 fun exec () =
adamc@649 56 ls <- get batched;
adamc@649 57
adamc@649 58 doBatch ls;
adamc@649 59 set batched Nil
adamc@649 60 in
adamc@649 61 return <xml><body>
adamc@649 62 <h2>Rows</h2>
adamc@649 63
adamc@649 64 {show True lss}
adamc@649 65
adamc@649 66 <button value="Update" onclick={ls <- allRows (); set lss ls}/><br/>
adamc@649 67 <br/>
adamc@649 68
adamc@649 69 <h2>Batch new rows to add</h2>
adamc@649 70
adamc@649 71 <table>
adamc@649 72 <tr> <th>Id:</th> <td><ctextbox source={id}/></td> </tr>
adamc@649 73 <tr> <th>A:</th> <td><ctextbox source={a}/></td> </tr>
adamc@649 74 <tr> <th/> <td><button value="Batch it" onclick={add ()}/></td> </tr>
adamc@649 75 </table>
adamc@649 76
adamc@649 77 <h2>Already batched:</h2>
adamc@649 78 {show False batched}
adamc@649 79 <button value="Execute" onclick={exec ()}/>
adamc@649 80 </body></xml>
adamc@649 81 end