ldbc-statement
0.3.0-RC1
API
Generated with
ldbc-statement/ldbc.statement/Select

Select

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

A model for constructing SELECT 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
Select.scala
Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait QueryProvider[A, B]
trait Query[A, B]
trait SQL
class Object
trait Matchable
class Any
Show all

Members list

Value members

Concrete methods

override def ++(sql: SQL): SQL

Attributes

Definition Classes
SQL
Source
Select.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.

 TableQuery[City]
   .select(_.name)
   .groupBy(_.name)

Value parameters

func

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

Attributes

Source
Select.scala
def where(func: A => Expression): Q[A, B]

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

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

 TableQuery[City]
   .select(_.name)
   .where(_.name === "Tokyo")

Value parameters

func

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

Attributes

Source
Select.scala
def whereOpt(func: A => Option[Expression]): Q[A, B]

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

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

 val opt: Option[String] = ???
 TableQuery[City]
   .select(_.name)
   .whereOpt(city => opt.map(value => city.name === value))

Value parameters

func

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

Attributes

Source
Select.scala
def whereOpt[C](opt: Option[C])(func: (A, C) => Expression): Q[A, B]

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

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

 TableQuery[City]
   .select(_.name)
   .whereOpt(Some("Tokyo"))((city, value) => city.name === value)

Value parameters

func

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

Attributes

Source
Select.scala

Inherited methods

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 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 query: Query[B]

A method to convert a query to a ldbc.dsl.Query.

A method to convert a query to a ldbc.dsl.Query.

 TableQuery[User].select(v => v.name *: v.age).query

Attributes

Returns

A ldbc.dsl.Query instance

Inherited from:
Query
Source
Query.scala
def queryTo[P <: Product](using m1: ProductOf[P], m2: ProductOf[B], check: m1.MirroredElemTypes =:= m2.MirroredElemTypes, decoder: Decoder[P]): Query[P]

A method to convert a query to a ldbc.dsl.Query.

A method to convert a query to a ldbc.dsl.Query.

 TableQuery[User].selectAll.queryTo[User]

Attributes

Returns

A ldbc.dsl.Query instance

Inherited from:
Query
Source
Query.scala
Generated with