Trait

scalikejdbc.QueryDSLFeature

ConditionSQLBuilder

Related Doc: package QueryDSLFeature

Permalink

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

    Permalink
    Definition Classes
    SQLBuilder

Concrete Value Members

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

    Permalink
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int

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

    Permalink
    Definition Classes
    AnyRef → Any
  4. def and(sqlPart: Option[(QueryDSLFeature.this)#SQLSyntax]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

    Permalink

    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
  7. def as(sq: (QueryDSLFeature.this)#SubQuerySQLSyntaxProvider): (QueryDSLFeature.this)#TableAsAliasSQLSyntax

    Permalink

    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

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

    Permalink
    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]

    Permalink
  11. def clone(): AnyRef

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

    Permalink
    Definition Classes
    PagingSQLBuilder
  13. def eq[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

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

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

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

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

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

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

    Permalink
  22. def finalize(): Unit

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

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

    Permalink
    Definition Classes
    ForUpdateQuerySQLBuilder
  25. def ge[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

    Permalink
    Definition Classes
    GroupBySQLBuilder
  28. def gt[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

    Permalink
  29. def hashCode(): Int

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

    Permalink
    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]

    Permalink
  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]

    Permalink
  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]

    Permalink
  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]

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

    Permalink
  36. def in[B](column: (QueryDSLFeature.this)#SQLSyntax, values: Seq[B])(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

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

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

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

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

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

    Permalink
  44. def le[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

    Permalink
    Definition Classes
    PagingSQLBuilder
  47. def lt[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

    Permalink

    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]

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

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

    Permalink
  52. def notBetween[B, C](column: (QueryDSLFeature.this)#SQLSyntax, a: B, b: C)(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

    Permalink
  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]

    Permalink
  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]

    Permalink
  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]

    Permalink
  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]

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

    Permalink
  60. def notIn[B](column: (QueryDSLFeature.this)#SQLSyntax, values: Seq[B])(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

    Permalink
  62. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef
  63. final def notifyAll(): Unit

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

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

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

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

    Permalink
    Definition Classes
    PagingSQLBuilder
  68. def roundBracket(inner: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

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

    Permalink
    Definition Classes
    SQLBuilder
  72. def toString(): String

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

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

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

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

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

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

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

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

    Permalink

    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