scalikejdbc.QueryDSLFeature

ConditionSQLBuilder

trait ConditionSQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A] with (QueryDSLFeature.this)#PagingSQLBuilder[A] with (QueryDSLFeature.this)#GroupBySQLBuilder[A]

Source
QueryDSLFeature.scala
Linear Supertypes
(QueryDSLFeature.this)#GroupBySQLBuilder[A], (QueryDSLFeature.this)#PagingSQLBuilder[A], (QueryDSLFeature.this)#SubQuerySQLBuilder[A], (QueryDSLFeature.this)#ForUpdateQuerySQLBuilder[A], (QueryDSLFeature.this)#IntersectQuerySQLBuilder[A], (QueryDSLFeature.this)#ExceptQuerySQLBuilder[A], (QueryDSLFeature.this)#UnionQuerySQLBuilder[A], (QueryDSLFeature.this)#SQLBuilder[A], AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. ConditionSQLBuilder
  2. GroupBySQLBuilder
  3. PagingSQLBuilder
  4. SubQuerySQLBuilder
  5. ForUpdateQuerySQLBuilder
  6. IntersectQuerySQLBuilder
  7. ExceptQuerySQLBuilder
  8. UnionQuerySQLBuilder
  9. SQLBuilder
  10. AnyRef
  11. Any
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

Abstract Value Members

  1. abstract def sql: (QueryDSLFeature.this)#SQLSyntax

    Definition Classes
    SQLBuilder

