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

Where

ldbc.statement.Where
See theWhere companion object
sealed transparent trait Where[A]

Trait for building Statements to be WHERE.

Type parameters

A

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

Attributes

Companion
object
Source
Where.scala
Graph
Supertypes
class Object
trait Matchable
class Any
Known subtypes
class C[A]
class Q[A, B]
Self type

Members list

Type members

Types

type Self

Attributes

Source
Where.scala

Value members

Abstract methods

def table: A

Trait for generating SQL table information.

Trait for generating SQL table information.

Attributes

Source
Where.scala

Concrete methods

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

Attributes

Source
Where.scala
def &&(func: A => Expression, bool: Boolean): Self

Attributes

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

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

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

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

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

Source
Where.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

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

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

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

Source
Where.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

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

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

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

Attributes

Source
Where.scala
def ||(func: A => Expression, bool: Boolean): Self

Attributes

Source
Where.scala
Generated with