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             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 !.-_"
  40
  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
  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
  56 val _ = Dbms.register ("mysql", {getpass = SOME Client.getpass,
  57                                  adduser = adduser,
  58                                  passwd = passwd,
  59                                  createdb = createdb})
  60
  61 end