6465377fe0df7083cb35a6ca287562f21ca5112d
[hcoop/domtool2.git] / 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 {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