adamc@56
|
1 type int
|
adamc@56
|
2 type float
|
adamc@56
|
3 type string
|
adamc@91
|
4
|
adamc@119
|
5 type unit = {}
|
adamc@119
|
6
|
adamc@186
|
7 datatype bool = False | True
|
adamc@186
|
8
|
adamc@91
|
9
|
adamc@203
|
10 (** SQL *)
|
adamc@203
|
11
|
adamc@203
|
12 con sql_table :: {Type} -> Type
|
adamc@203
|
13
|
adamc@204
|
14 (*** Queries *)
|
adamc@204
|
15
|
adamc@233
|
16 con sql_query :: {{Type}} -> {Type} -> Type
|
adamc@233
|
17 con sql_query1 :: {{Type}} -> {{Type}} -> {Type} -> Type
|
adamc@223
|
18 con sql_exp :: {{Type}} -> {{Type}} -> Type -> Type
|
adamc@204
|
19
|
adamc@223
|
20 con sql_subset :: {{Type}} -> {{Type}} -> Type
|
adamc@223
|
21 val sql_subset : keep_drop :: {({Type} * {Type})}
|
adamc@223
|
22 -> sql_subset
|
adamc@223
|
23 (fold (fn nm => fn fields :: ({Type} * {Type}) => fn acc =>
|
adamc@223
|
24 [nm] ~ acc => fields.1 ~ fields.2 =>
|
adamc@223
|
25 [nm = fields.1 ++ fields.2] ++ acc) [] keep_drop)
|
adamc@223
|
26 (fold (fn nm => fn fields :: ({Type} * {Type}) => fn acc =>
|
adamc@223
|
27 [nm] ~ acc =>
|
adamc@223
|
28 [nm = fields.1] ++ acc) [] keep_drop)
|
adamc@223
|
29 val sql_subset_all : tables :: {{Type}}
|
adamc@223
|
30 -> sql_subset tables tables
|
adamc@223
|
31
|
adamc@229
|
32 val sql_query1 : tables ::: {{Type}}
|
adamc@224
|
33 -> grouped ::: {{Type}}
|
adamc@233
|
34 -> selectedFields ::: {{Type}}
|
adamc@233
|
35 -> selectedExps ::: {Type}
|
adamc@223
|
36 -> {From : $(fold (fn nm => fn fields :: {Type} => fn acc =>
|
adamc@223
|
37 [nm] ~ acc => [nm = sql_table fields] ++ acc) [] tables),
|
adamc@223
|
38 Where : sql_exp tables [] bool,
|
adamc@224
|
39 GroupBy : sql_subset tables grouped,
|
adamc@224
|
40 Having : sql_exp grouped tables bool,
|
adamc@233
|
41 SelectFields : sql_subset grouped selectedFields,
|
adamc@233
|
42 SelectExps : $(fold (fn nm => fn t :: Type => fn acc =>
|
adamc@233
|
43 [nm] ~ acc => [nm = sql_exp grouped tables t] ++ acc) [] selectedExps) }
|
adamc@233
|
44 -> sql_query1 tables selectedFields selectedExps
|
adamc@229
|
45
|
adamc@229
|
46 type sql_relop
|
adamc@229
|
47 val sql_union : sql_relop
|
adamc@229
|
48 val sql_intersect : sql_relop
|
adamc@229
|
49 val sql_except : sql_relop
|
adamc@229
|
50 val sql_relop : sql_relop
|
adamc@229
|
51 -> tables1 ::: {{Type}}
|
adamc@229
|
52 -> tables2 ::: {{Type}}
|
adamc@233
|
53 -> selectedFields ::: {{Type}}
|
adamc@233
|
54 -> selectedExps ::: {Type}
|
adamc@233
|
55 -> sql_query1 tables1 selectedFields selectedExps
|
adamc@233
|
56 -> sql_query1 tables2 selectedFields selectedExps
|
adamc@233
|
57 -> sql_query1 selectedFields selectedFields selectedExps
|
adamc@229
|
58
|
adamc@230
|
59 type sql_direction
|
adamc@230
|
60 val sql_asc : sql_direction
|
adamc@230
|
61 val sql_desc : sql_direction
|
adamc@230
|
62
|
adamc@230
|
63 con sql_order_by :: {{Type}} -> Type
|
adamc@230
|
64 val sql_order_by_Nil : tables :: {{Type}} -> sql_order_by tables
|
adamc@230
|
65 val sql_order_by_Cons : tables ::: {{Type}} -> t ::: Type
|
adamc@230
|
66 -> sql_exp tables [] t -> sql_order_by tables
|
adamc@230
|
67 -> sql_order_by tables
|
adamc@230
|
68
|
adamc@231
|
69 type sql_limit
|
adamc@231
|
70 val sql_no_limit : sql_limit
|
adamc@231
|
71 val sql_limit : int -> sql_limit
|
adamc@231
|
72
|
adamc@232
|
73 type sql_offset
|
adamc@232
|
74 val sql_no_offset : sql_offset
|
adamc@232
|
75 val sql_offset : int -> sql_offset
|
adamc@232
|
76
|
adamc@229
|
77 val sql_query : tables ::: {{Type}}
|
adamc@233
|
78 -> selectedFields ::: {{Type}}
|
adamc@233
|
79 -> selectedExps ::: {Type}
|
adamc@233
|
80 -> {Rows : sql_query1 tables selectedFields selectedExps,
|
adamc@231
|
81 OrderBy : sql_order_by tables,
|
adamc@232
|
82 Limit : sql_limit,
|
adamc@232
|
83 Offset : sql_offset}
|
adamc@233
|
84 -> sql_query selectedFields selectedExps
|
adamc@204
|
85
|
adamc@225
|
86 val sql_field : otherTabs ::: {{Type}} -> otherFields ::: {Type} -> fieldType ::: Type -> agg ::: {{Type}}
|
adamc@221
|
87 -> tab :: Name -> field :: Name
|
adamc@223
|
88 -> sql_exp ([tab = [field = fieldType] ++ otherFields] ++ otherTabs) agg fieldType
|
adamc@209
|
89
|
adamc@221
|
90 class sql_injectable
|
adamc@221
|
91 val sql_bool : sql_injectable bool
|
adamc@221
|
92 val sql_int : sql_injectable int
|
adamc@221
|
93 val sql_float : sql_injectable float
|
adamc@221
|
94 val sql_string : sql_injectable string
|
adamc@223
|
95 val sql_inject : tables ::: {{Type}} -> agg ::: {{Type}} -> t ::: Type -> t -> sql_injectable t -> sql_exp tables agg t
|
adamc@209
|
96
|
adamc@220
|
97 con sql_unary :: Type -> Type -> Type
|
adamc@220
|
98 val sql_not : sql_unary bool bool
|
adamc@223
|
99 val sql_unary : tables ::: {{Type}} -> agg ::: {{Type}} -> arg ::: Type -> res ::: Type
|
adamc@223
|
100 -> sql_unary arg res -> sql_exp tables agg arg -> sql_exp tables agg res
|
adamc@220
|
101
|
adamc@220
|
102 con sql_binary :: Type -> Type -> Type -> Type
|
adamc@220
|
103 val sql_and : sql_binary bool bool bool
|
adamc@220
|
104 val sql_or : sql_binary bool bool bool
|
adamc@223
|
105 val sql_binary : tables ::: {{Type}} -> agg ::: {{Type}} -> arg1 ::: Type -> arg2 ::: Type -> res ::: Type
|
adamc@223
|
106 -> sql_binary arg1 arg2 res -> sql_exp tables agg arg1 -> sql_exp tables agg arg2 -> sql_exp tables agg res
|
adamc@220
|
107
|
adamc@219
|
108 type sql_comparison
|
adamc@219
|
109 val sql_eq : sql_comparison
|
adamc@219
|
110 val sql_ne : sql_comparison
|
adamc@219
|
111 val sql_lt : sql_comparison
|
adamc@219
|
112 val sql_le : sql_comparison
|
adamc@219
|
113 val sql_gt : sql_comparison
|
adamc@219
|
114 val sql_ge : sql_comparison
|
adamc@219
|
115 val sql_comparison : sql_comparison
|
adamc@223
|
116 -> tables ::: {{Type}} -> agg ::: {{Type}} -> t ::: Type -> sql_exp tables agg t -> sql_exp tables agg t
|
adamc@223
|
117 -> sql_injectable t -> sql_exp tables agg bool
|
adamc@203
|
118
|
adamc@203
|
119 (** XML *)
|
adamc@203
|
120
|
adamc@139
|
121 con tag :: {Type} -> {Unit} -> {Unit} -> {Type} -> {Type} -> Type
|
adamc@91
|
122
|
adamc@91
|
123
|
adamc@139
|
124 con xml :: {Unit} -> {Type} -> {Type} -> Type
|
adamc@141
|
125 val cdata : ctx ::: {Unit} -> use ::: {Type} -> string -> xml ctx use []
|
adamc@104
|
126 val tag : attrsGiven ::: {Type} -> attrsAbsent ::: {Type} -> attrsGiven ~ attrsAbsent
|
adamc@139
|
127 -> ctxOuter ::: {Unit} -> ctxInner ::: {Unit}
|
adamc@139
|
128 -> useOuter ::: {Type} -> useInner ::: {Type} -> useOuter ~ useInner
|
adamc@139
|
129 -> bindOuter ::: {Type} -> bindInner ::: {Type} -> bindOuter ~ bindInner
|
adamc@104
|
130 -> $attrsGiven
|
adamc@139
|
131 -> tag (attrsGiven ++ attrsAbsent) ctxOuter ctxInner useOuter bindOuter
|
adamc@139
|
132 -> xml ctxInner useInner bindInner
|
adamc@139
|
133 -> xml ctxOuter (useOuter ++ useInner) (bindOuter ++ bindInner)
|
adamc@140
|
134 val join : ctx ::: {Unit}
|
adamc@139
|
135 -> use1 ::: {Type} -> bind1 ::: {Type} -> bind2 ::: {Type}
|
adamc@139
|
136 -> use1 ~ bind1 -> bind1 ~ bind2
|
adamc@140
|
137 -> xml ctx use1 bind1
|
adamc@140
|
138 -> xml ctx (use1 ++ bind1) bind2
|
adamc@140
|
139 -> xml ctx use1 (bind1 ++ bind2)
|
adamc@148
|
140 val useMore : ctx ::: {Unit} -> use1 ::: {Type} -> use2 ::: {Type} -> bind ::: {Type}
|
adamc@148
|
141 -> use1 ~ use2
|
adamc@148
|
142 -> xml ctx use1 bind
|
adamc@148
|
143 -> xml ctx (use1 ++ use2) bind
|
adamc@91
|
144
|
adamc@110
|
145 con xhtml = xml [Html]
|
adamc@139
|
146 con page = xhtml [] []
|
adamc@110
|
147
|
adamc@204
|
148 (*** HTML details *)
|
adamc@204
|
149
|
adamc@140
|
150 con html = [Html]
|
adamc@140
|
151 con head = [Head]
|
adamc@140
|
152 con body = [Body]
|
adamc@141
|
153 con lform = [Body, LForm]
|
adamc@93
|
154
|
adamc@140
|
155 val head : unit -> tag [] html head [] []
|
adamc@140
|
156 val title : unit -> tag [] head [] [] []
|
adamc@110
|
157
|
adamc@140
|
158 val body : unit -> tag [] html body [] []
|
adamc@140
|
159 con bodyTag = fn attrs :: {Type} => ctx ::: {Unit} -> [Body] ~ ctx -> unit
|
adamc@140
|
160 -> tag attrs ([Body] ++ ctx) ([Body] ++ ctx) [] []
|
adamc@141
|
161 con bodyTagStandalone = fn attrs :: {Type} => ctx ::: {Unit} -> [Body] ~ ctx -> unit
|
adamc@141
|
162 -> tag attrs ([Body] ++ ctx) [] [] []
|
adamc@141
|
163
|
adamc@141
|
164 val br : bodyTagStandalone []
|
adamc@119
|
165
|
adamc@140
|
166 val p : bodyTag []
|
adamc@140
|
167 val b : bodyTag []
|
adamc@140
|
168 val i : bodyTag []
|
adamc@140
|
169 val font : bodyTag [Size = int, Face = string]
|
adamc@140
|
170
|
adamc@140
|
171 val h1 : bodyTag []
|
adamc@140
|
172 val li : bodyTag []
|
adamc@140
|
173
|
adamc@140
|
174 val a : bodyTag [Link = page]
|
adamc@140
|
175
|
adamc@141
|
176 val lform : ctx ::: {Unit} -> [Body] ~ ctx -> bind ::: {Type}
|
adamc@141
|
177 -> xml lform [] bind
|
adamc@141
|
178 -> xml ([Body] ++ ctx) [] []
|
adamc@153
|
179 con lformTag = fn ty :: Type => fn inner :: {Unit} => fn attrs :: {Type} =>
|
adamc@141
|
180 ctx ::: {Unit} -> [LForm] ~ ctx
|
adamc@141
|
181 -> nm :: Name -> unit
|
adamc@153
|
182 -> tag attrs ([LForm] ++ ctx) inner [] [nm = ty]
|
adamc@153
|
183 val textbox : lformTag string [] []
|
adamc@155
|
184 val password : lformTag string [] []
|
adamc@153
|
185 val ltextarea : lformTag string [] []
|
adamc@153
|
186
|
adamc@190
|
187 val checkbox : lformTag bool [] []
|
adamc@190
|
188
|
adamc@153
|
189 con radio = [Body, Radio]
|
adamc@153
|
190 val radio : lformTag string radio []
|
adamc@153
|
191 val radioOption : unit -> tag [Value = string] radio [] [] []
|
adamc@142
|
192
|
adamc@154
|
193 con select = [Select]
|
adamc@154
|
194 val lselect : lformTag string select []
|
adamc@154
|
195 val loption : unit -> tag [Value = string] select [] [] []
|
adamc@154
|
196
|
adamc@142
|
197 val submit : ctx ::: {Unit} -> [LForm] ~ ctx
|
adamc@142
|
198 -> use ::: {Type} -> unit
|
adamc@142
|
199 -> tag [Action = $use -> page] ([LForm] ++ ctx) ([LForm] ++ ctx) use []
|