LiteSQL class
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
Constructors
- LiteSQL({required Database database})
Properties
- database → Database
-
final
- hashCode → int
-
The hash code for this object.
no setterinherited
- lastInsertRowId ↔ int
-
getter/setter pair
- PRAGMA → Pragma
-
latefinal
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- updatedRows → int
-
no setter
- user_version ↔ int
-
getter/setter pair
Methods
-
close(
) → void -
countTable(
String table) → int -
createIndex(
String table, List< String> fields) → void -
createTable(
String table, List< String> columns, {List<String> constraints = const [], List<String> options = const []}) → void -
dropIndex(
String table, String fieldName) → void -
dropTable(
String table) → void -
dumpTable(
String table) → void -
execute(
String sql, [List< Object?> ? parameters]) → void -
existTable(
String table) → bool -
listIndex(
) → List< IndexName> -
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
prepareSQL(
String sql) → PreparedStatement -
rawInsert(
String sql, [List< Object?> ? parameters]) → int -
rawQuery(
String sql, [List< Object?> ? parameters]) → ResultSet -
rawUpdate(
String sql, [List< Object?> ? parameters]) → int -
stepQuery(
String sql, [List< Object?> ? parameters]) → StepCursor -
tableInfo(
String tableName) → List< SqliteTableInfo> -
toString(
) → String -
A string representation of this object.
inherited
-
transaction(
void callback()) → void -
vacuum(
) → void
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited
Static Properties
- version ↔ Version
-
getter/setter pair