Mercurial > urweb

view tests/dbupload2.ur @ 2166:8a01e8f21de9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Make OpenSSL usage thread-safe (closes #206) Enable OpenSSL?s multithreading support by defining locking and thread-ID callbacks. Remove a lock obviated by this change.
author Benjamin Barenblat <bbaren@mit.edu>
date Thu, 06 Aug 2015 10:15:53 -0400
parents 229a299d739d
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 handle (r : {File:file, Param:string}) =
    id <- nextval s;
    dml (INSERT INTO t (Id, Blob, MimeType)
         VALUES ({[id]}, {[fileData r.File]}, {[fileMimeType r.File]}));
    debug ("Text is " ^ r.Param);
    main ()

and main () : transaction page =
    x <- queryX1 (SELECT t.Id FROM t)
                 (fn r => <xml><img src={url (getImage r.Id)}/>
</xml>);
    return <xml><body>
      <form>
      <upload{#File}/>
      <textbox{#Param} value="text"/>
      <submit action={handle}/>
      </form>
      <hr/>
      {x}
    </body></xml>