Safe Haskell	None
Language	Haskell2010

Database.HDBC.PostgreSQL.Pure

Contents

Connection
Transaction
Orphan instances

Description

This is a compatible interface with HDBC-postgresql's Database.HDBC.PostgreSQL except Config.

Prepared statements are closed when some requests come once Statements are GCed, because HDBC doesn't have “close” interface.

Synopsis

data Config = Config {
- address :: Address
- user :: String
- password :: String
- database :: String
- sendingBufferSize :: Int
- receptionBufferSize :: Int
- encodeString :: ShortByteString -> StringEncoder
- decodeString :: ShortByteString -> StringDecoder
}
data Connection
data Address
- = AddressResolved SockAddr
- | AddressNotResolved HostName ServiceName
withConnection :: Config -> (Connection -> IO a) -> IO a
connect :: Config -> IO Connection
begin :: Connection -> IO ()

Connection

data Config Source #

A configuration of a connection.

Default configuration is def, which is following.

let Config { address, user, password, database, sendingBufferSize, receptionBufferSize } = def
in
  Config
    { address = address
    , user = user
    , password = password
    , database = database
    , sendingBufferSize = sendingBufferSize
    , receptionBufferSize = receptionBufferSize
    , encodeString = code -> case code of "UTF8" -> pure . fromString; _ -> const $ fail $ "unexpected character code: " <> show code
    , decodeString = code -> case code of "UTF8" -> pure . toString; _ -> const $ fail $ "unexpected character code: " <> show code
    }

Constructors

Config
Fields address :: Address user :: String password :: String database :: String sendingBufferSize :: Int in byte receptionBufferSize :: Int in byte encodeString :: ShortByteString -> StringEncoder decodeString :: ShortByteString -> StringDecoder

Instances

Show Config Source #
Instance details Defined in Database.HDBC.PostgreSQL.Pure Methods showsPrec :: Int -> Config -> ShowS # show :: Config -> String # showList :: [Config] -> ShowS #
Default Config Source #
Instance details Defined in Database.HDBC.PostgreSQL.Pure Methods def :: Config #

data Connection Source #

PostgreSQL connection.

Instances

IConnection Connection Source #

Instance details

Defined in Database.HDBC.PostgreSQL.Pure

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)] #

data Address Source #

IP address.

Constructors

AddressResolved SockAddr	Address which is DNS resolved.
AddressNotResolved HostName ServiceName	Address which is not DNS resolved.

Instances

Eq Address Source #
Instance details Defined in Database.PostgreSQL.Pure.Internal.Data Methods (==) :: Address -> Address -> Bool # (/=) :: Address -> Address -> Bool #
Show Address Source #
Instance details Defined in Database.PostgreSQL.Pure.Internal.Data Methods showsPrec :: Int -> Address -> ShowS # show :: Address -> String # showList :: [Address] -> ShowS #

withConnection :: Config -> (Connection -> IO a) -> IO a Source #

Bracket function for a connection.

connect :: Config -> IO Connection Source #

To connect to the server.

Transaction

begin :: Connection -> IO () Source #

To send BEGIN SQL statement.

Orphan instances

ToField Rational Source #	Security risk of DoS attack. You should convert `Rational` to `Scientific` with `fromRationalRepetend` in the user side. If the rational value is computed to repeating decimals like 1/3 = 0.3333…, this consumes a lot of memories. This is provided because of the HDBC compatibility.
Instance details Methods toField :: MonadFail m => BackendParameters -> StringEncoder -> Maybe Oid -> FormatCode -> Rational -> m (Maybe ByteString) Source #
ToField SqlValue Source #
Instance details Methods toField :: MonadFail m => BackendParameters -> StringEncoder -> Maybe Oid -> FormatCode -> SqlValue -> m (Maybe ByteString) Source #
FromField SqlValue Source #
Instance details Methods fromField :: MonadFail m => StringDecoder -> ColumnInfo -> Maybe ByteString -> m SqlValue Source #
Convertible Oid SqlTypeId Source #
Instance details Methods safeConvert :: Oid -> ConvertResult SqlTypeId #