object SQLSyntax
- Companion
- class
class Object
trait Matchable
class Any
Value members
Concrete methods
def between[A, B](column: SQLSyntax, a: A, b: B)(implicit evidence$7: ParameterBinderFactory[A], evidence$8: ParameterBinderFactory[B]): SQLSyntax
def in[A](column: SQLSyntax, values: Seq[A])(implicit evidence$11: ParameterBinderFactory[A]): SQLSyntax
def in[A, B](columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B)])(implicit evidence$13: ParameterBinderFactory[A], evidence$14: ParameterBinderFactory[B]): SQLSyntax
def in[A, B, C](columns: (SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C)])(implicit evidence$17: ParameterBinderFactory[A], evidence$18: ParameterBinderFactory[B], evidence$19: ParameterBinderFactory[C]): SQLSyntax
def in[A, B, C, D](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D)])(implicit evidence$23: ParameterBinderFactory[A], evidence$24: ParameterBinderFactory[B], evidence$25: ParameterBinderFactory[C], evidence$26: ParameterBinderFactory[D]): SQLSyntax
def in[A, B, C, D, E](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D, E)])(implicit evidence$31: ParameterBinderFactory[A], evidence$32: ParameterBinderFactory[B], evidence$33: ParameterBinderFactory[C], evidence$34: ParameterBinderFactory[D], evidence$35: ParameterBinderFactory[E]): SQLSyntax
def notBetween[A, B](column: SQLSyntax, a: A, b: B)(implicit evidence$9: ParameterBinderFactory[A], evidence$10: ParameterBinderFactory[B]): SQLSyntax
def notIn[A](column: SQLSyntax, values: Seq[A])(implicit evidence$12: ParameterBinderFactory[A]): SQLSyntax
def notIn[A, B](columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B)])(implicit evidence$15: ParameterBinderFactory[A], evidence$16: ParameterBinderFactory[B]): SQLSyntax
def notIn[A, B, C](columns: (SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C)])(implicit evidence$20: ParameterBinderFactory[A], evidence$21: ParameterBinderFactory[B], evidence$22: ParameterBinderFactory[C]): SQLSyntax
def notIn[A, B, C, D](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D)])(implicit evidence$27: ParameterBinderFactory[A], evidence$28: ParameterBinderFactory[B], evidence$29: ParameterBinderFactory[C], evidence$30: ParameterBinderFactory[D]): SQLSyntax
def notIn[A, B, C, D, E](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D, E)])(implicit evidence$36: ParameterBinderFactory[A], evidence$37: ParameterBinderFactory[B], evidence$38: ParameterBinderFactory[C], evidence$39: ParameterBinderFactory[D], evidence$40: ParameterBinderFactory[E]): 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")
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")