Index

$ A C D E F G H I J L M N O P Q R S T U V W
All Classes and Interfaces|All Packages

$

$(T) - Static method in class io.github.torand.fastersql.constant.Constants

Creates a scalar value constant.

A

abs(Expression) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the absolute value function for a numeric expression.

Abs - Class in io.github.torand.fastersql.function.singlerow

Implements the absolute value numeric function.

AccessDialect - Class in io.github.torand.fastersql.dialect

Defines the Microsoft Access SQL dialect.

AccessDialect() - Constructor for class io.github.torand.fastersql.dialect.AccessDialect

Creates a Microsoft Access Dialect implementation.

add(Expression, Expression) - Static method in class io.github.torand.fastersql.expression.arithmetic.ArithmeticExpressions

Creates an addition (sum) expression.

Addition - Class in io.github.torand.fastersql.expression.arithmetic

Implements the addition (sum) expression.

AggregateFunction - Interface in io.github.torand.fastersql.function.aggregate

Defines a function that returns a single value based upon a set of other values fetched from multiple rows.

AggregateFunctions - Class in io.github.torand.fastersql.function.aggregate

Provides factory methods for aggregate functions.

alias() - Method in class io.github.torand.fastersql.alias.ColumnRef

alias() - Method in class io.github.torand.fastersql.constant.GenericConstant

alias() - Method in class io.github.torand.fastersql.constant.NullConstant

alias() - Method in class io.github.torand.fastersql.expression.arithmetic.Addition

alias() - Method in class io.github.torand.fastersql.expression.arithmetic.Division

alias() - Method in class io.github.torand.fastersql.expression.arithmetic.Modulo

alias() - Method in class io.github.torand.fastersql.expression.arithmetic.Multiplication

alias() - Method in class io.github.torand.fastersql.expression.arithmetic.Subtraction

alias() - Method in class io.github.torand.fastersql.function.aggregate.Avg

alias() - Method in class io.github.torand.fastersql.function.aggregate.Count

alias() - Method in class io.github.torand.fastersql.function.aggregate.CountAll

alias() - Method in class io.github.torand.fastersql.function.aggregate.Max

alias() - Method in class io.github.torand.fastersql.function.aggregate.Min

alias() - Method in class io.github.torand.fastersql.function.aggregate.Sum

alias() - Method in class io.github.torand.fastersql.function.singlerow.Abs

alias() - Method in class io.github.torand.fastersql.function.singlerow.Ceil

alias() - Method in class io.github.torand.fastersql.function.singlerow.Concat

alias() - Method in class io.github.torand.fastersql.function.singlerow.Floor

alias() - Method in class io.github.torand.fastersql.function.singlerow.Length

alias() - Method in class io.github.torand.fastersql.function.singlerow.Lower

alias() - Method in class io.github.torand.fastersql.function.singlerow.Round

alias() - Method in class io.github.torand.fastersql.function.singlerow.Substring

alias() - Method in class io.github.torand.fastersql.function.singlerow.ToChar

alias() - Method in class io.github.torand.fastersql.function.singlerow.ToNumber

alias() - Method in class io.github.torand.fastersql.function.singlerow.Upper

alias() - Method in class io.github.torand.fastersql.function.system.CurrentDate

alias() - Method in class io.github.torand.fastersql.function.system.CurrentTime

alias() - Method in class io.github.torand.fastersql.function.system.CurrentTimestamp

alias() - Method in class io.github.torand.fastersql.model.Column

alias() - Method in class io.github.torand.fastersql.model.Table

alias() - Method in interface io.github.torand.fastersql.projection.Projection

Gets the column alias (label) assigned for this projection.

alias() - Method in interface io.github.torand.fastersql.relation.Relation

Gets the table alias specified for this relation.

alias() - Method in class io.github.torand.fastersql.subquery.ExpressionSubquery

alias() - Method in class io.github.torand.fastersql.subquery.TableSubquery

alias(String) - Static method in class io.github.torand.fastersql.alias.Aliases

Creates a column alias with specified name.

Alias - Interface in io.github.torand.fastersql.alias

Defines an alias (label) for a column or table

Aliases - Class in io.github.torand.fastersql.alias

Provides factory methods for aliases.

aliasRefs() - Method in class io.github.torand.fastersql.alias.ColumnAlias

aliasRefs() - Method in class io.github.torand.fastersql.alias.ColumnRef

aliasRefs() - Method in class io.github.torand.fastersql.alias.TableAlias

aliasRefs() - Method in class io.github.torand.fastersql.constant.GenericConstant

aliasRefs() - Method in class io.github.torand.fastersql.constant.NullConstant

aliasRefs() - Method in class io.github.torand.fastersql.expression.arithmetic.Addition

aliasRefs() - Method in class io.github.torand.fastersql.expression.arithmetic.Division

aliasRefs() - Method in class io.github.torand.fastersql.expression.arithmetic.Modulo

aliasRefs() - Method in class io.github.torand.fastersql.expression.arithmetic.Multiplication

aliasRefs() - Method in class io.github.torand.fastersql.expression.arithmetic.Subtraction

aliasRefs() - Method in class io.github.torand.fastersql.function.aggregate.Avg

aliasRefs() - Method in class io.github.torand.fastersql.function.aggregate.Count

aliasRefs() - Method in class io.github.torand.fastersql.function.aggregate.CountAll

aliasRefs() - Method in class io.github.torand.fastersql.function.aggregate.Max

aliasRefs() - Method in class io.github.torand.fastersql.function.aggregate.Min

aliasRefs() - Method in class io.github.torand.fastersql.function.aggregate.Sum

aliasRefs() - Method in class io.github.torand.fastersql.function.singlerow.Abs

aliasRefs() - Method in class io.github.torand.fastersql.function.singlerow.Ceil

aliasRefs() - Method in class io.github.torand.fastersql.function.singlerow.Concat

aliasRefs() - Method in class io.github.torand.fastersql.function.singlerow.Floor

aliasRefs() - Method in class io.github.torand.fastersql.function.singlerow.Length

aliasRefs() - Method in class io.github.torand.fastersql.function.singlerow.Lower

aliasRefs() - Method in class io.github.torand.fastersql.function.singlerow.Round

aliasRefs() - Method in class io.github.torand.fastersql.function.singlerow.Substring

aliasRefs() - Method in class io.github.torand.fastersql.function.singlerow.ToChar

aliasRefs() - Method in class io.github.torand.fastersql.function.singlerow.ToNumber

aliasRefs() - Method in class io.github.torand.fastersql.function.singlerow.Upper

aliasRefs() - Method in interface io.github.torand.fastersql.function.system.SystemFunction

aliasRefs() - Method in class io.github.torand.fastersql.join.Join

aliasRefs() - Method in class io.github.torand.fastersql.model.Column

aliasRefs() - Method in class io.github.torand.fastersql.model.Table

aliasRefs() - Method in class io.github.torand.fastersql.order.Ascending

aliasRefs() - Method in class io.github.torand.fastersql.order.Descending

aliasRefs() - Method in class io.github.torand.fastersql.predicate.comparison.Eq

aliasRefs() - Method in class io.github.torand.fastersql.predicate.comparison.Ge

aliasRefs() - Method in class io.github.torand.fastersql.predicate.comparison.Gt

aliasRefs() - Method in class io.github.torand.fastersql.predicate.comparison.Le

aliasRefs() - Method in class io.github.torand.fastersql.predicate.comparison.Lt

aliasRefs() - Method in class io.github.torand.fastersql.predicate.compound.And

aliasRefs() - Method in class io.github.torand.fastersql.predicate.compound.Not

aliasRefs() - Method in class io.github.torand.fastersql.predicate.compound.Or

aliasRefs() - Method in class io.github.torand.fastersql.predicate.ExistsSubquery

aliasRefs() - Method in class io.github.torand.fastersql.predicate.In

aliasRefs() - Method in class io.github.torand.fastersql.predicate.InSubquery

aliasRefs() - Method in class io.github.torand.fastersql.predicate.IsNull

aliasRefs() - Method in class io.github.torand.fastersql.predicate.Like

aliasRefs() - Method in class io.github.torand.fastersql.projection.ColumnPosition

aliasRefs() - Method in interface io.github.torand.fastersql.sql.Sql

Gets the column aliases referenced by this fragment.

aliasRefs() - Method in interface io.github.torand.fastersql.statement.PreparableStatement

aliasRefs() - Method in class io.github.torand.fastersql.subquery.ExpressionSubquery

aliasRefs() - Method in class io.github.torand.fastersql.subquery.TableSubquery

and(Join) - Method in class io.github.torand.fastersql.join.Join

Creates a nested JOIN clause by combining this JOIN clause with the specified JOIN clause.

and(OptionalPredicate) - Method in class io.github.torand.fastersql.predicate.OptionalPredicate

Creates an optional compound predicate of performing the boolean operator AND on this optional predicate and the specified optional predicate.

and(OptionalPredicate) - Method in interface io.github.torand.fastersql.predicate.Predicate

Creates an optional compound predicate using the boolean operator AND on this predicate and the specified optional predicate.

and(Predicate) - Method in class io.github.torand.fastersql.predicate.OptionalPredicate

Creates an optional compound predicate of performing the boolean operator AND on this optional predicate and the specified predicate.

and(Predicate) - Method in interface io.github.torand.fastersql.predicate.Predicate

Creates a compound predicate using the boolean operator AND on this predicate and the specified predicate.

and(Predicate...) - Static method in class io.github.torand.fastersql.predicate.compound.CompoundPredicates

Creates a compound predicate using the boolean operator AND on specified predicate operands.

And - Class in io.github.torand.fastersql.predicate.compound

Implements the compound predicate using the boolean operator AND on its operands.

