Mercurial > urweb
view demo/broadcast.ur @ 2209:0ca11d57c175
Cleans up interface (it's now a command line option) and renames project to "sqlcache" in the all-one-word style. Still has issues to do with concurrency, retrying transactions, and foreign function calls that either rely on state or have side effects.
author | Ziv Scully <ziv@mit.edu> |
---|---|
date | Sat, 31 May 2014 03:08:16 -0400 |
parents | 0406e9cccb72 |
children |
line wrap: on
line source
functor Make(M : sig type t end) = struct sequence s table t : {Id : int, Client : client, Channel : channel M.t} PRIMARY KEY (Id, Client) type topic = int val inj : sql_injectable topic = _ val create = nextval s fun subscribe id = cli <- self; ro <- oneOrNoRows (SELECT t.Channel FROM t WHERE t.Id = {[id]} AND t.Client = {[cli]}); case ro of None => ch <- channel; dml (INSERT INTO t (Id, Client, Channel) VALUES ({[id]}, {[cli]}, {[ch]})); return ch | Some r => return r.T.Channel fun send id msg = queryI (SELECT t.Channel FROM t WHERE t.Id = {[id]}) (fn r => Basis.send r.T.Channel msg) fun subscribers id = r <- oneRow (SELECT COUNT( * ) AS N FROM t WHERE t.Id = {[id]}); return r.N end