annotate src/settings.sml @ 880:8e9f2d247dba

Testing nested queries
author Adam Chlipala <adamc@hcoop.net>
date Fri, 17 Jul 2009 12:25:34 -0400
parents b2a175a0f2ef
children 9c1b7e46eed2
rev   line source
adamc@764 1 (* Copyright (c) 2008-2009, Adam Chlipala
adamc@764 2 * All rights reserved.
adamc@764 3 *
adamc@764 4 * Redistribution and use in source and binary forms, with or without
adamc@764 5 * modification, are permitted provided that the following conditions are met:
adamc@764 6 *
adamc@764 7 * - Redistributions of source code must retain the above copyright notice,
adamc@764 8 * this list of conditions and the following disclaimer.
adamc@764 9 * - Redistributions in binary form must reproduce the above copyright notice,
adamc@764 10 * this list of conditions and the following disclaimer in the documentation
adamc@764 11 * and/or other materials provided with the distribution.
adamc@764 12 * - The names of contributors may not be used to endorse or promote products
adamc@764 13 * derived from this software without specific prior written permission.
adamc@764 14 *
adamc@764 15 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
adamc@764 16 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
adamc@764 17 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
adamc@764 18 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
adamc@764 19 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
adamc@764 20 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
adamc@764 21 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
adamc@764 22 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
adamc@764 23 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
adamc@764 24 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
adamc@764 25 * POSSIBILITY OF SUCH DAMAGE.
adamc@764 26 *)
adamc@764 27
adamc@764 28 structure Settings :> SETTINGS = struct
adamc@764 29
adamc@764 30 val urlPrefix = ref "/"
adamc@764 31 val timeout = ref 0
adamc@764 32 val headers = ref ([] : string list)
adamc@766 33 val scripts = ref ([] : string list)
adamc@764 34
adamc@764 35 fun getUrlPrefix () = !urlPrefix
adamc@764 36 fun setUrlPrefix p =
adamc@764 37 urlPrefix := (if p = "" then
adamc@764 38 "/"
adamc@764 39 else if String.sub (p, size p - 1) <> #"/" then
adamc@764 40 p ^ "/"
adamc@764 41 else
adamc@764 42 p)
adamc@764 43
adamc@764 44 fun getTimeout () = !timeout
adamc@764 45 fun setTimeout n = timeout := n
adamc@764 46
adamc@764 47 fun getHeaders () = !headers
adamc@764 48 fun setHeaders ls = headers := ls
adamc@764 49
adamc@766 50 fun getScripts () = !scripts
adamc@766 51 fun setScripts ls = scripts := ls
adamc@766 52
adamc@765 53 type ffi = string * string
adamc@765 54
adamc@765 55 structure K = struct
adamc@765 56 type ord_key = ffi
adamc@765 57 fun compare ((m1, x1), (m2, x2)) =
adamc@765 58 Order.join (String.compare (m1, m2),
adamc@765 59 fn () => String.compare (x1, x2))
adamc@764 60 end
adamc@765 61
adamc@765 62 structure S = BinarySetFn(K)
adamc@765 63 structure M = BinaryMapFn(K)
adamc@765 64
adamc@765 65 fun basis x = S.addList (S.empty, map (fn x : string => ("Basis", x)) x)
adamc@765 66
adamc@765 67 val clientToServerBase = basis ["int",
adamc@765 68 "float",
adamc@765 69 "string",
adamc@765 70 "time",
adamc@765 71 "file",
adamc@765 72 "unit",
adamc@765 73 "option",
adamc@765 74 "list",
adamc@765 75 "bool"]
adamc@765 76 val clientToServer = ref clientToServerBase
adamc@765 77 fun setClientToServer ls = clientToServer := S.addList (clientToServerBase, ls)
adamc@765 78 fun mayClientToServer x = S.member (!clientToServer, x)
adamc@765 79
adamc@779 80 val effectfulBase = basis ["dml",
adamc@779 81 "nextval",
adamc@779 82 "set_cookie",
adamc@765 83 "new_client_source",
adamc@765 84 "get_client_source",
adamc@765 85 "set_client_source",
adamc@845 86 "current",
adamc@765 87 "alert",
adamc@765 88 "new_channel",
adamc@765 89 "send",
adamc@765 90 "onError",
adamc@765 91 "onFail",
adamc@765 92 "onConnectFail",
adamc@765 93 "onDisconnect",
adamc@765 94 "onServerError"]
adamc@765 95
adamc@765 96 val effectful = ref effectfulBase
adamc@765 97 fun setEffectful ls = effectful := S.addList (effectfulBase, ls)
adamc@765 98 fun isEffectful x = S.member (!effectful, x)
adamc@765 99
adamc@765 100 val clientBase = basis ["get",
adamc@765 101 "set",
adamc@841 102 "current",
adamc@765 103 "alert",
adamc@765 104 "recv",
adamc@765 105 "sleep",
adamc@765 106 "spawn",
adamc@765 107 "onError",
adamc@765 108 "onFail",
adamc@765 109 "onConnectFail",
adamc@765 110 "onDisconnect",
adamc@765 111 "onServerError"]
adamc@765 112 val client = ref clientBase
adamc@765 113 fun setClientOnly ls = client := S.addList (clientBase, ls)
adamc@765 114 fun isClientOnly x = S.member (!client, x)
adamc@765 115
adamc@765 116 val serverBase = basis ["requestHeader",
adamc@765 117 "query",
adamc@765 118 "dml",
adamc@765 119 "nextval",
adamc@765 120 "channel",
adamc@765 121 "send"]
adamc@765 122 val server = ref serverBase
adamc@765 123 fun setServerOnly ls = server := S.addList (serverBase, ls)
adamc@765 124 fun isServerOnly x = S.member (!server, x)
adamc@765 125
adamc@765 126 val basisM = foldl (fn ((k, v : string), m) => M.insert (m, ("Basis", k), v)) M.empty
adamc@765 127
adamc@765 128 val jsFuncsBase = basisM [("alert", "alert"),
adamc@765 129 ("get_client_source", "sg"),
adamc@841 130 ("current", "scur"),
adamc@765 131 ("htmlifyBool", "bs"),
adamc@765 132 ("htmlifyFloat", "ts"),
adamc@765 133 ("htmlifyInt", "ts"),
adamc@765 134 ("htmlifyString", "eh"),
adamc@765 135 ("new_client_source", "sc"),
adamc@765 136 ("set_client_source", "sv"),
adamc@838 137 ("stringToFloat", "pflo"),
adamc@838 138 ("stringToInt", "pio"),
adamc@765 139 ("stringToFloat_error", "pfl"),
adamc@765 140 ("stringToInt_error", "pi"),
adamc@765 141 ("urlifyInt", "ts"),
adamc@765 142 ("urlifyFloat", "ts"),
adamc@765 143 ("urlifyString", "uf"),
adamc@765 144 ("recv", "rv"),
adamc@765 145 ("strcat", "cat"),
adamc@765 146 ("intToString", "ts"),
adamc@765 147 ("floatToString", "ts"),
adamc@821 148 ("charToString", "ts"),
adamc@765 149 ("onError", "onError"),
adamc@765 150 ("onFail", "onFail"),
adamc@765 151 ("onConnectFail", "onConnectFail"),
adamc@765 152 ("onDisconnect", "onDisconnect"),
adamc@798 153 ("onServerError", "onServerError"),
adamc@798 154 ("attrifyString", "escape"),
adamc@798 155 ("attrifyInt", "ts"),
adamc@798 156 ("attrifyFloat", "ts"),
adamc@820 157 ("attrifyBool", "bs"),
adamc@821 158 ("boolToString", "ts"),
adamc@821 159 ("strsub", "sub"),
adamc@828 160 ("strsuffix", "suf"),
adamc@829 161 ("strlen", "slen"),
adamc@829 162 ("strindex", "sidx"),
adamc@829 163 ("strchr", "schr"),
adamc@831 164 ("substring", "ssub"),
adamc@831 165 ("strcspn", "sspn")]
adamc@765 166 val jsFuncs = ref jsFuncsBase
adamc@765 167 fun setJsFuncs ls = jsFuncs := foldl (fn ((k, v), m) => M.insert (m, k, v)) jsFuncsBase ls
adamc@765 168 fun jsFunc x = M.find (!jsFuncs, x)
adamc@765 169
adamc@768 170 datatype pattern_kind = Exact | Prefix
adamc@768 171 datatype action = Allow | Deny
adamc@768 172 type rule = { action : action, kind : pattern_kind, pattern : string }
adamc@768 173
adamc@768 174 datatype path_kind = Any | Url | Table | Sequence | View | Relation | Cookie | Style
adamc@768 175 type rewrite = { pkind : path_kind, kind : pattern_kind, from : string, to : string }
adamc@768 176
adamc@768 177 val rewrites = ref ([] : rewrite list)
adamc@768 178
adamc@768 179 fun subsume (pk1, pk2) =
adamc@768 180 pk1 = pk2
adamc@768 181 orelse pk2 = Any
adamc@768 182 orelse pk2 = Relation andalso (pk1 = Table orelse pk1 = Sequence orelse pk1 = View)
adamc@768 183
adamc@768 184 fun setRewriteRules ls = rewrites := ls
adamc@768 185 fun rewrite pk s =
adamc@768 186 let
adamc@768 187 fun rew (ls : rewrite list) =
adamc@768 188 case ls of
adamc@768 189 [] => s
adamc@768 190 | rewr :: ls =>
adamc@768 191 let
adamc@768 192 fun match () =
adamc@768 193 case #kind rewr of
adamc@768 194 Exact => if #from rewr = s then
adamc@768 195 SOME (size s)
adamc@768 196 else
adamc@768 197 NONE
adamc@768 198 | Prefix => if String.isPrefix (#from rewr) s then
adamc@768 199 SOME (size (#from rewr))
adamc@768 200 else
adamc@768 201 NONE
adamc@768 202 in
adamc@768 203 if subsume (pk, #pkind rewr) then
adamc@768 204 case match () of
adamc@768 205 NONE => rew ls
adamc@768 206 | SOME suffixStart => #to rewr ^ String.extract (s, suffixStart, NONE)
adamc@768 207 else
adamc@768 208 rew ls
adamc@768 209 end
adamc@768 210 in
adamc@768 211 rew (!rewrites)
adamc@768 212 end
adamc@768 213
adamc@769 214 val url = ref ([] : rule list)
adamc@769 215 val mime = ref ([] : rule list)
adamc@769 216
adamc@769 217 fun setUrlRules ls = url := ls
adamc@769 218 fun setMimeRules ls = mime := ls
adamc@769 219
adamc@770 220 fun getUrlRules () = !url
adamc@770 221 fun getMimeRules () = !mime
adamc@770 222
adamc@769 223 fun check f rules s =
adamc@769 224 let
adamc@769 225 fun chk (ls : rule list) =
adamc@769 226 case ls of
adamc@769 227 [] => false
adamc@769 228 | rule :: ls =>
adamc@769 229 let
adamc@769 230 val matches =
adamc@769 231 case #kind rule of
adamc@769 232 Exact => #pattern rule = s
adamc@769 233 | Prefix => String.isPrefix (#pattern rule) s
adamc@769 234 in
adamc@769 235 if matches then
adamc@769 236 case #action rule of
adamc@769 237 Allow => true
adamc@769 238 | Deny => false
adamc@769 239 else
adamc@769 240 chk ls
adamc@769 241 end
adamc@769 242 in
adamc@769 243 f s andalso chk (!rules)
adamc@769 244 end
adamc@769 245
adamc@769 246 val checkUrl = check (fn _ => true) url
adamc@769 247 val checkMime = check
adamc@769 248 (CharVector.all (fn ch => Char.isAlphaNum ch orelse ch = #"/" orelse ch = #"-" orelse ch = #"."))
adamc@769 249 mime
adamc@769 250
adamc@855 251
adamc@855 252 type protocol = {
adamc@855 253 name : string,
adamc@855 254 link : string,
adamc@858 255 persistent : bool
adamc@855 256 }
adamc@855 257 val protocols = ref ([] : protocol list)
adamc@855 258 fun addProtocol p = protocols := p :: !protocols
adamc@855 259 fun getProtocol s = List.find (fn p => #name p = s) (!protocols)
adamc@855 260
adamc@855 261 fun clibFile s = OS.Path.joinDirFile {dir = Config.libC,
adamc@855 262 file = s}
adamc@855 263
adamc@865 264 val curProto = ref {name = "",
adamc@865 265 link = "",
adamc@865 266 persistent = false}
adamc@856 267 fun setProtocol name =
adamc@856 268 case getProtocol name of
adamc@856 269 NONE => raise Fail ("Unknown protocol " ^ name)
adamc@856 270 | SOME p => curProto := p
adamc@855 271 fun currentProtocol () = !curProto
adamc@855 272
adamc@857 273 val debug = ref false
adamc@857 274 fun setDebug b = debug := b
adamc@857 275 fun getDebug () = !debug
adamc@857 276
adamc@867 277 datatype sql_type =
adamc@867 278 Int
adamc@867 279 | Float
adamc@867 280 | String
adamc@867 281 | Bool
adamc@867 282 | Time
adamc@867 283 | Blob
adamc@867 284 | Channel
adamc@867 285 | Client
adamc@867 286 | Nullable of sql_type
adamc@867 287
adamc@873 288 fun p_sql_ctype t =
adamc@867 289 let
adamc@867 290 open Print.PD
adamc@867 291 open Print
adamc@867 292 in
adamc@867 293 case t of
adamc@870 294 Int => "uw_Basis_int"
adamc@870 295 | Float => "uw_Basis_float"
adamc@870 296 | String => "uw_Basis_string"
adamc@870 297 | Bool => "uw_Basis_bool"
adamc@870 298 | Time => "uw_Basis_time"
adamc@870 299 | Blob => "uw_Basis_blob"
adamc@870 300 | Channel => "uw_Basis_channel"
adamc@870 301 | Client => "uw_Basis_client"
adamc@870 302 | Nullable String => "uw_Basis_string"
adamc@873 303 | Nullable t => p_sql_ctype t ^ "*"
adamc@867 304 end
adamc@867 305
adamc@867 306 fun isBlob Blob = true
adamc@867 307 | isBlob (Nullable t) = isBlob t
adamc@867 308 | isBlob _ = false
adamc@867 309
adamc@870 310 fun isNotNull (Nullable _) = false
adamc@870 311 | isNotNull _ = true
adamc@870 312
adamc@866 313 type dbms = {
adamc@866 314 name : string,
adamc@866 315 header : string,
adamc@866 316 link : string,
adamc@873 317 p_sql_type : sql_type -> string,
adamc@870 318 init : {dbstring : string,
adamc@870 319 prepared : (string * int) list,
adamc@870 320 tables : (string * (string * sql_type) list) list,
adamc@872 321 views : (string * (string * sql_type) list) list,
adamc@870 322 sequences : string list} -> Print.PD.pp_desc,
adamc@873 323 query : {loc : ErrorMsg.span, cols : sql_type list,
adamc@880 324 doCols : ({loc : ErrorMsg.span, wontLeakStrings : bool, col : int, typ : sql_type} -> Print.PD.pp_desc)
adamc@867 325 -> Print.PD.pp_desc}
adamc@867 326 -> Print.PD.pp_desc,
adamc@867 327 queryPrepared : {loc : ErrorMsg.span, id : int, query : string,
adamc@873 328 inputs : sql_type list, cols : sql_type list,
adamc@880 329 doCols : ({loc : ErrorMsg.span, wontLeakStrings : bool, col : int,
adamc@880 330 typ : sql_type} -> Print.PD.pp_desc)
adamc@879 331 -> Print.PD.pp_desc,
adamc@879 332 nested : bool}
adamc@868 333 -> Print.PD.pp_desc,
adamc@868 334 dml : ErrorMsg.span -> Print.PD.pp_desc,
adamc@868 335 dmlPrepared : {loc : ErrorMsg.span, id : int, dml : string,
adamc@869 336 inputs : sql_type list} -> Print.PD.pp_desc,
adamc@878 337 nextval : {loc : ErrorMsg.span, seqName : string option, seqE : Print.PD.pp_desc} -> Print.PD.pp_desc,
adamc@874 338 nextvalPrepared : {loc : ErrorMsg.span, id : int, query : string} -> Print.PD.pp_desc,
adamc@874 339 sqlifyString : string -> string,
adamc@874 340 p_cast : string * sql_type -> string,
adamc@874 341 p_blank : int * sql_type -> string,
adamc@877 342 supportsDeleteAs : bool,
adamc@877 343 createSequence : string -> string,
adamc@878 344 textKeysNeedLengths : bool,
adamc@879 345 supportsNextval : bool,
adamc@879 346 supportsNestedPrepared : bool
adamc@866 347 }
adamc@866 348
adamc@866 349 val dbmses = ref ([] : dbms list)
adamc@866 350 val curDb = ref ({name = "",
adamc@866 351 header = "",
adamc@866 352 link = "",
adamc@873 353 p_sql_type = fn _ => "",
adamc@867 354 init = fn _ => Print.box [],
adamc@867 355 query = fn _ => Print.box [],
adamc@868 356 queryPrepared = fn _ => Print.box [],
adamc@868 357 dml = fn _ => Print.box [],
adamc@869 358 dmlPrepared = fn _ => Print.box [],
adamc@869 359 nextval = fn _ => Print.box [],
adamc@874 360 nextvalPrepared = fn _ => Print.box [],
adamc@874 361 sqlifyString = fn s => s,
adamc@874 362 p_cast = fn _ => "",
adamc@874 363 p_blank = fn _ => "",
adamc@877 364 supportsDeleteAs = false,
adamc@877 365 createSequence = fn _ => "",
adamc@878 366 textKeysNeedLengths = false,
adamc@879 367 supportsNextval = false,
adamc@879 368 supportsNestedPrepared = false} : dbms)
adamc@866 369
adamc@866 370 fun addDbms v = dbmses := v :: !dbmses
adamc@866 371 fun setDbms s =
adamc@866 372 case List.find (fn db => #name db = s) (!dbmses) of
adamc@866 373 NONE => raise Fail ("Unknown DBMS " ^ s)
adamc@866 374 | SOME db => curDb := db
adamc@866 375 fun currentDbms () = !curDb
adamc@866 376
adamc@765 377 end