object SQLSyntax
- Source
- SQLSyntax.scala
Linear Supertypes
Ordering
- Alphabetic
- By Inheritance
Inherited
- SQLSyntax
- AnyRef
- Any
- Hide All
- Show All
Visibility
- Public
- All
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
- val ?: SQLSyntax
- def abs(column: SQLSyntax): SQLSyntax
- def and(andOpt: Option[SQLSyntax]): SQLSyntax
- def and(sqlPart: SQLSyntax): SQLSyntax
- def and: SQLSyntax
-
final
def
asInstanceOf[T0]: T0
- Definition Classes
- Any
- val asc: SQLSyntax
- def avg(column: SQLSyntax): SQLSyntax
- def between[A, B](column: SQLSyntax, a: A, b: B)(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax
- def ceil(column: SQLSyntax): SQLSyntax
- def ceiling(column: SQLSyntax): SQLSyntax
-
def
clone(): AnyRef
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @native() @throws( ... )
- def count(asteriskProvider: AsteriskProvider): SQLSyntax
- def count(column: SQLSyntax): SQLSyntax
- val count: SQLSyntax
-
def
createUnsafely(value: String, parameters: Seq[Any] = Nil): SQLSyntax
WARNING: Be aware of SQL injection vulnerability.
- def csv(parts: SQLSyntax*): SQLSyntax
- val currentDate: SQLSyntax
- val currentTimestamp: SQLSyntax
- val desc: SQLSyntax
- def distinct(columns: SQLSyntax*): SQLSyntax
- val dual: SQLSyntax
- val empty: SQLSyntax
- def eq[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
-
final
def
eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
def
equals(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- def exists(sqlPart: SQLSyntax): SQLSyntax
-
def
finalize(): Unit
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @throws( classOf[java.lang.Throwable] )
- def floor(column: SQLSyntax): SQLSyntax
- def ge[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
-
final
def
getClass(): Class[_]
- Definition Classes
- AnyRef → Any
- Annotations
- @native()
- def groupBy(columns: SQLSyntax*): SQLSyntax
- def gt[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
-
def
hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @native()
- def having(condition: SQLSyntax): SQLSyntax
- def in(column: SQLSyntax, subQuery: SQLSyntax): SQLSyntax
- 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
- 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
- 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
- def in[A, B](columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax
- def in[A](column: SQLSyntax, values: Seq[A])(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
-
final
def
isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- def isNotNull(column: SQLSyntax): SQLSyntax
- def isNull(column: SQLSyntax): SQLSyntax
- def join(parts: Seq[SQLSyntax], delimiter: SQLSyntax, spaceBeforeDelimiter: Boolean = true): SQLSyntax
- def joinWithAnd(parts: SQLSyntax*): SQLSyntax
- def joinWithOr(parts: SQLSyntax*): SQLSyntax
- def le[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
- def like(column: SQLSyntax, value: String): SQLSyntax
- def limit(n: Int): SQLSyntax
- def lower(column: SQLSyntax): SQLSyntax
- def lt[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
- def max(column: SQLSyntax): SQLSyntax
- def min(column: SQLSyntax): SQLSyntax
- def ne[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
-
final
def
ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def notBetween[A, B](column: SQLSyntax, a: A, b: B)(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax
- def notExists(sqlPart: SQLSyntax): SQLSyntax
- def notIn(column: SQLSyntax, subQuery: SQLSyntax): SQLSyntax
- 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
- 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
- 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
- def notIn[A, B](columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax
- def notIn[A](column: SQLSyntax, values: Seq[A])(implicit arg0: ParameterBinderFactory[A]): SQLSyntax
- def notLike(column: SQLSyntax, value: String): SQLSyntax
-
final
def
notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
-
final
def
notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
- def offset(n: Int): SQLSyntax
- def or(orOpt: Option[SQLSyntax]): SQLSyntax
- def or(sqlPart: SQLSyntax): SQLSyntax
- def or: SQLSyntax
- def orderBy(columns: SQLSyntax*): SQLSyntax
- def roundBracket(inner: SQLSyntax): SQLSyntax
- def sum(column: SQLSyntax): SQLSyntax
-
final
def
synchronized[T0](arg0: ⇒ T0): T0
- Definition Classes
- AnyRef
-
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")
-
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")
-
def
toString(): String
- Definition Classes
- AnyRef → Any
- def unapply(syntax: SQLSyntax): Option[(String, Seq[Any])]
- def upper(column: SQLSyntax): SQLSyntax
-
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 where(whereOpt: Option[SQLSyntax]): SQLSyntax
- def where(where: SQLSyntax): SQLSyntax
- val where: SQLSyntax