ldbc-statement
0.3.0
API
Generated with
ldbc-statement/ldbc.statement/Where/C

C

ldbc.statement.Where.C
case class C[A](table: A, statement: String, params: List[Dynamic], isFirst: Boolean) 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

isFirst

If True, this condition is added first, so the specified join condition is ignored and a WHERE statement is started.

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, bool: Boolean): Self

Attributes

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

Attributes

Inherited from:
Where
Source
Where.scala
def and(func: A => Expression, bool: Boolean): 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", false)
 // SELECT name FROM city WHERE population > ?

Value parameters

bool

Determine whether to add to the conditions. If false, the AND condition is not added to the query.

func

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

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")
 // SELECT name FROM city WHERE population > ? AND name = ?

Value parameters

func

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

Attributes

Inherited from:
Where
Source
Where.scala
def andOpt[B](opt: Option[B])(func: (A, B) => 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)
   .andOpt(Some("Tokyo"))((city, value) => city.name == value)
 // SELECT name FROM city WHERE population > ? AND name = ?

Value parameters

func

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

Attributes

Inherited from:
Where
Source
Where.scala
def andOpt(func: A => Option[Expression]): Self

Function to set additional conditions on WHERE statement.

Function to set additional conditions on WHERE statement.

 val opt: Option[String] = ???
 TableQuery[City]
   .select(_.name)
   .where(_.population > 1000000)
   .andOpt((city => opt.map(value => city.name === value))
 // SELECT name FROM city WHERE population > ? AND name = ?

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, bool: Boolean): 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", false)
 // SELECT name FROM city WHERE population > ?

Value parameters

bool

Determine whether to add to the conditions. If false, the OR condition is not added to the query.

func

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

Attributes

Inherited from:
Where
Source
Where.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")
 // SELECT name FROM city WHERE population > ? OR name = ?

Value parameters

func

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

Attributes

Inherited from:
Where
Source
Where.scala
def orOpt[B](opt: Option[B])(func: (A, B) => 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)
   .orOpt(Some("Tokyo"))((city, value) => city.name == value)
 // SELECT name FROM city WHERE population > ? OR name = ?

Value parameters

func

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

Attributes

Inherited from:
Where
Source
Where.scala
def orOpt(func: A => Option[Expression]): Self

Function to set additional conditions on WHERE statement.

Function to set additional conditions on WHERE statement.

 val opt: Option[String] = ???
 TableQuery[City]
   .select(_.name)
   .where(_.population > 1000000)
   .orOpt((city => opt.map(value => city.name === value))
 // SELECT name FROM city WHERE population > ? OR name = ?

Value parameters

func

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

Attributes

Inherited from:
Where
Source
Where.scala
def productElementNames: Iterator[String]

Attributes

Inherited from:
Product
def productIterator: Iterator[Any]

Attributes

Inherited from:
Product
def returning[T <: String | Int | Long](using decoder: Decoder[T]): DBIO[T]

A method to execute an insert operation against the MySQL server.

A method to execute an insert operation against the MySQL server.

 TableQuery[User]
   .insertInto(user => user.name *: user.age)
   .values(("Alice", 20))
   .returning[Long]

Type parameters

T

The type of the primary key

Attributes

Returns

The primary key value

Inherited from:
Command
Source
Command.scala
def update: DBIO[Int]

A method to execute an update operation against the MySQL server.

A method to execute an update operation against the MySQL server.

 TableQuery[User]
   .update(user => user.id *: user.name *: user.age)((1L, "Alice", 20))
   .where(_.id === 1L)
   .update

Attributes

Returns

The number of rows updated

Inherited from:
Command
Source
Command.scala
def xor(func: A => Expression, bool: Boolean): 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", false)
 // SELECT name FROM city WHERE population > ?

Value parameters

bool

Determine whether to add to the conditions. If false, the XOR condition is not added to the query.

func

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

Attributes

Inherited from:
Where
Source
Where.scala
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")
 // SELECT name FROM city WHERE population > ? XOR name = ?

Value parameters

func

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

Attributes

Inherited from:
Where
Source
Where.scala
def xorOpt[B](opt: Option[B])(func: (A, B) => 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)
   .xorOpt(Some("Tokyo"))((city, value) => city.name == value)
 // SELECT name FROM city WHERE population > ? XOR name = ?

Value parameters

func

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

Attributes

Inherited from:
Where
Source
Where.scala
def xorOpt(func: A => Option[Expression]): Self

Function to set additional conditions on WHERE statement.

Function to set additional conditions on WHERE statement.

 val opt: Option[String] = ???
 TableQuery[City]
   .select(_.name)
   .where(_.population > 1000000)
   .xorOpt((city => opt.map(value => city.name === value))
 // SELECT name FROM city WHERE population > ? XOR name = ?

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, bool: Boolean): Self

Attributes

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

Attributes

Inherited from:
Where
Source
Where.scala
Generated with