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