d2583946 |
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 | |
2bc895e7 |
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 | 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 !.-_" |
d2583946 |
40 | |
dc6789fc |
41 | fun 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 | |
d2583946 |
50 | fun 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 | |
a71b2f2b |
56 | fun 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 | |
962530dd |
62 | fun grant {user, dbname} = |
63 | if Slave.shell [Config.MySQL.grant, user, " ", dbname] then |
64 | NONE |
65 | else |
66 | SOME "Error executing GRANT script" |
67 | |
2bc895e7 |
68 | val _ = Dbms.register ("mysql", {getpass = SOME Client.getpass, |
69 | adduser = adduser, |
dc6789fc |
70 | passwd = passwd, |
a71b2f2b |
71 | createdb = createdb, |
962530dd |
72 | dropdb = dropdb, |
73 | grant = grant}) |
d2583946 |
74 | |
75 | end |