jaguar_query_sqljocky library

Implements Adapter interface for MySQL database

Contains composer to compose jaguar_query statements into MySQL 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 Find statement using adapter
Foreign
ImmutableCreateStatement
ImmutableFindStatement
ImmutableInsertManyStatement
ImmutableInsertStatement
ImmutableUpdateManyStatement
ImmutableUpdateStatement
ImmutableUpsertManyStatement
ImmutableUpsertStatement
InBetweenCol<ValType>
An in-between conditional 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>
MysqlAdapter
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
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>(Bean<MT> bean) Expression
MappedExpression<T>(T value) Expression