1 (* HCoop
Domtool (http
://hcoop
.sourceforge
.net
/)
2 * Copyright (c
) 2006, Adam Chlipala
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
.
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
.
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
.
19 (* MySQL user
/table management
*)
21 structure MySQL
:> MYSQL
= struct
23 val validPasswd
= CharVector
.all (fn ch
=> Char.isAlphaNum ch
29 fun adduser
{user
, passwd
} =
31 NONE
=> SOME
"No password given"
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
])
37 SOME
"Password contains characters besides letters, digits, and !.-_"
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
])
44 SOME
"Password contains characters besides letters, digits, and !.-_"
46 fun createdb
{user
, dbname
, encoding
} =
48 SOME _
=> SOME
"MySQL doesn't support specifying encodings"
50 Option
.map (fn s
=> "Error executing CREATE DATABASE script:\n" ^ s
)
51 (Slave
.shellOutput
[Config
.MySQL
.createdb
, user
, " ", dbname
])
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
])
57 fun grant
{user
, dbname
} =
58 Option
.map (fn s
=> "Error executing GRANT script:\n" ^ s
)
59 (Slave
.shellOutput
[Config
.MySQL
.grant
, user
, " ", dbname
])
61 val _
= Dbms
.register ("mysql", {getpass
= SOME Client
.getpass
,