ldbc.query.builder

Top-level imports provide aliases for the most commonly used types and modules. A typical starting set of imports might look something like this.

example:

 import ldbc.query.builder.*

Attributes

Members list

Type members

Classlikes

case class Column(name: String) extends StaticAnnotation

Attributes

Source
Column.scala
Supertypes
trait Serializable
trait Product
trait Equals
class Annotation
class Object
trait Matchable
class Any
Show all
trait SharedTable extends Dynamic

Attributes

Source
Table.scala
Supertypes
trait Dynamic
class Object
trait Matchable
class Any
Known subtypes
trait Table[P]
trait Opt[P]
trait Table[P] extends SharedTable, AbstractTable[P]

Attributes

Companion
object
Source
Table.scala
Supertypes
trait AbstractTable[P]
trait SharedTable
trait Dynamic
class Object
trait Matchable
class Any
Show all
object Table

Attributes

Companion
trait
Source
Table.scala
Supertypes
class Object
trait Matchable
class Any
Self type
Table.type
object TableQuery

Attributes

Source
TableQuery.scala
Supertypes
class Object
trait Matchable
class Any
Self type
TableQuery.type
case class TableQueryImpl[A <: SharedTable & AbstractTable[_], B <: Product](table: A, column: Column[Extract[A]], name: String, params: List[Dynamic]) extends TableQuery[A, Opt[Extract[A]]]

Attributes

Source
TableQuery.scala
Supertypes
trait Serializable
trait Product
trait Equals
trait TableQuery[A, Opt[Extract[A]]]
class Object
trait Matchable
class Any
Show all
case class TableQueryOpt[A, O <: SharedTable](table: O, column: Column[Extract[O]], name: String, params: List[Dynamic]) extends TableQuery[O, A]

Attributes

Source
TableQuery.scala
Supertypes
trait Serializable
trait Product
trait Equals
trait TableQuery[O, A]
class Object
trait Matchable
class Any
Show all

Types

type TableQuery[T] = TableQuery[Table[T], Opt[T]]

Attributes

Source
package.scala

Value members

Inherited methods

def and(s1: SQL, s2: SQL, ss: SQL*): Mysql

Returns (s1 AND s2 AND ... sn).

Returns (s1 AND s2 AND ... sn).

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def and[M[_] : Reducible](ss: M[SQL], grouping: Boolean): Mysql

Returns (s1 AND s2 AND ... sn) for a non-empty collection.

Returns (s1 AND s2 AND ... sn) for a non-empty collection.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def andFallbackTrue[M[_] : Foldable](ss: M[SQL]): Mysql

Similar to andOpt, but defaults to TRUE if passed an empty collection

Similar to andOpt, but defaults to TRUE if passed an empty collection

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala

Returns (s1 AND s2 AND ... sn) for all defined sql, returning Empty SQL if there are no defined sql

Returns (s1 AND s2 AND ... sn) for all defined sql, returning Empty SQL if there are no defined sql

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala

Returns (s1 AND s2 AND ... sn) for a non-empty collection.

Returns (s1 AND s2 AND ... sn) for a non-empty collection.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def comma[M[_] : Reducible](ss: M[SQL]): Mysql

Returns s1, s2, ... sn.

Returns s1, s2, ... sn.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def comma(s1: SQL, s2: SQL, ss: SQL*): Mysql

Returns s1, s2, ... sn.

Returns s1, s2, ... sn.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def in[M[_] : Functor, T](s: SQL, vs: M[T])(implicit evidence$1: Reducible[M], evidence$2: Functor[M], Encoder[T]): Mysql

Returns (sql IN (s0, s1, ...)).

Returns (sql IN (s0, s1, ...)).

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def in[T](s: SQL, v0: T, v1: T, vs: T*)(using Encoder[T]): Mysql

Returns (sql IN (v0, v1, ...)).

Returns (sql IN (v0, v1, ...)).

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def inOpt[M[_] : Foldable, T](s: SQL, vs: M[T])(implicit evidence$1: Foldable[M], Encoder[T]): Option[Mysql]

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def notIn[M[_] : Functor, T](s: SQL, vs: M[T])(implicit evidence$1: Reducible[M], evidence$2: Functor[M], Encoder[T]): Mysql

Returns (sql NOT IN (v0, v1, ...)), or true for empty fs.

Returns (sql NOT IN (v0, v1, ...)), or true for empty fs.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def notIn[T](s: SQL, v0: T, v1: T, vs: T*)(using Encoder[T]): Mysql

Returns (sql NOT IN (v0, v1, ...)).

Returns (sql NOT IN (v0, v1, ...)).

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def notInOpt[M[_] : Foldable, T](s: SQL, vs: M[T])(implicit evidence$1: Foldable[M], Encoder[T]): Option[Mysql]

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def or(s1: SQL, s2: SQL, ss: SQL*): SQL

Returns (s1 OR s2 OR ... sn).

