1 (* Copyright (C) 2000, HELM Team.
3 * This file is part of HELM, an Hypertextual, Electronic
4 * Library of Mathematics, developed at the Computer Science
5 * Department, University of Bologna, Italy.
7 * HELM is free software; you can redistribute it and/or
8 * modify it under the terms of the GNU General Public License
9 * as published by the Free Software Foundation; either version 2
10 * of the License, or (at your option) any later version.
12 * HELM is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
17 * You should have received a copy of the GNU General Public License
18 * along with HELM; if not, write to the Free Software
19 * Foundation, Inc., 59 Temple Place - Suite 330, Boston,
22 * For details, see the HELM World-Wide-Web page,
23 * http://cs.unibo.it/helm/.
26 (* AUTOR: Ferruccio Guidi <fguidi@cs.unibo.it>
32 try Mysql.quick_connect
33 ~host:"mowgli.cs.unibo.it" ~database:"mowgli" ~user:"helm" ()
34 with _ -> raise (Failure "mqi_connecion")
36 let close c = Mysql.disconnect c
41 let l = String.length s in
42 let i = String.index s '\'' in
43 String.sub s 0 i ^ "\\'" ^ quote_aux (String.sub s (succ i) (l - (succ i)))
46 "'" ^ quote_aux s ^ "'"
49 let g = function None -> "" | Some v -> v in
50 let f a = List.map g (Array.to_list a) in
51 out q; Mysql.map ~f:f (Mysql.exec c q)
53 let exec c table cols ct cfl =
54 let rec iter f last sep = function
57 | head :: tail -> f head ^ sep ^ iter f last sep tail
59 let avs_iter f last sep v =
60 let aux a s = function
61 | true -> a ^ (f s) ^ sep
64 if v = I.empty then last else I.iter aux "" v
66 let pg_cols = iter (fun x -> x) "" ", " cols in
67 let pg_msval v = avs_iter quote "" ", " v in
68 let pg_con (pat, col, v) =
70 let f s = col ^ " regexp " ^ quote ("^" ^ s ^ "$") in
71 if pat then "(" ^ avs_iter f "0" " or " v ^ ")"
72 else match I.single v with
73 | Some s -> col ^ " = " ^ (quote s)
74 | None -> col ^ " in (" ^ pg_msval v ^ ")"
77 let pg_cons l = iter pg_con "1" " and " l in
78 let pg_cons_not l = "not (" ^ pg_cons l ^ ")" in
79 let pg_cons_not_l ll = iter pg_cons_not "1" " and " ll in
80 let pg_where = match ct, cfl with
82 | lt, [] -> " where " ^ pg_cons lt
83 | [], llf -> " where " ^ pg_cons_not_l llf
84 | lt, llf -> " where " ^ pg_cons lt ^ " and " ^ pg_cons_not_l llf
87 let r = exec c ("select count(source) from " ^ table ^ pg_where) in
89 | [[s]] when int_of_string s > 0 -> [[]]
92 exec c ("select " ^ pg_cols ^ " from " ^ table ^ pg_where ^
93 " order by " ^ List.hd cols ^ " asc")