t

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
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[B, C](column: (QueryDSLFeature.this)#SQLSyntax, a: B, b: C)(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  11. def clone(): AnyRef
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @native() @throws( ... )
  12. def desc: (QueryDSLFeature.this)#PagingSQLBuilder[A]
    Definition Classes
    PagingSQLBuilder
  13. def eq[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (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[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  26. final def getClass(): Class[_]
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  27. def groupBy(columns: (QueryDSLFeature.this)#SQLSyntax*): (QueryDSLFeature.this)#GroupBySQLBuilder[A]
    Definition Classes
    GroupBySQLBuilder
  28. def gt[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  29. def hashCode(): Int
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  30. def having(condition: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#GroupBySQLBuilder[A]
    Definition Classes
    GroupBySQLBuilder
  31. def in[B, C, D, E, G](columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(B, C, D, E, G)])(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C], arg2: ParameterBinderFactory[D], arg3: ParameterBinderFactory[E], arg4: ParameterBinderFactory[G]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  32. def in[B, C, D, E](columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(B, C, D, E)])(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C], arg2: ParameterBinderFactory[D], arg3: ParameterBinderFactory[E]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  33. def in[B, C, D](columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(B, C, D)])(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C], arg2: ParameterBinderFactory[D]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  34. def in[B, C](columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(B, C)])(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  35. def in(column: (QueryDSLFeature.this)#SQLSyntax, subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  36. def in[B](column: (QueryDSLFeature.this)#SQLSyntax, values: Seq[B])(implicit arg0: ParameterBinderFactory[B]): (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[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (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[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (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[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  50. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  51. def not: (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  52. def notBetween[B, C](column: (QueryDSLFeature.this)#SQLSyntax, a: B, b: C)(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C]): (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[B, C, D, E, G](columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(B, C, D, E, G)])(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C], arg2: ParameterBinderFactory[D], arg3: ParameterBinderFactory[E], arg4: ParameterBinderFactory[G]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  56. def notIn[B, C, D, E](columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(B, C, D, E)])(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C], arg2: ParameterBinderFactory[D], arg3: ParameterBinderFactory[E]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  57. def notIn[B, C, D](columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(B, C, D)])(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C], arg2: ParameterBinderFactory[D]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  58. def notIn[B, C](columns: ((QueryDSLFeature.this)#SQLSyntax, (QueryDSLFeature.this)#SQLSyntax), valueSeqs: Seq[(B, C)])(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  59. def notIn(column: (QueryDSLFeature.this)#SQLSyntax, subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  60. def notIn[B](column: (QueryDSLFeature.this)#SQLSyntax, values: Seq[B])(implicit arg0: ParameterBinderFactory[B]): (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
    Annotations
    @native()
  63. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  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. def roundBracket(inner: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
  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
    @native() @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