Concrete Value Members

  1. final def !=(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  2. final def !=(arg0: Any): Boolean

    Definition Classes
    Any
  3. final def ##(): Int

    Definition Classes
    AnyRef → Any
  4. final def ==(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  5. final def ==(arg0: Any): Boolean

    Definition Classes
    Any
  6. def and(sqlPart: Option[(QueryDSLFeature.this)#SQLSyntax]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  7. def and: (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  8. def append(part: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

    Appends SQLSyntax directly.

    Appends SQLSyntax directly. e.g. select.from(User as u).where.eq(u.id, 123).append(sqls"order by ${u.id} desc")

    Definition Classes
    ConditionSQLBuilderGroupBySQLBuilderPagingSQLBuilderSQLBuilder
  9. def as(sq: (QueryDSLFeature.this)#SubQuerySQLSyntaxProvider): (QueryDSLFeature.this)#TableAsAliasSQLSyntax

    Converts SQLBuilder to sub-query part sqls.

    Converts SQLBuilder to sub-query part sqls. e.g. val x = SubQuery.syntax("x").include(u, g) withSQL { select.from(select.from(User as u).leftJoin(Group as g).on(u.groupId, g.id).where.eq(u.groupId, 234).as(x)) }

    Definition Classes
    SubQuerySQLBuilder
  10. final def asInstanceOf[T0]: T0

    Definition Classes
    Any
  11. def asc: (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    PagingSQLBuilder
  12. def between(column: (QueryDSLFeature.this)#SQLSyntax, a: Any, b: Any): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  13. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  14. def desc: (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    PagingSQLBuilder
  15. def eq(column: (QueryDSLFeature.this)#SQLSyntax, value: Any): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  16. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  17. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any
  18. def except(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ExceptQuerySQLBuilder
  19. def except(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ExceptQuerySQLBuilder
  20. def exceptAll(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ExceptQuerySQLBuilder
  21. def exceptAll(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ExceptQuerySQLBuilder
  22. def exists(subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  23. def exists(subQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  24. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  25. def forUpdate(option: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ForUpdateQuerySQLBuilder
  26. def forUpdate: (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ForUpdateQuerySQLBuilder
  27. def ge(column: (QueryDSLFeature.this)#SQLSyntax, value: Any): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  28. final def getClass(): Class[_]

    Definition Classes
    AnyRef → Any
  29. def groupBy(columns: (QueryDSLFeature.this)#SQLSyntax*): (QueryDSLFeature.this)#GroupBySQLBuilder[A]

    Definition Classes
    GroupBySQLBuilder
  30. def gt(column: (QueryDSLFeature.this)#SQLSyntax, value: Any): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  31. def hashCode(): Int

    Definition Classes
    AnyRef → Any
  32. def having(condition: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#GroupBySQLBuilder[A]

    Definition Classes
    GroupBySQLBuilder
  33. def in(columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(Any, Any, Any, Any, Any)]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  34. def in(columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(Any, Any, Any, Any)]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  35. def in(columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(Any, Any, Any)]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  36. def in(columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(Any, Any)]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  37. def in(column: (QueryDSLFeature.this)#SQLSyntax, subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  38. def in(column: (QueryDSLFeature.this)#SQLSyntax, values: Seq[Any]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  39. def intersect(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    IntersectQuerySQLBuilder
  40. def intersect(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    IntersectQuerySQLBuilder
  41. def intersectAll(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    IntersectQuerySQLBuilder
  42. def intersectAll(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    IntersectQuerySQLBuilder
  43. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any
  44. def isNotNull(column: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  45. def isNull(column: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  46. def le(column: (QueryDSLFeature.this)#SQLSyntax, value: Any): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  47. def like(column: (QueryDSLFeature.this)#SQLSyntax, value: String): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  48. def limit(n: Int): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    PagingSQLBuilder
  49. def lt(column: (QueryDSLFeature.this)#SQLSyntax, value: Any): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  50. def map(mapper: ((QueryDSLFeature.this)#ConditionSQLBuilder[A]) ⇒ (QueryDSLFeature.this)#ConditionSQLBuilder[A]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

    Maps SQLBuilder as follows.

    Maps SQLBuilder as follows. e.g. select.from(User as u).where.eq(u.id, 123).map { sql => if(name.isDefined) sql.and.eq(u.name, name) else sql }

  51. def ne(column: (QueryDSLFeature.this)#SQLSyntax, value: Any): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  52. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  53. def not: (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  54. def notExists(subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  55. def notExists(subQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  56. def notIn(columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(Any, Any, Any, Any, Any)]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  57. def notIn(columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(Any, Any, Any, Any)]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  58. def notIn(columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(Any, Any, Any)]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  59. def notIn(columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(Any, Any)]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  60. def notIn(column: (QueryDSLFeature.this)#SQLSyntax, subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  61. def notIn(column: (QueryDSLFeature.this)#SQLSyntax, values: Seq[Any]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  62. def notLike(column: (QueryDSLFeature.this)#SQLSyntax, value: String): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  63. final def notify(): Unit

    Definition Classes
    AnyRef
  64. final def notifyAll(): Unit

    Definition Classes
    AnyRef
  65. def offset(n: Int): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    PagingSQLBuilder
  66. def or(sqlPart: Option[(QueryDSLFeature.this)#SQLSyntax]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  67. def or: (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  68. def orderBy(columns: (QueryDSLFeature.this)#SQLSyntax*): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    PagingSQLBuilder
  69. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef
  70. def toSQL: SQL[A, NoExtractor]

    Definition Classes
    SQLBuilder
  71. def toSQLSyntax: (QueryDSLFeature.this)#SQLSyntax

    Definition Classes
    SQLBuilder
  72. def toString(): String

    Definition Classes
    AnyRef → Any
  73. def union(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    UnionQuerySQLBuilder
  74. def union(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    UnionQuerySQLBuilder
  75. def unionAll(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    UnionQuerySQLBuilder
  76. def unionAll(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    UnionQuerySQLBuilder
  77. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  78. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  79. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  80. def withRoundBracket[A](insidePart: ((QueryDSLFeature.this)#ConditionSQLBuilder[_]) ⇒ (QueryDSLFeature.this)#ConditionSQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

    Appends a round bracket in where clause.

    Appends a round bracket in where clause. e.g. select.from(User as u).where.withRoundBracket { _.eq(u.id, 123).and.eq(u.groupId, 234) }.or.eq(u.groupId, 345)

Inherited from (QueryDSLFeature.this)#GroupBySQLBuilder[A]

Inherited from (QueryDSLFeature.this)#PagingSQLBuilder[A]

Inherited from (QueryDSLFeature.this)#SubQuerySQLBuilder[A]

Inherited from (QueryDSLFeature.this)#ForUpdateQuerySQLBuilder[A]

Inherited from (QueryDSLFeature.this)#IntersectQuerySQLBuilder[A]

Inherited from (QueryDSLFeature.this)#ExceptQuerySQLBuilder[A]

Inherited from (QueryDSLFeature.this)#UnionQuerySQLBuilder[A]

Inherited from (QueryDSLFeature.this)#SQLBuilder[A]

Inherited from AnyRef

Inherited from Any

Ungrouped