ldbc-statement
0.3.0-beta9
API
Generated with
ldbc-statement/ldbc.statement/Where/Q

Q

ldbc.statement.Where.Q
case class Q[A, B](table: A, columns: Column[B], statement: String, params: List[Dynamic]) extends Where[A], Query[A, B], QueryProvider[A, B]

A model for constructing read-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.

B

Scala types to be converted by Decoder

Value parameters

columns

Union-type column list

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 QueryProvider[A, B]
trait Query[A, B]
trait SQL
trait Where[A]
class Object
trait Matchable
class Any
Show all

Members list

Type members

Types

override type Self = Q[A, B]

Attributes

Source
Where.scala

Value members

Concrete methods

override def ++(sql: SQL): SQL

Attributes

Definition Classes
SQL
Source
Where.scala
def groupBy[C](func: A => Column[C]): GroupBy[A, B]

A method for setting the GROUP BY condition in a SELECT statement.

A method for setting the GROUP BY condition in a SELECT statement.

Type parameters

C

Scala types to be converted by Decoder

Value parameters

func

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

Attributes

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]) ?=> Q[A, B]

A method for setting the LIMIT condition in a SELECT statement.

A method for setting the LIMIT condition in a SELECT statement.

 TableQuery[City]
   .select(_.population)
   .limit(10)

Value parameters

length

The number of rows to return.

Attributes

Inherited from:
QueryProvider
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
def orderBy[C](func: A => Order[C]): OrderBy[A, B]

A method for setting the ORDER BY condition in a statement.

A method for setting the ORDER BY condition in a statement.

TableQuery[City]
  .select(_.population)
  .orderBy(_.population.desc)

Value parameters

func

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

Attributes

Inherited from:
Provider (hidden)
Source
OrderBy.scala
def productElementNames: Iterator[String]

Attributes

Inherited from:
Product
def productIterator: Iterator[Any]

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
Generated with