Uses of Interface com.gengoai.sql.operator.SQLOperable (com.gengoai:mango 1.1-SNAPSHOT API)

Packages that use SQLOperable
Package Description

com.gengoai.sql

com.gengoai.sql.object

com.gengoai.sql.operator

Packages that use SQLOperable
Package	Description
com.gengoai.sql
com.gengoai.sql.object
com.gengoai.sql.operator

Uses of SQLOperable in com.gengoai.sql

Subinterfaces of SQLOperable in com.gengoai.sql
Modifier and Type	Interface	Description
`interface`	`CompositeSQLElement`	An `SQLElement` that is made up of one more sub elements.
`interface`	`PreRenderedSQL`	An `SQLElement` that is already rendered into SQL.

Classes in com.gengoai.sql that implement SQLOperable
Modifier and Type	Class	Description
`class`	`SQLFunction`	Encapsulates an SQL Function (e.g.

Methods in com.gengoai.sql that return SQLOperable
Modifier and Type	Method	Description
`static SQLOperable`	SQL.F.`abs(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the absolute value of the given argument.
`static SQLOperable`	SQL.F.`abs(@NonNull String arg)`	Generates an `SQLOperable` representing the absolute value of the given column.
`static SQLOperable`	SQL.`and(@NonNull SQLElement... elements)`	Combines one or more SQLElements via an `AND`
`static SQLOperable`	SQL.F.`average(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the average value of the given argument.
`static SQLOperable`	SQL.F.`average(@NonNull String arg)`	Generates an `SQLOperable` representing the average value of the given column.
`static SQLOperable`	SQL.`C(@NonNull Table table, String column)`
`static SQLOperable`	SQL.`C(String column)`	An `SQLOperable` defining a column name.
`static SQLOperable`	SQL.`C(String table, String column)`	An `SQLOperable` defining a fully qualified column name.
`static SQLOperable`	SQL.F.`coalesce(@NonNull SQLElement... args)`	Generates an `SQLOperable` representing the coalesce function which returns the first non-null value.
`static SQLOperable`	SQL.F.`count(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the count value of the given argument.
`static SQLOperable`	SQL.F.`count(@NonNull String arg)`	Generates an `SQLOperable` representing the count value of the given column.
`static SQLOperable`	SQL.F.`countDistinct(@NonNull SQLOperable arg)`	Generates an `SQLOperable` representing the distinct count value of the given argument.
`static SQLOperable`	SQL.F.`countDistinct(@NonNull String arg)`	Generates an `SQLOperable` representing the distinct count value of the given column.
`static SQLOperable`	SQL.F.`date(@NonNull SQLElement timeString, @NonNull SQLElement... args)`	Generates an `SQLOperable` representing the date function, which converts the given time string into a date object.
`static SQLOperable`	SQL.F.`date(@NonNull String timeString, @NonNull SQLElement... args)`	Generates an `SQLOperable` representing the date function, which converts the given time string into a date object.
`static SQLOperable`	SQL.F.`dateTime(@NonNull SQLElement timeString, @NonNull SQLElement... args)`	Generates an `SQLOperable` representing the datetime function, which converts the given time string into a date object.
`static SQLOperable`	SQL.F.`dateTime(@NonNull String timeString, @NonNull SQLElement... args)`	Generates an `SQLOperable` representing the datetime function, which converts the given time string into a date object.
`static SQLOperable`	SQL.`exists(@NonNull QueryStatement query)`	Creates an "exists" cause checking for the existence of a record in a sub query.
`static SQLOperable`	SQL.`group(@NonNull SQLElement... elements)`	Groups one or more expressions by placing them in parenthesis
`static SQLOperable`	SQL.F.`groupConcat(@NonNull SQLElement arg, @NonNull String delimiter)`	Generates an `SQLOperable` representing the group concat function, which concatenates one more items with a given delimiter.
`static SQLOperable`	SQL.F.`groupConcat(@NonNull String arg, @NonNull String delimiter)`	Generates an `SQLOperable` representing the group concat function, which concatenates one more items with a given delimiter.
`static SQLOperable`	SQL.F.`groupConcat(@NonNull Collection<? extends SQLElement> args, @NonNull String delimiter)`	Generates an `SQLOperable` representing the group concat function, which concatenates one more items with a given delimiter.
`static SQLOperable`	SQL.F.`ifNull(@NonNull SQLElement expression, @NonNull SQLElement value)`	Generates an `SQLOperable` representing an "if null" function, which returns the specified value if the expression is null.
`static SQLOperable`	SQL.F.`instr(@NonNull SQLElement string, @NonNull SQLElement substring)`	Generates an `SQLOperable` representing an "in string" function, which searches a string for a substring.
`static SQLOperable`	SQL.F.`instr(@NonNull SQLElement string, @NonNull String substring)`	Generates an `SQLOperable` representing an "in string" function, which searches a string for a substring.
`static SQLOperable`	SQL.F.`json_extract(@NonNull SQLElement json, @NonNull SQLElement jsonPath)`	Generates an `SQLOperable` representing a function to extract a json value (object, array, primitive) from a json column for a given path in the json tree.
`static SQLOperable`	SQL.F.`json_extract(@NonNull String column, @NonNull String jsonPath)`	Generates an `SQLOperable` representing a function to extract a json value (object, array, primitive) from a json column for a given path in the json tree.
`static SQLOperable`	SQL.`L(@NonNull String value)`	An `SQLOperable` defining a literal expression, which will automatically be placed in single quotes.
`static SQLOperable`	SQL.F.`length(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the length of the string value represented by the given argument.
`static SQLOperable`	SQL.F.`length(@NonNull String arg)`	Generates an `SQLOperable` representing the length of the string value in the given column.
`static SQLOperable`	SQL.F.`lower(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the lower function, which lower cases a string value.
`static SQLOperable`	SQL.F.`lower(@NonNull String arg)`	Generates an `SQLOperable` representing the lower function, which lower cases a string value.
`static SQLOperable`	SQL.F.`ltrim(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the ltrim function, which trims from the left side of a string.
`static SQLOperable`	SQL.F.`ltrim(@NonNull String arg)`	Generates an `SQLOperable` representing the ltrim function, which trims from the left side of a string.
`static SQLOperable`	SQL.F.`max(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the max function.
`static SQLOperable`	SQL.F.`max(@NonNull String arg)`	Generates an `SQLOperable` representing the max function.
`static SQLOperable`	SQL.F.`min(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the min function.
`static SQLOperable`	SQL.F.`min(@NonNull String arg)`	Generates an `SQLOperable` representing the min function.
`static SQLOperable`	SQL.`N(@NonNull Number value)`	Generates an `SQLOperable` for a numeric value
`static SQLOperable`	SQL.`namedArgument(@NonNull String name)`	Generates a named argument for use with `NamedPreparedStatement`
`static SQLOperable`	SQL.F.`nullIf(@NonNull SQLElement arg1, @NonNull SQLElement arg2)`	Generates an `SQLOperable` representing an "null if" function, which returns null if the two arguments are equal.
`static SQLOperable`	SQL.`or(@NonNull SQLElement... elements)`	Combines one or more SQLElements via an `OR`
`static SQLOperable`	SQL.F.`random()`	Generates an `SQLOperable` representing the random function
`static SQLOperable`	SQL.F.`regexp(@NonNull SQLElement arg1, @NonNull SQLElement arg2)`	Generates an `SQLOperable` representing a regular expression matching operating
`static SQLOperable`	SQL.F.`regexp(@NonNull SQLElement arg1, @NonNull String arg2)`	Generates an `SQLOperable` representing a regular expression matching operating
`static SQLOperable`	SQL.F.`replace(@NonNull SQLElement arg, String pattern, String replacement)`	Generates an `SQLOperable` representing an string "replace" function, which replaces a given pattern with a given replacement in string expression.
`static SQLOperable`	SQL.F.`replace(@NonNull String column, String pattern, String replacement)`	Generates an `SQLOperable` representing an string "replace" function, which replaces a given pattern with a given replacement in string expression.
`static SQLOperable`	SQL.F.`round(@NonNull SQLElement arg, int precision)`	Generates an `SQLOperable` that rounds the given argument to the given precision.
`static SQLOperable`	SQL.F.`round(@NonNull String column, int precision)`	Generates an `SQLOperable` that rounds the given argument to the given precision.
`static SQLOperable`	SQL.F.`rtrim(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the right function, which trims from the right side of a string.
`static SQLOperable`	SQL.F.`rtrim(@NonNull String arg)`	Generates an `SQLOperable` representing the rtrim function, which trims from the right side of a string.
`static SQLOperable`	SQL.F.`strftime(@NonNull SQLElement format, @NonNull SQLElement timeString, @NonNull SQLElement... args)`	Generates an `SQLOperable` representing a function to format times as strings.
`static SQLOperable`	SQL.F.`substr(@NonNull SQLElement arg, int start, int length)`	Generates an `SQLOperable` representing an "substring" function, which returns a substring from the given starting position and of the given length from an argument.
`static SQLOperable`	SQL.F.`substr(@NonNull SQLElement arg, @NonNull SQLElement start, @NonNull SQLElement length)`	Generates an `SQLOperable` representing an "substring" function, which returns a substring from the given starting position and of the given length from an argument.
`static SQLOperable`	SQL.F.`substr(@NonNull String column, int start, int length)`	Generates an `SQLOperable` representing an "substring" function, which returns a substring from the given starting position and of the given length from an argument.
`static SQLOperable`	SQL.F.`substr(@NonNull String column, @NonNull SQLElement start, @NonNull SQLElement length)`	Generates an `SQLOperable` representing an "substring" function, which returns a substring from the given starting position and of the given length from an argument.
`static SQLOperable`	SQL.F.`sum(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the sum function.
`static SQLOperable`	SQL.F.`sum(@NonNull String column)`	Generates an `SQLOperable` representing the sum function.
`static SQLOperable`	SQL.F.`time(@NonNull SQLOperable timeString, @NonNull SQLElement... args)`	Generates an `SQLOperable` representing the datetime function, which converts the given time string into a date object.
`static SQLOperable`	SQL.F.`time(@NonNull String timeString, @NonNull SQLElement... args)`	Generates an `SQLOperable` representing the time function, which converts the given time string into a date object.
`static SQLOperable`	SQL.F.`trim(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the trim function, which trims from the right and left side of a string.
`static SQLOperable`	SQL.F.`trim(@NonNull String arg)`	Generates an `SQLOperable` representing the trim function, which trims from the right and left side of a string.
`static SQLOperable`	SQL.F.`upper(@NonNull SQLElement arg)`	Generates an `SQLOperable` representing the lower function, which lower cases a string value.
`static SQLOperable`	SQL.F.`upper(@NonNull String arg)`	Generates an `SQLOperable` representing the upper function, which lower cases a string value.

Methods in com.gengoai.sql with parameters of type SQLOperable
Modifier and Type	Method	Description
`static SQLOperable`	SQL.F.`countDistinct(@NonNull SQLOperable arg)`	Generates an `SQLOperable` representing the distinct count value of the given argument.
`static SQLOperable`	SQL.F.`time(@NonNull SQLOperable timeString, @NonNull SQLElement... args)`	Generates an `SQLOperable` representing the datetime function, which converts the given time string into a date object.

Uses of SQLOperable in com.gengoai.sql.object

Classes in com.gengoai.sql.object that implement SQLOperable
Modifier and Type	Class	Description
`class`	`Column`	Represents a column in a database table.
`class`	`Table`	The type Table.

Methods in com.gengoai.sql.object that return SQLOperable
Modifier and Type	Method	Description
`SQLOperable`	Table.`qualifiedColumnName(@NonNull Column column)`	Gets the qualified column name, i.e.
`SQLOperable`	Table.`qualifiedColumnName(@NonNull String column)`	Gets the qualified column name, i.e.

Uses of SQLOperable in com.gengoai.sql.operator

Classes in com.gengoai.sql.operator that implement SQLOperable
Modifier and Type	Class	Description
`class`	`Between`	Specialized operator for SQL Between operators
`class`	`InfixBinaryOperator`	Specialized operator for binary infix operators
`class`	`PostfixUnaryOperator`	Unary Postfix `SQLOperator`
`class`	`PrefixUnaryOperator`	Unary Prefix `SQLOperator`
`class`	`QueryOperator`	A `SQLOperator` which works on `QueryStatement`s and result is also an `QueryStatement`
`class`	`SQLOperator`	Defines an SQL operator that operators over one or more `SQLElement`

Methods in com.gengoai.sql.operator that return SQLOperable
Modifier and Type	Method	Description
`default SQLOperable`	SQLOperable.`add(@NonNull SQLElement rhs)`	Adds this element with the given element.
`default SQLOperable`	SQLOperable.`add(@NonNull Number rhs)`	Adds this element with the given number.
`default SQLOperable`	SQLOperable.`and(@NonNull SQLElement rhs)`	Ands this element with given element.
`default SQLOperable`	SQLOperable.`as(@NonNull String name)`	Defines an alias over a column, table, or subquery.
`default SQLOperable`	SQLOperable.`asc()`	Informs the query that this element is to be sorted in ascending order.
`default SQLOperable`	SQLOperable.`between(@NonNull SQLElement lower, @NonNull SQLElement upper)`	Creates a BETWEEN operator with this element representing the column name
`default SQLOperable`	SQLOperable.`between(@NonNull Number lower, @NonNull Number upper)`	Creates a BETWEEN operator with this element representing the column name
`default SQLOperable`	SQLOperable.`concat(@NonNull SQLElement rhs)`	Concatenates this element with the given element
`default SQLOperable`	SQLOperable.`desc()`	Informs the query that this element is to be sorted in descending order.
`default SQLOperable`	SQLOperable.`div(@NonNull SQLElement rhs)`	Divides this element by the given element.
`default SQLOperable`	SQLOperable.`div(@NonNull Number rhs)`	Divides this element by the given element.
`default SQLOperable`	SQLOperable.`eq(@NonNull SQLElement rhs)`	Creates an equality check between this element and the given element
`default SQLOperable`	SQLOperable.`eq(@NonNull Number rhs)`	Creates an equality check between this element and the given element
`default SQLOperable`	SQLOperable.`fullTextMatch(@NonNull String string)`	Creates a full text search operator using this element as the column
`default SQLOperable`	SQLOperable.`gt(@NonNull SQLElement rhs)`	Creates a greater than equality check between this element and the given element
`default SQLOperable`	SQLOperable.`gt(@NonNull Number rhs)`	Creates a greater than equality check between this element and the given element
`default SQLOperable`	SQLOperable.`gte(@NonNull SQLElement rhs)`	Creates a greater than equal to equality check between this element and the given element
`default SQLOperable`	SQLOperable.`gte(@NonNull Number rhs)`	Creates a greater than equal to equality check between this element and the given element
`default SQLOperable`	SQLOperable.`in(@NonNull SQLElement element)`	Creates an IN operator treating this element as the item being checked and the given element as the list of items being checked in.
`default SQLOperable`	SQLOperable.`isNotNull()`	Creates an is not null check for this element
`default SQLOperable`	SQLOperable.`isNull()`	Creates a null check for this element
`default SQLOperable`	SQLOperable.`like(@NonNull SQLElement rhs)`	Creates a LIKE operator with this element as the column or expression being checked .
`default SQLOperable`	SQLOperable.`lt(@NonNull SQLElement rhs)`	Creates a less than equality check between this element and the given element
`default SQLOperable`	SQLOperable.`lt(@NonNull Number rhs)`	Creates a less than equality check between this element and the given element
`default SQLOperable`	SQLOperable.`lte(@NonNull SQLElement rhs)`	Creates a less than or equal to equality check between this element and the given element
`default SQLOperable`	SQLOperable.`lte(@NonNull Number rhs)`	Creates a less than or equal to equality check between this element and the given element
`default SQLOperable`	SQLOperable.`mod(@NonNull SQLElement rhs)`	Creates an `SQLOperable` that is the result of taking mode `rhs` of this number.
`default SQLOperable`	SQLOperable.`mod(@NonNull Number rhs)`	Creates an `SQLOperable` that is the result of taking mode `rhs` of this number.
`default SQLOperable`	SQLOperable.`mul(@NonNull SQLElement rhs)`	Multiplies this element with the given element.
`default SQLOperable`	SQLOperable.`mul(@NonNull Number rhs)`	Multiplies this element with the given element.
`default SQLOperable`	SQLOperable.`neq(@NonNull SQLElement rhs)`	Creates an inequality check between this element and the given element
`default SQLOperable`	SQLOperable.`neq(@NonNull Number rhs)`	Creates an inequality check between this element and the given element
`default SQLOperable`	SQLOperable.`not()`	Negates this expression
`default SQLOperable`	SQLOperable.`or(@NonNull SQLElement rhs)`	ORs this element with given element.
`default SQLOperable`	SQLOperable.`pow(@NonNull SQLElement rhs)`	Creates an `SQLOperable` that is the result of raising this number to the power of `rhs`.
`default SQLOperable`	SQLOperable.`pow(@NonNull Number rhs)`	Creates an `SQLOperable` that is the result of raising this number to the power of `rhs`.
`default SQLOperable`	SQLOperable.`regexp(@NonNull String regex)`	Checks if this element matches the given regular expression
`default SQLOperable`	SQLOperable.`sub(@NonNull SQLElement rhs)`	Subtracts the given element from this element with.
`default SQLOperable`	SQLOperable.`sub(@NonNull Number rhs)`	Subtracts the given element from this element with.

Uses of Interfacecom.gengoai.sql.operator.SQLOperable

Uses of SQLOperable in com.gengoai.sql

Uses of SQLOperable in com.gengoai.sql.object

Uses of SQLOperable in com.gengoai.sql.operator

Uses of Interface
com.gengoai.sql.operator.SQLOperable