litesql library

Mixins

TableColumn
don't use 'name', use 'columnName', enum's name maybe renamed.

Extension Types

SpaceBuffer

Extensions

ExpressExt on Express
ExpressWhereExt on Express
ListJoinMapEx on List<T>
ListWhereExt on List<Where>
LiteSqlInsertExt on LiteSQL
Bare columns in an aggregate query distinct on SELECT a, b, max(c) FROM tab1 GROUP BY a; min/max 在聚合查询时, 会返回包含min/max值的行. 利用这特特性, 可以实现postgresql distinct on 的特性 https://sqlite.org/lang_select.html#bareagg https://sqlite.org/lang_select.html
QueryResultExt on QueryResult
ResultSetToQueryResultExt on ResultSet
SqliteEscapeExt on String
StringExpressExt on String
StringJoinExt on String
StringSQLExt on String
StringWhereExt on String
TableColumnExpresExt on TableColumn
TypeTableExt on TableProto
WhereEnum on TableColumn

Constants

ALL_COLUMNS → const List<String>

Properties

emptyResult → QueryResult
final
logSQL ↔ TagLog
getter/setter pair

Functions

$(Type type) → TableProto
AND_ALL(List<Where> ws) → Where
AVG(Object express) → Express
COUNT(Object express) → Express
CUME_DIST() → Express
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
LAG(Object express, [int? offset, Object? defaultValue]) → Express
LAST_VALUE(Object express) → Express
LEAD(Object express, [int? offset, Object? defaultValue]) → Express
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
TOTAL(Object express) → Express
UNION(Express left, Express right) → Express
UNION_ALL(Express left, Express right) → Express

Typedefs

BlobSQL = Uint8List
ColumnValue<T extends Object> = MapEntry<T, dynamic>
LiteIndexInfo = ({int cid, String name, int seqno})
LiteIndexInfoX = ({int cid, String coll, int desc, int key, String? name, int seqno})
LiteIndexItem = ({String name, String origin, int partial, int seq, int unique})
LiteTableInfo = ({int cid, String? dflt_value, String name, int notnull, int pk, String type})
LiteTableInfoX = ({int cid, String? dflt_value, int hidden, String name, int notnull, int pk, String type})
LiteTableItem = ({String name, int ncol, String schema, int strict, String type, int wr})
ModelCreator<T> = T Function(AnyMap)

Exceptions / Errors

SQLException