AnsiIsoDialect - Class in io.github.torand.fastersql.dialect

Defines the ANSI/ISO (ISO/IEC 9075) SQL dialect.

AnsiIsoDialect() - Constructor for class io.github.torand.fastersql.dialect.AnsiIsoDialect

Creates an ANSI/ISO Dialect implementation.

ArithmeticExpressions - Class in io.github.torand.fastersql.expression.arithmetic

Provides factory methods for arithmetic expressions.

as(String) - Method in class io.github.torand.fastersql.alias.ColumnRef

as(String) - Method in class io.github.torand.fastersql.constant.GenericConstant

as(String) - Method in class io.github.torand.fastersql.constant.NullConstant

as(String) - Method in class io.github.torand.fastersql.expression.arithmetic.Addition

as(String) - Method in class io.github.torand.fastersql.expression.arithmetic.Division

as(String) - Method in class io.github.torand.fastersql.expression.arithmetic.Modulo

as(String) - Method in class io.github.torand.fastersql.expression.arithmetic.Multiplication

as(String) - Method in class io.github.torand.fastersql.expression.arithmetic.Subtraction

as(String) - Method in class io.github.torand.fastersql.function.aggregate.Avg

as(String) - Method in class io.github.torand.fastersql.function.aggregate.Count

as(String) - Method in class io.github.torand.fastersql.function.aggregate.CountAll

as(String) - Method in class io.github.torand.fastersql.function.aggregate.Max

as(String) - Method in class io.github.torand.fastersql.function.aggregate.Min

as(String) - Method in class io.github.torand.fastersql.function.aggregate.Sum

as(String) - Method in class io.github.torand.fastersql.function.singlerow.Abs

as(String) - Method in class io.github.torand.fastersql.function.singlerow.Ceil

as(String) - Method in class io.github.torand.fastersql.function.singlerow.Concat

as(String) - Method in class io.github.torand.fastersql.function.singlerow.Floor

as(String) - Method in class io.github.torand.fastersql.function.singlerow.Length

as(String) - Method in class io.github.torand.fastersql.function.singlerow.Lower

as(String) - Method in class io.github.torand.fastersql.function.singlerow.Round

as(String) - Method in class io.github.torand.fastersql.function.singlerow.Substring

as(String) - Method in class io.github.torand.fastersql.function.singlerow.ToChar

as(String) - Method in class io.github.torand.fastersql.function.singlerow.ToNumber

as(String) - Method in class io.github.torand.fastersql.function.singlerow.Upper

as(String) - Method in class io.github.torand.fastersql.function.system.CurrentDate

as(String) - Method in class io.github.torand.fastersql.function.system.CurrentTime

as(String) - Method in class io.github.torand.fastersql.function.system.CurrentTimestamp

as(String) - Method in class io.github.torand.fastersql.model.Column

as(String) - Method in class io.github.torand.fastersql.model.Table

as(String) - Method in interface io.github.torand.fastersql.projection.Projection

Assigns a column alias (label) for this projection.

as(String) - Method in interface io.github.torand.fastersql.relation.Relation

Specifies the table alias name of this relation.

as(String) - Method in class io.github.torand.fastersql.subquery.ExpressionSubquery

as(String) - Method in class io.github.torand.fastersql.subquery.TableSubquery

asc() - Method in class io.github.torand.fastersql.function.aggregate.CountAll

asc() - Method in interface io.github.torand.fastersql.order.OrderExpression

Creates an ascending ordering of this expression.

asc(OrderExpression) - Static method in class io.github.torand.fastersql.order.Orders

Creates an ascending ordering of an expression.

Ascending - Class in io.github.torand.fastersql.order

Implements an ascending order clause.

ascIf(boolean) - Method in class io.github.torand.fastersql.function.aggregate.CountAll

ascIf(boolean) - Method in interface io.github.torand.fastersql.order.OrderExpression

Creates an ordering of this expression, based on a condition.

avg(Expression) - Static method in class io.github.torand.fastersql.function.aggregate.AggregateFunctions

Creates the average aggregate of an expression.

Avg - Class in io.github.torand.fastersql.function.aggregate

Implements the average aggregate function.

C

Capability - Enum Class in io.github.torand.fastersql.dialect

Defines capabilities of an SQL dialect.

ceil(Expression) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the ceiling function for a numeric expression.

Ceil - Class in io.github.torand.fastersql.function.singlerow

Implements the ceiling numeric function.

Clause - Enum Class in io.github.torand.fastersql.sql

Defines clauses in a statement.

colPos(int) - Static method in class io.github.torand.fastersql.projection.Projections

Creates a numeric reference to a projected column in a query result.

colRef(String, String) - Static method in class io.github.torand.fastersql.alias.Aliases

Creates a reference to a specified column in a specified table using aliases.

column(String) - Method in class io.github.torand.fastersql.model.Table

Creates a model of a column belonging to this table.

Column - Class in io.github.torand.fastersql.model

Models a column in a database table.

Column(Table<?>, String) - Constructor for class io.github.torand.fastersql.model.Column

Creates a representation (model) of a column inside a database table.

ColumnAlias - Class in io.github.torand.fastersql.alias

Represents an alias (label) for a projection

ColumnAlias(String) - Constructor for class io.github.torand.fastersql.alias.ColumnAlias

Creates a column alias with specified name.

ColumnFunction - Interface in io.github.torand.fastersql.function

Defines a function that operates on a specific column (or no specific column).

ColumnPosition - Class in io.github.torand.fastersql.projection

Represents an enumeration of a projection, that is, a 1-based number referencing a single projection element in a SELECT clause.

ColumnPosition(int) - Constructor for class io.github.torand.fastersql.projection.ColumnPosition

Creates a column position.

ColumnRef - Class in io.github.torand.fastersql.alias

References a column using a combination of a table alias and a column alias.

columnRefs() - Method in class io.github.torand.fastersql.alias.ColumnAlias

columnRefs() - Method in class io.github.torand.fastersql.alias.ColumnRef

columnRefs() - Method in class io.github.torand.fastersql.alias.TableAlias

columnRefs() - Method in class io.github.torand.fastersql.constant.GenericConstant

columnRefs() - Method in class io.github.torand.fastersql.constant.NullConstant

columnRefs() - Method in class io.github.torand.fastersql.expression.arithmetic.Addition

columnRefs() - Method in class io.github.torand.fastersql.expression.arithmetic.Division

columnRefs() - Method in class io.github.torand.fastersql.expression.arithmetic.Modulo

columnRefs() - Method in class io.github.torand.fastersql.expression.arithmetic.Multiplication

columnRefs() - Method in class io.github.torand.fastersql.expression.arithmetic.Subtraction

columnRefs() - Method in class io.github.torand.fastersql.function.aggregate.Avg

columnRefs() - Method in class io.github.torand.fastersql.function.aggregate.Count

columnRefs() - Method in class io.github.torand.fastersql.function.aggregate.CountAll

columnRefs() - Method in class io.github.torand.fastersql.function.aggregate.Max

columnRefs() - Method in class io.github.torand.fastersql.function.aggregate.Min

columnRefs() - Method in class io.github.torand.fastersql.function.aggregate.Sum

columnRefs() - Method in class io.github.torand.fastersql.function.singlerow.Abs

columnRefs() - Method in class io.github.torand.fastersql.function.singlerow.Ceil

columnRefs() - Method in class io.github.torand.fastersql.function.singlerow.Concat

columnRefs() - Method in class io.github.torand.fastersql.function.singlerow.Floor

columnRefs() - Method in class io.github.torand.fastersql.function.singlerow.Length

columnRefs() - Method in class io.github.torand.fastersql.function.singlerow.Lower

columnRefs() - Method in class io.github.torand.fastersql.function.singlerow.Round

columnRefs() - Method in class io.github.torand.fastersql.function.singlerow.Substring

columnRefs() - Method in class io.github.torand.fastersql.function.singlerow.ToChar

columnRefs() - Method in class io.github.torand.fastersql.function.singlerow.ToNumber

columnRefs() - Method in class io.github.torand.fastersql.function.singlerow.Upper

columnRefs() - Method in interface io.github.torand.fastersql.function.system.SystemFunction

columnRefs() - Method in class io.github.torand.fastersql.join.Join

columnRefs() - Method in class io.github.torand.fastersql.model.Column

columnRefs() - Method in class io.github.torand.fastersql.model.Table

columnRefs() - Method in class io.github.torand.fastersql.order.Ascending

columnRefs() - Method in class io.github.torand.fastersql.order.Descending

columnRefs() - Method in class io.github.torand.fastersql.predicate.comparison.Eq

columnRefs() - Method in class io.github.torand.fastersql.predicate.comparison.Ge

columnRefs() - Method in class io.github.torand.fastersql.predicate.comparison.Gt

columnRefs() - Method in class io.github.torand.fastersql.predicate.comparison.Le

columnRefs() - Method in class io.github.torand.fastersql.predicate.comparison.Lt

columnRefs() - Method in class io.github.torand.fastersql.predicate.compound.And

columnRefs() - Method in class io.github.torand.fastersql.predicate.compound.Not

columnRefs() - Method in class io.github.torand.fastersql.predicate.compound.Or

columnRefs() - Method in class io.github.torand.fastersql.predicate.ExistsSubquery

columnRefs() - Method in class io.github.torand.fastersql.predicate.In

columnRefs() - Method in class io.github.torand.fastersql.predicate.InSubquery

columnRefs() - Method in class io.github.torand.fastersql.predicate.IsNull

columnRefs() - Method in class io.github.torand.fastersql.predicate.Like

columnRefs() - Method in class io.github.torand.fastersql.projection.ColumnPosition

columnRefs() - Method in interface io.github.torand.fastersql.sql.Sql

