ldbc-statement
0.3.0-beta10
API
Generated with
ldbc-statement/ldbc.statement/Column/Pure

Pure

ldbc.statement.Column.Pure
case class Pure[A](value: A) extends Column[A]

Attributes

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

Members list

Value members

Concrete methods

override def alias: Option[String]

Column alias name

Column alias name

Attributes

Definition Classes
Source
Column.scala
override def as(name: String): Column[A]

Functions for setting aliases on columns

Functions for setting aliases on columns

Attributes

Definition Classes
Source
Column.scala
override def decoder: Decoder[A]

Function to get a value of type T from a ResultSet

Function to get a value of type T from a ResultSet

Attributes

Definition Classes
Source
Column.scala
override def duplicateKeyUpdateStatement: String

Used in Update statement Column = VALUES(Column), Column = VALUES(Column) used in the Duplicate Key Update statement

Used in Update statement Column = VALUES(Column), Column = VALUES(Column) used in the Duplicate Key Update statement

Attributes

Definition Classes
Source
Column.scala
override def encoder: Encoder[A]

Function to set a value of type T to a PreparedStatement

Function to set a value of type T to a PreparedStatement

Attributes

Definition Classes
Source
Column.scala
override def insertStatement: String

Used in Insert statement (Column, Column) VALUES (?,?) used in the Insert statement

Used in Insert statement (Column, Column) VALUES (?,?) used in the Insert statement

Attributes

Definition Classes
Source
Column.scala
override def name: String

Column Field Name

Column Field Name

Attributes

Definition Classes
Source
Column.scala
override def updateStatement: String

Used in Update statement Column = ?, Column = ? used in the Update statement

Used in Update statement Column = ?, Column = ? used in the Update statement

Attributes

Definition Classes
Source
Column.scala
override def values: Int

Indicator of how many columns are specified

Indicator of how many columns are specified

Attributes

Definition Classes
Source
Column.scala

Inherited methods

def !==(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def !==(value: Extract[A])(using Encoder[Extract[A]]): NotEqual[A]

A function that sets a WHERE condition to check whether the values are not equal in a SELECT statement.

A function that sets a WHERE condition to check whether the values are not equal in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id !== 1L)
 // SELECT name, age FROM user WHERE id != ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check whether the values are not equal in a Where statement

Inherited from:
Column
Source
Column.scala
def %(cond: Extract[A], result: Extract[A])(using Encoder[Extract[A]]): Mod[A]

A function to set the WHERE condition for modulo operations in a SELECT statement.

A function to set the WHERE condition for modulo operations in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id %(1L, 2L))
 // SELECT name, age FROM user WHERE id % ? = ?

Value parameters

cond

Condition to check

result

Result to compare

Attributes

Returns

A query to check the modulo operation in a Where statement

Inherited from:
Column
Source
Column.scala
def *(other: Column[A])(using Codec[A]): MultiColumn[A]

A function to multiply columns in a SELECT statement.

A function to multiply columns in a SELECT statement.

 TableQuery[User].select(user => user.name * user.age)
 // SELECT name * age FROM user

Value parameters

other

Column to multiply

Attributes

Returns

A query to multiply columns in a SELECT statement

Inherited from:
Column
Source
Column.scala
def ++(other: Column[A])(using Codec[A]): MultiColumn[A]

A function to combine columns in a SELECT statement.

A function to combine columns in a SELECT statement.

 TableQuery[User].select(user => user.name ++ user.age)
 // SELECT name + age FROM user

Value parameters

other

Column to combine

Attributes

Returns

A query to combine columns in a SELECT statement

Inherited from:
Column
Source
Column.scala
def --(other: Column[A])(using Codec[A]): MultiColumn[A]

A function to subtract columns in a SELECT statement.

A function to subtract columns in a SELECT statement.

 TableQuery[User].select(user => user.name -- user.age)
 // SELECT name - age FROM user

Value parameters

other

Column to subtract

Attributes

Returns

A query to subtract columns in a SELECT statement

Inherited from:
Column
Source
Column.scala
def /(other: Column[A])(using Codec[A]): MultiColumn[A]

A function to divide columns in a SELECT statement.

A function to divide columns in a SELECT statement.

 TableQuery[User].select(user => user.name / user.age)
 // SELECT name / age FROM user

Value parameters

other

Column to divide

Attributes

Returns

A query to divide columns in a SELECT statement

Inherited from:
Column
Source
Column.scala
def <(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def <(value: SQL): SubQuery[A]

Attributes

Inherited from:
Column
Source
Column.scala
def <(value: Extract[A])(using Encoder[Extract[A]]): LessThan[A]

A function that sets a WHERE condition to check whether the values are less than in a SELECT statement.

A function that sets a WHERE condition to check whether the values are less than in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id < 1L)
 // SELECT name, age FROM user WHERE id < ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check whether the values are less than in a Where statement

