diff options
-rw-r--r-- | src/monoize.sml | 11 | ||||
-rw-r--r-- | tests/limit.ur | 20 |
2 files changed, 31 insertions, 0 deletions
diff --git a/src/monoize.sml b/src/monoize.sml index d2da6e27..620956f7 100644 --- a/src/monoize.sml +++ b/src/monoize.sml @@ -739,6 +739,17 @@ fun monoExp (env, st, fm) (all as (e, loc)) = | L.EFfi ("Basis", "sql_no_limit") => ((L'.EPrim (Prim.String ""), loc), fm) + | L.EFfiApp ("Basis", "sql_limit", [e]) => + let + val (e, fm) = monoExp (env, st, fm) e + in + (strcat loc [ + (L'.EPrim (Prim.String " LIMIT "), loc), + (L'.EFfiApp ("Basis", "sqlifyInt", [e]), loc) + ], + fm) + end + | L.EFfi ("Basis", "sql_no_offset") => ((L'.EPrim (Prim.String ""), loc), fm) diff --git a/tests/limit.ur b/tests/limit.ur index 5bfb1a81..03deb0b3 100644 --- a/tests/limit.ur +++ b/tests/limit.ur @@ -5,3 +5,23 @@ val q2 = fn n => (SELECT * FROM t LIMIT {n}) val q3 = (SELECT * FROM t OFFSET 3) val q4 = fn n => fn m => (SELECT * FROM t LIMIT {n} OFFSET {m}) + + +datatype list a = Nil | Cons of a * list a + +val r1 : transaction (list {A : int, B : string, C : float}) = + query (q2 3) + (fn fs acc => return (Cons (fs.T, acc))) + Nil + +val r2 : transaction string = + ls <- r1; + return (case ls of + Nil => "Problem" + | Cons ({B = b, ...}, _) => b) + +val main : unit -> transaction page = fn () => + s <- r2; + return <html><body> + {cdata s} + </body></html> |