scalikejdbc.QueryDSLFeature

ConditionSQLBuilder

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

Linear Supertypes
(QueryDSLFeature.this)#GroupBySQLBuilder[A], (QueryDSLFeature.this)#PagingSQLBuilder[A], (QueryDSLFeature.this)#SubQuerySQLBuilder[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. IntersectQuerySQLBuilder
  6. ExceptQuerySQLBuilder
  7. UnionQuerySQLBuilder
  8. SQLBuilder
  9. AnyRef
  10. 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: (QueryDSLFeature.this)#ConditionSQLBuilder[A]

  7. 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
  8. 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
  9. final def asInstanceOf[T0]: T0

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

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

  12. def clone(): AnyRef

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

    Definition Classes
    PagingSQLBuilder
  14. def dynamicAndConditions(conditions: Option[(QueryDSLFeature.this)#SQLSyntax]*): (QueryDSLFeature.this)#RawSQLBuilder[A] with (QueryDSLFeature.this)#ConditionSQLBuilder[A]

    Appends conditions with delimiter.

    Appends conditions with delimiter.

    .where
    .dynamicAndConditions(
      id.map(i => sqls.eq(u.id, i)),
      Some(sqls.isNotNull(u.name))
    )
  15. def dynamicOrConditions(conditions: Option[(QueryDSLFeature.this)#SQLSyntax]*): (QueryDSLFeature.this)#RawSQLBuilder[A] with (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

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

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

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

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

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

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

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

  25. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws()
  26. def ge(column: (QueryDSLFeature.this)#SQLSyntax, value: Any): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

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

  30. def hashCode(): Int

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

    Definition Classes
    GroupBySQLBuilder
  32. def in(column: (QueryDSLFeature.this)#SQLSyntax, subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  54. final def notify(): Unit

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

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

    Definition Classes
    PagingSQLBuilder
  57. def or: (QueryDSLFeature.this)#ConditionSQLBuilder[A]

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

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

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

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

    Definition Classes
    SQLBuilder
  62. def toString(): String

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

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

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

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

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

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

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

    Definition Classes
    AnyRef
    Annotations
    @throws()
  70. 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)

Deprecated Value Members

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

    Annotations
    @deprecated
    Deprecated

    (Since version 1.6.2) use between(column: SQLSyntax, a: Any, b: Any) instead

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

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

Inherited from (QueryDSLFeature.this)#SubQuerySQLBuilder[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