-
(* Copyright (C) 2000, HELM Team.
*
* This file is part of HELM, an Hypertextual, Electronic
* http://cs.unibo.it/helm/.
*)
+(* AUTOR: Ferruccio Guidi <fguidi@cs.unibo.it>
+ *)
+
module M = MathQL
+module I = M.I
+module U = AvsUtil
module P = MQIPostgres
-module U = MQIUtil
+module C = MQIConn
+module A = MQIMap
let not_supported s =
raise (Failure ("MQIProperty: feature not supported: " ^ s))
(* PostgreSQL backend ******************************************************)
-let pg_query table cols ct cf =
+let pg_query h table cols ct cfl =
+ let exec q =
+ if C.set h C.Log then C.log h (q ^ "\n");
+ P.exec (C.pgc h) q
+ in
let rec iter f sep = function
| [] -> ""
| [head] -> f head
| head :: tail -> f head ^ sep ^ iter f sep tail
in
+ let avs_iter f sep v =
+ let aux a s = function
+ | true -> a ^ (f s) ^ sep
+ | false -> a ^ (f s)
+ in
+ I.iter aux "" v
+ in
let pg_cols = iter (fun x -> x) ", " cols in
- let pg_msval v = iter P.quote ", " v in
+ let pg_msval v = avs_iter P.quote ", " v in
let pg_con (pat, col, v) =
if col <> "" then
let f s = col ^ " ~ " ^ P.quote ("^" ^ s ^ "$") in
- if pat then "(" ^ iter f " or " v ^ ")"
- else col ^ " in (" ^ pg_msval v ^ ")"
+ if pat then "(" ^ avs_iter f " or " v ^ ")"
+ else match I.single v with
+ | Some s -> col ^ " = " ^ (P.quote s)
+ | None -> col ^ " in (" ^ pg_msval v ^ ")"
else "true"
in
let pg_cons l = iter pg_con " and " l in
let pg_cons_not l = "not (" ^ pg_cons l ^ ")" in
- let pg_where = match ct, cf with
- | [], [] -> ""
- | lt, [] -> " where " ^ pg_cons lt
- | [], lf -> " where " ^ pg_cons_not lf
- | lt, lf -> " where " ^ pg_cons lt ^ " and " ^ pg_cons_not lf
+ let pg_cons_not_l ll = iter pg_cons_not " and " ll in
+ let pg_where = match ct, cfl with
+ | [], [] -> ""
+ | lt, [] -> " where " ^ pg_cons lt
+ | [], llf -> " where " ^ pg_cons_not_l llf
+ | lt, llf -> " where " ^ pg_cons lt ^ " and " ^ pg_cons_not_l llf
in
- if cols = [] then [] else begin
- let q = "select " ^ pg_cols ^ " from " ^ table ^ pg_where ^
- " order by " ^ List.hd cols ^ " asc" in
- prerr_endline q;
- P.exec q end
-
-let pg_result distinct subj el res =
- let compose = if distinct then List.map else fun f -> U.mql_iter (fun x -> [f x]) in
+ if cols = [] then
+ let r = exec ("select count (source) from " ^ table ^ pg_where) in
+ match r with
+ | [[s]] when int_of_string s > 0 -> [[]]
+ | _ -> []
+ else
+ exec ("select " ^ pg_cols ^ " from " ^ table ^ pg_where ^
+ " order by " ^ List.hd cols ^ " asc") (* desc *)
+
+(* Galax backend ***********************************************************)
+
+let gx_query h table cols ct cfl = not_supported "Galax"
+
+(* Common functions ********************************************************)
+
+let pg_result subj el res =
let get_name = function (p, None) -> p | (_, Some p) -> p in
let names = List.map get_name el in
- let mk_grp l =
- let grp = U.mql_iter2 (fun p s -> [(p, [s])]) names l in
- if grp = [] then [] else [grp]
- in
- let mk_avs l =
- if subj = "" then ("", mk_grp l) else (List.hd l, mk_grp (List.tl l))
+ let mk_grp l = U.grp_iter2 I.grp_make names l in
+ let mk_avs l =
+ if subj = "" then I.make "" (mk_grp l)
+ else I.make (List.hd l) (mk_grp (List.tl l))
in
- compose mk_avs res
-
-let get_table mc ct cf el =
- let fst = function
- | [] -> None
- | head :: tail -> Some head
- in
- let comp n1 n2 = match n1, n2 with
- | None, _ -> n2
- | Some h, Some k when h = k -> n2
- | _, None -> n1
- | _ -> not_supported "comp"
- in
- let rec get_c prev = function
- | [] -> prev
- | (_, p, _) :: tail -> get_c (comp prev (fst p)) tail
- in
- let rec get_e prev = function
- | [] -> prev
- | (p, _) :: tail -> get_e (comp prev (fst p)) tail
- in
- get_e (get_c (get_c (fst mc) ct) cf) el
-
-let rec decolon s =
- let l = String.length s in
- try
- let i = String.index s ':' in
- String.sub s 0 i ^ "_" ^ decolon (String.sub s (succ i) (l - succ i))
- with Not_found -> s
-
-let conv = function
- | [] -> "source"
- | ["objectname"] -> "value"
- | [t] -> ""
- | [_; t] -> decolon t
- | _ -> not_supported "conv"
-
-let postgres_single mc ct cf el t =
- let table = match t with Some t -> decolon t | None -> "objectname" in
+ U.iter mk_avs res
+
+let get_table h mc ct cfl el =
+ let aux_c ts (_, p, _) = A.refine_tables ts (C.tables h p) in
+ let aux_e ts (p, _) = A.refine_tables ts (C.tables h p) in
+ let fst = C.tables h mc in
+ let snd = List.fold_left aux_c fst (ct @ (List.concat cfl)) in
+ let trd = List.fold_left aux_e snd el in
+ A.default_table trd
+
+let exec_single h mc ct cfl el table =
+ let conv p = C.field h p table in
let first = conv mc in
let mk_con l = List.map (fun (pat, p, v) -> (pat, conv p, v)) l in
let cons_true = mk_con ct in
- let cons_false = mk_con cf in
+ let cons_false = List.map mk_con cfl in
let other_cols = List.map (fun (p, _) -> conv p) el in
- let cols = if first = "" then other_cols else first :: other_cols in
- pg_result false first el (pg_query table cols cons_true cons_false)
+ let cols = if first = "" then other_cols else first :: other_cols in
+ let low_level = if C.set h C.Galax then gx_query else pg_query in
+ let result = low_level h (C.resolve h table) cols cons_true cons_false in
+ pg_result first el result
let deadline = 100
-let postgres refine mc ct cf el =
- if refine <> M.RefineExact then not_supported "postgres";
- cl_print ct;
- let table = get_table mc ct cf el in
- let rec postgres_aux ct = match ct with
- | (pat, p, v) :: tail when List.length v > deadline ->
- let single s = postgres_aux ((pat, p, [s]) :: tail) in
- U.mql_iter single v
+let exec h refine mc ct cfl el =
+ if refine <> M.RefineExact then not_supported "exec";
+ let table = get_table h mc ct cfl el in
+ let rec exec_aux ct = match ct with
+ | (pat, p, v) :: tail when U.count v > deadline ->
+ let single a s _ = I.union a (exec_aux ((pat, p, I.make s I.grp_empty) :: tail)) in
+ I.iter single U.val_false v
| _ ->
- postgres_single mc ct cf el table
- in postgres_aux ct
-
-(* Galax backend ***********************************************************)
-
-let galax refine mc ct cf el = not_supported "Galax"
+ exec_single h mc ct cfl el table
+ in exec_aux ct
(* funzioni vecchie ********************************************************)
-let pg_name s =
+let pg_name h s =
let q = "select id from registry where uri = " ^ P.quote s in
- match P.exec q with
+ match P.exec h q with
| [[id]] -> "t" ^ id
| _ -> ""
let get_id b = if b then ["B"] else ["F"]
+
projects / helm.git / blobdiff