Copyright	Flipstone Technology Partners 2023
License	MIT
Stability	Stable
Safe Haskell	Safe-Inferred
Language	Haskell2010

Orville.PostgreSQL.Expr.Transaction

Description

Since: 1.0.0.0

Synopsis

Documentation

data BeginTransactionExpr Source #

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

Instances details

SqlExpression BeginTransactionExpr Source #
Instance details Defined in Orville.PostgreSQL.Expr.Transaction Methods toRawSql :: BeginTransactionExpr -> RawSql Source # unsafeFromRawSql :: RawSql -> BeginTransactionExpr Source #

beginTransaction :: Maybe TransactionMode -> BeginTransactionExpr Source #

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

Since: 1.0.0.0

data TransactionMode Source #

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

Instances details

SqlExpression TransactionMode Source #
Instance details Defined in Orville.PostgreSQL.Expr.Transaction Methods toRawSql :: TransactionMode -> RawSql Source # unsafeFromRawSql :: RawSql -> TransactionMode Source #

readWrite :: TransactionMode Source #

The READ WRITE transaction mode.

Since: 1.0.0.0

readOnly :: TransactionMode Source #

The READ ONLY transaction mode.

Since: 1.0.0.0

deferrable :: TransactionMode Source #

The DEFERRABLE transaction mode.

Since: 1.0.0.0

notDeferrable :: TransactionMode Source #

The NOT DEFERRABLE transaction mode.

Since: 1.0.0.0

isolationLevel :: IsolationLevel -> TransactionMode Source #

An ISOLATION LEVEL transaction mode with the given IsolationLevel.

Since: 1.0.0.0

data IsolationLevel Source #

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

Instances details

SqlExpression IsolationLevel Source #
Instance details Defined in Orville.PostgreSQL.Expr.Transaction Methods toRawSql :: IsolationLevel -> RawSql Source # unsafeFromRawSql :: RawSql -> IsolationLevel Source #

serializable :: IsolationLevel Source #

The SERIALIZABLE isolation level.

Since: 1.0.0.0

repeatableRead :: IsolationLevel Source #

The REPEATABLE READ isolation level.

Since: 1.0.0.0

readCommitted :: IsolationLevel Source #

The READ COMMITTED isolation level.

Since: 1.0.0.0

readUncommitted :: IsolationLevel Source #

The READ UNCOMMITTED isolation level.

Since: 1.0.0.0

data CommitExpr Source #

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

Instances details

SqlExpression CommitExpr Source #
Instance details Defined in Orville.PostgreSQL.Expr.Transaction Methods toRawSql :: CommitExpr -> RawSql Source # unsafeFromRawSql :: RawSql -> CommitExpr Source #

commit :: CommitExpr Source #

A COMMIT transaction statement.

Since: 1.0.0.0

data RollbackExpr Source #

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

Instances details

SqlExpression RollbackExpr Source #
Instance details Defined in Orville.PostgreSQL.Expr.Transaction Methods toRawSql :: RollbackExpr -> RawSql Source # unsafeFromRawSql :: RawSql -> RollbackExpr Source #

rollback :: RollbackExpr Source #

A ROLLBACK transaction statement.

Since: 1.0.0.0

rollbackTo :: SavepointName -> RollbackExpr Source #

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

Since: 1.0.0.0

data SavepointExpr Source #

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

Instances details

SqlExpression SavepointExpr Source #
Instance details Defined in Orville.PostgreSQL.Expr.Transaction Methods toRawSql :: SavepointExpr -> RawSql Source # unsafeFromRawSql :: RawSql -> SavepointExpr Source #

savepoint :: SavepointName -> SavepointExpr Source #

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

Since: 1.0.0.0

data ReleaseSavepointExpr Source #

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

Instances details

SqlExpression ReleaseSavepointExpr Source #
Instance details Defined in Orville.PostgreSQL.Expr.Transaction Methods toRawSql :: ReleaseSavepointExpr -> RawSql Source # unsafeFromRawSql :: RawSql -> ReleaseSavepointExpr Source #

releaseSavepoint :: SavepointName -> ReleaseSavepointExpr Source #

A RELEASE SAVEPOINT statement that will release the specified savepoint.

Since: 1.0.0.0