Commit | Line | Data |
---|---|---|
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 | ||
21 | structure MySQL :> MYSQL = struct | |
22 | ||
21d921a5 AC |
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 !.-_" | |
ae147938 | 40 | |
86aa5de7 AC |
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 | ||
ae147938 AC |
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 | ||
21d921a5 AC |
56 | val _ = Dbms.register ("mysql", {getpass = SOME Client.getpass, |
57 | adduser = adduser, | |
86aa5de7 | 58 | passwd = passwd, |
ae147938 AC |
59 | createdb = createdb}) |
60 | ||
61 | end |