src/plugins/mysql.sml

   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
  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             Option.map (fn s => "Error executing CREATE USER script:\n" ^ s)
  35                        (Slave.shellOutput [Config.MySQL.adduser, user, " ", passwd])
  36         else
  37             SOME "Password contains characters besides letters, digits, and !.-_"
  38
  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])
  43     else
  44         SOME "Password contains characters besides letters, digits, and !.-_"
  45
  46 fun createdb {user, dbname} =
  47     Option.map (fn s => "Error executing CREATE DATABASE script:\n" ^ s)
  48                (Slave.shellOutput [Config.MySQL.createdb, user, " ", dbname])
  49
  50 fun dropdb {user, dbname} =
  51     Option.map (fn s => "Error executing DROP DATABASE script:\n" ^ s)
  52                (Slave.shellOutput [Config.MySQL.dropdb, user, " ", dbname])
  53
  54 fun grant {user, dbname} =
  55     Option.map (fn s => "Error executing GRANT script:\n" ^ s)
  56                (Slave.shellOutput [Config.MySQL.grant, user, " ", dbname])
  57
  58 val _ = Dbms.register ("mysql", {getpass = SOME Client.getpass,
  59                                  adduser = adduser,
  60                                  passwd = passwd,
  61                                  createdb = createdb,
  62                                  dropdb = dropdb,
  63                                  grant = grant})
  64
  65 end