Method for setting the primary key to the column.
Attributes
- Companion
- object
- Source
- DataTypeColumn.scala
- Graph
-
- Supertypes
- Known subtypes
Members list
Value members
Abstract methods
List of attributes to be set for the column
Data type to be set for the column
Method for setting the default value to the current time.
Method for setting the default value to NULL.
Default value to be set for the column
Value indicating whether DataType is null-allowed or not.
Value indicating whether DataType is null-allowed or not.
Attributes
- Returns
-
true if NULL is allowed, false if NULL is not allowed
- Source
- DataTypeColumn.scala
Method for setting the attributes to the column.
Concrete methods
Method for setting the comment to the column.
Method for setting the unique key to the column.
Inherited methods
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
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
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
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
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
- head
-
Value to compare
- tail
-
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
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 NonEmptyList.of(1L, 2L, 3L))
// SELECT name, age FROM user WHERE id IN (?, ?, ?)
Value parameters
- values
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are equal in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
List of join query methods
List of sub query methods
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
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
Indicator of how many columns are specified
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
Inherited and Abstract methods
Column alias name
Functions for setting aliases on columns
Function to get a value of type T from a ResultSet
Function to get a value of type T from a ResultSet
Attributes
- Inherited from:
- Column
- Source
- Column.scala
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
- Inherited from:
- Column
- Source
- Column.scala
Function to set a value of type T to a PreparedStatement
Function to set a value of type T to a PreparedStatement
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Column Field Name
Used in Update statement Column = ?, Column = ?
used in the Update statement
Used in Update statement Column = ?, Column = ?
used in the Update statement
Attributes
- Inherited from:
- Column
- Source
- Column.scala