Orville.PostgreSQL.Expr.Transaction

Since: 1.0.0.0

Documentation

data BeginTransactionExpr

Type to represent the name of a begin transaction statement. E.G.

BEGIN TRANSACTION

BeginTransactionExpr provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression BeginTransactionExpr

Defined in Orville.PostgreSQL.Expr.Transaction

Methods

toRawSql :: BeginTransactionExpr -> RawSql

unsafeFromRawSql :: RawSql -> BeginTransactionExpr

beginTransaction :: Maybe TransactionMode -> BeginTransactionExpr

Constructs a BeginTransactionExpr that will begin a transaction using the specified mode, if any.

Since: 1.0.0.0

data TransactionMode

Type to represent the transaction mode. E.G.

ISOLATION LEVEL SERIALIZABLE

TransactionMode provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression TransactionMode

Defined in Orville.PostgreSQL.Expr.Transaction

Methods

toRawSql :: TransactionMode -> RawSql

unsafeFromRawSql :: RawSql -> TransactionMode

readWrite :: TransactionMode

The READ WRITE transaction mode.

Since: 1.0.0.0

readOnly :: TransactionMode

The READ ONLY transaction mode.

Since: 1.0.0.0

deferrable :: TransactionMode

The DEFERRABLE transaction mode.

Since: 1.0.0.0

notDeferrable :: TransactionMode

The NOT DEFERRABLE transaction mode.

Since: 1.0.0.0

isolationLevel :: IsolationLevel -> TransactionMode

An ISOLATION LEVEL transaction mode with the given IsolationLevel.

Since: 1.0.0.0

data IsolationLevel

Type to represent the transaction isolation level. E.G.

SERIALIZABLE

IsolationLevel provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression IsolationLevel

Defined in Orville.PostgreSQL.Expr.Transaction

Methods

toRawSql :: IsolationLevel -> RawSql

unsafeFromRawSql :: RawSql -> IsolationLevel

serializable :: IsolationLevel

The SERIALIZABLE isolation level.

Since: 1.0.0.0

repeatableRead :: IsolationLevel

The REPEATABLE READ isolation level.

Since: 1.0.0.0

readCommitted :: IsolationLevel

The READ COMMITTED isolation level.

Since: 1.0.0.0

readUncommitted :: IsolationLevel

The READ UNCOMMITTED isolation level.

Since: 1.0.0.0

data CommitExpr

Type to represent the transaction commit statement. E.G.

COMMIT

CommitExpr provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression CommitExpr

Defined in Orville.PostgreSQL.Expr.Transaction

Methods

toRawSql :: CommitExpr -> RawSql

unsafeFromRawSql :: RawSql -> CommitExpr

commit :: CommitExpr

A COMMIT transaction statement.

Since: 1.0.0.0

data RollbackExpr

Type to represent the transaction rollback statement. E.G.

ROLLBACK

RollbackExpr provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression RollbackExpr

Defined in Orville.PostgreSQL.Expr.Transaction

Methods

toRawSql :: RollbackExpr -> RawSql

unsafeFromRawSql :: RawSql -> RollbackExpr

rollback :: RollbackExpr

A ROLLBACK transaction statement.

Since: 1.0.0.0

rollbackTo :: SavepointName -> RollbackExpr

A ROLLBACK TO transaction statement that will rollback to the specified savepoint.

Since: 1.0.0.0

data SavepointExpr

Type to represent the transaction savepoint statement. E.G.

SAVEPOINT foo

SavepointExpr provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression SavepointExpr

Defined in Orville.PostgreSQL.Expr.Transaction

Methods

toRawSql :: SavepointExpr -> RawSql

unsafeFromRawSql :: RawSql -> SavepointExpr

savepoint :: SavepointName -> SavepointExpr

A SAVEPOINT statement that will create a savepoint with the given name.

Since: 1.0.0.0

data ReleaseSavepointExpr

Type to represent the transaction release savepoint statement. E.G.

RELEASE SAVEPOINT foo

ReleaseSavepointExpr provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression ReleaseSavepointExpr

Defined in Orville.PostgreSQL.Expr.Transaction

Methods

toRawSql :: ReleaseSavepointExpr -> RawSql

unsafeFromRawSql :: RawSql -> ReleaseSavepointExpr

releaseSavepoint :: SavepointName -> ReleaseSavepointExpr

A RELEASE SAVEPOINT statement that will release the specified savepoint.

Since: 1.0.0.0