raindrop_sqlite library

Classes

BigIntTransformer
Encodes a BigInt as one sign byte followed by big-endian magnitude bytes, so values of any size round-trip exactly.
BooleanTransformer
Encodes a bool as an int, where true becomes 1 and false becomes 0.
CurrentTimestamp
SQLite CURRENT_TIMESTAMP, YYYY-MM-DD HH:MM:SS in UTC.
DateTimeTransformer
Encodes a DateTime as its DateTime.millisecondsSinceEpoch value.
Excluded<V>
A reference to a column of the excluded row, the row that an insert tried and failed to store.
LimitedWriteClause
A capped UPDATE or DELETE, in whichever form the library can parse.
OnConflictBuilder<S extends Schema<R>, R>
An opened ON CONFLICT [(target)] [WHERE ...] clause, closed by doNothing or doUpdate.
OnConflictClause
An ON CONFLICT [(target)] [WHERE ...] DO ... clause of a SQLite insert.
ReturningClause
RETURNING <selection> for this driver's writes (whole-row by table).
SQLiteDelegate
Delegate for the SQLite database.
SQLiteDialect
SQL dialect for the SQLite database.
TransactionDelegate
Delegate used within transactional environments.
Unixepoch
SQLite unixepoch(), seconds since the epoch, evaluated by the database.

Extensions

BigIntColumnDefinition on SchemaBuilder<R>
Arbitrary-precision integers, stored as a BLOB.
BlobColumnDefinition on SchemaBuilder<R>
Raw binary data, stored as a BLOB.
BooleanColumnDefinition on SchemaBuilder<R>
Booleans, stored as an INTEGER.
DateTimeColumnDefinition on SchemaBuilder<R>
Timestamps, stored as an INTEGER.
IntColumnDefinition on SchemaBuilder<R>
Whole numbers, stored as an INTEGER.
RealColumnDefinition on SchemaBuilder<R>
Floating-point numbers, stored as a REAL.
SQLiteDeleteLimit on DeleteWhereBuilder<S, R, V>
SQLite supports capping a DELETE.
SQLiteDeleteLimitedReturning on DeleteLimitedBuilder<S, R, void>
Adds .returning() to a capped delete.
SQLiteDeleteReturning on DeleteWhereBuilder<S, R, void>
Adds .returning() to a delete.
SQLiteInsertOrIgnore on RaindropExecutor<Delegate>
Adds insertOrIgnore for SQLite, which skips rows that would violate a constraint instead of failing.
SQLiteInsertReturning on InsertWithValuesBuilder<S, R, void>
Adds .returning() to an insert.
SQLiteOnConflictExtension on InsertWithValuesBuilder<S, R, void>
Adds onConflict(...) to a SQLite insert, opening an upsert clause that reads in SQL order:
SQLiteUpdateLimit on UpdateWhereBuilder<S, R, V>
SQLite supports capping an UPDATE.
SQLiteUpdateLimitedReturning on UpdateLimitedBuilder<S, R, void>
Adds .returning() to a capped update.
SQLiteUpdateReturning on UpdateWhereBuilder<S, R, void>
Adds .returning() to an update.
TextColumnDefinition on SchemaBuilder<R>
Strings, stored as a TEXT.

Constants

dialect → const SQLiteDialect
This driver's dialect.

Functions

currentTimestamp() → CurrentTimestamp
SQLite CURRENT_TIMESTAMP, YYYY-MM-DD HH:MM:SS in UTC.
excluded<V>(ColumnType<V> column) → Excluded<V>
The row that failed to insert, usable in doUpdate assignments:
sqliteTable<S extends Schema<R>, R>(String name, S builder(SchemaBuilder<R>), [void extra(S table)?]) → S
Creates a SQLite table with the given name and builder.
unixepoch() → Unixepoch
SQLite unixepoch(), seconds since the epoch, evaluated by the database.