Database.PostgreSQL.Typed.HDBC

Use postgresql-typed as a backend for HDBC.

Documentation

data Connection

A wrapped PGConnection. This differs from a bare PGConnection in a few ways:

1. It always has exactly one active transaction (with pgBegin)
2. It automatically disconnects on GC
3. It provides a mutex around the underlying PGConnection for thread-safety

Instances

IConnection Connection

Defined in Database.PostgreSQL.Typed.HDBC

Methods

disconnect :: Connection -> IO ()

commit :: Connection -> IO ()

rollback :: Connection -> IO ()

runRaw :: Connection -> String -> IO ()

run :: Connection -> String -> [SqlValue] -> IO Integer

prepare :: Connection -> String -> IO Statement

clone :: Connection -> IO Connection

hdbcDriverName :: Connection -> String

hdbcClientVer :: Connection -> String

proxiedClientName :: Connection -> String

proxiedClientVer :: Connection -> String

dbServerVer :: Connection -> String

dbTransactionSupport :: Connection -> Bool

getTables :: Connection -> IO [String]

describeTable :: Connection -> String -> IO [(String, SqlColDesc)]

connect :: PGDatabase -> IO Connection

Connect to a database for HDBC use (equivalent to pgConnect and pgBegin).

fromPGConnection :: PGConnection -> IO Connection

Convert an existing PGConnection to an HDBC-compatible Connection. The caveats under connectionPG apply if you plan to continue using the original PGConnection.

withPGConnection :: Connection -> (PGConnection -> IO a) -> IO a

Use the underlying PGConnection directly. You must be careful to ensure that the first invariant is preserved: you should not call pgBegin, pgCommit, or pgRollback on it. All other operations should be safe.

reloadTypes :: Connection -> IO Connection

Reload the table of all types from the database. This may be needed if you make structural changes to the database.

connectionFetchSize :: Connection -> Word32

Number of rows to fetch (and cache) with execute and each time fetchRow requires more rows. A higher value will result in fewer round-trips to the database but potentially more wasted data. Defaults to 1. 0 means fetch all rows.

setFetchSize :: Word32 -> Connection -> Connection

Change the connectionFetchSize for new Statements created with prepare. Ideally this could be set with each call to execute and fetchRow, but the HDBC interface provides no way to do this.