ColumnImpl

ldbc.schema.ColumnImpl
case class ColumnImpl[T](name: String, alias: Option[String], dataType: DataType[T], attributes: List[Attribute[T]]) extends Column[T]

Case class for representing SQL Column

Type parameters

T

Scala types that match SQL DataType

Value parameters

alias

Column alias name

attributes

Extra attribute of column

dataType

Column data type

name

Column Field Name

Attributes

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

Members list

Value members

Concrete methods

override def as(name: String): Column[T]

Functions for setting aliases on columns

Functions for setting aliases on columns

Attributes

Definition Classes
Source
ColumnImpl.scala

Define SQL query string for each Column

Define SQL query string for each Column

Attributes

Returns

SQL query string

Source
ColumnImpl.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
Source
ColumnImpl.scala

Inherited methods

Attributes

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
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

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

Attributes

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

Attributes

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
Source
Column.scala

Attributes

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

Attributes

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
Source
Column.scala

Attributes

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

Attributes

Inherited from:
Column
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

Inherited from:
Column
Source
Column.scala

Attributes

Inherited from:
Column
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

Inherited from:
Column
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

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

Attributes

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

Attributes

Inherited from:
Column
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

Inherited from:
Column
Source
Column.scala

Attributes

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

Attributes

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
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

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

Attributes

Inherited from:
Column
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

Inherited from:
Column
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.

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
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

Inherited from:
Column
Source
Column.scala

List of join query methods

List of join query methods

Attributes

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

List of sub query methods

List of sub query methods

Attributes

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

Attributes

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

Attributes

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

Attributes

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

Attributes

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

Attributes

Inherited from:
Column
Source
Column.scala
def count: Count

Attributes

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

Attributes

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

Attributes

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

Attributes

Inherited from:
Column
Source
Column.scala

Attributes

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

Attributes

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

Attributes

Inherited from:
Column
Source
Column.scala

Attributes

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

Attributes

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

Attributes

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

Attributes

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

Attributes

Inherited from:
Column
Source
Column.scala

Attributes

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

Attributes

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

Attributes

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

Attributes

Inherited from:
Column
Source
Column.scala

Attributes

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

Attributes

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

Attributes

Inherited from:
Column
Source
Column.scala

Attributes

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

Attributes

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

Attributes

Inherited from:
Column
Source
Column.scala

Attributes

Inherited from:
Product

Attributes

Inherited from:
Product
def rightShift(value: Extract[T])(using Parameter[Extract[T]]): RightShift[T]

Attributes

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

Attributes

Inherited from:
Column
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

Inherited from:
Column
Source
Column.scala