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.  val ?: SQLSyntax
5.  def abs(column: SQLSyntax): SQLSyntax
6.  def and(andOpt: Option[SQLSyntax]): SQLSyntax
7.  def and(sqlPart: SQLSyntax): SQLSyntax
8.  def and: SQLSyntax
9.  final def asInstanceOf[T0]: T0

   Definition Classes

   Any

10.  val asc: SQLSyntax
11.  def avg(column: SQLSyntax): SQLSyntax
12.  def between[A, B](column: SQLSyntax, a: A, b: B)(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax
13.  def ceil(column: SQLSyntax): SQLSyntax
14.  def ceiling(column: SQLSyntax): SQLSyntax
15.  def clone(): AnyRef

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @native() @throws( ... )

16.  def count(asteriskProvider: AsteriskProvider): SQLSyntax
17.  def count(column: SQLSyntax): SQLSyntax
18.  val count: SQLSyntax
19.  def createUnsafely(value: String, parameters: Seq[Any] = Nil): SQLSyntax

    WARNING: Be aware of SQL injection vulnerability.

20.  def csv(parts: SQLSyntax*): SQLSyntax
21.  val currentDate: SQLSyntax
22.  val currentTimestamp: SQLSyntax
23.  val desc: SQLSyntax
24.  def distinct(columns: SQLSyntax*): SQLSyntax
25.  val dual: SQLSyntax
26.  val empty: SQLSyntax
27.  def eq[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
28.  final def eq(arg0: AnyRef): Boolean

    Definition Classes

    AnyRef

29.  def equals(arg0: Any): Boolean

    Definition Classes

    AnyRef → Any

30.  def exists(sqlPart: SQLSyntax): SQLSyntax
31.  def finalize(): Unit

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @throws( classOf[java.lang.Throwable] )

32.  def floor(column: SQLSyntax): SQLSyntax
33.  def ge[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
34.  final def getClass(): Class[_]

    Definition Classes

    AnyRef → Any

    Annotations

    @native()

35.  def groupBy(columns: SQLSyntax*): SQLSyntax
36.  def gt[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
37.  def hashCode(): Int

    Definition Classes

    AnyRef → Any

    Annotations

    @native()

38.  def having(condition: SQLSyntax): SQLSyntax
39.  def in(column: SQLSyntax, subQuery: SQLSyntax): SQLSyntax
40.  def in[A, B, C, D, E](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D, E)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C], arg3: ParameterBinderFactory[D], arg4: ParameterBinderFactory[E]): SQLSyntax
41.  def in[A, B, C, D](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C], arg3: ParameterBinderFactory[D]): SQLSyntax
42.  def in[A, B, C](columns: (SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C]): SQLSyntax
43.  def in[A, B](columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax
44.  def in[A](column: SQLSyntax, values: Seq[A])(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
45.  final def isInstanceOf[T0]: Boolean

    Definition Classes

    Any

46.  def isNotNull(column: SQLSyntax): SQLSyntax
47.  def isNull(column: SQLSyntax): SQLSyntax
48.  def join(parts: Seq[SQLSyntax], delimiter: SQLSyntax, spaceBeforeDelimiter: Boolean = true): SQLSyntax
49.  def joinWithAnd(parts: SQLSyntax*): SQLSyntax
50.  def joinWithOr(parts: SQLSyntax*): SQLSyntax
51.  def le[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
52.  def like(column: SQLSyntax, value: String): SQLSyntax
53.  def limit(n: Int): SQLSyntax
54.  def lower(column: SQLSyntax): SQLSyntax
55.  def lt[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
56.  def max(column: SQLSyntax): SQLSyntax
57.  def min(column: SQLSyntax): SQLSyntax
58.  def ne[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
59.  final def ne(arg0: AnyRef): Boolean

    Definition Classes

    AnyRef

60.  def notBetween[A, B](column: SQLSyntax, a: A, b: B)(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax
61.  def notExists(sqlPart: SQLSyntax): SQLSyntax
62.  def notIn(column: SQLSyntax, subQuery: SQLSyntax): SQLSyntax
63.  def notIn[A, B, C, D, E](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D, E)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C], arg3: ParameterBinderFactory[D], arg4: ParameterBinderFactory[E]): SQLSyntax
64.  def notIn[A, B, C, D](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C], arg3: ParameterBinderFactory[D]): SQLSyntax
65.  def notIn[A, B, C](columns: (SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C]): SQLSyntax
66.  def notIn[A, B](columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax
67.  def notIn[A](column: SQLSyntax, values: Seq[A])(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
68.  def notLike(column: SQLSyntax, value: String): SQLSyntax
69.  final def notify(): Unit

    Definition Classes

    AnyRef

    Annotations

    @native()

70.  final def notifyAll(): Unit

    Definition Classes

    AnyRef

    Annotations

    @native()

71.  def offset(n: Int): SQLSyntax
72.  def or(orOpt: Option[SQLSyntax]): SQLSyntax
73.  def or(sqlPart: SQLSyntax): SQLSyntax
74.  def or: SQLSyntax
75.  def orderBy(columns: SQLSyntax*): SQLSyntax
76.  def roundBracket(inner: SQLSyntax): SQLSyntax
77.  def sum(column: SQLSyntax): SQLSyntax
78.  final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes

    AnyRef

79.  def toAndConditionOpt(conditions: Option[SQLSyntax]*): Option[SQLSyntax]

    Returns an optional SQLSyntax which is flatten (from option array) and joined with 'and'.

    Returns an optional SQLSyntax which is flatten (from option array) and joined with 'and'.

    val (id, name) = (123, "Alice")
    val cond: Option[SQLSyntax] = SQLSyntax.toAndConditionOpt(Some(sqls"id = ${id}"), None, Some(sqls"name = ${name} or name is null"))
    cond.get.value // "id = ? and (name = ? or name is null)"
    cond.get.parameters // Seq(123, "Alice")

80.  def toOrConditionOpt(conditions: Option[SQLSyntax]*): Option[SQLSyntax]

    Returns an optional SQLSyntax which is flatten (from option array) and joined with 'or'.

    Returns an optional SQLSyntax which is flatten (from option array) and joined with 'or'.

    val (id, name) = (123, "Alice")
    val cond: Option[SQLSyntax] = SQLSyntax.toOrConditionOpt(Some(sqls"id = ${id}"), None, Some(sqls"name = ${name} or name is null"))
    cond.get.value // "id = ? or (name = ? or name is null)"
    cond.get.parameters // Seq(123, "Alice")

81.  def toString(): String

    Definition Classes

    AnyRef → Any

82.  def unapply(syntax: SQLSyntax): Option[(String, Seq[Any])]
83.  def upper(column: SQLSyntax): SQLSyntax
84.  final def wait(): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

85.  final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

86.  final def wait(arg0: Long): Unit

    Definition Classes

    AnyRef

    Annotations

    @native() @throws( ... )

87.  def where(whereOpt: Option[SQLSyntax]): SQLSyntax
88.  def where(where: SQLSyntax): SQLSyntax
89.  val where: SQLSyntax