adamc@623: (** Row folding *)
adamc@623: 
adamc@623: con folder = K ==> fn r :: {K} =>
adamc@623:                       tf :: ({K} -> Type)
adamc@623:                       -> (nm :: Name -> v :: K -> r :: {K} -> tf r
adamc@629:                           -> [[nm] ~ r] => tf ([nm = v] ++ r))
adamc@623:                       -> tf [] -> tf r
adamc@623: 
adamc@627: structure Folder = struct
adamc@631:     fun fold K (r ::: {K}) (fl : folder r) = fl
adamc@631: 
adamc@627:     fun nil K (tf :: {K} -> Type)
adamc@627:             (f : nm :: Name -> v :: K -> r :: {K} -> tf r
adamc@629:                  -> [[nm] ~ r] => tf ([nm = v] ++ r))
adamc@627:             (i : tf []) = i
adamc@627: 
adamc@627:     fun cons K (r ::: {K}) (nm :: Name) (v :: K) [[nm] ~ r] (fold : folder r)
adamc@627:              (tf :: {K} -> Type)
adamc@627:              (f : nm :: Name -> v :: K -> r :: {K} -> tf r
adamc@629:                   -> [[nm] ~ r] => tf ([nm = v] ++ r))
adamc@629:              (i : tf []) = f [nm] [v] [r] (fold [tf] f i) !
adamc@628: 
adamc@628:     fun concat K (r1 ::: {K}) (r2 ::: {K}) [r1 ~ r2]
adamc@628:         (f1 : folder r1) (f2 : folder r2)
adamc@628:         (tf :: {K} -> Type)
adamc@628:         (f : nm :: Name -> v :: K -> r :: {K} -> tf r
adamc@629:              -> [[nm] ~ r] => tf ([nm = v] ++ r))
adamc@628:         (i : tf []) =
adamc@629:         f1 [fn r1' => [r1' ~ r2] => tf (r1' ++ r2)]
adamc@629:            (fn (nm :: Name) (v :: K) (r1' :: {K}) (acc : [r1' ~ r2] => tf (r1' ++ r2))
adamc@628:                             [[nm] ~ r1'] [[nm = v] ++ r1' ~ r2] =>
adamc@629:                f [nm] [v] [r1' ++ r2] acc !)
adamc@629:            (fn [[] ~ r2] => f2 [tf] f i) !
adamc@630: 
adamc@630:     fun mp K1 K2 (f ::: K1 -> K2) (r ::: {K1})
adamc@630:         (fold : folder r)
adamc@630:         (tf :: {K2} -> Type)
adamc@630:         (f : nm :: Name -> v :: K2 -> r :: {K2} -> tf r
adamc@630:              -> [[nm] ~ r] => tf ([nm = v] ++ r))
adamc@630:         (i : tf []) =
adamc@630:         fold [fn r => tf (map f r)]
adamc@630:         (fn (nm :: Name) (v :: K1) (rest :: {K1}) (acc : tf (map f rest)) [[nm] ~ rest] =>
adamc@630:             f [nm] [f v] [map f rest] acc !)
adamc@630:         i
adamc@627: end
adamc@627: 
adamc@623: 
adamc@422: fun not b = if b then False else True
adamc@422: 
adamc@356: con idT (t :: Type) = t
adamc@356: con record (t :: {Type}) = $t
adamc@637: con fst = K1 ==> K2 ==> fn t :: (K1 * K2) => t.1
adamc@637: con snd = K1 ==> K2 ==> fn t :: (K1 * K2) => t.2
adamc@637: con fst3 = K1 ==> K2 ==> K3 ==> fn t :: (K1 * K2 * K3) => t.1
adamc@637: con snd3 = K1 ==> K2 ==> K3 ==> fn t :: (K1 * K2 * K3) => t.2
adamc@637: con thd3 = K1 ==> K2 ==> K3 ==> fn t :: (K1 * K2 * K3) => t.3
adamc@329: 
adamc@621: con mapUT = fn f :: Type => map (fn _ :: Unit => f)
adamc@445: 
adamc@339: con ex = fn tf :: (Type -> Type) =>
adamc@356:             res ::: Type -> (choice :: Type -> tf choice -> res) -> res
adamc@339: 
adamc@339: fun ex (tf :: (Type -> Type)) (choice :: Type) (body : tf choice) : ex tf =
adamc@356:  fn (res ::: Type) (f : choice :: Type -> tf choice -> res) =>
adamc@356:     f [choice] body
adamc@339: 
adamc@356: fun compose (t1 ::: Type) (t2 ::: Type) (t3 ::: Type)
adamc@356:             (f1 : t2 -> t3) (f2 : t1 -> t2) (x : t1) = f1 (f2 x)
adamc@325: 
adamc@564: fun txt (t ::: Type) (ctx ::: {Unit}) (use ::: {Type}) (_ : show t) (v : t) =
adamc@564:     cdata (show v)
adamc@328: 
adamc@411: fun foldUR (tf :: Type) (tr :: {Unit} -> Type)
adamc@411:            (f : nm :: Name -> rest :: {Unit}
adamc@629:                 -> [[nm] ~ rest] =>
adamc@411:                       tf -> tr rest -> tr ([nm] ++ rest))
adamc@632:            (i : tr []) (r :: {Unit}) (fold : folder r)=
adamc@411:     fold [fn r :: {Unit} => $(mapUT tf r) -> tr r]
adamc@623:          (fn (nm :: Name) (t :: Unit) (rest :: {Unit}) acc
adamc@623:                           [[nm] ~ rest] r =>
adamc@629:              f [nm] [rest] ! r.nm (acc (r -- nm)))
adamc@623:          (fn _ => i)
adamc@411: 
adamc@418: fun foldUR2 (tf1 :: Type) (tf2 :: Type) (tr :: {Unit} -> Type)
adamc@418:            (f : nm :: Name -> rest :: {Unit}
adamc@629:                 -> [[nm] ~ rest] =>
adamc@418:                       tf1 -> tf2 -> tr rest -> tr ([nm] ++ rest))
adamc@632:            (i : tr []) (r :: {Unit}) (fold : folder r) =
adamc@418:     fold [fn r :: {Unit} => $(mapUT tf1 r) -> $(mapUT tf2 r) -> tr r]
adamc@623:          (fn (nm :: Name) (t :: Unit) (rest :: {Unit}) acc
adamc@623:                           [[nm] ~ rest] r1 r2 =>
adamc@629:              f [nm] [rest] ! r1.nm r2.nm (acc (r1 -- nm) (r2 -- nm)))
adamc@623:          (fn _ _ => i)
adamc@418: 
adamc@418: fun foldURX2 (tf1 :: Type) (tf2 :: Type) (ctx :: {Unit})
adamc@418:            (f : nm :: Name -> rest :: {Unit}
adamc@629:                 -> [[nm] ~ rest] =>
adamc@418:                       tf1 -> tf2 -> xml ctx [] []) =
adamc@418:     foldUR2 [tf1] [tf2] [fn _ => xml ctx [] []]
adamc@418:             (fn (nm :: Name) (rest :: {Unit}) [[nm] ~ rest] v1 v2 acc =>
adamc@629:                 <xml>{f [nm] [rest] ! v1 v2}{acc}</xml>)
adamc@418:             <xml/>
adamc@418: 
adamc@623: fun foldR K (tf :: K -> Type) (tr :: {K} -> Type)
adamc@623:            (f : nm :: Name -> t :: K -> rest :: {K}
adamc@629:                 -> [[nm] ~ rest] =>
adamc@356:                       tf t -> tr rest -> tr ([nm = t] ++ rest))
adamc@632:            (i : tr []) (r :: {K}) (fold : folder r) =
adamc@623:     fold [fn r :: {K} => $(map tf r) -> tr r]
adamc@623:              (fn (nm :: Name) (t :: K) (rest :: {K}) (acc : _ -> tr rest)
adamc@356:                               [[nm] ~ rest] r =>
adamc@629:                  f [nm] [t] [rest] ! r.nm (acc (r -- nm)))
adamc@356:              (fn _ => i)
adamc@336: 
adamc@623: fun foldR2 K (tf1 :: K -> Type) (tf2 :: K -> Type) (tr :: {K} -> Type)
adamc@623:             (f : nm :: Name -> t :: K -> rest :: {K}
adamc@629:                  -> [[nm] ~ rest] =>
adamc@367:                        tf1 t -> tf2 t -> tr rest -> tr ([nm = t] ++ rest))
adamc@632:             (i : tr []) (r :: {K}) (fold : folder r) =
adamc@623:     fold [fn r :: {K} => $(map tf1 r) -> $(map tf2 r) -> tr r]
adamc@623:          (fn (nm :: Name) (t :: K) (rest :: {K})
adamc@623:                           (acc : _ -> _ -> tr rest) [[nm] ~ rest] r1 r2 =>
adamc@629:              f [nm] [t] [rest] ! r1.nm r2.nm (acc (r1 -- nm) (r2 -- nm)))
adamc@623:          (fn _ _ => i)
adamc@332: 
adamc@623: fun foldRX K (tf :: K -> Type) (ctx :: {Unit})
adamc@623:             (f : nm :: Name -> t :: K -> rest :: {K}
adamc@629:                  -> [[nm] ~ rest] =>
adamc@356:                        tf t -> xml ctx [] []) =
adamc@623:     foldR [tf] [fn _ => xml ctx [] []]
adamc@623:           (fn (nm :: Name) (t :: K) (rest :: {K}) [[nm] ~ rest] r acc =>
adamc@629:               <xml>{f [nm] [t] [rest] ! r}{acc}</xml>)
adamc@623:           <xml/>
adamc@336: 
adamc@623: fun foldRX2 K (tf1 :: K -> Type) (tf2 :: K -> Type) (ctx :: {Unit})
adamc@623:              (f : nm :: Name -> t :: K -> rest :: {K}
adamc@629:                   -> [[nm] ~ rest] =>
adamc@356:                         tf1 t -> tf2 t -> xml ctx [] []) =
adamc@623:     foldR2 [tf1] [tf2] [fn _ => xml ctx [] []]
adamc@623:            (fn (nm :: Name) (t :: K) (rest :: {K}) [[nm] ~ rest]
adamc@623:                             r1 r2 acc =>
adamc@629:                <xml>{f [nm] [t] [rest] ! r1 r2}{acc}</xml>)
adamc@623:            <xml/>
adamc@445: 
adamc@356: fun queryX (tables ::: {{Type}}) (exps ::: {Type}) (ctx ::: {Unit})
adamc@632:            [tables ~ exps] (q : sql_query tables exps)
adamc@621:            (f : $(exps ++ map (fn fields :: {Type} => $fields) tables)
adamc@356:                 -> xml ctx [] []) =
adamc@356:     query q
adamc@356:           (fn fs acc => return <xml>{acc}{f fs}</xml>)
adamc@360:           <xml/>
adamc@341: 
adamc@469: fun queryX' (tables ::: {{Type}}) (exps ::: {Type}) (ctx ::: {Unit})
adamc@632:             [tables ~ exps] (q : sql_query tables exps)
adamc@621:             (f : $(exps ++ map (fn fields :: {Type} => $fields) tables)
adamc@469:                  -> transaction (xml ctx [] [])) =
adamc@469:     query q
adamc@469:           (fn fs acc =>
adamc@469:               r <- f fs;
adamc@469:               return <xml>{acc}{r}</xml>)
adamc@469:           <xml/>
adamc@469: 
adamc@356: fun oneOrNoRows (tables ::: {{Type}}) (exps ::: {Type})
adamc@629:                 [tables ~ exps]
adamc@629:                 (q : sql_query tables exps)  =
adamc@356:     query q
adamc@356:           (fn fs _ => return (Some fs))
adamc@356:           None
adamc@440: 
adamc@440: fun oneRow (tables ::: {{Type}}) (exps ::: {Type})
adamc@629:                 [tables ~ exps] (q : sql_query tables exps) =
adamc@440:     o <- oneOrNoRows q;
adamc@440:     return (case o of
adamc@440:                 None => error <xml>Query returned no rows</xml>
adamc@440:               | Some r => r)
adamc@440: 
adamc@470: fun eqNullable (tables ::: {{Type}}) (agg ::: {{Type}}) (exps ::: {Type})
adamc@470:     (t ::: Type) (_ : sql_injectable (option t))
adamc@470:     (e1 : sql_exp tables agg exps (option t))
adamc@470:     (e2 : sql_exp tables agg exps (option t)) =
adamc@471:     (SQL ({e1} IS NULL AND {e2} IS NULL) OR {e1} = {e2})
adamc@470: 
adamc@470: fun eqNullable' (tables ::: {{Type}}) (agg ::: {{Type}}) (exps ::: {Type})
adamc@564:     (t ::: Type) (_ : sql_injectable (option t))
adamc@470:     (e1 : sql_exp tables agg exps (option t))
adamc@470:     (e2 : option t) =
adamc@470:     case e2 of
adamc@471:         None => (SQL {e1} IS NULL)
adamc@564:       | Some _ => sql_binary sql_eq e1 (sql_inject e2)