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 | |
41 | fun createdb {user, dbname} = |
42 | if Slave.shell [Config.MySQL.createdb, user, " ", dbname] then |
43 | NONE |
44 | else |
45 | SOME "Error executing CREATE DATABASE script" |
46 | |
2bc895e7 |
47 | val _ = Dbms.register ("mysql", {getpass = SOME Client.getpass, |
48 | adduser = adduser, |
d2583946 |
49 | createdb = createdb}) |
50 | |
51 | end |