ldbc-query-builder
0.3.0-beta6
API
Generated with
ldbc-query-builder/ldbc.query.builder/Column

Column

ldbc.query.builder.Column
See theColumn companion object
trait Column[T]

Trait for representing SQL Column

Type parameters

T

Scala types that match SQL DataType

Attributes

Companion
object
Source
Column.scala
Graph
Supertypes
class Object
trait Matchable
class Any

Members list

Value members

Abstract methods

def alias: Option[String]

Column alias name

Column alias name

Attributes

Source
Column.scala
def as(name: String): Column[T]

Functions for setting aliases on columns

Functions for setting aliases on columns

Attributes

Source
Column.scala
def name: String

Column Field Name

Column Field Name

Attributes

Source
Column.scala

Concrete methods

def !==(value: Extract[T])(using Parameter[Extract[T]]): NotEqual[T]

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.

 Table[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

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

Attributes

Source
Column.scala
def %(cond: Extract[T], result: Extract[T])(using Parameter[Extract[T]]): Mod[T]

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.

 Table[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

Source
Column.scala
def *(other: Column[T]): MultiColumn[T]

A function to multiply columns in a SELECT statement.

A function to multiply columns in a SELECT statement.

 Table[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

Source
Column.scala
def ++(other: Column[T]): MultiColumn[T]

A function to combine columns in a SELECT statement.

A function to combine columns in a SELECT statement.

 Table[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

Source
Column.scala
def --(other: Column[T]): MultiColumn[T]

A function to subtract columns in a SELECT statement.

A function to subtract columns in a SELECT statement.

 Table[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

Source
Column.scala
def /(other: Column[T]): MultiColumn[T]

A function to divide columns in a SELECT statement.

A function to divide columns in a SELECT statement.

 Table[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

Source
Column.scala
def <(value: Extract[T])(using Parameter[Extract[T]]): LessThan[T]

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.

 Table[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

Source
Column.scala
def <(value: SQL): SubQuery[T]

Attributes

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

Attributes

Source
Column.scala
def <<(value: Extract[T])(using Parameter[Extract[T]]): LeftShift[T]

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.

 Table[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

Source
Column.scala
def <=(value: Extract[T])(using Parameter[Extract[T]]): LessThanOrEqualTo[T]

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.

 Table[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

Source
Column.scala
def <=(value: SQL): SubQuery[T]

Attributes

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

Attributes

Source
Column.scala
def <=>(value: Extract[T])(using Parameter[Extract[T]]): NullSafeEqual[T]

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.

 Table[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

Source
Column.scala
def <>(value: Extract[T])(using Parameter[Extract[T]]): NotEqual[T]

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.

 Table[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

Source
Column.scala
def <>(value: SQL): SubQuery[T]

Attributes

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

Attributes

Source
Column.scala
def ===(value: Extract[T])(using Parameter[Extract[T]]): MatchCondition[T]

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.

 Table[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

Source
Column.scala
def ===(value: SQL): SubQuery[T]

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 = ???
 Table[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

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

Attributes

Source
Column.scala
def >(value: Extract[T])(using Parameter[Extract[T]]): Over[T]

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.

 Table[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

Source
Column.scala
def >(value: SQL): SubQuery[T]

Attributes

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

Attributes

Source
Column.scala
def >=(value: Extract[T])(using Parameter[Extract[T]]): OrMore[T]

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.

 Table[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

Source
Column.scala
def >=(value: SQL): SubQuery[T]

Attributes

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

Attributes

Source
Column.scala
def >>(value: Extract[T])(using Parameter[Extract[T]]): RightShift[T]

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.

 Table[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

Source
Column.scala
def BETWEEN(start: Extract[T], end: Extract[T])(using Parameter[Extract[T]]): Between[T]

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.

 Table[User].select(user => (user.name, user.age)).where(_.updateAt BETWEEN (LocalDateTime.now(), LocalDateTime.now()))
 // SELECT `name`, `age` FROM `user` WHERE `updateAt` 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

Source
Column.scala
def DIV(cond: Extract[T], result: Extract[T])(using Parameter[Extract[T]]): Div[T]

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.

 Table[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

Source
Column.scala
def IN(value: Extract[T]*)(using Parameter[Extract[T]]): In[T]

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.

 Table[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

Source
Column.scala
def IN(value: SQL): SubQuery[T]

Attributes

Source
Column.scala
def IS[A <: "TRUE" | "FALSE" | "UNKNOWN" | "NULL"](value: A): Is[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.

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

Type parameters

A

Type of value to compare

Value parameters

value

Value to compare

Attributes

Returns

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

Source
Column.scala
def LIKE(value: Extract[T])(using Parameter[Extract[T]]): Like[T]

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.

 Table[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

Source
Column.scala
def LIKE_ESCAPE(like: Extract[T], escape: Extract[T])(using Parameter[Extract[T]]): LikeEscape[T]

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.

 Table[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

Source
Column.scala
def MOD(cond: Extract[T], result: Extract[T])(using Parameter[Extract[T]]): Mod[T]

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.

 Table[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

Source
Column.scala
def REGEXP(value: Extract[T])(using Parameter[Extract[T]]): Regexp[T]

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.

 Table[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

Source
Column.scala
def ^(value: Extract[T])(using Parameter[Extract[T]]): BitXOR[T]

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.

 Table[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

Source
Column.scala
def _equals(value: Extract[T])(using Parameter[Extract[T]]): MatchCondition[T]

Attributes

Source
Column.scala
def _equals(value: SQL): SubQuery[T]

List of sub query methods

List of sub query methods

Attributes

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

List of join query methods

List of join query methods

Attributes

Source
Column.scala
def asc: Order[T]

Attributes

Source
Column.scala
def bitFlip(value: Extract[T])(using Parameter[Extract[T]]): BitFlip[T]

Attributes

Source
Column.scala
def bitXOR(value: Extract[T])(using Parameter[Extract[T]]): BitXOR[T]

Attributes

Source
Column.scala
def combine(other: Column[T]): MultiColumn[T]

Attributes

Source
Column.scala
def count: Count

Attributes

Source
Column.scala
def deduct(other: Column[T]): MultiColumn[T]

Attributes

Source
Column.scala
def desc: Order[T]

Attributes

Source
Column.scala
def leftShift(value: Extract[T])(using Parameter[Extract[T]]): LeftShift[T]

Attributes

Source
Column.scala
def lessThan(value: Extract[T])(using Parameter[Extract[T]]): LessThan[T]

Attributes

Source
Column.scala
def lessThan(value: SQL): SubQuery[T]

Attributes

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

Attributes

Source
Column.scala
def lessThanOrEqual(value: Extract[T])(using Parameter[Extract[T]]): LessThanOrEqualTo[T]

Attributes

Source
Column.scala
def lessThanOrEqual(value: SQL): SubQuery[T]

Attributes

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

Attributes

Source
Column.scala
def mod(cond: Extract[T], result: Extract[T])(using Parameter[Extract[T]]): Mod[T]

Attributes

Source
Column.scala
def multiply(other: Column[T]): MultiColumn[T]

Attributes

Source
Column.scala
def notEqual(value: Extract[T])(using Parameter[Extract[T]]): NotEqual[T]

Attributes

Source
Column.scala
def notEqual(value: SQL): SubQuery[T]

Attributes

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

Attributes

Source
Column.scala
def nullSafeEqual(value: Extract[T])(using Parameter[Extract[T]]): NullSafeEqual[T]

Attributes

Source
Column.scala
def orMore(value: Extract[T])(using Parameter[Extract[T]]): OrMore[T]

Attributes

Source
Column.scala
def orMore(value: SQL): SubQuery[T]

Attributes

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

Attributes

Source
Column.scala
def over(value: Extract[T])(using Parameter[Extract[T]]): Over[T]

Attributes

Source
Column.scala
def over(value: SQL): SubQuery[T]

Attributes

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

Attributes

Source
Column.scala
def rightShift(value: Extract[T])(using Parameter[Extract[T]]): RightShift[T]

Attributes

Source
Column.scala
def smash(other: Column[T]): MultiColumn[T]

Attributes

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
Any
Source
Column.scala
def ~(value: Extract[T])(using Parameter[Extract[T]]): BitFlip[T]

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.

 Table[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

Source
Column.scala
Generated with