Adding database dropping to dbtool
[hcoop/domtool2.git] / src / plugins / mysql.sml
CommitLineData
ae147938
AC
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
21structure MySQL :> MYSQL = struct
22
21d921a5
AC
23val validPasswd = CharVector.all (fn ch => Char.isAlphaNum ch
24 orelse ch = #"!"
25 orelse ch = #"."
26 orelse ch = #"-"
27 orelse ch = #"_")
28
29fun adduser {user, passwd} =
30 case passwd of
31 NONE => SOME "No password given"
32 | SOME passwd =>
33 if validPasswd passwd then
34 if Slave.shell [Config.MySQL.adduser, user, " ", passwd] then
35 NONE
36 else
37 SOME "Error executing CREATE USER script"
38 else
39 SOME "Password contains characters besides letters, digits, and !.-_"
ae147938 40
86aa5de7
AC
41fun passwd {user, passwd} =
42 if validPasswd passwd then
43 if Slave.shell [Config.MySQL.passwd, user, " ", passwd] then
44 NONE
45 else
46 SOME "Error executing SET PASSWORD script"
47 else
48 SOME "Password contains characters besides letters, digits, and !.-_"
49
ae147938
AC
50fun createdb {user, dbname} =
51 if Slave.shell [Config.MySQL.createdb, user, " ", dbname] then
52 NONE
53 else
54 SOME "Error executing CREATE DATABASE script"
55
35659203
AC
56fun dropdb {user, dbname} =
57 if Slave.shell [Config.MySQL.dropdb, user, " ", dbname] then
58 NONE
59 else
60 SOME "Error executing DROP DATABASE script"
61
21d921a5
AC
62val _ = Dbms.register ("mysql", {getpass = SOME Client.getpass,
63 adduser = adduser,
86aa5de7 64 passwd = passwd,
35659203
AC
65 createdb = createdb,
66 dropdb = dropdb})
ae147938
AC
67
68end