mysql library
Classes
-
ARRAY<
T extends Object> - BasicMigrator
- BasicMySQLMigrator
- BasicPostgresMigrator
- BasicSQLiteMigrator
- BIGINT
- BLOB
- BOOLEAN
- CHAR
- ColumnMeta
- ColumnProto
- ConnectionSettings
- DATE
- DOUBLE
- Endpoint
- Express
- ExpressFunc
- FLOAT32
- INT32
- JoinExpress
- JSON
- JSONB
-
RowData? row = await ex.insert(Person, values: [
Person.info >> JSONB_VALUE(
1, 2, 3) ]); - MySQLExecutor
- MySQLPoolExecutor
- NUMERIC
- OnMigrate
- OnMigratorMySQL
- OnMigratorPostgres
- OnMigratorSQLite
- PoolSettings
- QueryResult
- ResultMeta
- Returning
- RowData
- RowStreamIterator
- SessionExecutor
- SQLExecutor
-
TableModel<
E> -
TableOf<
M extends TableModel< E> , E> - TableProto
- TEXT
- TIME
- TIMESTAMP
- TIMESTAMPTZ
- TIMETZ
- TranscationalExecutor
- UUID
- VARCHAR
- Where
Mixins
- TableColumn
- don't use 'name', use 'columnName', enum's name maybe renamed.
Extension Types
Extensions
-
AnyListEmptyExt
on List<
T> ? - Asss on StringBuffer
- ConnectionExecutorTableExt on TranscationalExecutor
- ExpressExecutorExt on T
- ExpressExt on Express
- ExpressTypedExt on T
- ExpressWhereExt on Express
-
ListWhereExt
on List<
Where> - LiteSqlInsertExt on SQLExecutor
- QueryResultExt on QueryResult
- SqliteEscapeExt on String
-
StreamDoneExt
on Stream<
T> - StringExpressExt on String
- StringJoinExt on String
- StringSQLExt on String
- StringWhereExt on String
- TableColumnExpresExt on TableColumn
- TypeTableExt on TableProto
- WhereEnum on TableColumn
Properties
- 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 -
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 -
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> -
FutureCallback
= Future<
void> Function() -
FutureOrCallback
= FutureOr<
void> Function() -
ModelCreator<
T> = T Function(AnyMap)