trait ConditionSQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A] with (QueryDSLFeature.this)#PagingSQLBuilder[A] with (QueryDSLFeature.this)#GroupBySQLBuilder[A]
- Source
- QueryDSLFeature.scala
- Alphabetic
- By Inheritance
- ConditionSQLBuilder
- GroupBySQLBuilder
- PagingSQLBuilder
- SubQuerySQLBuilder
- ForUpdateQuerySQLBuilder
- IntersectQuerySQLBuilder
- ExceptQuerySQLBuilder
- UnionQuerySQLBuilder
- SQLBuilder
- AnyRef
- Any
- Hide All
- Show All
- Public
- All
Abstract Value Members
-
abstract
def
sql: (QueryDSLFeature.this)#SQLSyntax
- Definition Classes
- SQLBuilder
Concrete Value Members
-
final
def
!=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
final
def
##(): Int
- Definition Classes
- AnyRef → Any
-
final
def
==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- def and(sqlPart: Option[(QueryDSLFeature.this)#SQLSyntax]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def and: (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
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
-
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
-
final
def
asInstanceOf[T0]: T0
- Definition Classes
- Any
-
def
asc: (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- PagingSQLBuilder
- def between[B, C](column: (QueryDSLFeature.this)#SQLSyntax, a: B, b: C)(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
def
clone(): AnyRef
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @native() @throws( ... )
-
def
desc: (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- PagingSQLBuilder
- def eq[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
final
def
eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
def
equals(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
def
except(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- ExceptQuerySQLBuilder
-
def
except(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- ExceptQuerySQLBuilder
-
def
exceptAll(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- ExceptQuerySQLBuilder
-
def
exceptAll(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- ExceptQuerySQLBuilder
- def exists(subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def exists(subQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
def
finalize(): Unit
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @throws( classOf[java.lang.Throwable] )
-
def
forUpdate(option: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- ForUpdateQuerySQLBuilder
-
def
forUpdate: (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- ForUpdateQuerySQLBuilder
- def ge[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
final
def
getClass(): Class[_]
- Definition Classes
- AnyRef → Any
- Annotations
- @native()
-
def
groupBy(columns: (QueryDSLFeature.this)#SQLSyntax*): (QueryDSLFeature.this)#GroupBySQLBuilder[A]
- Definition Classes
- GroupBySQLBuilder
- def gt[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
def
hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @native()
-
def
having(condition: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#GroupBySQLBuilder[A]
- Definition Classes
- GroupBySQLBuilder
- 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]
- 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]
- 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]
- 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]
- def in(column: (QueryDSLFeature.this)#SQLSyntax, subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def in[B](column: (QueryDSLFeature.this)#SQLSyntax, values: Seq[B])(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
def
intersect(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- IntersectQuerySQLBuilder
-
def
intersect(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- IntersectQuerySQLBuilder
-
def
intersectAll(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- IntersectQuerySQLBuilder
-
def
intersectAll(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- IntersectQuerySQLBuilder
-
final
def
isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- def isNotNull(column: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def isNull(column: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def le[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def like(column: (QueryDSLFeature.this)#SQLSyntax, value: String): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
def
limit(n: Int): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- PagingSQLBuilder
- def lt[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
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 }
- def ne[B](column: (QueryDSLFeature.this)#SQLSyntax, value: B)(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
final
def
ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def not: (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def notBetween[B, C](column: (QueryDSLFeature.this)#SQLSyntax, a: B, b: C)(implicit arg0: ParameterBinderFactory[B], arg1: ParameterBinderFactory[C]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def notExists(subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def notExists(subQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- 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]
- 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]
- 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]
- 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]
- def notIn(column: (QueryDSLFeature.this)#SQLSyntax, subQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def notIn[B](column: (QueryDSLFeature.this)#SQLSyntax, values: Seq[B])(implicit arg0: ParameterBinderFactory[B]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def notLike(column: (QueryDSLFeature.this)#SQLSyntax, value: String): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
final
def
notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
-
final
def
notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
-
def
offset(n: Int): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- PagingSQLBuilder
- def or(sqlPart: Option[(QueryDSLFeature.this)#SQLSyntax]): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
- def or: (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
def
orderBy(columns: (QueryDSLFeature.this)#SQLSyntax*): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- PagingSQLBuilder
- def roundBracket(inner: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#ConditionSQLBuilder[A]
-
final
def
synchronized[T0](arg0: ⇒ T0): T0
- Definition Classes
- AnyRef
-
def
toSQL: SQL[A, NoExtractor]
- Definition Classes
- SQLBuilder
-
def
toSQLSyntax: (QueryDSLFeature.this)#SQLSyntax
- Definition Classes
- SQLBuilder
-
def
toString(): String
- Definition Classes
- AnyRef → Any
-
def
union(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- UnionQuerySQLBuilder
-
def
union(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- UnionQuerySQLBuilder
-
def
unionAll(anotherQuery: (QueryDSLFeature.this)#SQLBuilder[_]): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- UnionQuerySQLBuilder
-
def
unionAll(anotherQuery: (QueryDSLFeature.this)#SQLSyntax): (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- UnionQuerySQLBuilder
-
final
def
wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
final
def
wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
final
def
wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @native() @throws( ... )
-
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)