Mercurial > urweb
view tests/dbupload.ur @ 1918:c3c84fd38815
Postgres: remove DML error code logging and (hopefully) fix the real problem, not checking for concurrency faults on SELECTs
author | Adam Chlipala <adam@chlipala.net> |
---|---|
date | Fri, 29 Nov 2013 08:12:57 -0500 |
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