ConnectionInterface class abstract

Inheritance

• Object
• ExecutionContext
• ConnectionInterface

Implementers

• CoreConnection
• PostgreSqlPool

Constructors

ConnectionInterface()

Properties

hashCode → int

The hash code for this object.

no setter, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

beginTransaction() → Future<TransactionContext>

close() → Future<void>

commit(TransactionContext transaction) → Future<void>

connect({int? delayBeforeConnect}) → Future<CoreConnection>

execute(String sql) → Future<int>

execute a sql command e return affected row count Example: con.execute('DROP SCHEMA IF EXISTS myschema CASCADE;')

inherited

executeStatement(Query query, {bool isDeallocate = false}) → Future<Results>

run prepared query with (prepareStatement) method and return List of Row

inherited

executeStatementAsStream(Query query) → Future<ResultStream>

run query prepared with (prepareStatement) method

inherited

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

prepareStatement(String sql, dynamic params, {bool isUnamedStatement = false, PlaceholderIdentifier placeholderIdentifier = PlaceholderIdentifier.pgDefault}) → Future<Query>

prepare statement params parameters can be a list or a map, if you use placeholderIdentifier is PlaceholderIdentifier.pgDefault or PlaceholderIdentifier.onlyQuestionMark it has to be a List, if different it has to be a Map return Query prepared with statementName for execute with (executeStatement) method Example: var statement = await prepareStatement('SELECT * FROM table LIMIT $1', 0); var result await executeStatement(statement);

inherited

queryNamed(String sql, dynamic params, {PlaceholderIdentifier placeholderIdentifier = PlaceholderIdentifier.pgDefault, bool isDeallocate = false}) → Future<Results>

inherited

querySimple(String sql) → Future<Results>

execute a simple query whitout prepared statement this use a simple Postgresql Protocol https://www.postgresql.org/docs/current/protocol-flow.html#id-1.10.6.7.4

inherited

querySimpleAsStream(String sql) → Future<ResultStream>

execute a simple query whitout prepared statement this use a simple Postgresql Protocol https://www.postgresql.org/docs/current/protocol-flow.html#id-1.10.6.7.4

inherited

queryUnnamed(String sql, dynamic params, {PlaceholderIdentifier placeholderIdentifier = PlaceholderIdentifier.pgDefault, bool isDeallocate = false}) → Future<Results>

execute a prepared unnamed statement params parameters can be a list or a map, if you use placeholderIdentifier is PlaceholderIdentifier.pgDefault or PlaceholderIdentifier.onlyQuestionMark it has to be a List, if different it has to be a Map return Query prepared with statementName for execute with (executeStatement) method Example: com.queryUnnamed(r'select * from crud_teste.pessoas limit $1', 1);

inherited

rollBack(TransactionContext transaction) → Future<void>

runInTransaction<T>(Future<T> operation(TransactionContext ctx)) → Future<T>

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited