| 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 {user, passwd} = |
| 24 | Option.map (fn s => "Error executing CREATE USER script:\n" ^ s) |
| 25 | (Slave.shellOutput [Config.Postgres.adduser, user]) |
| 26 | |
| 27 | fun passwd _ = SOME "We don't use PostgreSQL passwords." |
| 28 | |
| 29 | fun createdb {user, dbname, encoding} = |
| 30 | Option.map (fn s => "Error executing CREATE DATABASE script:\n" ^ s) |
| 31 | (Slave.shellOutput [Config.Postgres.createdb, |
| 32 | " ", user, " ", dbname, |
| 33 | case encoding of NONE => "" | SOME e => " " ^ e]) |
| 34 | |
| 35 | fun dropdb {user, dbname} = |
| 36 | Option.map (fn s => "Error executing DROP DATABASE script:\n" ^ s) |
| 37 | (Slave.shellOutput [Config.Postgres.dropdb, user, " ", dbname]) |
| 38 | |
| 39 | val _ = Dbms.register ("postgres", {getpass = NONE, |
| 40 | adduser = adduser, |
| 41 | passwd = passwd, |
| 42 | createdb = createdb, |
| 43 | dropdb = dropdb, |
| 44 | grant = fn _ => SOME "You don't need to use GRANT for Postgres."}) |
| 45 | |
| 46 | end |