postgres_dart library
Support for doing something awesome.
More dartdocs go here.
Classes
- Aggregate
-
Aggregate functions such as Count, Sum, Avg, min and max
columnName The Column being aggregated; ie,
SUM("amount")
whereamount
is the columnName label is used for the column name; ie:sum("amount") as myTotal
, where myTotal is the label castToNumeric is used when the some or all the values in the columns are saved as String(varchar) but are numbers; converts"10"
to 10 - Avg
- Avg returns the average for specified column
- Column
- columnName is the column name as in the table columnAs is name of the column on the response
- ColumnDescription
- A description of a column.
- Count
- Count returns the total row count for the query
- DbResponse
- Join
- tableAs is an alias you can assign to the table for easier table reference; ie, if the table is named myTable, and given tableAs as mt Accessing columns can be mt.amount instead od myTable.amount
- JoinOn
- ON leftTable.column1 = rightTable.column2
- JoinUsing
- Using (columnName)
- LSN
- LSN is a PostgreSQL Log Sequence Number.
- Max
- Returns the maximum Value in the given column
- Min
- Returns the minimum Value in the given column
- Notification
- Represents a notification from PostgreSQL.
- OnorUsing
- OrderBy
- For multiple order by, use OrderBy.and ie;
- PgPoint
-
Describes PostgreSQL's geometric type:
point
. - PostgresDb
- PostgreSQLConnection
- Instances of this class connect to and communicate with a PostgreSQL database.
- PostgreSQLExecutionContext
- PostgreSQLFormat
- PostgreSQLResult
- The query result.
- PostgreSQLResultRow
- A single row of a query result.
- PostgreSQLRollback
- Represents a rollback from a transaction.
- PostgresTable
-
Contains Table methods such as select, insert,
inserMany
, update, delete, deleteAll, min, max, count, sum, avg, aggregate, group, join - Sum
- Sum returns the total sum for specified column
- Where
-
Where("age", WhereOperator.isGreaterThan, 40); Where("age", WhereOperator.isGreaterThan, 40).and("gender", WhereOperator.isEqual, "M"); Where.not("age", WhereOperator.isGreaterThan, 40).and("gender", WhereOperator.isEqual, "M");
Enums
- AggregateType
- JoinType
- PostgreSQLSeverity
- The severity level of a PostgreSQLException.
- ReplicationMode
- Streaming Replication Protocol Options
- WhereOperator
Typedefs
-
PostgreSQLDataType
= PgDataType<
Object>
Exceptions / Errors
- PostgreSQLException
- Exception thrown by PostgreSQLConnection instances.