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)#SubQuerySQLBuilder[A]

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

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

  21. def finalize(): Unit

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

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

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

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

  26. def hashCode(): Int

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

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

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

  30. final def isInstanceOf[T0]: Boolean

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  46. final def notify(): Unit

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

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

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

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

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

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

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

    Definition Classes
    SQLBuilder
  54. def toString(): String

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

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

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

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

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

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

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

    Definition Classes
    AnyRef
    Annotations
    @throws()
  62. 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)#UnionQuerySQLBuilder[A]

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

Inherited from AnyRef

Inherited from Any

Ungrouped