Safe Haskell	None
Language	Haskell2010

Hpgsql.Transaction

Synopsis

withTransaction :: HPgConnection -> IO a -> IO a
withTransactionMode :: HPgConnection -> IsolationLevel -> ReadWriteMode -> IO a -> IO a
begin :: HPgConnection -> IO ()
beginMode :: HPgConnection -> IsolationLevel -> ReadWriteMode -> IO ()
commit :: HPgConnection -> IO ()
rollback :: HPgConnection -> IO ()
transactionStatus :: HPgConnection -> IO TransactionStatus
data IsolationLevel
- = DefaultIsolationLevel
- | ReadUncommitted
- | ReadCommitted
- | RepeatableRead
- | Serializable
data ReadWriteMode
- = DefaultReadWriteMode
- | ReadWrite
- | ReadOnly
data TransactionStatus
- = TransActive
- | TransIdle
- | TransInTrans
- | TransInError

Documentation

withTransaction :: HPgConnection -> IO a -> IO a Source #

Runs the supplied function inside a transaction with the database's default isolation level and read-write mode, i.e. BEGINs a transaction, runs the supplied function and then COMMITs if there are no exceptions. In case the supplied function throws an exception, this runs ROLLBACK. In case an asynchronous exception is thrown, Hpgsql ensures a ROLLBACK will be issued before your next query on the same connection.

withTransactionMode :: HPgConnection -> IsolationLevel -> ReadWriteMode -> IO a -> IO a Source #

Runs the supplied function inside a transaction with the supplied isolation level and read-write mode, i.e. BEGINs a transaction, runs the supplied function and then COMMITs if there are no exceptions. In case the supplied function throws an exception, this runs ROLLBACK. In case an asynchronous exception is thrown, Hpgsql ensures a ROLLBACK will be issued before your next query on this connection.

begin :: HPgConnection -> IO () Source #

beginMode :: HPgConnection -> IsolationLevel -> ReadWriteMode -> IO () Source #

commit :: HPgConnection -> IO () Source #

rollback :: HPgConnection -> IO () Source #

transactionStatus :: HPgConnection -> IO TransactionStatus Source #

The current transaction status. Note that if withTransaction is interruped by an asynchronous exception, this may still report TransActive until you run your next command. See withTransaction for details.

data IsolationLevel Source #

Constructors

DefaultIsolationLevel
ReadUncommitted
ReadCommitted
RepeatableRead
Serializable

Instances

Instances details

Bounded IsolationLevel Source #
Instance details Defined in Hpgsql.Transaction Methods minBound :: IsolationLevel # maxBound :: IsolationLevel #
Enum IsolationLevel Source #
Instance details Defined in Hpgsql.Transaction Methods succ :: IsolationLevel -> IsolationLevel # pred :: IsolationLevel -> IsolationLevel # toEnum :: Int -> IsolationLevel # fromEnum :: IsolationLevel -> Int # enumFrom :: IsolationLevel -> [IsolationLevel] # enumFromThen :: IsolationLevel -> IsolationLevel -> [IsolationLevel] # enumFromTo :: IsolationLevel -> IsolationLevel -> [IsolationLevel] # enumFromThenTo :: IsolationLevel -> IsolationLevel -> IsolationLevel -> [IsolationLevel] #
Show IsolationLevel Source #
Instance details Defined in Hpgsql.Transaction Methods showsPrec :: Int -> IsolationLevel -> ShowS # show :: IsolationLevel -> String # showList :: [IsolationLevel] -> ShowS #
Eq IsolationLevel Source #
Instance details Defined in Hpgsql.Transaction Methods (==) :: IsolationLevel -> IsolationLevel -> Bool # (/=) :: IsolationLevel -> IsolationLevel -> Bool #
Ord IsolationLevel Source #
Instance details Defined in Hpgsql.Transaction Methods compare :: IsolationLevel -> IsolationLevel -> Ordering # (<) :: IsolationLevel -> IsolationLevel -> Bool # (<=) :: IsolationLevel -> IsolationLevel -> Bool # (>) :: IsolationLevel -> IsolationLevel -> Bool # (>=) :: IsolationLevel -> IsolationLevel -> Bool # max :: IsolationLevel -> IsolationLevel -> IsolationLevel # min :: IsolationLevel -> IsolationLevel -> IsolationLevel #

data ReadWriteMode Source #

Constructors

DefaultReadWriteMode
ReadWrite
ReadOnly

Instances

Instances details

Bounded ReadWriteMode Source #
Instance details Defined in Hpgsql.Transaction Methods minBound :: ReadWriteMode # maxBound :: ReadWriteMode #
Enum ReadWriteMode Source #
Instance details Defined in Hpgsql.Transaction Methods succ :: ReadWriteMode -> ReadWriteMode # pred :: ReadWriteMode -> ReadWriteMode # toEnum :: Int -> ReadWriteMode # fromEnum :: ReadWriteMode -> Int # enumFrom :: ReadWriteMode -> [ReadWriteMode] # enumFromThen :: ReadWriteMode -> ReadWriteMode -> [ReadWriteMode] # enumFromTo :: ReadWriteMode -> ReadWriteMode -> [ReadWriteMode] # enumFromThenTo :: ReadWriteMode -> ReadWriteMode -> ReadWriteMode -> [ReadWriteMode] #
Show ReadWriteMode Source #
Instance details Defined in Hpgsql.Transaction Methods showsPrec :: Int -> ReadWriteMode -> ShowS # show :: ReadWriteMode -> String # showList :: [ReadWriteMode] -> ShowS #
Eq ReadWriteMode Source #
Instance details Defined in Hpgsql.Transaction Methods (==) :: ReadWriteMode -> ReadWriteMode -> Bool # (/=) :: ReadWriteMode -> ReadWriteMode -> Bool #
Ord ReadWriteMode Source #
Instance details Defined in Hpgsql.Transaction Methods compare :: ReadWriteMode -> ReadWriteMode -> Ordering # (<) :: ReadWriteMode -> ReadWriteMode -> Bool # (<=) :: ReadWriteMode -> ReadWriteMode -> Bool # (>) :: ReadWriteMode -> ReadWriteMode -> Bool # (>=) :: ReadWriteMode -> ReadWriteMode -> Bool # max :: ReadWriteMode -> ReadWriteMode -> ReadWriteMode # min :: ReadWriteMode -> ReadWriteMode -> ReadWriteMode #

data TransactionStatus Source #

Constructors

TransActive	A command is in progress
TransIdle	Not inside a transaction
TransInTrans	Inside a transaction, but no command running
TransInError

Instances

Instances details

Show TransactionStatus Source #
Instance details Defined in Hpgsql.TransactionStatusInternal Methods showsPrec :: Int -> TransactionStatus -> ShowS # show :: TransactionStatus -> String # showList :: [TransactionStatus] -> ShowS #
Eq TransactionStatus Source #
Instance details Defined in Hpgsql.TransactionStatusInternal Methods (==) :: TransactionStatus -> TransactionStatus -> Bool # (/=) :: TransactionStatus -> TransactionStatus -> Bool #