RFC.Psql

Documentation

module Database.PostgreSQL.Simple

module Database.PostgreSQL.Simple.FromField

module Database.PostgreSQL.Simple.FromRow

module Database.PostgreSQL.Simple.ToField

module Database.PostgreSQL.Simple.ToRow

module Database.PostgreSQL.Simple.SqlQQ

module Database.PostgreSQL.Simple.Types

type ConnectionPool = Pool Connection

class (MonadIO m, MonadCatch m, MonadBaseControl IO m) => HasPsql m where

Minimal complete definition

getPsqlPool

Methods

getPsqlPool :: m ConnectionPool

withPsqlConnection :: (Connection -> m a) -> m a

withPsqlTransaction :: (Connection -> m a) -> m a

defaultConnectInfo :: MonadIO m => m ConnectInfo

createConnectionPool :: MonadIO m => ConnectInfo -> m ConnectionPool

query :: (MonadIO m, FromRow r, ToRow q) => Connection -> Query -> q -> m [r]

query_ :: (MonadIO m, FromRow r) => Connection -> Query -> m [r]

query1 :: (MonadIO m, FromRow r, ToRow q) => Connection -> Query -> q -> m (Maybe r)

query1_ :: (MonadIO m, FromRow r) => Connection -> Query -> m (Maybe r)

query1Else :: (MonadIO m, FromRow r, ToRow q, Exception e) => Connection -> Query -> q -> e -> m (Maybe r)

query1Else_ :: (MonadIO m, FromRow r, Exception e) => Connection -> Query -> e -> m (Maybe r)

execute :: (MonadIO m, ToRow q) => Connection -> Query -> q -> m Int64

execute_ :: MonadIO m => Connection -> Query -> m Int64

executeMany :: (MonadIO m, ToRow q) => Connection -> Query -> [q] -> m Int64