scalikejdbc-core
API
Generated with
scalikejdbc-core/scalikejdbc/scalikejdbc.interpolation/SQLSyntax

SQLSyntax

scalikejdbc.interpolation.SQLSyntax
See theSQLSyntax companion class
object SQLSyntax

Attributes

Companion
class
Source
SQLSyntax.scala
Graph
Supertypes
class Object
trait Matchable
class Any
Self type
SQLSyntax.type

Members list

Value members

Concrete methods

def abs(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def and: SQLSyntax

Attributes

Source
SQLSyntax.scala
def and(sqlPart: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def and(andOpt: Option[SQLSyntax]): SQLSyntax

Attributes

Source
SQLSyntax.scala
def avg(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def between[A : ParameterBinderFactory, B : ParameterBinderFactory](column: SQLSyntax, a: A, b: B): SQLSyntax

Attributes

Source
SQLSyntax.scala
def ceil(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def ceiling(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def count(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def count(asteriskProvider: AsteriskProvider): SQLSyntax

Attributes

Source
SQLSyntax.scala
def createUnsafely(value: String, parameters: Seq[Any]): SQLSyntax

WARNING: Be aware of SQL injection vulnerability.

WARNING: Be aware of SQL injection vulnerability.

Attributes

Source
SQLSyntax.scala
def csv(parts: SQLSyntax*): SQLSyntax

Attributes

Source
SQLSyntax.scala
def distinct(columns: SQLSyntax*): SQLSyntax

Attributes

Source
SQLSyntax.scala
def eq[A : ParameterBinderFactory](column: SQLSyntax, value: A): SQLSyntax

Attributes

Source
SQLSyntax.scala
def exists(sqlPart: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def floor(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def ge[A : ParameterBinderFactory](column: SQLSyntax, value: A): SQLSyntax

Attributes

Source
SQLSyntax.scala
def groupBy(columns: SQLSyntax*): SQLSyntax

Attributes

Source
SQLSyntax.scala
def gt[A : ParameterBinderFactory](column: SQLSyntax, value: A): SQLSyntax

Attributes

Source
SQLSyntax.scala
def having(condition: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def in[A : ParameterBinderFactory](column: SQLSyntax, values: Seq[A]): SQLSyntax

Attributes

Source
SQLSyntax.scala
def in[A : ParameterBinderFactory, B : ParameterBinderFactory](columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B)]): SQLSyntax

Attributes

Source
SQLSyntax.scala
def in[A : ParameterBinderFactory, B : ParameterBinderFactory, C : ParameterBinderFactory](columns: (SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C)]): SQLSyntax

Attributes

Source
SQLSyntax.scala
def in[A : ParameterBinderFactory, B : ParameterBinderFactory, C : ParameterBinderFactory, D : ParameterBinderFactory](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D)]): SQLSyntax

Attributes

Source
SQLSyntax.scala
def in(column: SQLSyntax, subQuery: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def isNotNull(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def isNull(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def join(parts: Seq[SQLSyntax], delimiter: SQLSyntax, spaceBeforeDelimiter: Boolean): SQLSyntax

Attributes

Source
SQLSyntax.scala
def joinWithAnd(parts: SQLSyntax*): SQLSyntax

Attributes

Source
SQLSyntax.scala
def joinWithOr(parts: SQLSyntax*): SQLSyntax

Attributes

Source
SQLSyntax.scala
def le[A : ParameterBinderFactory](column: SQLSyntax, value: A): SQLSyntax

Attributes

Source
SQLSyntax.scala
def like(column: SQLSyntax, value: String): SQLSyntax

Attributes

Source
SQLSyntax.scala
def limit(n: Int): SQLSyntax

Attributes

Source
SQLSyntax.scala
def lower(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def lt[A : ParameterBinderFactory](column: SQLSyntax, value: A): SQLSyntax

Attributes

Source
SQLSyntax.scala
def max(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def min(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def ne[A : ParameterBinderFactory](column: SQLSyntax, value: A): SQLSyntax

Attributes

Source
SQLSyntax.scala
def notBetween[A : ParameterBinderFactory, B : ParameterBinderFactory](column: SQLSyntax, a: A, b: B): SQLSyntax

Attributes

Source
SQLSyntax.scala
def notExists(sqlPart: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def notIn[A : ParameterBinderFactory](column: SQLSyntax, values: Seq[A]): SQLSyntax

Attributes

Source
SQLSyntax.scala
def notIn[A : ParameterBinderFactory, B : ParameterBinderFactory](columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B)]): SQLSyntax

Attributes

Source
SQLSyntax.scala
def notIn[A : ParameterBinderFactory, B : ParameterBinderFactory, C : ParameterBinderFactory](columns: (SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C)]): SQLSyntax

Attributes

Source
SQLSyntax.scala
def notIn(column: SQLSyntax, subQuery: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def notLike(column: SQLSyntax, value: String): SQLSyntax

Attributes

Source
SQLSyntax.scala
def offset(n: Int): SQLSyntax

Attributes

Source
SQLSyntax.scala
def or: SQLSyntax

Attributes

Source
SQLSyntax.scala
def or(sqlPart: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def or(orOpt: Option[SQLSyntax]): SQLSyntax

Attributes

Source
SQLSyntax.scala
def orderBy(columns: SQLSyntax*): SQLSyntax

Attributes

Source
SQLSyntax.scala
def roundBracket(inner: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def sum(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
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")

Attributes

Source
SQLSyntax.scala
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")

Attributes

Source
SQLSyntax.scala
def unapply(syntax: SQLSyntax): Some[(String, Seq[Any])]

Attributes

Source
SQLSyntax.scala
def upper(column: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def where(where: SQLSyntax): SQLSyntax

Attributes

Source
SQLSyntax.scala
def where(whereOpt: Option[SQLSyntax]): SQLSyntax

Attributes

Source
SQLSyntax.scala

Concrete fields

val ?: SQLSyntax

Attributes

Source
SQLSyntax.scala
val asc: SQLSyntax

Attributes

Source
SQLSyntax.scala
val count: SQLSyntax

Attributes

Source
SQLSyntax.scala
val currentDate: SQLSyntax

Attributes

Source
SQLSyntax.scala
val currentTimestamp: SQLSyntax

Attributes

Source
SQLSyntax.scala
val desc: SQLSyntax

Attributes

Source
SQLSyntax.scala
val dual: SQLSyntax

Attributes

Source
SQLSyntax.scala
val empty: SQLSyntax

Attributes

Source
SQLSyntax.scala
val where: SQLSyntax

Attributes

Source
SQLSyntax.scala
Generated with