Gets the columns referenced by this fragment.

columnRefs() - Method in interface io.github.torand.fastersql.statement.PreparableStatement

columnRefs() - Method in class io.github.torand.fastersql.subquery.ExpressionSubquery

columnRefs() - Method in class io.github.torand.fastersql.subquery.TableSubquery

Command - Enum Class in io.github.torand.fastersql.sql

Defines available statement commands.

ComparisonPredicates - Class in io.github.torand.fastersql.predicate.comparison

Provides factory methods for comparison predicates.

CompoundPredicates - Class in io.github.torand.fastersql.predicate.compound

Provides factory methods for compound predicates.

concat(Expression, Expression, Expression...) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the concatenation function for string expressions.

Concat - Class in io.github.torand.fastersql.function.singlerow

Implements the concatenation string function.

CONCAT_OPERATOR - Enum constant in enum class io.github.torand.fastersql.dialect.Capability

Supports a string concatenation infix operator

constant(T) - Static method in class io.github.torand.fastersql.constant.Constants

Creates a scalar value constant.

Constant - Interface in io.github.torand.fastersql.constant

Defines a constant value.

Constants - Class in io.github.torand.fastersql.constant

Provides factory methods for constants.

Context - Class in io.github.torand.fastersql.sql

Holds the context of statement SQL builders.

count() - Static method in class io.github.torand.fastersql.function.aggregate.AggregateFunctions

Creates the count aggregate of all rows.

count(Expression) - Static method in class io.github.torand.fastersql.function.aggregate.AggregateFunctions

Creates the count aggregate of an expression.

Count - Class in io.github.torand.fastersql.function.aggregate

Implements the count aggregate function.

CountAll - Class in io.github.torand.fastersql.function.aggregate

Implements the count all aggregate function.

CURRENT_TIME - Enum constant in enum class io.github.torand.fastersql.dialect.Capability

Supports a current time literal or function

currentDate() - Static method in class io.github.torand.fastersql.function.system.SystemFunctions

Creates the current date system function.

CurrentDate - Class in io.github.torand.fastersql.function.system

Implements the current date system function.

currentTime() - Static method in class io.github.torand.fastersql.function.system.SystemFunctions

Creates the current time system function.

CurrentTime - Class in io.github.torand.fastersql.function.system

Implements the current time system function.

currentTimestamp() - Static method in class io.github.torand.fastersql.function.system.SystemFunctions

Creates the current timestamp system function.

CurrentTimestamp - Class in io.github.torand.fastersql.function.system

Implements the current timestamp system function.

D

delete() - Static method in class io.github.torand.fastersql.statement.Statements

Creates a DELETE statement builder.

DELETE - Enum constant in enum class io.github.torand.fastersql.sql.Command

The DELETE command.

deleteFrom(Table<?>) - Static method in class io.github.torand.fastersql.statement.Statements

Creates a DELETE statement with specified FROM clause.

DeleteFromBuilder - Class in io.github.torand.fastersql.statement

Builder of DELETE statements with a FROM clause.

DeleteStatement - Class in io.github.torand.fastersql.statement

Implements a DELETE statement.

desc() - Method in class io.github.torand.fastersql.function.aggregate.CountAll

desc() - Method in interface io.github.torand.fastersql.order.OrderExpression

Creates a descending ordering of this expression.

desc(OrderExpression) - Static method in class io.github.torand.fastersql.order.Orders

Creates a descending ordering of an expression.

Descending - Class in io.github.torand.fastersql.order

Implements a descending order clause.

Dialect - Interface in io.github.torand.fastersql.dialect

Defines an SQL dialect as implemented by a specific database vendor.

distinct() - Method in class io.github.torand.fastersql.statement.SelectFromBuilder

Specifies that statement should return unique rows.

divide(Expression, Expression) - Static method in class io.github.torand.fastersql.expression.arithmetic.ArithmeticExpressions

Creates a division (quotient) expression.

dividedBy(Expression) - Method in interface io.github.torand.fastersql.expression.Expression

Creates the expression of dividing this expression by another expression.

dividedBy(Object) - Method in interface io.github.torand.fastersql.expression.Expression

Creates the expression of dividing this expression by a constant value.

Division - Class in io.github.torand.fastersql.expression.arithmetic

Implements the division (quotient) expression.

E

empty() - Static method in class io.github.torand.fastersql.predicate.OptionalPredicate

Creates an optional predicate with no wrapped predicate.

eq(Expression) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates an equivalence predicate from this left operand and the specified expression.

eq(LeftOperand, Expression) - Static method in class io.github.torand.fastersql.predicate.comparison.ComparisonPredicates

Creates an equivalence predicate taking an expression as right operand.

eq(LeftOperand, Object) - Static method in class io.github.torand.fastersql.predicate.comparison.ComparisonPredicates

Creates an equivalence predicate taking a scalar value as right operand.

eq(SelectStatement) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates an equivalence predicate from this left operand and the specified subquery.

eq(Object) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates an equivalence predicate from this left operand and the specified constant value.

eq(Optional<?>) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates an optional equivalence predicate from this left operand and the specified optional value.

Eq - Class in io.github.torand.fastersql.predicate.comparison

Implements the equivalence predicate.

exists(ExpressionSubquery) - Static method in class io.github.torand.fastersql.predicate.Predicates

Create an 'existence' (at least one row) predicate taking a subquery as right operand.

ExistsSubquery - Class in io.github.torand.fastersql.predicate

Implements the 'existence' (at least one row) predicate.

Expression - Interface in io.github.torand.fastersql.expression

Defines an expression resulting in a scalar value or a table with rows and columns.

ExpressionSubquery - Class in io.github.torand.fastersql.subquery

Implements a subquery to be used as projection or as operand for a predicate.

ExpressionSubquery(SelectStatement) - Constructor for class io.github.torand.fastersql.subquery.ExpressionSubquery

Creates an expression subquery.

F

floor(Expression) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the floor function for a numeric expression.

Floor - Class in io.github.torand.fastersql.function.singlerow

Implements the floor numeric function.

forColumn(Column) - Method in interface io.github.torand.fastersql.constant.Constant

Creates a projection of the constant.

forColumn(Column) - Method in class io.github.torand.fastersql.constant.GenericConstant

forColumn(Column) - Method in class io.github.torand.fastersql.constant.NullConstant

formatCeilFunction(String) - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatCeilFunction(String) - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatCeilFunction(String) - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the 'ceil' function formatted for a specific SQL dialect.

formatCeilFunction(String) - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatCeilFunction(String) - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatCeilFunction(String) - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatCeilFunction(String) - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatCeilFunction(String) - Method in class io.github.torand.fastersql.dialect.OracleDialect

formatCeilFunction(String) - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatCeilFunction(String) - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatCeilFunction(String) - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

formatConcatFunction(List<String>) - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatConcatFunction(List<String>) - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatConcatFunction(List<String>) - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the 'concat' function formatted for a specific SQL dialect.

formatConcatFunction(List<String>) - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatConcatFunction(List<String>) - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatConcatFunction(List<String>) - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatConcatFunction(List<String>) - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatConcatFunction(List<String>) - Method in class io.github.torand.fastersql.dialect.OracleDialect

formatConcatFunction(List<String>) - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatConcatFunction(List<String>) - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatConcatFunction(List<String>) - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

formatCurrentDateFunction() - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatCurrentDateFunction() - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatCurrentDateFunction() - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the 'current_date' system function formatted for a specific SQL dialect.

formatCurrentDateFunction() - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatCurrentDateFunction() - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatCurrentDateFunction() - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatCurrentDateFunction() - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatCurrentDateFunction() - Method in class io.github.torand.fastersql.dialect.OracleDialect

formatCurrentDateFunction() - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatCurrentDateFunction() - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatCurrentDateFunction() - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

formatLengthFunction(String) - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatLengthFunction(String) - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatLengthFunction(String) - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the 'length' function formatted for a specific SQL dialect.

formatLengthFunction(String) - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatLengthFunction(String) - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatLengthFunction(String) - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatLengthFunction(String) - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatLengthFunction(String) - Method in class io.github.torand.fastersql.dialect.OracleDialect

formatLengthFunction(String) - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatLengthFunction(String) - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatLengthFunction(String) - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

formatModuloFunction(String, String) - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatModuloFunction(String, String) - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatModuloFunction(String, String) - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the 'mod' function formatted for a specific SQL dialect.

formatModuloFunction(String, String) - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatModuloFunction(String, String) - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatModuloFunction(String, String) - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatModuloFunction(String, String) - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatModuloFunction(String, String) - Method in class io.github.torand.fastersql.dialect.OracleDialect

formatModuloFunction(String, String) - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatModuloFunction(String, String) - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatModuloFunction(String, String) - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

formatRoundFunction(String) - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatRoundFunction(String) - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatRoundFunction(String) - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the 'round' function formatted for a specific SQL dialect.

formatRoundFunction(String) - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatRoundFunction(String) - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatRoundFunction(String) - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatRoundFunction(String) - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatRoundFunction(String) - Method in class io.github.torand.fastersql.dialect.OracleDialect

formatRoundFunction(String) - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatRoundFunction(String) - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatRoundFunction(String) - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

formatRowLimitClause() - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatRowLimitClause() - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatRowLimitClause() - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the _row limit clause_ formatted for a specific SQL dialect.

formatRowLimitClause() - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatRowLimitClause() - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatRowLimitClause() - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatRowLimitClause() - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatRowLimitClause() - Method in class io.github.torand.fastersql.dialect.OracleDialect

Row limit clause is supported from Oracle 12c onwards

formatRowLimitClause() - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatRowLimitClause() - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatRowLimitClause() - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

Row limit clause is supported from SQL Server 2012 onwards

