postgres
library
Mixins
-
TableColumn
-
don't use 'name', use 'columnName', enum's name maybe renamed.
Properties
-
logSQL
↔ TagLog
-
getter/setter pair
Functions
-
$(Type type)
→ TableProto
-
-
AND_ALL(List<Where> ws)
→ Where
-
-
ARRAY_BOOL(List<bool> value)
→ TypedValue<Object>
-
-
ARRAY_DOUBLE(List<double> value)
→ TypedValue<Object>
-
-
ARRAY_INT(List<int> value)
→ TypedValue<Object>
-
-
ARRAY_TEXT(List<String> value)
→ TypedValue<Object>
-
-
ARRAY_VALUE<T>(List<T> value)
→ TypedValue<Object>
-
-
AVG(Object express)
→ Express
-
-
BLOB_VALUE(List<int> value)
→ TypedValue<List<int>>
-
-
COUNT(Object express)
→ Express
-
-
CUME_DIST()
→ Express
-
-
DATE_VALUE(DateTime value)
→ TypedValue<DateTime>
-
-
DENSE_RANK()
→ Express
-
-
errorSQL(String message)
→ Never
-
-
EXCEPT(Express left, Express right)
→ Express
-
-
EXISTS(Express express)
→ Where
-
-
FIRST_VALUE(Object express)
→ Express
-
-
GROUP_CONCAT(Object express, [String sep = "','"])
→ Express
-
-
INTERSECT(Express left, Express right)
→ Express
-
-
JSON_VALUE(dynamic value)
→ TypedValue<Object>
-
value will been json.encode(value), before send to database
-
JSONB_VALUE(dynamic value)
→ TypedValue<Object>
-
value will been json.encode(value), before send to database
-
LAG(Object express, [int? offset, Object? defaultValue])
→ Express
-
-
LAST_VALUE(Object express)
→ Express
-
-
LEAD(Object express, [int? offset, Object? defaultValue])
→ Express
-
-
logQuery(String sql, AnyList? parameters)
→ void
-
-
makeIndexName(String table, List<String> fields)
→ String
-
-
MAX(Object express)
→ Express
-
-
MEDIAN(Object express)
→ Express
-
-
MIN(Object express)
→ Express
-
-
NOT(Express express)
→ Where
-
-
NTH_VALUE(Object express, int n)
→ Express
-
-
NTILE(int n)
→ Express
-
-
OR_ALL(List<Where> ws)
→ Where
-
-
ORDER_BY(Object express)
→ Express
-
-
PARTITION_BY(Object express)
→ Express
-
-
PERCENT_RANK()
→ Express
-
-
PERCENTILE(Object express, double p)
→ Express
-
-
PERCENTILE_CONT(Object express, double p)
→ Express
-
-
PERCENTILE_DISC(Object express, double p)
→ Express
-
-
PROTO(Type type)
→ TableProto
-
-
RANK()
→ Express
-
-
ROW_NUMBER()
→ Express
-
-
SELECT(AnyList columns)
→ Express
-
SELECT("name", Person.name, "name".AS("a"))
String, Express, TableColumn
-
SELECT_ALL()
→ Express
-
-
SELECT_DISTINCT(AnyList columns)
→ Express
-
-
STRING_AGG(Object express, [String sep = "','"])
→ Express
-
-
SUM(Object express)
→ Express
-
-
TIME_VALUE(Time value)
→ TypedValue<Time>
-
-
TIMESTAMP_VALUE(DateTime value)
→ TypedValue<DateTime>
-
-
TIMESTAMPZ_VALUE(DateTime value)
→ TypedValue<DateTime>
-
-
TOTAL(Object express)
→ Express
-
-
UNION(Express left, Express right)
→ Express
-
-
UNION_ALL(Express left, Express right)
→ Express
-
-
UUID_VALUE(String value)
→ TypedValue<String>
-
RowData? row = await ex.insert(Person, values: [
Person.info >> JSONB_VALUE(
1, 2, 3)
]);