Returns (s1 OR s2 OR ... sn).

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def or[M[_] : Reducible](ss: M[SQL], grouping: Boolean): Mysql

Returns (s1 OR s2 OR ... sn) for a non-empty collection.

Returns (s1 OR s2 OR ... sn) for a non-empty collection.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def orFallbackFalse[M[_] : Foldable](ss: M[SQL]): Mysql

Similar to orOpt, but defaults to FALSE if passed an empty collection

Similar to orOpt, but defaults to FALSE if passed an empty collection

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala

Returns (s1 OR s2 OR ... sn) for all defined sql, returning Empty SQL if there are no defined sql

Returns (s1 OR s2 OR ... sn) for all defined sql, returning Empty SQL if there are no defined sql

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala

Returns (s1 OR s2 OR ... sn) for all defined sql, returning Empty SQL if there are no defined sql

Returns (s1 OR s2 OR ... sn) for all defined sql, returning Empty SQL if there are no defined sql

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def orderBy[M[_] : Reducible](ss: M[SQL]): Mysql

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def orderBy(s1: SQL, ss: SQL*): SQL

Returns ORDER BY s1, s2, ... sn.

Returns ORDER BY s1, s2, ... sn.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala

Returns ORDER BY s1, s2, ... sn for defined s, if any, otherwise the empty sql.

Returns ORDER BY s1, s2, ... sn for defined s, if any, otherwise the empty sql.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def orderByOpt[M[_] : Foldable](ss: M[SQL]): Mysql

Returns ORDER BY s1, s2, ... sn or the empty sql if ss is empty.

Returns ORDER BY s1, s2, ... sn or the empty sql if ss is empty.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala

Returns (sql).

Returns (sql).

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala

Function for setting parameters to be used as static strings.

Function for setting parameters to be used as static strings.

 val table = sc("table")
 sql"SELECT * FROM $table WHERE id = ${1L}"
 // SELECT * FROM table WHERE id = ?

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def set[M[_] : Reducible](fs: M[SQL]): Mysql

Returns SET s1, s2, ... sn.

Returns SET s1, s2, ... sn.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def set(s1: SQL, ss: SQL*): Mysql

Returns SET s1, s2, ... sn.

Returns SET s1, s2, ... sn.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def values[M[_] : Reducible, T](vs: M[T])(implicit evidence$1: Reducible[M], Encoder[T]): Mysql

Returns VALUES (v0, v1), (v2, v3), ....

Returns VALUES (v0, v1), (v2, v3), ....

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def whereAnd[M[_] : Reducible](ss: M[SQL]): Mysql

Returns WHERE s1 AND s2 AND ... sn or the empty sql if ss is empty.

Returns WHERE s1 AND s2 AND ... sn or the empty sql if ss is empty.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def whereAnd(s1: SQL, ss: SQL*): Mysql

Returns WHERE s1 AND s2 AND ... sn.

Returns WHERE s1 AND s2 AND ... sn.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def whereAndOpt[M[_] : Foldable](ss: M[SQL]): Mysql

Returns WHERE s1 AND s2 AND ... sn if collection is not empty. If collection is empty returns an empty sql.

Returns WHERE s1 AND s2 AND ... sn if collection is not empty. If collection is empty returns an empty sql.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala

Returns WHERE s1 AND s2 AND ... sn for defined s, if any, otherwise the empty sql.

Returns WHERE s1 AND s2 AND ... sn for defined s, if any, otherwise the empty sql.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def whereOr[M[_] : Reducible](ss: M[SQL]): Mysql

Returns WHERE s1 OR s2 OR ... sn or the empty sql if ss is empty.

Returns WHERE s1 OR s2 OR ... sn or the empty sql if ss is empty.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def whereOr(s1: SQL, ss: SQL*): Mysql

Returns WHERE s1 OR s2 OR ... sn.

Returns WHERE s1 OR s2 OR ... sn.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala
def whereOrOpt[M[_] : Foldable](ss: M[SQL]): Mysql

Returns WHERE s1 OR s2 OR ... sn if collection is not empty. If collection is empty returns an empty sql.

Returns WHERE s1 OR s2 OR ... sn if collection is not empty. If collection is empty returns an empty sql.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala

Returns WHERE s1 OR s2 OR ... sn for defined s, if any, otherwise the empty sql.

Returns WHERE s1 OR s2 OR ... sn for defined s, if any, otherwise the empty sql.

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala

Extensions

Inherited extensions

extension (sc: StringContext)
def p(args: Dynamic*): Mysql

Attributes

Inherited from:
StringContextSyntax
Source
StringContextSyntax.scala

Attributes

Inherited from:
StringContextSyntax
Source
StringContextSyntax.scala

Implicits

Inherited implicits

implicit def toDBIO[A](dbio: DBIO[A]): Ops[A]

Attributes

Inherited from:
HelperFunctionsSyntax
Source
HelperFunctionsSyntax.scala