Safe Haskell | None |
---|---|
Language | Haskell2010 |
Create temporary postgresql databases.
The main usecase for this are tests where you don’t want to assume that a certain database exists.
Documentation
withTmpDB' :: ByteString -> (DBInfo -> IO a) -> IO a Source #
Create a temporary database and a temporary role that the callback can operate on. After the action has finished the database and the role are destroyed.
This function assumes that the connection string points to a
database containing the tables called pg_roles
and pg_database
and that the user has the CREATEDB
and CREATEROLE
privileges.
newRole :: Connection -> IO Text Source #
Create a new role that does not already exist and return its name.
The new role does not have a password and has the CREATEDB
privilege. The database that the connection points to is assumed to
contain a table called pg_roles
with a rolname
column.
defaultDB :: ByteString Source #
Connection string for the postgres
database owned by the
postgres
user