Packages

c

slick.jdbc.SQLServerProfile

SQLServerQueryBuilder

class SQLServerQueryBuilder extends QueryBuilder

Source
SQLServerProfile.scala
Linear Supertypes
SQLServerProfile.QueryBuilder, InterpolationContext, AnyRef, Any
Type Hierarchy
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. SQLServerQueryBuilder
  2. QueryBuilder
  3. InterpolationContext
  4. AnyRef
  5. Any
Implicitly
  1. by StringFormat
  2. by Ensuring
  3. by ArrowAssoc
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. Protected

Instance Constructors

  1. new SQLServerQueryBuilder(tree: Node, state: CompilerState)

Value Members

  1. final def !=(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  2. final def ##: Int
    Definition Classes
    AnyRef → Any
  3. def ->[B](y: B): (SQLServerQueryBuilder, B)
    Implicit
    This member is added by an implicit conversion from SQLServerQueryBuilder toArrowAssoc[SQLServerQueryBuilder] performed by method ArrowAssoc in scala.Predef.
    Definition Classes
    ArrowAssoc
    Annotations
    @inline()
  4. final def ==(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  5. val alwaysAliasSubqueries: Boolean
    Attributes
    protected
    Definition Classes
    QueryBuilder
  6. val alwaysAliasTables: Boolean

    Alias every table in a FROM clause and qualify the column references, also in single-table SELECTs.

    Alias every table in a FROM clause and qualify the column references, also in single-table SELECTs. SQLite needs this because it reads an unknown, unqualified double-quoted column name as a string literal instead of failing.

    Attributes
    protected
    Definition Classes
    QueryBuilder
  7. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  8. val b: SQLBuilder
    Attributes
    protected
    Definition Classes
    QueryBuilder
  9. def buildComprehension(c: Base): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  10. def buildDelete(): Result
    Definition Classes
    QueryBuilder
  11. def buildDeleteFrom(tableName: String): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  12. def buildFetchOffsetClause(fetch: Option[Node], offset: Option[Node]): Unit
    Attributes
    protected
    Definition Classes
    SQLServerQueryBuilder → QueryBuilder
  13. def buildFrom(n: Node, alias: Option[TermSymbol]): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  14. final def buildFrom(n: Node, alias: Option[TermSymbol], skipParens: Boolean): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  15. def buildFromClause(from: Seq[(TermSymbol, Node)]): Unit
    Attributes
    protected
    Definition Classes
    SQLServerQueryBuilder → QueryBuilder
  16. def buildGroupByClause(groupBy: Option[Node]): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  17. def buildGroupByColumn(by: Node): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  18. def buildHavingClause(having: Option[Node]): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  19. def buildJoin(j: Join): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  20. def buildLockingClause(strength: Option[LockStrength]): Unit
    Attributes
    protected
    Definition Classes
    SQLServerQueryBuilder → QueryBuilder
  21. def buildOrderByClause(order: ConstArray[(Node, Ordering)]): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  22. def buildOrdering(n: Node, o: Ordering): Unit
    Attributes
    protected
    Definition Classes
    SQLServerQueryBuilder → QueryBuilder
  23. final def buildSelect(): Result
    Definition Classes
    QueryBuilder
  24. def buildSelectClause(c: Base): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  25. def buildSelectModifiers(c: Base): Unit
    Attributes
    protected
    Definition Classes
    SQLServerQueryBuilder → QueryBuilder
  26. def buildSelectPart(n: Node): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  27. def buildUpdate(): Result
    Definition Classes
    QueryBuilder
  28. def buildWhereClause(where: Option[Node]): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  29. final def building(p: SQLServerProfile.StatementPart)(f: => Unit): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
    Annotations
    @inline()
  30. def castNullLiteralInSelect(ti: JdbcType[_]): Boolean

    Whether a NULL literal of type ti that is a column of a select list is written as cast(null as <type>).

    Whether a NULL literal of type ti that is a column of a select list is written as cast(null as <type>). Without the cast, a database has to guess the type of the column, e.g. in a subquery or a union of NULLs, and PostgreSQL and HSQLDB guess one that does not match the other side of a union or the column's use in an outer query. A bind variable is never cast.

    The cast's type is the default SQL type of ti, not the type of the other sides of a union. A union of strings, times or most numbers takes the largest length or precision of its sides, so the cast can only widen the result. A union of DECIMALs adds up the largest scale and the largest number of integer digits of its sides, so where that sum is capped (38 digits on SQL Server, 31 on DB2), the cast's DECIMAL(21,2) can cost a high-scale column its scale or integer digits. Those profiles leave a DECIMAL NULL untyped.

    A String mapped onto a column of a custom database type, such as a PostgreSQL enum, has the SQL type VARCHAR, so its NULL is cast to VARCHAR and does not match the column in a union. Such a type needs a sqlTypeName that names the real type.

    Attributes
    protected
    Definition Classes
    SQLServerQueryBuilder → QueryBuilder
  31. def clone(): AnyRef
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.CloneNotSupportedException]) @IntrinsicCandidate() @native()
  32. val concatOperator: Some[String]
    Attributes
    protected
    Definition Classes
    SQLServerQueryBuilder → QueryBuilder
  33. var currentPart: SQLServerProfile.StatementPart
    Attributes
    protected
    Definition Classes
    QueryBuilder
  34. var currentUniqueFrom: Option[TermSymbol]
    Attributes
    protected
    Definition Classes
    QueryBuilder
  35. var dmlTargetTableName: Option[String]

    The name of the target table of the UPDATE or DELETE statement being built.

    The name of the target table of the UPDATE or DELETE statement being built. A subquery that reads the same table must alias it, so that its columns don't resolve to the target table.

    Attributes
    protected
    Definition Classes
    QueryBuilder
  36. def ensuring(cond: (SQLServerQueryBuilder) => Boolean, msg: => Any): SQLServerQueryBuilder
    Implicit
    This member is added by an implicit conversion from SQLServerQueryBuilder toEnsuring[SQLServerQueryBuilder] performed by method Ensuring in scala.Predef.
    Definition Classes
    Ensuring
  37. def ensuring(cond: (SQLServerQueryBuilder) => Boolean): SQLServerQueryBuilder
    Implicit
    This member is added by an implicit conversion from SQLServerQueryBuilder toEnsuring[SQLServerQueryBuilder] performed by method Ensuring in scala.Predef.
    Definition Classes
    Ensuring
  38. def ensuring(cond: Boolean, msg: => Any): SQLServerQueryBuilder
    Implicit
    This member is added by an implicit conversion from SQLServerQueryBuilder toEnsuring[SQLServerQueryBuilder] performed by method Ensuring in scala.Predef.
    Definition Classes
    Ensuring
  39. def ensuring(cond: Boolean): SQLServerQueryBuilder
    Implicit
    This member is added by an implicit conversion from SQLServerQueryBuilder toEnsuring[SQLServerQueryBuilder] performed by method Ensuring in scala.Predef.
    Definition Classes
    Ensuring
  40. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  41. def equals(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef → Any
  42. def expr(n: Node): Unit
    Definition Classes
    SQLServerQueryBuilder → QueryBuilder → InterpolationContext
  43. final def expr(n: Node, skipParens: Boolean): Unit
    Definition Classes
    QueryBuilder
  44. def flattenJoins(s: TermSymbol, n: Node): (Seq[(TermSymbol, Node)], Seq[Node])
    Attributes
    protected
    Definition Classes
    QueryBuilder
  45. final def getClass(): Class[_ <: AnyRef]
    Definition Classes
    AnyRef → Any
    Annotations
    @IntrinsicCandidate() @native()
  46. val hasPiFunction: Boolean
    Attributes
    protected
    Definition Classes
    QueryBuilder
  47. val hasRadDegConversion: Boolean
    Attributes
    protected
    Definition Classes
    QueryBuilder
  48. def hashCode(): Int
    Definition Classes
    AnyRef → Any
    Annotations
    @IntrinsicCandidate() @native()
  49. implicit def interpolationContext: InterpolationContext
    Definition Classes
    QueryBuilder
  50. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  51. val joins: HashMap[TermSymbol, Join]
    Attributes
    protected
    Definition Classes
    QueryBuilder
  52. val maxFlatBooleanOperands: Int

    The maximum number of operands of an and or or that are rendered as one flat list.

    The maximum number of operands of an and or or that are rendered as one flat list. Longer chains are split into a balanced tree of parenthesized groups, so that their nesting depth in the database's SQL parser stays logarithmic (e.g. SQLite limits the expression depth to 1000 and Derby's SQL compiler recurses over it).

    Attributes
    protected
    Definition Classes
    QueryBuilder
  53. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  54. final def notify(): Unit
    Definition Classes
    AnyRef
    Annotations
    @IntrinsicCandidate() @native()
  55. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @IntrinsicCandidate() @native()
  56. val parenthesizeNestedRHSJoin: Boolean
    Attributes
    protected
    Definition Classes
    QueryBuilder
  57. val pi: String
    Attributes
    protected
    Definition Classes
    QueryBuilder
  58. def quoteIdentifier(s: String): String
    Definition Classes
    QueryBuilder → InterpolationContext
  59. val quotedJdbcFns: Option[Seq[JdbcFunction]]
    Attributes
    protected
    Definition Classes
    QueryBuilder
  60. def scanJoins(from: ConstArray[(TermSymbol, Node)]): Unit
    Attributes
    protected
    Definition Classes
    QueryBuilder
  61. final def skipParens: Boolean
    Definition Classes
    QueryBuilder → InterpolationContext
  62. def sqlBuilder: SQLBuilder
    Definition Classes
    QueryBuilder → InterpolationContext
  63. val state: CompilerState
    Definition Classes
    QueryBuilder
  64. val supportsCast: Boolean
    Attributes
    protected
    Definition Classes
    QueryBuilder
  65. val supportsLiteralGroupBy: Boolean
    Attributes
    protected
    Definition Classes
    QueryBuilder
  66. val supportsTuples: Boolean
    Attributes
    protected
    Definition Classes
    SQLServerQueryBuilder → QueryBuilder
  67. val symbolName: SymbolNamer
    Definition Classes
    QueryBuilder → InterpolationContext
  68. final def synchronized[T0](arg0: => T0): T0
    Definition Classes
    AnyRef
  69. def toString(): String
    Definition Classes
    AnyRef → Any
  70. val tree: Node
    Definition Classes
    QueryBuilder
  71. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])
  72. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException]) @native()
  73. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])
  74. final def withSkipParens[U](b: Boolean)(f: => U): U
    Definition Classes
    QueryBuilder → InterpolationContext