formatRowNumLiteral() - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatRowNumLiteral() - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatRowNumLiteral() - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the _row number_ literal formatted for a specific SQL dialect.

formatRowNumLiteral() - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatRowNumLiteral() - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatRowNumLiteral() - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatRowNumLiteral() - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatRowNumLiteral() - Method in class io.github.torand.fastersql.dialect.OracleDialect

formatRowNumLiteral() - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatRowNumLiteral() - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatRowNumLiteral() - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

SQL Server has the ROW_NUMBER() function but must be combined with OVER() in this context.

formatRowOffsetClause() - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatRowOffsetClause() - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatRowOffsetClause() - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the _row offset clause_ formatted for a specific SQL dialect.

formatRowOffsetClause() - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatRowOffsetClause() - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatRowOffsetClause() - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatRowOffsetClause() - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatRowOffsetClause() - Method in class io.github.torand.fastersql.dialect.OracleDialect

Row offset clause is supported from Oracle 12c onwards

formatRowOffsetClause() - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatRowOffsetClause() - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatRowOffsetClause() - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

Row offset clause is supported from SQL Server 2012 onwards

formatSubstringFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatSubstringFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatSubstringFunction(String, int, int) - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the 'substring' function formatted for a specific SQL dialect.

formatSubstringFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatSubstringFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatSubstringFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatSubstringFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatSubstringFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.OracleDialect

formatSubstringFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatSubstringFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatSubstringFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

formatToCharFunction(String, String) - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatToCharFunction(String, String) - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatToCharFunction(String, String) - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the 'to_char' function formatted for a specific SQL dialect.

formatToCharFunction(String, String) - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatToCharFunction(String, String) - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatToCharFunction(String, String) - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatToCharFunction(String, String) - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatToCharFunction(String, String) - Method in class io.github.torand.fastersql.dialect.OracleDialect

formatToCharFunction(String, String) - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatToCharFunction(String, String) - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatToCharFunction(String, String) - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

formatToNumberFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.AccessDialect

formatToNumberFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

formatToNumberFunction(String, int, int) - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the 'to_number' function formatted for a specific SQL dialect.

formatToNumberFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.H2Dialect

formatToNumberFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

formatToNumberFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

formatToNumberFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.MySqlDialect

formatToNumberFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.OracleDialect

formatToNumberFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

formatToNumberFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.SqliteDialect

formatToNumberFunction(String, int, int) - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

forUpdate() - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds a FOR UPDATE clause.

from(Table<?>) - Method in class io.github.torand.fastersql.statement.DeleteFromBuilder

Creates a DELETE statement with specified FROM clause.

from(Relation, Relation...) - Method in class io.github.torand.fastersql.statement.SelectFromBuilder

Creates a SELECT statement with specified FROM clauses (relations).

fromConnection(Connection) - Static method in interface io.github.torand.fastersql.dialect.Dialect

Creates the Dialect instance corresponding to database vendor associated with specified connection.

Function - Interface in io.github.torand.fastersql.function

Defines a construct that evaluates to a single value, based upon zero, one or multiple rows.

G

ge(Expression) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'greater than or equal' predicate from this left operand and the specified expression.

ge(LeftOperand, Expression) - Static method in class io.github.torand.fastersql.predicate.comparison.ComparisonPredicates

Creates a greater than or equal predicate taking an expression as right operand.

ge(LeftOperand, Object) - Static method in class io.github.torand.fastersql.predicate.comparison.ComparisonPredicates

Creates a greater than or equal predicate taking a scalar value as right operand.

ge(SelectStatement) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'greater than or equal' predicate from this left operand and the specified subquery.

ge(Object) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'greater than or equal' predicate from this left operand and the specified constant value.

ge(Optional<?>) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates an optional 'greater than or equal' predicate from this left operand and the specified optional value.

Ge - Class in io.github.torand.fastersql.predicate.comparison

Implements the greater than or equal predicate.

generate(String) - Static method in class io.github.torand.fastersql.alias.ColumnAlias

Factory method to create a random column alias using specified prefix.

GenericConstant<T> - Class in io.github.torand.fastersql.constant

Represents a scalar value constant of any type.

get() - Method in class io.github.torand.fastersql.predicate.OptionalPredicate

Gets the wrapped predicate if present.

getCommand() - Method in class io.github.torand.fastersql.sql.Context

Gets the current statement command.

getConcatOperator() - Method in class io.github.torand.fastersql.dialect.AccessDialect

getConcatOperator() - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

getConcatOperator() - Method in interface io.github.torand.fastersql.dialect.Dialect

Returns the string concatenation operator for a specific SQL Dialect.

getConcatOperator() - Method in class io.github.torand.fastersql.dialect.H2Dialect

getConcatOperator() - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

getConcatOperator() - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

getConcatOperator() - Method in class io.github.torand.fastersql.dialect.MySqlDialect

getConcatOperator() - Method in class io.github.torand.fastersql.dialect.OracleDialect

getConcatOperator() - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

getConcatOperator() - Method in class io.github.torand.fastersql.dialect.SqliteDialect

getConcatOperator() - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

getDialect() - Method in class io.github.torand.fastersql.sql.Context

Gets the SQL dialect.

getOuterStatements() - Method in class io.github.torand.fastersql.sql.Context

Gets the current outer statements, if any.

getProductName() - Method in class io.github.torand.fastersql.dialect.AccessDialect

getProductName() - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

getProductName() - Method in interface io.github.torand.fastersql.dialect.Dialect

Gets the name of the RDBMS product.

getProductName() - Method in class io.github.torand.fastersql.dialect.H2Dialect

getProductName() - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

getProductName() - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

getProductName() - Method in class io.github.torand.fastersql.dialect.MySqlDialect

getProductName() - Method in class io.github.torand.fastersql.dialect.OracleDialect

getProductName() - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

getProductName() - Method in class io.github.torand.fastersql.dialect.SqliteDialect

getProductName() - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

groupBy(Column...) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds one or columns as groups to the GROUP BY clause.

gt(Expression) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'greater than' predicate from this left operand and the specified expression.

gt(LeftOperand, Expression) - Static method in class io.github.torand.fastersql.predicate.comparison.ComparisonPredicates

Creates a greater than predicate taking an expression as right operand.

gt(LeftOperand, Object) - Static method in class io.github.torand.fastersql.predicate.comparison.ComparisonPredicates

Creates a greater than predicate taking a scalar value as right operand.

gt(SelectStatement) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'greater than' predicate from this left operand and the specified subquery.

gt(Object) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'greater than' predicate from this left operand and the specified constant value.

gt(Optional<?>) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates an optional 'greater than' predicate from this left operand and the specified optional value.

Gt - Class in io.github.torand.fastersql.predicate.comparison

Implements the greater than predicate.

H

H2Dialect - Class in io.github.torand.fastersql.dialect

Defines the H2 SQL dialect.

H2Dialect() - Constructor for class io.github.torand.fastersql.dialect.H2Dialect

Creates a H2 Dialect implementation.

having(OptionalPredicate...) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds optional predicates to the HAVING clause if the wrapped predicates are present.

having(Predicate...) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds one or more predicates to the HAVING clause.

havingIf(boolean, Supplier<Predicate>...) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds one or more predicates to the HAVING clause, if the condition is true.

Helpers - Class in io.github.torand.fastersql.statement

Provides statement utility functions.

HsqldbDialect - Class in io.github.torand.fastersql.dialect

Defines the HyperSQL (HSQLDB) SQL dialect.

HsqldbDialect() - Constructor for class io.github.torand.fastersql.dialect.HsqldbDialect

Creates a HyperSQL (HSQLDB) Dialect implementation.

I

in(LeftOperand, ExpressionSubquery) - Static method in class io.github.torand.fastersql.predicate.Predicates

Create a 'member of set' predicate taking a subquery as right operand.

in(LeftOperand, Collection<?>) - Static method in class io.github.torand.fastersql.predicate.Predicates

Create a 'member of set' predicate taking a collection of scalar values as right operand.

in(SelectStatement) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'member of set' predicate from this left operand and the specified subquery.

in(Object...) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'member of set' predicate from this left operand and the specified array of constant values.

in(Collection<?>) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'member of set' predicate from this left operand and the specified collection of constant values.

in(Optional<? extends Collection<?>>) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates an optional 'member of set' predicate from this left operand and the specified optional collection of constant values.

In - Class in io.github.torand.fastersql.predicate

Implements the 'member of set' predicate, using a set of scalar values.

insert() - Static method in class io.github.torand.fastersql.statement.Statements

Creates an INSERT statement builder.

INSERT - Enum constant in enum class io.github.torand.fastersql.sql.Command

The INSERT command.

insertBatch(Collection<T>) - Static method in class io.github.torand.fastersql.statement.Statements

Creates an INSERT (batch) statement builder, for specified entities.

InsertBatchIntoBuilder<T> - Class in io.github.torand.fastersql.statement

Builder of INSERT (batch) statements with an INTO clause.

InsertBatchStatement<T> - Class in io.github.torand.fastersql.statement

Implements an INSERT statement for batch (multi-row) insertion.

insertInto(Table<?>) - Static method in class io.github.torand.fastersql.statement.Statements

Creates an INSERT statement with specified INTO clause.

InsertIntoBuilder - Class in io.github.torand.fastersql.statement

Builder of INSERT statements with an INTO clause.

InsertIntoBuilder() - Constructor for class io.github.torand.fastersql.statement.InsertIntoBuilder

Creates an INSERT INTO builder.

InsertStatement - Class in io.github.torand.fastersql.statement

Implements an INSERT statement for single row insertion.

InSubquery - Class in io.github.torand.fastersql.predicate

Implements the 'member of set' predicate, using a set defined by a subquery.

into(Table<?>) - Method in class io.github.torand.fastersql.statement.InsertBatchIntoBuilder

Creates an INSERT (batch) statement with specified INTO clause.

into(Table<?>) - Method in class io.github.torand.fastersql.statement.InsertIntoBuilder

Creates an INSERT statement with specified INTO clause.

io.github.torand.fastersql - package io.github.torand.fastersql

This is the root package of the FasterSQL library.

io.github.torand.fastersql.alias - package io.github.torand.fastersql.alias

Provides classes and interfaces related to column and table aliases.

io.github.torand.fastersql.constant - package io.github.torand.fastersql.constant

Provides classes and interfaces related to inline value constants for statements.

io.github.torand.fastersql.dialect - package io.github.torand.fastersql.dialect

Provides classes and interfaces related to supported SQL dialects.

io.github.torand.fastersql.expression - package io.github.torand.fastersql.expression

Provides classes and interfaces related to scalar or tabular expressions.

io.github.torand.fastersql.expression.arithmetic - package io.github.torand.fastersql.expression.arithmetic

Provides classes representing arithmetic expressions.

io.github.torand.fastersql.function - package io.github.torand.fastersql.function

Provides classes and interfaces related to aggregate, single row and system functions.

io.github.torand.fastersql.function.aggregate - package io.github.torand.fastersql.function.aggregate

Provides classes and interfaces related to aggregate functions.

io.github.torand.fastersql.function.singlerow - package io.github.torand.fastersql.function.singlerow

Provides classes and interfaces related to single row functions.

io.github.torand.fastersql.function.system - package io.github.torand.fastersql.function.system

Provides classes and interfaces related to system functions.

io.github.torand.fastersql.join - package io.github.torand.fastersql.join

Provides classes representing join clauses.

io.github.torand.fastersql.model - package io.github.torand.fastersql.model

Provides classes representing the database model.

io.github.torand.fastersql.order - package io.github.torand.fastersql.order

Provides classes and interfaces representing order clauses.

io.github.torand.fastersql.predicate - package io.github.torand.fastersql.predicate

Provides classes and interfaces related to predicates.

io.github.torand.fastersql.predicate.comparison - package io.github.torand.fastersql.predicate.comparison

Provides classes and interfaces representing comparison predicates.

io.github.torand.fastersql.predicate.compound - package io.github.torand.fastersql.predicate.compound

Provides classes and interfaces representing predicates made up by multiple sub-predicates.

io.github.torand.fastersql.projection - package io.github.torand.fastersql.projection

Provides classes and interfaces related to projections.

io.github.torand.fastersql.relation - package io.github.torand.fastersql.relation

Provides classes and interfaces representing relations.

io.github.torand.fastersql.sql - package io.github.torand.fastersql.sql

Provides classes and interfaces related to SQL fragments.

io.github.torand.fastersql.statement - package io.github.torand.fastersql.statement

Provides classes and interfaces related to statements.

io.github.torand.fastersql.subquery - package io.github.torand.fastersql.subquery

Provides classes and interfaces related to subqueries.

io.github.torand.fastersql.util - package io.github.torand.fastersql.util

Provides utility classes and interfaces.

isClause(Clause) - Method in class io.github.torand.fastersql.sql.Context

Indicates whether the current statement clause is a specific clause.

isCommand(Command) - Method in class io.github.torand.fastersql.sql.Context

Indicates whether the current statement command is a specific command.

isNull() - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates an 'is null' predicate from this left operand.

isNull(LeftOperand) - Static method in class io.github.torand.fastersql.predicate.Predicates

Creates an 'is null' predicate.

IsNull - Class in io.github.torand.fastersql.predicate

Implements the 'is null' predicate.

isPresent() - Method in class io.github.torand.fastersql.predicate.OptionalPredicate

Indicates whether there is a wrapped predicate.

J

join(Join...) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds one or more JOIN clauses.

Join - Class in io.github.torand.fastersql.join

Implements a JOIN clause.

Join(Column, Column) - Constructor for class io.github.torand.fastersql.join.Join

Creates a join clause.

joined() - Method in class io.github.torand.fastersql.join.Join

Gets the table joined with.

joinIf(boolean, Supplier<Join>...) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds one or more JOIN clauses, if the condition is true.

L

le(Expression) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'less than or equal' predicate from this left operand and the specified expression.

le(LeftOperand, Expression) - Static method in class io.github.torand.fastersql.predicate.comparison.ComparisonPredicates

Creates a less than or equal predicate taking an expression as right operand.

le(LeftOperand, Object) - Static method in class io.github.torand.fastersql.predicate.comparison.ComparisonPredicates

Creates a less than or equal predicate taking a scalar value as right operand.

le(SelectStatement) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'less than or equal' predicate from this left operand and the specified subquery.

le(Object) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'less than or equal' predicate from this left operand and the specified constant value.

le(Optional<?>) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates an optional 'less than or equal' predicate from this left operand and the specified optional value.

Le - Class in io.github.torand.fastersql.predicate.comparison

Implements the less than or equal predicate.

LeftOperand - Interface in io.github.torand.fastersql.predicate

Defines the left operand of an expression.

leftOuter() - Method in class io.github.torand.fastersql.join.Join

Specifies that this is a LEFT OUTER JOIN clause.

leftOuterJoin(Join) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds a LEFT OUTER JOIN clause.

length(Expression) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the length function for a string expression.

Length - Class in io.github.torand.fastersql.function.singlerow

Implements the length string function.

like(LeftOperand, String) - Static method in class io.github.torand.fastersql.predicate.Predicates

Creates a pattern matching predicate.

like(String) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a pattern matching predicate from this left operand and the specified string pattern.

like(Optional<String>) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates an optional pattern matching predicate from this left operand and the specified optional string pattern.

Like - Class in io.github.torand.fastersql.predicate

Implements the pattern matching predicate.

limit(long) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds a LIMIT clause.

LIMIT_OFFSET - Enum constant in enum class io.github.torand.fastersql.dialect.Capability

Supports row limiting clauses

lower(Expression) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the lower case function for a string expression.

Lower - Class in io.github.torand.fastersql.function.singlerow

Implements the lower case string function.

lt(Expression) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'less than' predicate from this left operand and the specified expression.

lt(LeftOperand, Expression) - Static method in class io.github.torand.fastersql.predicate.comparison.ComparisonPredicates

Creates a less than predicate taking an expression as right operand.

lt(LeftOperand, Object) - Static method in class io.github.torand.fastersql.predicate.comparison.ComparisonPredicates

Creates a less than predicate taking a scalar value as right operand.

lt(SelectStatement) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'less than' predicate from this left operand and the specified subquery.

lt(Object) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates a 'less than' predicate from this left operand and the specified constant value.

lt(Optional<?>) - Method in interface io.github.torand.fastersql.predicate.LeftOperand

Creates an optional 'less than' predicate from this left operand and the specified optional value.

Lt - Class in io.github.torand.fastersql.predicate.comparison

Implements the less than predicate.

M

MariaDbDialect - Class in io.github.torand.fastersql.dialect

Defines the MariaDB SQL dialect.

MariaDbDialect() - Constructor for class io.github.torand.fastersql.dialect.MariaDbDialect

Creates a MariaDb Dialect implementation.

max(Expression) - Static method in class io.github.torand.fastersql.function.aggregate.AggregateFunctions

Creates the maximum aggregate of an expression.

Max - Class in io.github.torand.fastersql.function.aggregate

Implements the maximum aggregate function.

min(Expression) - Static method in class io.github.torand.fastersql.function.aggregate.AggregateFunctions

Creates the minimum aggregate of an expression.

Min - Class in io.github.torand.fastersql.function.aggregate

Implements the minimum aggregate function.

minus(Expression) - Method in interface io.github.torand.fastersql.expression.Expression

Creates the expression of subtracting another expression from this expression.

minus(Object) - Method in interface io.github.torand.fastersql.expression.Expression

Creates the expression of subtracting a constant value from this expression.

mod(Expression) - Method in interface io.github.torand.fastersql.expression.Expression

Creates the expression of calculating the remainder after dividing this expression by another expression.

mod(Expression, Expression) - Static method in class io.github.torand.fastersql.expression.arithmetic.ArithmeticExpressions

Creates a modulo (division remainder) expression.

mod(Object) - Method in interface io.github.torand.fastersql.expression.Expression

Creates the expression of calculating the remainder after dividing this expression by a constant value.

Modulo - Class in io.github.torand.fastersql.expression.arithmetic

Implements the modulo (division remainder) expression.

MODULO_OPERATOR - Enum constant in enum class io.github.torand.fastersql.dialect.Capability

Supports a numeric modulo infix operator

Multiplication - Class in io.github.torand.fastersql.expression.arithmetic

Implements the multiplication (product) expression.

multiply(Expression, Expression) - Static method in class io.github.torand.fastersql.expression.arithmetic.ArithmeticExpressions

Creates a multiplication (product) expression.

MySqlDialect - Class in io.github.torand.fastersql.dialect

Defines the MySQL SQL dialect.

MySqlDialect() - Constructor for class io.github.torand.fastersql.dialect.MySqlDialect

Creates a MySQL Dialect implementation.

N

name() - Method in interface io.github.torand.fastersql.alias.Alias

Gets the alias name.

name() - Method in class io.github.torand.fastersql.alias.ColumnAlias

name() - Method in class io.github.torand.fastersql.alias.TableAlias

name() - Method in class io.github.torand.fastersql.model.Column

Gets the column name.

name() - Method in class io.github.torand.fastersql.model.Table

Gets the table name.

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Eq

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Ge

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Gt

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Le

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Lt

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.compound.And

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.compound.Not

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.compound.Or

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.ExistsSubquery

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.In

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.InSubquery

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.IsNull