Inherited from:
Column
Source
Column.scala
def <<(value: Extract[A])(using Encoder[Extract[A]]): LeftShift[A]

A function to set a WHERE condition to check whether the values are shifted to the left in a SELECT statement.

A function to set a WHERE condition to check whether the values are shifted to the left in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id << 1L)
 // SELECT name, age FROM user WHERE id << ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check whether the values are shifted to the left in a Where statement

Inherited from:
Column
Source
Column.scala
def <=(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def <=(value: SQL): SubQuery[A]

Attributes

Inherited from:
Column
Source
Column.scala
def <=(value: Extract[A])(using Encoder[Extract[A]]): LessThanOrEqualTo[A]

A function that sets a WHERE condition to check whether the values are less than or equal to in a SELECT statement.

A function that sets a WHERE condition to check whether the values are less than or equal to in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id <= 1L)
 // SELECT name, age FROM user WHERE id <= ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check whether the values are less than or equal to in a Where statement

Inherited from:
Column
Source
Column.scala
def <=>(value: Extract[A])(using Encoder[Extract[A]]): NullSafeEqual[A]

A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.

A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id <=> 1L)
 // SELECT name, age FROM user WHERE id <=> ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check whether the values are equal in a Where statement

Inherited from:
Column
Source
Column.scala
def <>(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def <>(value: SQL): SubQuery[A]

Attributes

Inherited from:
Column
Source
Column.scala
def <>(value: Extract[A])(using Encoder[Extract[A]]): NotEqual[A]

A function that sets a WHERE condition to check whether the values are not equal in a SELECT statement.

A function that sets a WHERE condition to check whether the values are not equal in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id <> 1L)
 // SELECT name, age FROM user WHERE id <> ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check whether the values are not equal in a Where statement

Inherited from:
Column
Source
Column.scala
def ===(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def ===(value: SQL): SubQuery[A]

A function to perform a comparison with the column of interest using a subquery.

A function to perform a comparison with the column of interest using a subquery.

 val sub: SQL = ???
 TableQuery[User].select(user => user.name *: user.age).where(_.id === sub)
 // SELECT name, age FROM user WHERE id = (SELECT ...)

Value parameters

value

Value to compare

Attributes

Returns

A query to compare with the column of interest using a subquery

Inherited from:
Column
Source
Column.scala
def ===(value: Extract[A])(using Encoder[Extract[A]]): MatchCondition[A]

A function that sets a WHERE condition to check whether the values match in a SELECT statement.

A function that sets a WHERE condition to check whether the values match in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id === 1L)
 // SELECT name, age FROM user WHERE id = ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check whether the values match in a Where statement

Inherited from:
Column
Source
Column.scala
def >(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def >(value: SQL): SubQuery[A]

Attributes

Inherited from:
Column
Source
Column.scala
def >(value: Extract[A])(using Encoder[Extract[A]]): Over[A]

A function that sets a WHERE condition to check whether the values are greater than in a SELECT statement.

A function that sets a WHERE condition to check whether the values are greater than in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id > 1L)
 // SELECT name, age FROM user WHERE id > ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check whether the values are greater than in a Where statement

Inherited from:
Column
Source
Column.scala
def >=(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def >=(value: SQL): SubQuery[A]

Attributes

Inherited from:
Column
Source
Column.scala
def >=(value: Extract[A])(using Encoder[Extract[A]]): OrMore[A]

A function that sets a WHERE condition to check whether the values are greater than or equal to in a SELECT statement.

A function that sets a WHERE condition to check whether the values are greater than or equal to in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id >= 1L)
 // SELECT name, age FROM user WHERE id >= ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check whether the values are greater than or equal to in a Where statement

Inherited from:
Column
Source
Column.scala
def >>(value: Extract[A])(using Encoder[Extract[A]]): RightShift[A]

A function to set a WHERE condition to check whether the values are shifted to the right in a SELECT statement.

A function to set a WHERE condition to check whether the values are shifted to the right in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id >> 1L)
 // SELECT name, age FROM user WHERE id >> ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check whether the values are shifted to the right in a Where statement

Inherited from:
Column
Source
Column.scala
def BETWEEN(start: Extract[A], end: Extract[A])(using Encoder[Extract[A]]): Between[A]

A function that sets a WHERE condition to check whether a value is included in a specified range in a SELECT statement.

