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