negatedSql(Context) - Method in class io.github.torand.fastersql.predicate.Like

negatedSql(Context) - Method in interface io.github.torand.fastersql.predicate.Predicate

Formats negated predicate as an SQL fragment.

newInstance(String) - Method in interface io.github.torand.fastersql.model.TableFactory

Creates a new instance of a database Table model.

not(Predicate) - Static method in class io.github.torand.fastersql.predicate.compound.CompoundPredicates

Creates a compound predicate using the boolean negation operator on specified predicate operand.

Not - Class in io.github.torand.fastersql.predicate.compound

Implements the compound predicate using the boolean negation operator on its operand.

NULL_ORDERING - Enum constant in enum class io.github.torand.fastersql.dialect.Capability

Supports "nulls First" and "nulls last" for NULL ordering

NullConstant - Class in io.github.torand.fastersql.constant

Represents the 'null' constant value.

nullsFirst() - Method in class io.github.torand.fastersql.order.Ascending

nullsFirst() - Method in class io.github.torand.fastersql.order.Descending

nullsFirst() - Method in interface io.github.torand.fastersql.order.Order

Specifies that null values are to be ordered _before_ non-null values.

nullsLast() - Method in class io.github.torand.fastersql.order.Ascending

nullsLast() - Method in class io.github.torand.fastersql.order.Descending

nullsLast() - Method in interface io.github.torand.fastersql.order.Order

Specifies that null values are to be ordered _after_ non-null values.

nullValue() - Static method in class io.github.torand.fastersql.constant.Constants

Creates a null constant.

O

of(Dialect) - Static method in class io.github.torand.fastersql.sql.Context

Creates context with specified SQL dialect.

of(Predicate) - Static method in class io.github.torand.fastersql.predicate.OptionalPredicate

Creates an optional predicate wrapping specified non-null predicate.

offset(long) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds a OFFSET clause.

offsetBeforeLimit() - Method in class io.github.torand.fastersql.dialect.AccessDialect

offsetBeforeLimit() - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

offsetBeforeLimit() - Method in interface io.github.torand.fastersql.dialect.Dialect

Indicates whether offset clause must be specified before limit clause; if supported.

offsetBeforeLimit() - Method in class io.github.torand.fastersql.dialect.H2Dialect

offsetBeforeLimit() - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

offsetBeforeLimit() - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

offsetBeforeLimit() - Method in class io.github.torand.fastersql.dialect.MySqlDialect

offsetBeforeLimit() - Method in class io.github.torand.fastersql.dialect.OracleDialect

offsetBeforeLimit() - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

offsetBeforeLimit() - Method in class io.github.torand.fastersql.dialect.SqliteDialect

offsetBeforeLimit() - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

ofNullable(Predicate) - Static method in class io.github.torand.fastersql.predicate.OptionalPredicate

Creates an optional predicate wrapping specified null or non-null predicate.

on(Column) - Method in class io.github.torand.fastersql.model.Column

Creates a JOIN clause by associating this column with specified column of another table.

OptionalPredicate - Class in io.github.torand.fastersql.predicate

Implements an optional predicate.

or(OptionalPredicate) - Method in class io.github.torand.fastersql.predicate.OptionalPredicate

Creates an optional compound predicate of performing the boolean operator OR on this optional predicate and the specified optional predicate.

or(OptionalPredicate) - Method in interface io.github.torand.fastersql.predicate.Predicate

Creates an optional compound predicate using the boolean operator OR on this predicate and the specified optional predicate.

or(Predicate) - Method in class io.github.torand.fastersql.predicate.OptionalPredicate

Creates an optional compound predicate of performing the boolean operator OR on this optional predicate and the specified predicate.

or(Predicate) - Method in interface io.github.torand.fastersql.predicate.Predicate

Creates a compound predicate using the boolean operator OR on this predicate and the specified predicate.

or(Predicate...) - Static method in class io.github.torand.fastersql.predicate.compound.CompoundPredicates

Creates a compound predicate using the boolean operator OR on specified predicate operands.

Or - Class in io.github.torand.fastersql.predicate.compound

Implements the compound predicate using the boolean operator OR on its operands.

OracleDialect - Class in io.github.torand.fastersql.dialect

Defines the Oracle SQL dialect.

OracleDialect() - Constructor for class io.github.torand.fastersql.dialect.OracleDialect

Creates an Oracle Dialect implementation.

Order - Interface in io.github.torand.fastersql.order

Defines an ordering specification for the ORDER BY clause.

orderBy(Order...) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds one or more ORDER clauses.

OrderExpression - Interface in io.github.torand.fastersql.order

Defines an expression specifying the ordering of rows from a query.

Orders - Class in io.github.torand.fastersql.order

Provides factory methods for order clauses.

P

paramMarkers(long) - Static method in class io.github.torand.fastersql.statement.Helpers

Generates a string with comma separated statement parameter markers.

params(Context) - Method in class io.github.torand.fastersql.alias.ColumnAlias

params(Context) - Method in class io.github.torand.fastersql.alias.ColumnRef

params(Context) - Method in class io.github.torand.fastersql.alias.TableAlias

params(Context) - Method in class io.github.torand.fastersql.constant.GenericConstant

params(Context) - Method in class io.github.torand.fastersql.constant.NullConstant

params(Context) - Method in class io.github.torand.fastersql.expression.arithmetic.Addition

params(Context) - Method in class io.github.torand.fastersql.expression.arithmetic.Division

params(Context) - Method in class io.github.torand.fastersql.expression.arithmetic.Modulo

params(Context) - Method in class io.github.torand.fastersql.expression.arithmetic.Multiplication

params(Context) - Method in class io.github.torand.fastersql.expression.arithmetic.Subtraction

params(Context) - Method in class io.github.torand.fastersql.function.aggregate.Avg

params(Context) - Method in class io.github.torand.fastersql.function.aggregate.Count

params(Context) - Method in class io.github.torand.fastersql.function.aggregate.CountAll

params(Context) - Method in class io.github.torand.fastersql.function.aggregate.Max

params(Context) - Method in class io.github.torand.fastersql.function.aggregate.Min

params(Context) - Method in class io.github.torand.fastersql.function.aggregate.Sum

params(Context) - Method in class io.github.torand.fastersql.function.singlerow.Abs

params(Context) - Method in class io.github.torand.fastersql.function.singlerow.Ceil

params(Context) - Method in class io.github.torand.fastersql.function.singlerow.Concat

params(Context) - Method in class io.github.torand.fastersql.function.singlerow.Floor

params(Context) - Method in class io.github.torand.fastersql.function.singlerow.Length

params(Context) - Method in class io.github.torand.fastersql.function.singlerow.Lower

params(Context) - Method in class io.github.torand.fastersql.function.singlerow.Round

params(Context) - Method in class io.github.torand.fastersql.function.singlerow.Substring

params(Context) - Method in class io.github.torand.fastersql.function.singlerow.ToChar

params(Context) - Method in class io.github.torand.fastersql.function.singlerow.ToNumber

params(Context) - Method in class io.github.torand.fastersql.function.singlerow.Upper

params(Context) - Method in interface io.github.torand.fastersql.function.system.SystemFunction

params(Context) - Method in class io.github.torand.fastersql.join.Join

params(Context) - Method in class io.github.torand.fastersql.model.Column

params(Context) - Method in class io.github.torand.fastersql.model.Table

params(Context) - Method in class io.github.torand.fastersql.order.Ascending

params(Context) - Method in class io.github.torand.fastersql.order.Descending

