1 (* HCoop
Domtool (http
://hcoop
.sourceforge
.net
/)
2 * Copyright (c
) 2006, Adam Chlipala
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
.
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
.
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
.
19 (* PostgreSQL user
/table management
*)
21 structure Postgres
:> POSTGRES
= struct
23 fun adduser
{user
, passwd
} =
24 Option
.map (fn s
=> "Error executing CREATE USER script:\n" ^ s
)
25 (Slave
.shellOutput
[Config
.Postgres
.adduser
, user
])
27 fun passwd _
= SOME
"We don't use PostgreSQL passwords."
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
])
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
])
39 val _
= Dbms
.register ("postgres", {getpass
= NONE
,
44 grant
= fn _
=> SOME
"You don't need to use GRANT for Postgres."})