Deprecated Value Members

  1. def finalize(): Unit
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.Throwable]) @Deprecated
    Deprecated

    (Since version 9)

  2. def formatted(fmtstr: String): String
    Implicit
    This member is added by an implicit conversion from SQLServerQueryBuilder toStringFormat[SQLServerQueryBuilder] performed by method StringFormat in scala.Predef.
    Definition Classes
    StringFormat
    Annotations
    @deprecated @inline()
    Deprecated

    (Since version 2.12.16) Use formatString.format(value) instead of value.formatted(formatString), or use the f"" string interpolator. In Java 15 and later, formatted resolves to the new method in String which has reversed parameters.

  3. def →[B](y: B): (SQLServerQueryBuilder, B)
    Implicit
    This member is added by an implicit conversion from SQLServerQueryBuilder toArrowAssoc[SQLServerQueryBuilder] performed by method ArrowAssoc in scala.Predef.
    Definition Classes
    ArrowAssoc
    Annotations
    @deprecated
    Deprecated

    (Since version 2.13.0) Use -> instead. If you still wish to display it as one character, consider using a font with programming ligatures such as Fira Code.

Inherited from SQLServerProfile.QueryBuilder

Inherited from InterpolationContext

Inherited from AnyRef

Inherited from Any

Inherited by implicit conversion StringFormat fromSQLServerQueryBuilder to StringFormat[SQLServerQueryBuilder]

Inherited by implicit conversion Ensuring fromSQLServerQueryBuilder to Ensuring[SQLServerQueryBuilder]

Inherited by implicit conversion ArrowAssoc fromSQLServerQueryBuilder to ArrowAssoc[SQLServerQueryBuilder]

Ungrouped