params(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Eq

params(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Ge

params(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Gt

params(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Le

params(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Lt

params(Context) - Method in class io.github.torand.fastersql.predicate.compound.And

params(Context) - Method in class io.github.torand.fastersql.predicate.compound.Not

params(Context) - Method in class io.github.torand.fastersql.predicate.compound.Or

params(Context) - Method in class io.github.torand.fastersql.predicate.ExistsSubquery

params(Context) - Method in class io.github.torand.fastersql.predicate.In

params(Context) - Method in class io.github.torand.fastersql.predicate.InSubquery

params(Context) - Method in class io.github.torand.fastersql.predicate.IsNull

params(Context) - Method in class io.github.torand.fastersql.predicate.Like

params(Context) - Method in class io.github.torand.fastersql.projection.ColumnPosition

params(Context) - Method in interface io.github.torand.fastersql.sql.Sql

Gets the statement parameters introduced by this fragment.

params(Context) - Method in class io.github.torand.fastersql.statement.DeleteStatement

params(Context) - Method in class io.github.torand.fastersql.statement.InsertBatchStatement

params(Context) - Method in class io.github.torand.fastersql.statement.InsertStatement

params(Context) - Method in class io.github.torand.fastersql.statement.SelectStatement

params(Context) - Method in class io.github.torand.fastersql.statement.TruncateStatement

params(Context) - Method in class io.github.torand.fastersql.statement.UpdateStatement

params(Context) - Method in class io.github.torand.fastersql.subquery.ExpressionSubquery

params(Context) - Method in class io.github.torand.fastersql.subquery.TableSubquery

plus(Expression) - Method in interface io.github.torand.fastersql.expression.Expression

Creates the expression of adding another expression to this expression.

plus(Object) - Method in interface io.github.torand.fastersql.expression.Expression

Creates the expression of adding a constant value to this expression.

PostgreSqlDialect - Class in io.github.torand.fastersql.dialect

Defines the PostgreSQL SQL dialect

PostgreSqlDialect() - Constructor for class io.github.torand.fastersql.dialect.PostgreSqlDialect

Creates a PostgreSQL Dialect implementation.

Predicate - Interface in io.github.torand.fastersql.predicate

Defines a restriction on the rows fetched by a SELECT or affected by an UPDATE or DELETE.

Predicates - Class in io.github.torand.fastersql.predicate

Provides factory methods for predicates.

PreparableStatement - Interface in io.github.torand.fastersql.statement

Defines a statement that can be formatted as SQL.

prepare(PreparableStatement) - Method in class io.github.torand.fastersql.statement.PreparedStatementBuilder

Creates JDBC prepared statement from the specified preparable statement, ready for execution.

PreparedStatementBuilder - Class in io.github.torand.fastersql.statement

Builder for creating PreparedStatement with a Connection.

Projection - Interface in io.github.torand.fastersql.projection

Defines a construct which can be returned in a result set, i.e. an item in the SELECT clause.

PROJECTION - Enum constant in enum class io.github.torand.fastersql.sql.Clause

The projection clause of a (SELECT) statement.

Projections - Class in io.github.torand.fastersql.projection

Provides factory methods for projections.

Q

query() - Method in class io.github.torand.fastersql.subquery.ExpressionSubquery

query() - Method in interface io.github.torand.fastersql.subquery.Subquery

Gets the SELECT statement of this subquery.

query() - Method in class io.github.torand.fastersql.subquery.TableSubquery

R

Relation - Interface in io.github.torand.fastersql.relation

Defines a table of columns and rows, whether a permanent database table or a temporary table (the result of a subquery).

Relations - Class in io.github.torand.fastersql.relation

Provides factory methods for relations, i.e. subqueries.

RESTRICTION - Enum constant in enum class io.github.torand.fastersql.sql.Clause

The restriction (WHERE) clause of a (SELECT/UPDATE/DELETE) statement.

rightOuter() - Method in class io.github.torand.fastersql.join.Join

Specifies that this is a RIGHT OUTER JOIN clause.

rightOuterJoin(Join) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds a RIGHT OUTER JOIN clause.

round(Expression) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the round function for a numeric expression.

Round - Class in io.github.torand.fastersql.function.singlerow

Implements the round numeric function.

ROW_NUM - Enum constant in enum class io.github.torand.fastersql.dialect.Capability

Supports a row number literal or function

S

select(Projection, Projection...) - Static method in class io.github.torand.fastersql.statement.Statements

Creates a SELECT statement builder.

SELECT - Enum constant in enum class io.github.torand.fastersql.sql.Command

The SELECT command.

SELECT_FOR_UPDATE - Enum constant in enum class io.github.torand.fastersql.dialect.Capability

Supports "SELECT ...

selectDistinct(Projection, Projection...) - Static method in class io.github.torand.fastersql.statement.Statements

Creates a SELECT statement builder with DISTINCT clause added.

SelectFromBuilder - Class in io.github.torand.fastersql.statement

Builder of SELECT statements with a FROM clause.

SelectStatement - Class in io.github.torand.fastersql.statement

Implements a SELECT statement.

set(Column, Expression) - Method in class io.github.torand.fastersql.statement.UpdateStatement

Adds an expression value to be updated for a column.

set(Column, Object) - Method in class io.github.torand.fastersql.statement.UpdateStatement

Adds a constant value to be updated for a column.

set(Column, Optional<?>) - Method in class io.github.torand.fastersql.statement.UpdateStatement

Adds an optional value to be updated for a column.

SingleRowFunction - Interface in io.github.torand.fastersql.function.singlerow

Defines a function that returns a single value based upon one value from a single row.

SingleRowFunctions - Class in io.github.torand.fastersql.function.singlerow

Provides factory methods for single row functions.

sql(Context) - Method in class io.github.torand.fastersql.alias.ColumnAlias

sql(Context) - Method in class io.github.torand.fastersql.alias.ColumnRef

sql(Context) - Method in class io.github.torand.fastersql.alias.TableAlias

sql(Context) - Method in class io.github.torand.fastersql.constant.GenericConstant

sql(Context) - Method in class io.github.torand.fastersql.constant.NullConstant

sql(Context) - Method in class io.github.torand.fastersql.expression.arithmetic.Addition

sql(Context) - Method in class io.github.torand.fastersql.expression.arithmetic.Division

sql(Context) - Method in class io.github.torand.fastersql.expression.arithmetic.Modulo

sql(Context) - Method in class io.github.torand.fastersql.expression.arithmetic.Multiplication

sql(Context) - Method in class io.github.torand.fastersql.expression.arithmetic.Subtraction

sql(Context) - Method in class io.github.torand.fastersql.function.aggregate.Avg

sql(Context) - Method in class io.github.torand.fastersql.function.aggregate.Count

sql(Context) - Method in class io.github.torand.fastersql.function.aggregate.CountAll

sql(Context) - Method in class io.github.torand.fastersql.function.aggregate.Max

sql(Context) - Method in class io.github.torand.fastersql.function.aggregate.Min

sql(Context) - Method in class io.github.torand.fastersql.function.aggregate.Sum

sql(Context) - Method in class io.github.torand.fastersql.function.singlerow.Abs

sql(Context) - Method in class io.github.torand.fastersql.function.singlerow.Ceil

sql(Context) - Method in class io.github.torand.fastersql.function.singlerow.Concat

sql(Context) - Method in class io.github.torand.fastersql.function.singlerow.Floor

sql(Context) - Method in class io.github.torand.fastersql.function.singlerow.Length

sql(Context) - Method in class io.github.torand.fastersql.function.singlerow.Lower

sql(Context) - Method in class io.github.torand.fastersql.function.singlerow.Round

sql(Context) - Method in class io.github.torand.fastersql.function.singlerow.Substring

sql(Context) - Method in class io.github.torand.fastersql.function.singlerow.ToChar

sql(Context) - Method in class io.github.torand.fastersql.function.singlerow.ToNumber

sql(Context) - Method in class io.github.torand.fastersql.function.singlerow.Upper

sql(Context) - Method in class io.github.torand.fastersql.function.system.CurrentDate

sql(Context) - Method in class io.github.torand.fastersql.function.system.CurrentTime

sql(Context) - Method in class io.github.torand.fastersql.function.system.CurrentTimestamp

sql(Context) - Method in class io.github.torand.fastersql.join.Join

sql(Context) - Method in class io.github.torand.fastersql.model.Column

sql(Context) - Method in class io.github.torand.fastersql.model.Table

sql(Context) - Method in class io.github.torand.fastersql.order.Ascending

sql(Context) - Method in class io.github.torand.fastersql.order.Descending

sql(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Eq

sql(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Ge

sql(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Gt

sql(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Le

sql(Context) - Method in class io.github.torand.fastersql.predicate.comparison.Lt

sql(Context) - Method in class io.github.torand.fastersql.predicate.compound.And

sql(Context) - Method in class io.github.torand.fastersql.predicate.compound.Not

sql(Context) - Method in class io.github.torand.fastersql.predicate.compound.Or

sql(Context) - Method in class io.github.torand.fastersql.predicate.ExistsSubquery

sql(Context) - Method in class io.github.torand.fastersql.predicate.In

sql(Context) - Method in class io.github.torand.fastersql.predicate.InSubquery

sql(Context) - Method in class io.github.torand.fastersql.predicate.IsNull

sql(Context) - Method in class io.github.torand.fastersql.predicate.Like

sql(Context) - Method in class io.github.torand.fastersql.projection.ColumnPosition

sql(Context) - Method in interface io.github.torand.fastersql.sql.Sql

Formats object as an SQL fragment.

sql(Context) - Method in class io.github.torand.fastersql.statement.DeleteStatement

sql(Context) - Method in class io.github.torand.fastersql.statement.InsertBatchStatement

sql(Context) - Method in class io.github.torand.fastersql.statement.InsertStatement

sql(Context) - Method in class io.github.torand.fastersql.statement.SelectStatement

sql(Context) - Method in class io.github.torand.fastersql.statement.TruncateStatement

sql(Context) - Method in class io.github.torand.fastersql.statement.UpdateStatement

sql(Context) - Method in class io.github.torand.fastersql.subquery.ExpressionSubquery

sql(Context) - Method in class io.github.torand.fastersql.subquery.TableSubquery

Sql - Interface in io.github.torand.fastersql.sql

Defines a construct that can be expressed as an SQL fragment.

SqliteDialect - Class in io.github.torand.fastersql.dialect

Defines the SQLite SQL dialect.

SqliteDialect() - Constructor for class io.github.torand.fastersql.dialect.SqliteDialect

Creates a SQLite Dialect implementation.

SqlServerDialect - Class in io.github.torand.fastersql.dialect

Defines the Microsoft SQL Server SQL dialect.

SqlServerDialect() - Constructor for class io.github.torand.fastersql.dialect.SqlServerDialect

Creates a Microsoft SQL Server Dialect implementation.

Statements - Class in io.github.torand.fastersql.statement

Provides factory methods for statements and statement builders.

stream() - Method in class io.github.torand.fastersql.predicate.OptionalPredicate

Gets a stream containing the wrapped predicate, if any.

subquery(SelectStatement) - Static method in class io.github.torand.fastersql.projection.Projections

Creates a subquery expression to be used as a projection.

Subquery - Interface in io.github.torand.fastersql.subquery

Defines a subquery.

substring(Expression, int, int) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the substring function for a string expression.

Substring - Class in io.github.torand.fastersql.function.singlerow

Implements the substring string function.

subtract(Expression, Expression) - Static method in class io.github.torand.fastersql.expression.arithmetic.ArithmeticExpressions

Creates a subtraction (difference) expression.

Subtraction - Class in io.github.torand.fastersql.expression.arithmetic

Implements the subtraction (difference) expression.

sum(Expression) - Static method in class io.github.torand.fastersql.function.aggregate.AggregateFunctions

Creates the sum aggregate of an expression.

Sum - Class in io.github.torand.fastersql.function.aggregate

Implements the sum aggregate function.

supports(Capability) - Method in class io.github.torand.fastersql.dialect.AccessDialect

supports(Capability) - Method in class io.github.torand.fastersql.dialect.AnsiIsoDialect

supports(Capability) - Method in interface io.github.torand.fastersql.dialect.Dialect

Indicates whether a capability is supported by a specific SQL dialect.

supports(Capability) - Method in class io.github.torand.fastersql.dialect.H2Dialect

supports(Capability) - Method in class io.github.torand.fastersql.dialect.HsqldbDialect

supports(Capability) - Method in class io.github.torand.fastersql.dialect.MariaDbDialect

supports(Capability) - Method in class io.github.torand.fastersql.dialect.MySqlDialect

supports(Capability) - Method in class io.github.torand.fastersql.dialect.OracleDialect

supports(Capability) - Method in class io.github.torand.fastersql.dialect.PostgreSqlDialect

supports(Capability) - Method in class io.github.torand.fastersql.dialect.SqliteDialect

supports(Capability) - Method in class io.github.torand.fastersql.dialect.SqlServerDialect

SystemFunction - Interface in io.github.torand.fastersql.function.system

Defines a function that returns a single value without operating on table rows.

SystemFunctions - Class in io.github.torand.fastersql.function.system

Provides factory methods for system functions.

T

table() - Method in class io.github.torand.fastersql.model.Column

Gets the table this column belongs to.

table(Table<?>) - Method in class io.github.torand.fastersql.statement.TruncateTableBuilder

Creates a TRUNCATE statement with the specified TABLE clause.

table(SelectStatement) - Static method in class io.github.torand.fastersql.relation.Relations

Creates a table subquery to be used in FROM clauses.

Table<ENTITY> - Class in io.github.torand.fastersql.model

Models a database table.

Table(String, TableFactory<ENTITY>) - Constructor for class io.github.torand.fastersql.model.Table

Creates a representation (model) of a database table.

Table(String, String, TableFactory<ENTITY>) - Constructor for class io.github.torand.fastersql.model.Table

Creates a representation (model) of a database table.

TableAlias - Class in io.github.torand.fastersql.alias

Represents an alias (label) for a table

TableAlias(String) - Constructor for class io.github.torand.fastersql.alias.TableAlias

Creates a table alias.

TableFactory<ENTITY> - Interface in io.github.torand.fastersql.model

Defines a factory to create instances of a database Table model.

TableSubquery - Class in io.github.torand.fastersql.subquery

Implements a subquery to be used in a FROM clause.

TableSubquery(SelectStatement) - Constructor for class io.github.torand.fastersql.subquery.TableSubquery

Creates a table subquery.

times(Expression) - Method in interface io.github.torand.fastersql.expression.Expression

Creates the expression of multiplying another expression with this expression.

times(Object) - Method in interface io.github.torand.fastersql.expression.Expression

Creates the expression of multiplying a constant value with this expression.

toChar(Expression, String) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the timestamp/number to string conversion function for an expression.

ToChar - Class in io.github.torand.fastersql.function.singlerow

Implements the timestamp/number to string conversion function.

toNumber(Expression, int) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the string to integer number conversion function for an expression.

toNumber(Expression, int, int) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the string to decimal number conversion function for an expression.

ToNumber - Class in io.github.torand.fastersql.function.singlerow

Implements the string to number conversion function.

toString() - Method in class io.github.torand.fastersql.statement.DeleteStatement

toString() - Method in class io.github.torand.fastersql.statement.InsertBatchStatement

toString() - Method in class io.github.torand.fastersql.statement.InsertStatement

toString() - Method in class io.github.torand.fastersql.statement.SelectStatement

toString() - Method in class io.github.torand.fastersql.statement.TruncateStatement

toString() - Method in class io.github.torand.fastersql.statement.UpdateStatement

toString(Dialect) - Method in interface io.github.torand.fastersql.statement.PreparableStatement

Gets the SQL of specified dialect for this statement.

truncate() - Static method in class io.github.torand.fastersql.statement.Statements

Creates a TRUNCATE statement builder.

TRUNCATE - Enum constant in enum class io.github.torand.fastersql.sql.Command

The TRUNCATE command.

TRUNCATE_TABLE - Enum constant in enum class io.github.torand.fastersql.dialect.Capability

Supports "TRUNCATE TABLE..." clauses

TruncateStatement - Class in io.github.torand.fastersql.statement

Implements a TRUNCATE statement.

truncateTable(Table<?>) - Static method in class io.github.torand.fastersql.statement.Statements

Creates a TRUNCATE statement with specified TABLE clause.

TruncateTableBuilder - Class in io.github.torand.fastersql.statement

Builder for TRUNCATE statements with a TABLE clause.

TruncateTableBuilder() - Constructor for class io.github.torand.fastersql.statement.TruncateTableBuilder

Creates a TRUNCATE statement builder.

U

unwrap(OptionalPredicate...) - Static method in class io.github.torand.fastersql.predicate.OptionalPredicate

Gets a list of present wrapped predicates from the specified array of optional predicates.

unwrapOptional(Object) - Static method in class io.github.torand.fastersql.statement.Helpers

Returns the wrapped object if specified object is an optional, else returns the object itself.

unwrapSuppliers(Supplier<T>...) - Static method in class io.github.torand.fastersql.statement.Helpers

Returns a collection of non-null values produces by the specified suppliers.

update(Table<?>) - Static method in class io.github.torand.fastersql.statement.Statements

Creates an UPDATE statement for specified table.

UPDATE - Enum constant in enum class io.github.torand.fastersql.sql.Command

The UPDATE command.

UpdateStatement - Class in io.github.torand.fastersql.statement

Implements an UPDATE statement.

upper(Expression) - Static method in class io.github.torand.fastersql.function.singlerow.SingleRowFunctions

Creates the upper case function for a string expression.

Upper - Class in io.github.torand.fastersql.function.singlerow

Implements the upper case string function.

using(Connection) - Static method in class io.github.torand.fastersql.statement.PreparedStatementBuilder

Creates builder for statements to be executed on specified connection.

using(Connection, Dialect) - Static method in class io.github.torand.fastersql.statement.PreparedStatementBuilder

Creates builder for statements to be executed on specified connection, using specified SQL dialect.

V

value() - Method in interface io.github.torand.fastersql.constant.Constant

Gets the constant value.

value() - Method in class io.github.torand.fastersql.constant.GenericConstant

value() - Method in class io.github.torand.fastersql.constant.NullConstant

value(Column, Expression) - Method in class io.github.torand.fastersql.statement.InsertStatement

Adds an expression value to be inserted into a column.

value(Column, Object) - Method in class io.github.torand.fastersql.statement.InsertStatement

Adds a constant value to be inserted into a column.

value(Column, Function<? super T, Object>) - Method in class io.github.torand.fastersql.statement.InsertBatchStatement

Registers a column-value mapper.

value(Column, Optional<?>) - Method in class io.github.torand.fastersql.statement.InsertStatement

Adds an optional value to be inserted into a column.

valueOf(String) - Static method in enum class io.github.torand.fastersql.dialect.Capability

Returns the enum constant of this class with the specified name.

valueOf(String) - Static method in enum class io.github.torand.fastersql.sql.Clause

Returns the enum constant of this class with the specified name.

valueOf(String) - Static method in enum class io.github.torand.fastersql.sql.Command

Returns the enum constant of this class with the specified name.

values() - Static method in enum class io.github.torand.fastersql.dialect.Capability

Returns an array containing the constants of this enum class, in the order they are declared.

values() - Static method in enum class io.github.torand.fastersql.sql.Clause

Returns an array containing the constants of this enum class, in the order they are declared.

values() - Static method in enum class io.github.torand.fastersql.sql.Command

Returns an array containing the constants of this enum class, in the order they are declared.

W

where(OptionalPredicate...) - Method in class io.github.torand.fastersql.statement.DeleteStatement

Adds optional predicates to the WHERE clause if the wrapped predicates are present.

where(OptionalPredicate...) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds optional predicates to the WHERE clause if the wrapped predicates are present.

where(OptionalPredicate...) - Method in class io.github.torand.fastersql.statement.UpdateStatement

Adds optional predicates to the WHERE clause if the wrapped predicates are present.

where(Predicate...) - Method in class io.github.torand.fastersql.statement.DeleteStatement

Adds one or more predicates to the WHERE clause.

where(Predicate...) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds one or more predicates to the WHERE clause.

where(Predicate...) - Method in class io.github.torand.fastersql.statement.UpdateStatement

Adds one or more predicates to the WHERE clause.

whereIf(boolean, Supplier<Predicate>...) - Method in class io.github.torand.fastersql.statement.DeleteStatement

Adds supplied predicates to the WHERE clause, if the condition is true.

whereIf(boolean, Supplier<Predicate>...) - Method in class io.github.torand.fastersql.statement.SelectStatement

Adds supplied predicates to the WHERE clause, if the condition is true.

withClause(Clause) - Method in class io.github.torand.fastersql.sql.Context

Sets the current statement clause.

withCommand(Command) - Method in class io.github.torand.fastersql.sql.Context

Sets the current statement command.

withCustomizations(Connection) - Method in class io.github.torand.fastersql.dialect.H2Dialect

Adds some user defined functions emulating common SQL constructs not supported by default.

withLegacyRowLimiting() - Method in class io.github.torand.fastersql.dialect.OracleDialect

Enables emulating OFFSET and LIMIT constructs for older Oracle versions.

withOuterStatement(SelectStatement) - Method in class io.github.torand.fastersql.sql.Context

Sets the current outer statement.

$ A C D E F G H I J L M N O P Q R S T U V W
All Classes and Interfaces|All Packages