PostgresqlAccess class
The PostgreSQL plugin used with the Postgresql2 driver.
Note
- It assumes the table name is the same as
Entity.otype. - Each table has a primary key called
oid. - It assumes case-sensitive for the names of tables and columns.
- Implemented types
Constructors
- PostgresqlAccess(Connection conn, {bool cache = true})
- Constructor. *
Properties
- agent → AccessAgent
-
The interface for accessing the storage (aka., database).
*
no setteroverride
- conn → Connection
-
The connection to the postgreSQL server.
final
- hashCode → int
-
The hash code for this object.
no setterinherited
- reader → AccessReader
-
The access reader for converting data from what the database returns.
final
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- writer → AccessWriter
-
The access writer for converting data into what the database accepts.
final
Methods
-
cache<
T extends Entity> (T entity) → T -
Caches the entity.
It returns
entitydirectly.override -
clearCache(
) → void - Clear the cache.
-
execute(
String sql, [Map? values]) → Future< int> - Queues a command for execution, and when done, returns the number of rows affected by the SQL command.
-
fetch<
T extends Entity> (String? otype, String? oid) → T? -
Returns the entity of the given OID, if it is stored in the cache.
override
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
query(
String sql, [Map? values]) → Stream< Row> - Queue a SQL query to be run, returning a Stream of rows.
-
toString(
) → String -
A string representation of this object.
inherited
-
uncache(
String? otype, String? oid) → Entity? -
Removes the caching of the entity of the given
otypeandoid.override
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited