scalikejdbc.QueryDSLFeature

ConditionSQLBuilder

Related Doc: package QueryDSLFeature

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: Any): Boolean

    Definition Classes
    AnyRef → Any

  2. final def ##(): Int

    Definition Classes
    AnyRef → Any

  3. final def ==(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  4. def and(sqlPart: Option[(QueryDSLFeature.this)#SQLSyntax]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

  6. 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
    ConditionSQLBuilder → GroupBySQLBuilder → PagingSQLBuilder → SQLBuilder

  7. 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

  8. final def asInstanceOf[T0]: T0

    Definition Classes
    Any

  9. def asc: (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    PagingSQLBuilder

  10. def between(column: (QueryDSLFeature.this)#SQLSyntax, a: Any, b: Any): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  11. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  12. def desc: (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    PagingSQLBuilder

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

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

    Definition Classes
    AnyRef

  15. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  16. def except(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ExceptQuerySQLBuilder

  17. def except(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ExceptQuerySQLBuilder

  18. def exceptAll(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ExceptQuerySQLBuilder

  19. def exceptAll(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ExceptQuerySQLBuilder

  20. def exists(subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

  22. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )

  23. def forUpdate(option: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ForUpdateQuerySQLBuilder

  24. def forUpdate: (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    ForUpdateQuerySQLBuilder

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

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

    Definition Classes
    AnyRef → Any

  27. def groupBy(columns: (QueryDSLFeature.this)#SQLSyntax*): (QueryDSLFeature.this)#GroupBySQLBuilder[A]

    Definition Classes
    GroupBySQLBuilder

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

  29. def hashCode(): Int

    Definition Classes
    AnyRef → Any

  30. def having(condition: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#GroupBySQLBuilder[A]

    Definition Classes
    GroupBySQLBuilder

  31. 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]

  32. 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]

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

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

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

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

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

    Definition Classes
    IntersectQuerySQLBuilder

  38. def intersect(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    IntersectQuerySQLBuilder

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

    Definition Classes
    IntersectQuerySQLBuilder

  40. def intersectAll(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    IntersectQuerySQLBuilder

  41. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any

  42. def isNotNull(column: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

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

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

    Definition Classes
    PagingSQLBuilder

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

  48. 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 }

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

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

    Definition Classes
    AnyRef

  51. def not: (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  52. def notBetween(column: (QueryDSLFeature.this)#SQLSyntax, a: Any, b: Any): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

  55. 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]

  56. 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]

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

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

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

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

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

  62. final def notify(): Unit

    Definition Classes
    AnyRef

  63. final def notifyAll(): Unit

    Definition Classes
    AnyRef

  64. def offset(n: Int): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    PagingSQLBuilder

  65. def or(sqlPart: Option[(QueryDSLFeature.this)#SQLSyntax]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

    Definition Classes
    PagingSQLBuilder

  68. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef

  69. def toSQL: SQL[A, NoExtractor]

    Definition Classes
    SQLBuilder

  70. def toSQLSyntax: (QueryDSLFeature.this)#SQLSyntax

    Definition Classes
    SQLBuilder

  71. def toString(): String

    Definition Classes
    AnyRef → Any

  72. def union(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    UnionQuerySQLBuilder

  73. def union(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    UnionQuerySQLBuilder

  74. def unionAll(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    UnionQuerySQLBuilder

  75. def unionAll(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]

    Definition Classes
    UnionQuerySQLBuilder

  76. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  77. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  78. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  79. 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