Mercurial > urweb
view tests/dbupload.ur @ 2006:c3b03d099e04
Allow parens grouping joins in FROM clauses
author | Adam Chlipala <adam@chlipala.net> |
---|---|
date | Tue, 29 Apr 2014 16:47:45 -0400 |
parents | 216a3a67ebe3 |
children |
line wrap: on
line source
table t : { Id : int, Blob : blob, MimeType : string } sequence s fun getImage id : transaction page = r <- oneRow1 (SELECT t.Blob, t.MimeType FROM t WHERE t.Id = {[id]}); returnBlob r.Blob (blessMime r.MimeType) fun main () : transaction page = let fun handle r = id <- nextval s; dml (INSERT INTO t (Id, Blob, MimeType) VALUES ({[id]}, {[fileData r.File]}, {[fileMimeType r.File]})); main () in x <- queryX1 (SELECT t.Id FROM t) (fn r => <xml><img src={url (getImage r.Id)}/><br/></xml>); return <xml><body> <form><upload{#File}/> <submit action={handle}/></form> <hr/> {x} </body></xml> end