C

ldbc.statement.Where.C
case class C[A](table: A, statement: String, params: List[Dynamic]) extends Where[A], Command, CommandProvider

A model for constructing write-only query WHERE statements in MySQL.

Type parameters

A

The type of Table. in the case of Join, it is a Tuple of type Table.

Value parameters

params

A list of Traits that generate values from Parameter, allowing PreparedStatement to be set to a value by index only.

statement

SQL statement string

table

Trait for generating SQL table information.

Attributes

Source
Where.scala
Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Command
trait SQL
trait Where[A]
class Object
trait Matchable
class Any
Show all

Members list

Type members

Types

override type Self = C[A]

Attributes

Source
Where.scala

Value members

Concrete methods

override def ++(sql: SQL): SQL

Attributes

Definition Classes
SQL
Source
Where.scala

Inherited methods

def &&(func: A => Expression): Self

Attributes

Inherited from:
Where
Source
Where.scala
def and(func: A => Expression): Self

Function to set additional conditions on WHERE statement.

Function to set additional conditions on WHERE statement.

 TableQuery[City]
   .select(_.name)
   .where(_.population > 1000000)
   .and(_.name == "Tokyo")

Value parameters

func

Function to construct an expression using the columns that Table has.

Attributes

Inherited from:
Where
Source
Where.scala
def limit(length: Long): (Encoder[Long]) ?=> C

A method for setting the LIMIT condition in a UPDATE/DELETE statement.

A method for setting the LIMIT condition in a UPDATE/DELETE statement.

 TableQuery[City]
   .delete
   .limit(10)

Value parameters

length

The number of rows to return.

Attributes

Inherited from:
CommandProvider
Source
Limit.scala
def or(func: A => Expression): Self

Function to set additional conditions on WHERE statement.

Function to set additional conditions on WHERE statement.

 TableQuery[City]
   .select(_.name)
   .where(_.population > 1000000)
   .or(_.name == "Tokyo")

Value parameters

func

Function to construct an expression using the columns that Table has.

Attributes

Inherited from:
Where
Source
Where.scala

Attributes

Inherited from:
Product

Attributes

Inherited from:
Product
def xor(func: A => Expression): Self

Function to set additional conditions on WHERE statement.

Function to set additional conditions on WHERE statement.

 TableQuery[City]
   .select(_.name)
   .where(_.population > 1000000)
   .xor(_.name == "Tokyo")

Value parameters

func

Function to construct an expression using the columns that Table has.

Attributes

Inherited from:
Where
Source
Where.scala
def ||(func: A => Expression): Self

Attributes

Inherited from:
Where
Source
Where.scala