annotate lib/ur/basis.urs @ 751:f95d652086cd

RIGHT and FULL JOIN
author Adam Chlipala <adamc@hcoop.net>
date Tue, 28 Apr 2009 11:14:24 -0400
parents 059074c8d2fc
children d484df4e841a
rev   line source
adamc@56 1 type int
adamc@56 2 type float
adamc@56 3 type string
adamc@436 4 type time
adamc@737 5 type blob
adamc@91 6
adamc@119 7 type unit = {}
adamc@119 8
adamc@186 9 datatype bool = False | True
adamc@186 10
adamc@288 11 datatype option t = None | Some of t
adamc@284 12
adamc@91 13
adamc@256 14 (** Basic type classes *)
adamc@256 15
adamc@256 16 class eq
adamc@256 17 val eq : t ::: Type -> eq t -> t -> t -> bool
adamc@257 18 val ne : t ::: Type -> eq t -> t -> t -> bool
adamc@256 19 val eq_int : eq int
adamc@394 20 val eq_float : eq float
adamc@256 21 val eq_string : eq string
adamc@256 22 val eq_bool : eq bool
adamc@437 23 val eq_time : eq time
adamc@422 24 val mkEq : t ::: Type -> (t -> t -> bool) -> eq t
adamc@256 25
adamc@389 26 class num
adamc@417 27 val zero : t ::: Type -> num t -> t
adamc@389 28 val neg : t ::: Type -> num t -> t -> t
adamc@389 29 val plus : t ::: Type -> num t -> t -> t -> t
adamc@389 30 val minus : t ::: Type -> num t -> t -> t -> t
adamc@389 31 val times : t ::: Type -> num t -> t -> t -> t
adamc@389 32 val div : t ::: Type -> num t -> t -> t -> t
adamc@389 33 val mod : t ::: Type -> num t -> t -> t -> t
adamc@389 34 val num_int : num int
adamc@390 35 val num_float : num float
adamc@389 36
adamc@391 37 class ord
adamc@391 38 val lt : t ::: Type -> ord t -> t -> t -> bool
adamc@391 39 val le : t ::: Type -> ord t -> t -> t -> bool
adamc@391 40 val gt : t ::: Type -> ord t -> t -> t -> bool
adamc@391 41 val ge : t ::: Type -> ord t -> t -> t -> bool
adamc@391 42 val ord_int : ord int
adamc@394 43 val ord_float : ord float
adamc@394 44 val ord_string : ord string
adamc@394 45 val ord_bool : ord bool
adamc@437 46 val ord_time : ord time
adamc@391 47
adamc@256 48
adamc@283 49 (** String operations *)
adamc@283 50
adamc@283 51 val strcat : string -> string -> string
adamc@283 52
adamc@286 53 class show
adamc@286 54 val show : t ::: Type -> show t -> t -> string
adamc@286 55 val show_int : show int
adamc@286 56 val show_float : show float
adamc@286 57 val show_string : show string
adamc@286 58 val show_bool : show bool
adamc@436 59 val show_time : show time
adamc@452 60 val mkShow : t ::: Type -> (t -> string) -> show t
adamc@286 61
adamc@290 62 class read
adamc@290 63 val read : t ::: Type -> read t -> string -> option t
adamc@292 64 val readError : t ::: Type -> read t -> string -> t
adamc@292 65 (* [readError] calls [error] if the input is malformed. *)
adamc@290 66 val read_int : read int
adamc@290 67 val read_float : read float
adamc@290 68 val read_string : read string
adamc@290 69 val read_bool : read bool
adamc@436 70 val read_time : read time
adamc@288 71
adamc@283 72
adamc@564 73 (** * Monads *)
adamc@564 74
adamc@711 75 class monad :: (Type -> Type) -> Type
adamc@564 76 val return : m ::: (Type -> Type) -> t ::: Type
adamc@564 77 -> monad m
adamc@564 78 -> t -> m t
adamc@564 79 val bind : m ::: (Type -> Type) -> t1 ::: Type -> t2 ::: Type
adamc@564 80 -> monad m
adamc@564 81 -> m t1 -> (t1 -> m t2)
adamc@564 82 -> m t2
adamc@564 83
adamc@456 84 con transaction :: Type -> Type
adamc@564 85 val transaction_monad : monad transaction
adamc@456 86
adamc@565 87 con source :: Type -> Type
adamc@565 88 val source : t ::: Type -> t -> transaction (source t)
adamc@575 89 val set : t ::: Type -> source t -> t -> transaction unit
adamc@601 90 val get : t ::: Type -> source t -> transaction t
adamc@565 91
adamc@565 92 con signal :: Type -> Type
adamc@565 93 val signal_monad : monad signal
adamc@565 94 val signal : t ::: Type -> source t -> signal t
adamc@456 95
adamc@456 96
adamc@456 97 (** HTTP operations *)
adamc@456 98
adamc@456 99 val requestHeader : string -> transaction (option string)
adamc@456 100
adamc@459 101 con http_cookie :: Type -> Type
adamc@459 102 val getCookie : t ::: Type -> http_cookie t -> transaction (option t)
adamc@459 103 val setCookie : t ::: Type -> http_cookie t -> t -> transaction unit
adamc@459 104
adamc@456 105
adamc@566 106 (** JavaScript-y gadgets *)
adamc@566 107
adamc@566 108 val alert : string -> transaction unit
adamc@694 109 val spawn : transaction unit -> transaction unit
adamc@695 110 val sleep : int -> transaction unit
adamc@566 111
adamc@566 112
adamc@678 113 (** Channels *)
adamc@678 114
adamc@678 115 con channel :: Type -> Type
adamc@678 116 val channel : t ::: Type -> transaction (channel t)
adamc@678 117 val send : t ::: Type -> channel t -> t -> transaction unit
adamc@678 118 val recv : t ::: Type -> channel t -> transaction t
adamc@678 119
adamc@682 120 type client
adamc@682 121 val self : transaction client
adamc@682 122
adamc@678 123
adamc@203 124 (** SQL *)
adamc@203 125
adamc@705 126 con sql_table :: {Type} -> {{Unit}} -> Type
adamc@203 127
adamc@704 128 (*** Constraints *)
adamc@704 129
adamc@707 130 (**** Primary keys *)
adamc@707 131
adamc@707 132 class sql_injectable_prim
adamc@707 133 val sql_bool : sql_injectable_prim bool
adamc@707 134 val sql_int : sql_injectable_prim int
adamc@707 135 val sql_float : sql_injectable_prim float
adamc@707 136 val sql_string : sql_injectable_prim string
adamc@707 137 val sql_time : sql_injectable_prim time
adamc@737 138 val sql_blob : sql_injectable_prim blob
adamc@707 139 val sql_channel : t ::: Type -> sql_injectable_prim (channel t)
adamc@707 140 val sql_client : sql_injectable_prim client
adamc@707 141
adamc@707 142 con primary_key :: {Type} -> {{Unit}} -> Type
adamc@707 143 val no_primary_key : fs ::: {Type} -> primary_key fs []
adamc@707 144 val primary_key : rest ::: {Type} -> t ::: Type -> key1 :: Name -> keys :: {Type}
adamc@707 145 -> [[key1] ~ keys] => [[key1 = t] ++ keys ~ rest]
adamc@707 146 => $([key1 = sql_injectable_prim t] ++ map sql_injectable_prim keys)
adamc@707 147 -> primary_key ([key1 = t] ++ keys ++ rest)
adamc@707 148 [Pkey = [key1] ++ map (fn _ => ()) keys]
adamc@707 149
adamc@707 150 (**** Other constraints *)
adamc@707 151
adamc@705 152 con sql_constraints :: {Type} -> {{Unit}} -> Type
adamc@705 153 (* Arguments: column types, uniqueness implications of constraints *)
adamc@704 154
adamc@705 155 con sql_constraint :: {Type} -> {Unit} -> Type
adamc@704 156
adamc@705 157 val no_constraint : fs ::: {Type} -> sql_constraints fs []
adamc@705 158 val one_constraint : fs ::: {Type} -> unique ::: {Unit} -> name :: Name
adamc@705 159 -> sql_constraint fs unique
adamc@705 160 -> sql_constraints fs [name = unique]
adamc@705 161 val join_constraints : fs ::: {Type}
adamc@705 162 -> uniques1 ::: {{Unit}} -> uniques2 ::: {{Unit}} -> [uniques1 ~ uniques2]
adamc@705 163 => sql_constraints fs uniques1 -> sql_constraints fs uniques2
adamc@705 164 -> sql_constraints fs (uniques1 ++ uniques2)
adamc@705 165
adamc@709 166
adamc@705 167 val unique : rest ::: {Type} -> t ::: Type -> unique1 :: Name -> unique :: {Type}
adamc@705 168 -> [[unique1] ~ unique] => [[unique1 = t] ++ unique ~ rest]
adamc@705 169 => sql_constraint ([unique1 = t] ++ unique ++ rest) ([unique1] ++ map (fn _ => ()) unique)
adamc@704 170
adamc@712 171 class linkable :: Type -> Type -> Type
adamc@712 172 val linkable_same : t ::: Type -> linkable t t
adamc@712 173 val linkable_from_nullable : t ::: Type -> linkable (option t) t
adamc@712 174 val linkable_to_nullable : t ::: Type -> linkable t (option t)
adamc@712 175
adamc@709 176 con matching :: {Type} -> {Type} -> Type
adamc@709 177 val mat_nil : matching [] []
adamc@712 178 val mat_cons : t1 ::: Type -> rest1 ::: {Type} -> t2 ::: Type -> rest2 ::: {Type}
adamc@709 179 -> nm1 :: Name -> nm2 :: Name
adamc@709 180 -> [[nm1] ~ rest1] => [[nm2] ~ rest2]
adamc@712 181 => linkable t1 t2
adamc@712 182 -> matching rest1 rest2
adamc@712 183 -> matching ([nm1 = t1] ++ rest1) ([nm2 = t2] ++ rest2)
adamc@709 184
adamc@709 185 con propagation_mode :: {Type} -> Type
adamc@709 186 val restrict : fs ::: {Type} -> propagation_mode fs
adamc@709 187 val cascade : fs ::: {Type} -> propagation_mode fs
adamc@709 188 val no_action : fs ::: {Type} -> propagation_mode fs
adamc@709 189 val set_null : fs ::: {Type} -> propagation_mode (map option fs)
adamc@709 190
adamc@709 191
adamc@709 192 val foreign_key : mine1 ::: Name -> t ::: Type -> mine ::: {Type} -> munused ::: {Type}
adamc@709 193 -> foreign ::: {Type} -> funused ::: {Type}
adamc@709 194 -> nm ::: Name -> uniques ::: {{Unit}}
adamc@709 195 -> [[mine1] ~ mine] => [[mine1 = t] ++ mine ~ munused]
adamc@709 196 => [foreign ~ funused] => [[nm] ~ uniques]
adamc@709 197 => matching ([mine1 = t] ++ mine) foreign
adamc@709 198 -> sql_table (foreign ++ funused) ([nm = map (fn _ => ()) foreign] ++ uniques)
adamc@709 199 -> {OnDelete : propagation_mode ([mine1 = t] ++ mine),
adamc@709 200 OnUpdate : propagation_mode ([mine1 = t] ++ mine)}
adamc@709 201 -> sql_constraint ([mine1 = t] ++ mine ++ munused) []
adamc@709 202
adamc@714 203 con sql_exp :: {{Type}} -> {{Type}} -> {Type} -> Type -> Type
adamc@714 204
adamc@714 205 val check : fs ::: {Type}
adamc@714 206 -> sql_exp [] [] fs bool
adamc@714 207 -> sql_constraint fs []
adamc@714 208
adamc@714 209
adamc@704 210
adamc@204 211 (*** Queries *)
adamc@204 212
adamc@233 213 con sql_query :: {{Type}} -> {Type} -> Type
adamc@233 214 con sql_query1 :: {{Type}} -> {{Type}} -> {Type} -> Type
adamc@204 215
adamc@223 216 con sql_subset :: {{Type}} -> {{Type}} -> Type
adamc@223 217 val sql_subset : keep_drop :: {({Type} * {Type})}
adamc@354 218 -> sql_subset
adamc@621 219 (map (fn fields :: ({Type} * {Type}) => fields.1 ++ fields.2) keep_drop)
adamc@621 220 (map (fn fields :: ({Type} * {Type}) => fields.1) keep_drop)
adamc@354 221 val sql_subset_all : tables :: {{Type}} -> sql_subset tables tables
adamc@223 222
adamc@748 223 con sql_from_items :: {{Type}} -> Type
adamc@748 224
adamc@748 225 val sql_from_table : cols ::: {Type} -> keys ::: {{Unit}}
adamc@748 226 -> name :: Name -> sql_table cols keys
adamc@748 227 -> sql_from_items [name = cols]
adamc@748 228 val sql_from_comma : tabs1 ::: {{Type}} -> tabs2 ::: {{Type}}
adamc@748 229 -> [tabs1 ~ tabs2]
adamc@748 230 => sql_from_items tabs1 -> sql_from_items tabs2
adamc@748 231 -> sql_from_items (tabs1 ++ tabs2)
adamc@749 232 val sql_inner_join : tabs1 ::: {{Type}} -> tabs2 ::: {{Type}}
adamc@749 233 -> [tabs1 ~ tabs2]
adamc@749 234 => sql_from_items tabs1 -> sql_from_items tabs2
adamc@749 235 -> sql_exp (tabs1 ++ tabs2) [] [] bool
adamc@749 236 -> sql_from_items (tabs1 ++ tabs2)
adamc@748 237
adamc@750 238 class nullify :: Type -> Type -> Type
adamc@750 239 val nullify_option : t ::: Type -> nullify (option t) (option t)
adamc@750 240 val nullify_prim : t ::: Type -> sql_injectable_prim t -> nullify t (option t)
adamc@750 241
adamc@750 242 val sql_left_join : tabs1 ::: {{Type}} -> tabs2 ::: {{(Type * Type)}}
adamc@750 243 -> [tabs1 ~ tabs2]
adamc@750 244 => $(map (fn r => $(map (fn p :: (Type * Type) => nullify p.1 p.2) r)) tabs2)
adamc@750 245 -> sql_from_items tabs1 -> sql_from_items (map (map (fn p :: (Type * Type) => p.1)) tabs2)
adamc@750 246 -> sql_exp (tabs1 ++ map (map (fn p :: (Type * Type) => p.1)) tabs2) [] [] bool
adamc@750 247 -> sql_from_items (tabs1 ++ map (map (fn p :: (Type * Type) => p.2)) tabs2)
adamc@750 248
adamc@751 249 val sql_right_join : tabs1 ::: {{(Type * Type)}} -> tabs2 ::: {{Type}}
adamc@751 250 -> [tabs1 ~ tabs2]
adamc@751 251 => $(map (fn r => $(map (fn p :: (Type * Type) => nullify p.1 p.2) r)) tabs1)
adamc@751 252 -> sql_from_items (map (map (fn p :: (Type * Type) => p.1)) tabs1) -> sql_from_items tabs2
adamc@751 253 -> sql_exp (map (map (fn p :: (Type * Type) => p.1)) tabs1 ++ tabs2) [] [] bool
adamc@751 254 -> sql_from_items (map (map (fn p :: (Type * Type) => p.2)) tabs1 ++ tabs2)
adamc@751 255
adamc@751 256 val sql_full_join : tabs1 ::: {{(Type * Type)}} -> tabs2 ::: {{(Type * Type)}}
adamc@751 257 -> [tabs1 ~ tabs2]
adamc@751 258 => $(map (fn r => $(map (fn p :: (Type * Type) => nullify p.1 p.2) r)) (tabs1 ++ tabs2))
adamc@751 259 -> sql_from_items (map (map (fn p :: (Type * Type) => p.1)) tabs1)
adamc@751 260 -> sql_from_items (map (map (fn p :: (Type * Type) => p.1)) tabs2)
adamc@751 261 -> sql_exp (map (map (fn p :: (Type * Type) => p.1)) (tabs1 ++ tabs2)) [] [] bool
adamc@751 262 -> sql_from_items (map (map (fn p :: (Type * Type) => p.2)) (tabs1 ++ tabs2))
adamc@751 263
adamc@748 264 val sql_query1 : tables ::: {{Type}}
adamc@354 265 -> grouped ::: {{Type}}
adamc@354 266 -> selectedFields ::: {{Type}}
adamc@354 267 -> selectedExps ::: {Type}
adamc@748 268 -> {From : sql_from_items tables,
adamc@748 269 Where : sql_exp tables [] [] bool,
adamc@748 270 GroupBy : sql_subset tables grouped,
adamc@748 271 Having : sql_exp grouped tables [] bool,
adamc@354 272 SelectFields : sql_subset grouped selectedFields,
adamc@748 273 SelectExps : $(map (sql_exp grouped tables [])
adamc@705 274 selectedExps) }
adamc@748 275 -> sql_query1 tables selectedFields selectedExps
adamc@229 276
adamc@229 277 type sql_relop
adamc@229 278 val sql_union : sql_relop
adamc@229 279 val sql_intersect : sql_relop
adamc@229 280 val sql_except : sql_relop
adamc@260 281 val sql_relop : tables1 ::: {{Type}}
adamc@354 282 -> tables2 ::: {{Type}}
adamc@354 283 -> selectedFields ::: {{Type}}
adamc@354 284 -> selectedExps ::: {Type}
adamc@354 285 -> sql_relop
adamc@354 286 -> sql_query1 tables1 selectedFields selectedExps
adamc@354 287 -> sql_query1 tables2 selectedFields selectedExps
adamc@354 288 -> sql_query1 selectedFields selectedFields selectedExps
adamc@229 289
adamc@230 290 type sql_direction
adamc@230 291 val sql_asc : sql_direction
adamc@230 292 val sql_desc : sql_direction
adamc@230 293
adamc@234 294 con sql_order_by :: {{Type}} -> {Type} -> Type
adamc@234 295 val sql_order_by_Nil : tables ::: {{Type}} -> exps :: {Type} -> sql_order_by tables exps
adamc@234 296 val sql_order_by_Cons : tables ::: {{Type}} -> exps ::: {Type} -> t ::: Type
adamc@354 297 -> sql_exp tables [] exps t -> sql_direction
adamc@354 298 -> sql_order_by tables exps
adamc@354 299 -> sql_order_by tables exps
adamc@230 300
adamc@231 301 type sql_limit
adamc@231 302 val sql_no_limit : sql_limit
adamc@231 303 val sql_limit : int -> sql_limit
adamc@354 304
adamc@232 305 type sql_offset
adamc@232 306 val sql_no_offset : sql_offset
adamc@232 307 val sql_offset : int -> sql_offset
adamc@232 308
adamc@229 309 val sql_query : tables ::: {{Type}}
adamc@354 310 -> selectedFields ::: {{Type}}
adamc@354 311 -> selectedExps ::: {Type}
adamc@354 312 -> {Rows : sql_query1 tables selectedFields selectedExps,
adamc@354 313 OrderBy : sql_order_by tables selectedExps,
adamc@354 314 Limit : sql_limit,
adamc@354 315 Offset : sql_offset}
adamc@354 316 -> sql_query selectedFields selectedExps
adamc@204 317
adamc@354 318 val sql_field : otherTabs ::: {{Type}} -> otherFields ::: {Type}
adamc@354 319 -> fieldType ::: Type -> agg ::: {{Type}}
adamc@354 320 -> exps ::: {Type}
adamc@354 321 -> tab :: Name -> field :: Name
adamc@354 322 -> sql_exp
adamc@354 323 ([tab = [field = fieldType] ++ otherFields] ++ otherTabs)
adamc@354 324 agg exps fieldType
adamc@234 325
adamc@354 326 val sql_exp : tabs ::: {{Type}} -> agg ::: {{Type}} -> t ::: Type -> rest ::: {Type}
adamc@354 327 -> nm :: Name
adamc@354 328 -> sql_exp tabs agg ([nm = t] ++ rest) t
adamc@209 329
adamc@221 330 class sql_injectable
adamc@676 331 val sql_prim : t ::: Type -> sql_injectable_prim t -> sql_injectable t
adamc@676 332 val sql_option_prim : t ::: Type -> sql_injectable_prim t -> sql_injectable (option t)
adamc@676 333
adamc@354 334 val sql_inject : tables ::: {{Type}} -> agg ::: {{Type}} -> exps ::: {Type}
adamc@354 335 -> t ::: Type
adamc@354 336 -> sql_injectable t -> t -> sql_exp tables agg exps t
adamc@209 337
adamc@470 338 val sql_is_null : tables ::: {{Type}} -> agg ::: {{Type}} -> exps ::: {Type}
adamc@470 339 -> t ::: Type
adamc@470 340 -> sql_exp tables agg exps (option t)
adamc@470 341 -> sql_exp tables agg exps bool
adamc@470 342
adamc@559 343 class sql_arith
adamc@559 344 val sql_int_arith : sql_arith int
adamc@559 345 val sql_float_arith : sql_arith float
adamc@559 346
adamc@220 347 con sql_unary :: Type -> Type -> Type
adamc@220 348 val sql_not : sql_unary bool bool
adamc@354 349 val sql_unary : tables ::: {{Type}} -> agg ::: {{Type}} -> exps ::: {Type}
adamc@354 350 -> arg ::: Type -> res ::: Type
adamc@354 351 -> sql_unary arg res -> sql_exp tables agg exps arg
adamc@354 352 -> sql_exp tables agg exps res
adamc@220 353
adamc@559 354 val sql_neg : t ::: Type -> sql_arith t -> sql_unary t t
adamc@559 355
adamc@220 356 con sql_binary :: Type -> Type -> Type -> Type
adamc@220 357 val sql_and : sql_binary bool bool bool
adamc@220 358 val sql_or : sql_binary bool bool bool
adamc@234 359 val sql_binary : tables ::: {{Type}} -> agg ::: {{Type}} -> exps ::: {Type}
adamc@354 360 -> arg1 ::: Type -> arg2 ::: Type -> res ::: Type
adamc@354 361 -> sql_binary arg1 arg2 res -> sql_exp tables agg exps arg1
adamc@354 362 -> sql_exp tables agg exps arg2
adamc@354 363 -> sql_exp tables agg exps res
adamc@220 364
adamc@559 365 val sql_plus : t ::: Type -> sql_arith t -> sql_binary t t t
adamc@559 366 val sql_minus : t ::: Type -> sql_arith t -> sql_binary t t t
adamc@559 367 val sql_times : t ::: Type -> sql_arith t -> sql_binary t t t
adamc@559 368 val sql_div : t ::: Type -> sql_arith t -> sql_binary t t t
adamc@559 369 val sql_mod : sql_binary int int int
adamc@559 370
adamc@559 371 val sql_eq : t ::: Type -> sql_binary t t bool
adamc@559 372 val sql_ne : t ::: Type -> sql_binary t t bool
adamc@559 373 val sql_lt : t ::: Type -> sql_binary t t bool
adamc@559 374 val sql_le : t ::: Type -> sql_binary t t bool
adamc@559 375 val sql_gt : t ::: Type -> sql_binary t t bool
adamc@559 376 val sql_ge : t ::: Type -> sql_binary t t bool
adamc@203 377
adamc@235 378 val sql_count : tables ::: {{Type}} -> agg ::: {{Type}} -> exps ::: {Type}
adamc@544 379 -> sql_exp tables agg exps int
adamc@235 380
adamc@236 381 con sql_aggregate :: Type -> Type
adamc@354 382 val sql_aggregate : tables ::: {{Type}} -> agg ::: {{Type}} -> exps ::: {Type}
adamc@354 383 -> t ::: Type
adamc@354 384 -> sql_aggregate t -> sql_exp agg agg exps t
adamc@354 385 -> sql_exp tables agg exps t
adamc@236 386
adamc@236 387 class sql_summable
adamc@236 388 val sql_summable_int : sql_summable int
adamc@236 389 val sql_summable_float : sql_summable float
adamc@236 390 val sql_avg : t ::: Type -> sql_summable t -> sql_aggregate t
adamc@236 391 val sql_sum : t ::: Type -> sql_summable t -> sql_aggregate t
adamc@236 392
adamc@236 393 class sql_maxable
adamc@236 394 val sql_maxable_int : sql_maxable int
adamc@236 395 val sql_maxable_float : sql_maxable float
adamc@236 396 val sql_maxable_string : sql_maxable string
adamc@437 397 val sql_maxable_time : sql_maxable time
adamc@236 398 val sql_max : t ::: Type -> sql_maxable t -> sql_aggregate t
adamc@236 399 val sql_min : t ::: Type -> sql_maxable t -> sql_aggregate t
adamc@236 400
adamc@441 401 con sql_nfunc :: Type -> Type
adamc@441 402 val sql_nfunc : tables ::: {{Type}} -> agg ::: {{Type}} -> exps ::: {Type}
adamc@441 403 -> t ::: Type
adamc@441 404 -> sql_nfunc t -> sql_exp tables agg exps t
adamc@441 405 val sql_current_timestamp : sql_nfunc time
adamc@441 406
adamc@746 407 con sql_ufunc :: Type -> Type -> Type
adamc@746 408 val sql_ufunc : tables ::: {{Type}} -> agg ::: {{Type}} -> exps ::: {Type}
adamc@746 409 -> dom ::: Type -> ran ::: Type
adamc@746 410 -> sql_ufunc dom ran -> sql_exp tables agg exps dom
adamc@746 411 -> sql_exp tables agg exps ran
adamc@746 412 val sql_octet_length : sql_ufunc blob int
adamc@746 413
adamc@235 414
adamc@243 415 (*** Executing queries *)
adamc@243 416
adamc@354 417 val query : tables ::: {{Type}} -> exps ::: {Type}
adamc@629 418 -> [tables ~ exps] =>
adamc@354 419 state ::: Type
adamc@354 420 -> sql_query tables exps
adamc@621 421 -> ($(exps ++ map (fn fields :: {Type} => $fields) tables)
adamc@354 422 -> state
adamc@354 423 -> transaction state)
adamc@354 424 -> state
adamc@354 425 -> transaction state
adamc@243 426
adamc@243 427
adamc@299 428 (*** Database mutators *)
adamc@299 429
adamc@299 430 type dml
adamc@299 431 val dml : dml -> transaction unit
adamc@299 432
adamc@705 433 val insert : fields ::: {Type} -> uniques ::: {{Unit}}
adamc@705 434 -> sql_table fields uniques
adamc@621 435 -> $(map (fn t :: Type => sql_exp [] [] [] t) fields)
adamc@354 436 -> dml
adamc@299 437
adamc@705 438 val update : unchanged ::: {Type} -> uniques ::: {{Unit}} -> changed :: {Type} ->
adamc@629 439 [changed ~ unchanged] =>
adamc@621 440 $(map (fn t :: Type => sql_exp [T = changed ++ unchanged] [] [] t) changed)
adamc@705 441 -> sql_table (changed ++ unchanged) uniques
adamc@354 442 -> sql_exp [T = changed ++ unchanged] [] [] bool
adamc@354 443 -> dml
adamc@299 444
adamc@705 445 val delete : fields ::: {Type} -> uniques ::: {{Unit}}
adamc@705 446 -> sql_table fields uniques
adamc@354 447 -> sql_exp [T = fields] [] [] bool
adamc@354 448 -> dml
adamc@299 449
adamc@338 450 (*** Sequences *)
adamc@338 451
adamc@338 452 type sql_sequence
adamc@338 453 val nextval : sql_sequence -> transaction int
adamc@338 454
adamc@299 455
adamc@203 456 (** XML *)
adamc@203 457
adamc@721 458 type css_class
adamc@718 459
adamc@720 460 con tag :: {Type} -> {Unit} -> {Unit} -> {Type} -> {Type} -> Type
adamc@91 461
adamc@720 462 con xml :: {Unit} -> {Type} -> {Type} -> Type
adamc@720 463 val cdata : ctx ::: {Unit} -> use ::: {Type} -> string -> xml ctx use []
adamc@354 464 val tag : attrsGiven ::: {Type} -> attrsAbsent ::: {Type}
adamc@354 465 -> ctxOuter ::: {Unit} -> ctxInner ::: {Unit}
adamc@354 466 -> useOuter ::: {Type} -> useInner ::: {Type}
adamc@354 467 -> bindOuter ::: {Type} -> bindInner ::: {Type}
adamc@629 468 -> [attrsGiven ~ attrsAbsent] =>
adamc@629 469 [useOuter ~ useInner] =>
adamc@629 470 [bindOuter ~ bindInner] =>
adamc@721 471 option css_class
adamc@721 472 -> $attrsGiven
adamc@629 473 -> tag (attrsGiven ++ attrsAbsent)
adamc@720 474 ctxOuter ctxInner useOuter bindOuter
adamc@720 475 -> xml ctxInner useInner bindInner
adamc@720 476 -> xml ctxOuter (useOuter ++ useInner) (bindOuter ++ bindInner)
adamc@140 477 val join : ctx ::: {Unit}
adamc@720 478 -> use1 ::: {Type} -> bind1 ::: {Type} -> bind2 ::: {Type}
adamc@720 479 -> [use1 ~ bind1] => [bind1 ~ bind2] =>
adamc@720 480 xml ctx use1 bind1
adamc@720 481 -> xml ctx (use1 ++ bind1) bind2
adamc@720 482 -> xml ctx use1 (bind1 ++ bind2)
adamc@354 483 val useMore : ctx ::: {Unit} -> use1 ::: {Type} -> use2 ::: {Type}
adamc@720 484 -> bind ::: {Type}
adamc@629 485 -> [use1 ~ use2] =>
adamc@720 486 xml ctx use1 bind
adamc@720 487 -> xml ctx (use1 ++ use2) bind
adamc@91 488
adamc@110 489 con xhtml = xml [Html]
adamc@139 490 con page = xhtml [] []
adamc@720 491 con xbody = xml [Body] [] []
adamc@720 492 con xtr = xml [Body, Tr] [] []
adamc@720 493 con xform = xml [Body, Form] [] []
adamc@110 494
adamc@718 495
adamc@204 496 (*** HTML details *)
adamc@204 497
adamc@140 498 con html = [Html]
adamc@140 499 con head = [Head]
adamc@140 500 con body = [Body]
adamc@361 501 con form = [Body, Form]
adamc@332 502 con tabl = [Body, Table]
adamc@332 503 con tr = [Body, Tr]
adamc@93 504
adamc@724 505 type url
adamc@724 506 val bless : string -> url
adamc@724 507
adamc@720 508 val dyn : use ::: {Type} -> bind ::: {Type} -> unit
adamc@720 509 -> tag [Signal = signal (xml body use bind)] body [] use bind
adamc@568 510
adamc@720 511 val head : unit -> tag [] html head [] []
adamc@720 512 val title : unit -> tag [] head [] [] []
adamc@724 513 val link : unit -> tag [Rel = string, Typ = string, Href = url, Media = string] head [] [] []
adamc@110 514
adamc@720 515 val body : unit -> tag [Onload = transaction unit] html body [] []
adamc@354 516 con bodyTag = fn (attrs :: {Type}) =>
adamc@354 517 ctx ::: {Unit} ->
adamc@629 518 [[Body] ~ ctx] =>
adamc@720 519 unit -> tag attrs ([Body] ++ ctx) ([Body] ++ ctx) [] []
adamc@354 520 con bodyTagStandalone = fn (attrs :: {Type}) =>
adamc@354 521 ctx ::: {Unit}
adamc@629 522 -> [[Body] ~ ctx] =>
adamc@720 523 unit -> tag attrs ([Body] ++ ctx) [] [] []
adamc@141 524
adamc@141 525 val br : bodyTagStandalone []
adamc@119 526
adamc@691 527 val span : bodyTag []
adamc@691 528
adamc@140 529 val p : bodyTag []
adamc@140 530 val b : bodyTag []
adamc@140 531 val i : bodyTag []
adamc@407 532 val tt : bodyTag []
adamc@140 533 val font : bodyTag [Size = int, Face = string]
adamc@140 534
adamc@140 535 val h1 : bodyTag []
adamc@443 536 val h2 : bodyTag []
adamc@443 537 val h3 : bodyTag []
adamc@443 538 val h4 : bodyTag []
adamc@469 539
adamc@140 540 val li : bodyTag []
adamc@469 541 val ol : bodyTag []
adamc@469 542 val ul : bodyTag []
adamc@140 543
adamc@410 544 val hr : bodyTag []
adamc@410 545
adamc@720 546 val a : bodyTag [Link = transaction page, Href = url, Onclick = transaction unit]
adamc@717 547
adamc@717 548 val img : bodyTag [Src = url]
adamc@140 549
adamc@720 550 val form : ctx ::: {Unit} -> bind ::: {Type}
adamc@629 551 -> [[Body] ~ ctx] =>
adamc@720 552 xml form [] bind
adamc@720 553 -> xml ([Body] ++ ctx) [] []
adamc@361 554 con formTag = fn (ty :: Type) (inner :: {Unit}) (attrs :: {Type}) =>
adamc@354 555 ctx ::: {Unit}
adamc@629 556 -> [[Form] ~ ctx] =>
adamc@354 557 nm :: Name -> unit
adamc@720 558 -> tag attrs ([Form] ++ ctx) inner [] [nm = ty]
adamc@598 559 val textbox : formTag string [] [Value = string, Size = int, Source = source string]
adamc@444 560 val password : formTag string [] [Value = string, Size = int]
adamc@444 561 val textarea : formTag string [] [Rows = int, Cols = int]
adamc@153 562
adamc@361 563 val checkbox : formTag bool [] [Checked = bool]
adamc@190 564
adamc@737 565 type file
adamc@737 566 val fileName : file -> option string
adamc@740 567 val fileMimeType : file -> string
adamc@737 568 val fileData : file -> blob
adamc@737 569
adamc@739 570 val upload : formTag file [] [Value = string, Size = int]
adamc@737 571
adamc@741 572 type mimeType
adamc@741 573 val blessMime : string -> mimeType
adamc@741 574 val returnBlob : t ::: Type -> blob -> mimeType -> transaction t
adamc@745 575 val blobSize : blob -> int
adamc@741 576
adamc@153 577 con radio = [Body, Radio]
adamc@361 578 val radio : formTag string radio []
adamc@720 579 val radioOption : unit -> tag [Value = string] radio [] [] []
adamc@142 580
adamc@154 581 con select = [Select]
adamc@361 582 val select : formTag string select []
adamc@720 583 val option : unit -> tag [Value = string, Selected = bool] select [] [] []
adamc@154 584
adamc@720 585 val submit : ctx ::: {Unit} -> use ::: {Type}
adamc@629 586 -> [[Form] ~ ctx] =>
adamc@354 587 unit
adamc@720 588 -> tag [Value = string, Action = $use -> transaction page]
adamc@720 589 ([Form] ++ ctx) ([Form] ++ ctx) use []
adamc@283 590
adamc@601 591 (*** AJAX-oriented widgets *)
adamc@601 592
adamc@601 593 con cformTag = fn (attrs :: {Type}) =>
adamc@601 594 ctx ::: {Unit}
adamc@629 595 -> [[Body] ~ ctx] =>
adamc@720 596 unit -> tag attrs ([Body] ++ ctx) [] [] []
adamc@601 597
adamc@601 598 val ctextbox : cformTag [Value = string, Size = int, Source = source string]
adamc@601 599 val button : cformTag [Value = string, Onclick = transaction unit]
adamc@601 600
adamc@720 601 (*** Tables *)
adamc@720 602
adamc@720 603 val tabl : other ::: {Unit} -> [other ~ [Body, Table]] =>
adamc@720 604 unit -> tag [Border = int] ([Body] ++ other) ([Body, Table] ++ other) [] []
adamc@720 605 val tr : other ::: {Unit} -> [other ~ [Body, Table, Tr]] =>
adamc@720 606 unit -> tag [] ([Body, Table] ++ other) ([Body, Tr] ++ other) [] []
adamc@720 607 val th : other ::: {Unit} -> [other ~ [Body, Tr]] =>
adamc@720 608 unit -> tag [] ([Body, Tr] ++ other) ([Body] ++ other) [] []
adamc@720 609 val td : other ::: {Unit} -> [other ~ [Body, Tr]] =>
adamc@720 610 unit -> tag [] ([Body, Tr] ++ other) ([Body] ++ other) [] []
adamc@720 611
adamc@283 612
adamc@283 613 (** Aborting *)
adamc@283 614
adamc@726 615 val error : t ::: Type -> xbody -> t
adamc@720 616
adamc@729 617 (* Client-side-only handlers: *)
adamc@726 618 val onError : (xbody -> transaction unit) -> transaction unit
adamc@728 619 val onFail : (string -> transaction unit) -> transaction unit
adamc@729 620 val onConnectFail : transaction unit -> transaction unit
adamc@729 621 val onDisconnect : transaction unit -> transaction unit
adamc@729 622 val onServerError : (string -> transaction unit) -> transaction unit
adamc@727 623
adamc@727 624 val show_xml : ctx ::: {Unit} -> use ::: {Type} -> bind ::: {Type} -> show (xml ctx use bind)