jaguar_query_sqflite_nullsafety library
Implements Adapter interface for SQLite database
Contains composer to compose jaguar_query statements into PostgreSQL queries
Classes
-
Adapter<
ConnType> - Adapter interface that must be implemented to support new databases
-
AddColumn<
T> - Alter
- Alter table statement
- AlterClause
- And
- A 'logical and' expression of two or more expressions
-
Bean<
ModelType> - Interface for bean class for a model
-
Between<
ValType> - An in-between conditional expression
- BoolField
- BoolField is a convenience DSL used to construct queries in a concise and understandable way.
-
Cond<
ValType> - A relational conditional expression
-
CondCol<
ValType> - A relational conditional expression
- CountSelColumn
- Create
- CreateBool
- Clause to create bool column in SQL table.
-
CreateColumn<
ValType> - Clause to create a column in a SQL table.
- CreateDateTime
- Clause to create datetime column in SQL table.
- CreateDb
- CreateDouble
- Clause to create double column in SQL table.
- CreateInt
- Clause to create int column in SQL table.
- CreateStr
- Clause to create string column in SQL table.
- DateTimeField
- DateTimeField is a convenience DSL used to construct queries in a concise and understandable way.
- DoubleField
- DoubleField is a convenience DSL used to construct queries in a concise and understandable way.
- Drop
- DropColumn
- DropDb
- Expression
- An SQL expression
-
Field<
ValType> - Field is a convenience DSL used to construct queries in a concise and understandable way.
- Find
- Select SQL statement builder.
-
FindExecutor<
ConnType> -
Convenience class to execute
Findstatement using adapter - Foreign
- ImmutableCreateStatement
- ImmutableFindStatement
- ImmutableInsertManyStatement
- ImmutableInsertStatement
- ImmutableUpdateManyStatement
- ImmutableUpdateStatement
- ImmutableUpsertManyStatement
- ImmutableUpsertStatement
-
InBetweenCol<
ValType> - An in-between conditional expression
-
InOperation<
ValType> - An in expression
- Insert
- Insert SQL statement builder.
- InsertMany
- Insert many SQL statement builder.
- IntField
- IntField is a convenience DSL used to construct queries in a concise and understandable way.
- JoinedTable
- JoinType
- A SQL join type that can be used in 'SELECT' statements
-
ModifyColumn<
T> - Op
- Relational comparision operator
- Or
- A 'logical or' expression of two or more expressions
- OrderBy
- QueryJoinedTableInfo
- QueryRemoveInfo
- Remove
- SelColumn
-
SetColumn<
ValType> - name:value pair used to set a column named name to value. Used during inserts and updates.
- Settable
- SqfliteAdapter
- Sql
- Main DSL class to create SQL statements
- Statement
- StrField
- StrField is a convenience DSL used to construct queries in a concise and understandable way.
- Table
- Table selector
- TableName
- TableName
- Update
- UpdateMany
- Upsert
- Insert or update SQL statement builder.
- UpsertMany
- Insert or update many SQL statement builder.
- Whereable
Functions
-
between<
ValType> (String field, ValType low, ValType high, {String? tableName}) → Between< ValType> - DSL to create 'in-between' relational condition
-
eq<
ValType> (String field, ValType rhs, {String? tableName}) → Cond< ValType> - DSL to create 'is equal to' relational condition
-
eqInt(
String field, int rhs, {String? tableName}) → Cond< int> - DSL to create 'is equal to' relational condition
-
eqStr(
String field, String rhs, {String? tableName}) → Cond< String> - DSL to create 'is equal to' relational condition
-
gt<
ValType> (String field, ValType rhs, {String? tableName}) → Cond< ValType> - DSL to create 'is greater than' relational condition
-
gtEq<
ValType> (String field, ValType rhs, {String? tableName}) → Cond< ValType> - DSL to create 'is greater than or equal to' relational condition
-
gtEqInt(
String field, int rhs, {String? tableName}) → Cond< int> - DSL to create 'is greater than or equal to' relational condition
-
gtEqStr(
String field, String rhs, {String? tableName}) → Cond< String> - DSL to create 'is greater than or equal to' relational condition
-
gtInt(
String field, int rhs, {String? tableName}) → Cond< int> - DSL to create 'is greater than' relational condition
-
gtStr(
String field, String rhs, {String? tableName}) → Cond< String> - DSL to create 'is greater than' relational condition
-
inBetweenInt(
String field, int low, int high, {String? tableName}) → Between< int> - DSL to create 'in-between' relational condition
-
inBetweenStr(
String field, String low, String high, {String? tableName}) → Between< String> - DSL to create 'in-between' relational condition
-
like(
String field, String value, {String? tableName}) → Cond< String> - DSL to create 'is like' relational condition
-
lt<
ValType> (String field, ValType rhs, {String? tableName}) → Cond< ValType> - DSL to create 'is less than' relational condition
-
ltEq<
ValType> (String field, ValType rhs, {String? tableName}) → Cond< ValType> - DSL to create 'is less than or equal to' relational condition
-
ltEqInt(
String field, int rhs, {String? tableName}) → Cond< int> - DSL to create 'is less than or equal to' relational condition
-
ltEqStr(
String field, String rhs, {String? tableName}) → Cond< String> - DSL to create 'is less than or equal to' relational condition
-
ltInt(
String field, int rhs, {String? tableName}) → Cond< int> - DSL to create 'is less than' relational condition
-
ltStr(
String field, String rhs, {String? tableName}) → Cond< String> - DSL to create 'is less than' relational condition
-
ne<
ValType> (String field, ValType rhs, {String? tableName}) → Cond< ValType> - DSL to create 'is not equal to' relational condition
-
neInt(
String field, int rhs, {String? tableName}) → Cond< int> - DSL to create 'is not equal to' relational condition
-
neStr(
String field, String rhs, {String? tableName}) → Cond< String> - DSL to create 'is not equal to' relational condition
Typedefs
-
ExpressionMaker<
MT> = Expression Function(Bean< MT> bean) -
MappedExpression<
T> = Expression Function(T value)