A function that sets a WHERE condition to check whether a value is included in a specified range in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.updateAt BETWEEN (LocalDateTime.now(), LocalDateTime.now()))
 // SELECT name, age FROM user WHERE update_at BETWEEN ? AND ?

Value parameters

end

End value

start

Start value

Attributes

Returns

A query to check whether the value is included in a specified range in a Where statement

Inherited from:
Column
Source
Column.scala
def DIV(cond: Extract[A], result: Extract[A])(using Encoder[Extract[A]]): Div[A]

A function to set a WHERE condition to check whether the values are added in a SELECT statement.

A function to set a WHERE condition to check whether the values are added in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id DIV(1L, 2L))
 // SELECT name, age FROM user WHERE id DIV ? = ?

Value parameters

cond

Condition to check

result

Result to compare

Attributes

Returns

A query to check whether the values are added in a Where statement

Inherited from:
Column
Source
Column.scala
def IN(value: SQL): SubQuery[A]

Attributes

Inherited from:
Column
Source
Column.scala
def IN(value: Extract[A]*)(using Encoder[Extract[A]]): In[A]

A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.

A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id IN (1L, 2L, 3L))
 // SELECT name, age FROM user WHERE id IN (?, ?, ?)

Value parameters

value

Value to compare

Attributes

Returns

A query to check whether the values are equal in a Where statement

Inherited from:
Column
Source
Column.scala
def IS[B <: "TRUE" | "FALSE" | "UNKNOWN" | "NULL"](value: B): Is[B]

A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.

A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id IS "NULL")
 // SELECT name, age FROM user WHERE id IS NULL

Type parameters

B

Type of value to compare

Value parameters

value

Value to compare

Attributes

Returns

Query to check whether values are equal in a Where statement.

Inherited from:
Column
Source
Column.scala
def LIKE(value: Extract[A])(using Encoder[Extract[A]]): Like[A]

A function to set a WHERE condition to check a value with an ambiguous search in a SELECT statement.

A function to set a WHERE condition to check a value with an ambiguous search in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.name LIKE "Tak%")
 // SELECT name, age FROM user WHERE name LIKE ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check a value with an ambiguous search in a Where statement

Inherited from:
Column
Source
Column.scala
def LIKE_ESCAPE(like: Extract[A], escape: Extract[A])(using Encoder[Extract[A]]): LikeEscape[A]

A function to set a WHERE condition to check a value with an ambiguous search in a SELECT statement.

A function to set a WHERE condition to check a value with an ambiguous search in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.name LIKE "Tak%" ESCAPE "!")
 // SELECT name, age FROM user WHERE name LIKE ? ESCAPE ?

Value parameters

escape

Value to escape

like

Value to compare

Attributes

Returns

A query to check a value with an ambiguous search in a Where statement

Inherited from:
Column
Source
Column.scala
def MOD(cond: Extract[A], result: Extract[A])(using Encoder[Extract[A]]): Mod[A]

A function to set the WHERE condition for modulo operations in a SELECT statement.

A function to set the WHERE condition for modulo operations in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id MOD(1L, 2L))
 // SELECT name, age FROM user WHERE id MOD ? = ?

Value parameters

cond

Condition to check

result

Result to compare

Attributes

Returns

A query to check the modulo operation in a Where statement

Inherited from:
Column
Source
Column.scala
def REGEXP(value: Extract[A])(using Encoder[Extract[A]]): Regexp[A]

A function to set a WHERE condition to check values in a regular expression in a SELECT statement.

A function to set a WHERE condition to check values in a regular expression in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.name REGEXP "Tak.*")
 // SELECT name, age FROM user WHERE name REGEXP ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check values in a regular expression in a Where statement

Inherited from:
Column
Source
Column.scala
def ^(value: Extract[A])(using Encoder[Extract[A]]): BitXOR[A]

A function to set the WHERE condition for bitwise XOR operations in a SELECT statement.

A function to set the WHERE condition for bitwise XOR operations in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id ^ 1L)
 // SELECT name, age FROM user WHERE id ^ ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check the bitwise XOR operation in a Where statement

Inherited from:
Column
Source
Column.scala
def _equals(other: Column[_]): Expression

List of join query methods

List of join query methods

Attributes

Inherited from:
Column
Source
Column.scala
def _equals(value: SQL): SubQuery[A]

List of sub query methods

List of sub query methods

Attributes

Inherited from:
Column
Source
Column.scala
def _equals(value: Extract[A])(using Encoder[Extract[A]]): MatchCondition[A]

Attributes

Inherited from:
Column
Source
Column.scala
def asc: Order[A]

Attributes

