Move ambient environment defaults into Env.env
[hcoop/domtool2.git] / src / plugins / mysql.sml
1 (* HCoop Domtool (http://hcoop.sourceforge.net/)
2 * Copyright (c) 2006, Adam Chlipala
3 *
4 * This program is free software; you can redistribute it and/or
5 * modify it under the terms of the GNU General Public License
6 * as published by the Free Software Foundation; either version 2
7 * of the License, or (at your option) any later version.
8 *
9 * This program is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
13 *
14 * You should have received a copy of the GNU General Public License
15 * along with this program; if not, write to the Free Software
16 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
17 *)
18
19 (* MySQL user/table management *)
20
21 structure MySQL :> MYSQL = struct
22
23 val validPasswd = CharVector.all (fn ch => Char.isAlphaNum ch
24 orelse ch = #"!"
25 orelse ch = #"."
26 orelse ch = #"-"
27 orelse ch = #"_")
28
29 fun adduser {user, passwd} =
30 case passwd of
31 NONE => SOME "No password given"
32 | SOME passwd =>
33 if validPasswd passwd then
34 Option.map (fn s => "Error executing CREATE USER script:\n" ^ s)
35 (Slave.shellOutput [Config.MySQL.adduser, " ", user, " ", passwd])
36 else
37 SOME "Password contains characters besides letters, digits, and !.-_"
38
39 fun passwd {user, passwd} =
40 if validPasswd passwd then
41 Option.map (fn s => "Error executing SET PASSWORD script:\n" ^ s)
42 (Slave.shellOutput [Config.MySQL.passwd, " ", user, " ", passwd])
43 else
44 SOME "Password contains characters besides letters, digits, and !.-_"
45
46 fun createdb {user, dbname, encoding} =
47 case encoding of
48 SOME _ => SOME "MySQL doesn't support specifying encodings"
49 | NONE =>
50 Option.map (fn s => "Error executing CREATE DATABASE script:\n" ^ s)
51 (Slave.shellOutput [Config.MySQL.createdb, " ", user, " ", dbname])
52
53 fun dropdb {user, dbname} =
54 Option.map (fn s => "Error executing DROP DATABASE script:\n" ^ s)
55 (Slave.shellOutput [Config.MySQL.dropdb, " ", user, " ", dbname])
56
57 fun grant {user, dbname} =
58 Option.map (fn s => "Error executing GRANT script:\n" ^ s)
59 (Slave.shellOutput [Config.MySQL.grant, " ", user, " ", dbname])
60
61 val _ = Dbms.register ("mysql", {getpass = SOME Client.getpass,
62 adduser = adduser,
63 passwd = passwd,
64 createdb = createdb,
65 dropdb = dropdb,
66 grant = grant})
67
68 end