Trait for generating SQL table information.
Type parameters
- P
-
A class that implements a Product that is one-to-one with the table definition.
Attributes
- Companion
- object
- Source
- Table.scala
- Graph
-
- Supertypes
Members list
Value members
Abstract methods
An alias for the table.
The name of the table.
Function for setting alias names for tables.
Function for setting alias names for tables.
Value parameters
- name
-
Alias name
Attributes
- Returns
-
Table with alias name
- Source
- Table.scala
A method to get the column names defined in the table.
Function for setting table names.
Function for setting table names.
Value parameters
- name
-
Table name
Attributes
- Returns
-
Table with table name
- Source
- Table.scala
Concrete methods
A method to build a query model that inserts data from multiple models into all columns defined in a table.
A method to build a query model that inserts data from multiple models into all columns defined in a table.
Value parameters
- mirror
-
product isomorphism map
- values
-
A class that implements a Product that is one-to-one with the table definition.
Attributes
- Source
- Table.scala
A method to build a query model that inserts data from the model into all columns defined in the table.
A method to build a query model that inserts data from the model into all columns defined in the table.
Value parameters
- mirror
-
product isomorphism map
- value
-
A class that implements a Product that is one-to-one with the table definition.
Attributes
- Source
- Table.scala
Method to construct a query to delete a table.
Method to construct a query to drop a table.
A method to build a query model that inserts data into all columns defined in the table.
A method to build a query model that inserts data into all columns defined in the table.
Value parameters
- mirror
-
product isomorphism map
- values
-
A list of Tuples constructed with all the property types that Table has.
Attributes
- Source
- Table.scala
A method to build a query model that inserts data into specified columns defined in a table.
A method to build a query model that inserts data into specified columns defined in a table.
Type parameters
- T
-
Type of value to be obtained
Value parameters
- func
-
Function to retrieve columns from Table.
Attributes
- Source
- Table.scala
A method to perform a simple Join.
A method to perform a simple Join.
Table[Person].join(Table[City])((person, city) => person.cityId == city.id)
// ... person JOIN city ON person.cityId = city.id
Type parameters
- O
-
A class that implements a Product that is one-to-one with the table definition.
Value parameters
- on
-
Comparison function that performs a Join.
- other
-
Table to do a Join.
Attributes
- Source
- Table.scala
A method to get the table name.
Method to perform Left Join.
Method to perform Left Join.
Table[Person].leftJoin(Table[City])((person, city) => person.cityId == city.id)
// ... person LEFT JOIN city ON person.cityId = city.id
Type parameters
- O
-
A class that implements a Product that is one-to-one with the table definition.
Value parameters
- on
-
Comparison function that performs a Join.
- other
-
Table to do a Join.
Attributes
- Source
- Table.scala
Method to perform Right Join.
Method to perform Right Join.
Table[Person].rightJoin(Table[City])((person, city) => person.cityId == city.id)
// ... person RIGHT JOIN city ON person.cityId = city.id
Type parameters
- O
-
A class that implements a Product that is one-to-one with the table definition.
Value parameters
- on
-
Comparison function that performs a Join.
- other
-
Table to do a Join.
Attributes
- Source
- Table.scala
A method to perform a simple Select.
A method to perform a simple Select.
Table[Person].select(person => (person.id, person.name))
// SELECT id, name FROM person
Type parameters
- T
-
Type of value to be obtained
Value parameters
- func
-
Function to retrieve columns from Table.
Attributes
- Returns
-
Select model
- Source
- Table.scala
A method to perform a simple Select.
A method to perform a simple Select.
Table[Person].selectAll
// SELECT id, name, age FROM person
Attributes
- Source
- Table.scala
A method to get a specific column defined in the table.
A method to get a specific column defined in the table.
Type parameters
- Tag
-
Type with a single instance
Value parameters
- index
-
Position of the specified type in tuple X
- mirror
-
product isomorphism map
- tag
-
A type with a single instance. Here, Column is passed.
Attributes
- Source
- Table.scala
Method to construct a query to truncate a table.
A method to build a query model that updates specified columns defined in a table.
A method to build a query model that updates specified columns defined in a table.
Type parameters
- T
-
Scala types that match SQL DataType
- Tag
-
Type with a single instance
Value parameters
- check
-
A value to verify that the specified type matches the type of the specified column that the Table has.
- index
-
Position of the specified type in tuple X
- mirror
-
product isomorphism map
- tag
-
A type with a single instance. Here, Column is passed.
- value
-
A value of type T to be inserted into the specified column.
Attributes
- Source
- Table.scala
A method to build a query model that updates all columns defined in the table using the model.
A method to build a query model that updates all columns defined in the table using the model.
Value parameters
- mirror
-
product isomorphism map
- value
-
A class that implements a Product that is one-to-one with the table definition.
Attributes
- Source
- Table.scala
Inherited methods
A method to get all columns defined in the table.
A method to get all columns defined in the table.
Attributes
- Inherited from:
- MySQLTable
- Source
- Table.scala