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 | |
abcfe83a AC |
34 | Option.map (fn s => "Error executing CREATE USER script:\n" ^ s) |
35 | (Slave.shellOutput [Config.MySQL.adduser, user, " ", passwd]) | |
21d921a5 AC |
36 | else |
37 | SOME "Password contains characters besides letters, digits, and !.-_" | |
ae147938 | 38 | |
86aa5de7 AC |
39 | fun passwd {user, passwd} = |
40 | if validPasswd passwd then | |
abcfe83a AC |
41 | Option.map (fn s => "Error executing SET PASSWORD script:\n" ^ s) |
42 | (Slave.shellOutput [Config.MySQL.passwd, user, " ", passwd]) | |
86aa5de7 AC |
43 | else |
44 | SOME "Password contains characters besides letters, digits, and !.-_" | |
45 | ||
fe789bea AC |
46 | fun createdb {user, dbname, encoding} = |
47 | case encoding of | |
48 | SOME _ => SOME "MySQL doesn't support specifying encodings" | |
49 | | NONE => | |
50 | Option.map (fn s => "Error executing CREATE DATABASE script:\n" ^ s) | |
51 | (Slave.shellOutput [Config.MySQL.createdb, user, " ", dbname]) | |
ae147938 | 52 | |
35659203 | 53 | fun dropdb {user, dbname} = |
abcfe83a AC |
54 | Option.map (fn s => "Error executing DROP DATABASE script:\n" ^ s) |
55 | (Slave.shellOutput [Config.MySQL.dropdb, user, " ", dbname]) | |
35659203 | 56 | |
99cc4144 | 57 | fun grant {user, dbname} = |
abcfe83a AC |
58 | Option.map (fn s => "Error executing GRANT script:\n" ^ s) |
59 | (Slave.shellOutput [Config.MySQL.grant, user, " ", dbname]) | |
99cc4144 | 60 | |
21d921a5 AC |
61 | val _ = Dbms.register ("mysql", {getpass = SOME Client.getpass, |
62 | adduser = adduser, | |
86aa5de7 | 63 | passwd = passwd, |
35659203 | 64 | createdb = createdb, |
99cc4144 AC |
65 | dropdb = dropdb, |
66 | grant = grant}) | |
ae147938 AC |
67 | |
68 | end |