SQLDefinition

Used in dependent type expressions.

Returns the SQL which evaluates to true if all columns of this SQLDefinition are equal to the given value.

Converts the value into a vector of (columnName, value) pairs.

Changes the type of the definition. The change must be invariant and cannot fail. Useful for wrapper types.

Was this SQLDefinition created from a option method.

Creates an Option version of the SQLDefinition, giving that it is not already an Option.

Useful when you are doing joins and want a non-nullable Column/SQLDefinition to be represented as a nullable one.

The SQL Fragment containing all of the Column.name joined with ",".

Useful in preparing batch inserts.

 Update[Person](
   sql"INSERT INTO $personTable (${person.columnsSql}) VALUES (${person.valuesSql})".rawSql
 ).updateMany(persons)

Returns Update for batch inserts into the given table.

Full SQL for inserting into the given table.

Generates a Fragment that sets all columns of the SQLDefinition to their excluded values.

To allow widening the type of Column and similar ones to SQLDefinition.

This is useful when working with tuples of SQLDefinitions, because (Column[Int], Column[String]) is not the same thing as (SQLDefinition[Int], SQLDefinition[String]).

Changes the type of the definition. The change cannot fail. Useful for wrapper types.

To allow widening the type of Column and similar ones to SQLDefinitionRead.

This is useful when working with tuples of SQLDefinitions, because (Column[Int], Column[String]) is not the same thing as (SQLDefinitionRead[Int], SQLDefinitionRead[String]).

To allow widening the type of Column and similar ones to TypedMultiFragment.

This is useful when working with tuples of TypedMultiFragments, because (Column[Int], Column[String]) is not the same thing as (TypedMultiFragment[Int], TypedMultiFragment[String]).

Vector of columns

Prefixes all column names with prefix.. If this already had a prefix, the prefix is replaced.

Combines columnsSql and valuesSql.

Useful in preparing batch inserts.

 Update[Person](
   sql"INSERT INTO $personTable ${person.insertSql}".rawSql
 ).updateMany(persons)

The SQL Fragment containing as many value placeholders (?) as there are columns joined with ",".

Useful in preparing batch inserts. See columnsSql.

Prefixes all column names with EXCLUDED, which is a special SQL table name when resolving insert/update conflicts.

Example:

 sql""" ${t.Row.insertSqlFor(t)} ON CONFLICT (${t.userId},
${t.weaponId}) DO UPDATE SET ${t.kills} = ${t.kills} +
${t.kills.excluded} """ 

SQL that lists all of the columns to get this SQL result.