Inherited from:
Column
Source
Column.scala
def bitFlip(value: Extract[A])(using Encoder[Extract[A]]): BitFlip[A]

Attributes

Inherited from:
Column
Source
Column.scala
def bitXOR(value: Extract[A])(using Encoder[Extract[A]]): BitXOR[A]

Attributes

Inherited from:
Column
Source
Column.scala
def combine(other: Column[A])(using Codec[A]): MultiColumn[A]

Attributes

Inherited from:
Column
Source
Column.scala
def count(using Decoder[Int], Encoder[Int]): Count

Attributes

Inherited from:
Column
Source
Column.scala
def deduct(other: Column[A])(using Codec[A]): MultiColumn[A]

Attributes

Inherited from:
Column
Source
Column.scala
def desc: Order[A]

Attributes

Inherited from:
Column
Source
Column.scala
def imap[B](f: A => B)(g: B => A): Column[B]

Attributes

Inherited from:
Column
Source
Column.scala
def leftShift(value: Extract[A])(using Encoder[Extract[A]]): LeftShift[A]

Attributes

Inherited from:
Column
Source
Column.scala
def lessThan(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def lessThan(value: SQL): SubQuery[A]

Attributes

Inherited from:
Column
Source
Column.scala
def lessThan(value: Extract[A])(using Encoder[Extract[A]]): LessThan[A]

Attributes

Inherited from:
Column
Source
Column.scala
def lessThanOrEqual(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def lessThanOrEqual(value: SQL): SubQuery[A]

Attributes

Inherited from:
Column
Source
Column.scala
def lessThanOrEqual(value: Extract[A])(using Encoder[Extract[A]]): LessThanOrEqualTo[A]

Attributes

Inherited from:
Column
Source
Column.scala
def mod(cond: Extract[A], result: Extract[A])(using Encoder[Extract[A]]): Mod[A]

Attributes

Inherited from:
Column
Source
Column.scala
def multiply(other: Column[A])(using Codec[A]): MultiColumn[A]

Attributes

Inherited from:
Column
Source
Column.scala
def notEqual(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def notEqual(value: SQL): SubQuery[A]

Attributes

Inherited from:
Column
Source
Column.scala
def notEqual(value: Extract[A])(using Encoder[Extract[A]]): NotEqual[A]

Attributes

Inherited from:
Column
Source
Column.scala
def nullSafeEqual(value: Extract[A])(using Encoder[Extract[A]]): NullSafeEqual[A]

Attributes

Inherited from:
Column
Source
Column.scala
def opt: Column[Option[A]]

Attributes

Inherited from:
Column
Source
Column.scala
def orMore(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def orMore(value: SQL): SubQuery[A]

Attributes

Inherited from:
Column
Source
Column.scala
def orMore(value: Extract[A])(using Encoder[Extract[A]]): OrMore[A]

Attributes

Inherited from:
Column
Source
Column.scala
def over(other: Column[_]): Expression

Attributes

Inherited from:
Column
Source
Column.scala
def over(value: SQL): SubQuery[A]

Attributes

Inherited from:
Column
Source
Column.scala
def over(value: Extract[A])(using Encoder[Extract[A]]): Over[A]

Attributes

Inherited from:
Column
Source
Column.scala
def product[B](fb: Column[B]): Column[(A, B)]

Attributes

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

Attributes

Inherited from:
Product
def productIterator: Iterator[Any]

Attributes

Inherited from:
Product
def rightShift(value: Extract[A])(using Encoder[Extract[A]]): RightShift[A]

Attributes

Inherited from:
Column
Source
Column.scala
def smash(other: Column[A])(using Codec[A]): MultiColumn[A]

Attributes

Inherited from:
Column
Source
Column.scala
def statement: String

Used in select statement Column, Column used in the Insert statement

Used in select statement Column, Column used in the Insert statement

Attributes

Inherited from:
Column
Source
Column.scala
override def toString: String

Returns a string representation of the object.

Returns a string representation of the object.

The default representation is platform dependent.

Attributes

Returns

a string representation of the object.

Definition Classes
Column -> Any
Inherited from:
Column
Source
Column.scala
def ~(value: Extract[A])(using Encoder[Extract[A]]): BitFlip[A]

A function to set the WHERE condition for bitwise NOT operations in a SELECT statement.

A function to set the WHERE condition for bitwise NOT operations in a SELECT statement.

 TableQuery[User].select(user => user.name *: user.age).where(_.id ~ 1L)
 // SELECT name, age FROM user WHERE id ~ ?

Value parameters

value

Value to compare

Attributes

Returns

A query to check the bitwise NOT operation in a Where statement

Inherited from:
Column
Source
Column.scala
Generated with