class JdbcSQLQueryBuilder extends AnyRef
The builder to build a single SELECT query.
Note: All the withXXX methods will be invoked at most once. The invocation order does not
matter, as all these clauses follow the natural SQL order: sample the table first, then filter,
then group by, then sort, then offset, then limit.
- Source
- JdbcSQLQueryBuilder.scala
- Since
3.5.0
- Alphabetic
- By Inheritance
- JdbcSQLQueryBuilder
- AnyRef
- Any
- Hide All
- Show All
- Public
- Protected
Instance Constructors
- new JdbcSQLQueryBuilder(dialect: JdbcDialect, options: JDBCOptions)
Value Members
- final def !=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- final def ##: Int
- Definition Classes
- AnyRef → Any
- final def ==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- final def asInstanceOf[T0]: T0
- Definition Classes
- Any
- def build(): String
Build the final SQL query that following dialect's SQL syntax.
- def clone(): AnyRef
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.CloneNotSupportedException]) @IntrinsicCandidate() @native()
- var columnList: String
columns, but as a String suitable for injection into a SQL query.columns, but as a String suitable for injection into a SQL query.- Attributes
- protected
- final def eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def equals(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef → Any
- final def getClass(): Class[_ <: AnyRef]
- Definition Classes
- AnyRef → Any
- Annotations
- @IntrinsicCandidate() @native()
- var groupByClause: String
A GROUP BY clause representing pushed-down grouping columns.
A GROUP BY clause representing pushed-down grouping columns.
- Attributes
- protected
- def hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @IntrinsicCandidate() @native()
- final def isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- var limit: Int
A LIMIT value representing pushed-down limit.
A LIMIT value representing pushed-down limit.
- Attributes
- protected
- final def ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- final def notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @IntrinsicCandidate() @native()
- final def notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @IntrinsicCandidate() @native()
- var offset: Int
A OFFSET value representing pushed-down offset.
A OFFSET value representing pushed-down offset.
- Attributes
- protected
- var orderByClause: String
A ORDER BY clause representing pushed-down sort of top n.
A ORDER BY clause representing pushed-down sort of top n.
- Attributes
- protected
- final def synchronized[T0](arg0: => T0): T0
- Definition Classes
- AnyRef
- var tableSampleClause: String
A table sample clause representing pushed-down table sample.
A table sample clause representing pushed-down table sample.
- Attributes
- protected
- def toString(): String
- Definition Classes
- AnyRef → Any
- final def wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- final def wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException]) @native()
- final def wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- var whereClause: String
A WHERE clause representing both
filters, if any, and the current partition.A WHERE clause representing both
filters, if any, and the current partition.- Attributes
- protected
- def withColumns(columns: Array[String]): JdbcSQLQueryBuilder
The columns names that following dialect's SQL syntax.
The columns names that following dialect's SQL syntax. e.g. The column name is the raw name or quoted name.
- def withGroupByColumns(groupByColumns: Array[String]): JdbcSQLQueryBuilder
Constructs the GROUP BY clause that following dialect's SQL syntax.
- def withLimit(limit: Int): JdbcSQLQueryBuilder
Saves the limit value used to construct LIMIT clause.
- def withOffset(offset: Int): JdbcSQLQueryBuilder
Saves the offset value used to construct OFFSET clause.
- def withPredicates(predicates: Array[Predicate], part: JDBCPartition): JdbcSQLQueryBuilder
Constructs the WHERE clause that following dialect's SQL syntax.
- def withSortOrders(sortOrders: Array[String]): JdbcSQLQueryBuilder
Constructs the ORDER BY clause that following dialect's SQL syntax.
- def withTableSample(sample: TableSampleInfo): JdbcSQLQueryBuilder
Constructs the table sample clause that following dialect's SQL syntax.
Deprecated Value Members
- def finalize(): Unit
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.Throwable]) @Deprecated
- Deprecated
(Since version 9)