Package-level declarations
Types
Bulk insert expression, represents a bulk insert statement in MySQL.
DSL builder for bulk insert or update on duplicate key clause.
DSL builder for bulk insert or update statements.
DSL builder for bulk insert statements.
Insert or update expression, represents an insert statement with an on duplicate key update
clause in MySQL.
DSL builder for insert or update statements.
MySQL locking clause, See https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
MySQL locking mode.
MySQL wait strategy for locked records.
Match against expression, represents an match ... against ...
operation in MySQL. See https://dev.mysql.com/doc/refman/5.5/en/insert-on-duplicate.html
Intermediate class that wraps the search columns of a MatchAgainstExpression.
Base class of MySQL DSL builders, provide basic functions used to build assignments for insert or update DSL.
SqlDialect implementation for MySQL database.
Base interface designed to visit or modify MySQL expression trees using visitor pattern.
SqlFormatter implementation for MySQL, formatting SQL expressions as strings with their execution arguments.
MySQL natural join expression.
Enum class represents search modifiers in MySQL match ... against ...
expressions. See https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html
Functions
Create a MatchAgainstExpression that searches on the current MatchColumns. Translated to match (col1, col2) against (searchString modifier)
in SQL.
Construct a bulk insert expression in the given closure, then execute it and return the effected row count.
Bulk insert records to the table, determining if there is a key conflict while inserting each of them, and automatically performs updates if any conflict exists.
MySQL datediff function, translated to datediff(left, right)
.
Return a default value for this column, see DefaultValueExpression.
MySQL greatest function, translated to greatest(column1, column2, ...)
.
MySQL greatest function, translated to greatest(left, right)
.
MySQL if
function, translated to if(condition, then, otherwise)
.
MySQL ifnull function, translated to ifnull(left, right)
.
Insert a record to the table, determining if there is a key conflict while it's being inserted, and automatically performs an update if any conflict exists.
MySQL json_extract function, translated to json_extract(column, path)
.
MySQL least function, translated to least(column1, column2, ...)
.
MySQL least function, translated to least(left, right)
.
Specify the locking clause of this query, an example generated SQL could be:
Return an intermediate object that wraps the columns to be searched. We can continue to call against on the returned object to create a MatchAgainstExpression that searches the wrapped columns.
Join the right table and return a new QuerySource, translated to natural join
in SQL.
MySQL rand function, translated to rand()
.
MySQL replace function, translated to replace(str, oldValue, newValue)
.
MySQL lower function, translated to lower(str).
MySQL upper function, translated to upper(str).