IsolationLevel enum

The isolation level of a transaction determines what data the transaction can see when other transactions are running concurrently.

Inheritance

Values

readCommitted → const IsolationLevel

A statement can only see rows committed before it began. This is the default.

const IsolationLevel._('READ COMMITTED')
repeatableRead → const IsolationLevel

All statements of the current transaction can only see rows committed before the first query or data-modification statement was executed in this transaction.

const IsolationLevel._('REPEATABLE READ')
serializable → const IsolationLevel

All statements of the current transaction can only see rows committed before the first query or data-modification statement was executed in this transaction. If a pattern of reads and writes among concurrent serializable transactions would create a situation which could not have occurred for any serial (one-at-a-time) execution of those transactions, one of them will be rolled back with a serialization_failure error.

const IsolationLevel._('SERIALIZABLE')
readUncommitted → const IsolationLevel

One transaction may see uncommitted changes made by some other transaction. In PostgreSQL READ UNCOMMITTED is treated as READ COMMITTED.

const IsolationLevel._('READ UNCOMMITTED')

Properties

hashCode int
The hash code for this object.
no setterinherited
index int
A numeric identifier for the enumerated value.
no setterinherited
queryPart String
The SQL identifier of the isolation level including "ISOLATION LEVEL" prefix and leading space.
final
runtimeType Type
A representation of the runtime type of the object.
no setterinherited

Methods

noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() String
A string representation of this object.
inherited

Operators

operator ==(Object other) bool
The equality operator.
inherited

Constants

values → const List<IsolationLevel>
A constant List of the values in this enum, in order of their declaration.