src/plugins/postgres.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 (* PostgreSQL user/table management *)
  20
  21 structure Postgres :> POSTGRES = struct
  22
  23 fun adduser port {user, passwd} =
  24     Option.map (fn s => "Error executing CREATE USER script:\n" ^ s)
  25                (Slave.shellOutput [Config.Postgres.adduser, " ", port, " ", user])
  26
  27 fun passwd _ = SOME "We don't use PostgreSQL passwords."
  28
  29 fun createdb port {user, dbname, encoding} =
  30     Option.map (fn s => "Error executing CREATE DATABASE script:\n" ^ s)
  31                (Slave.shellOutput [Config.Postgres.createdb,
  32                                    " ", port, " ", user, " ", dbname,
  33                                    case encoding of NONE => "" | SOME e => " " ^ e])
  34
  35 fun dropdb port {user, dbname} =
  36     Option.map (fn s => "Error executing DROP DATABASE script:\n" ^ s)
  37                (Slave.shellOutput [Config.Postgres.dropdb, " ", port, " ", user, " ", dbname])
  38
  39 val _ = Dbms.register ("postgres", {getpass = NONE,
  40                                     adduser = adduser Config.Postgres.postgres81port,
  41                                     passwd = passwd,
  42                                     createdb = createdb Config.Postgres.postgres81port,
  43                                     dropdb = dropdb Config.Postgres.postgres81port,
  44                                     grant = fn _ => SOME "You don't need to use GRANT for Postgres."})
  45
  46 val _ = Dbms.register ("postgres-9.1", {getpass = NONE,
  47                                         adduser = adduser Config.Postgres.postgres91port,
  48                                         passwd = passwd,
  49                                         createdb = createdb Config.Postgres.postgres91port,
  50                                         dropdb = dropdb Config.Postgres.postgres91port,
  51                                         grant = fn _ => SOME "You don't need to use GRANT for Postgres."})
  52
  53 end