context

Type Members

1. trait CanOutputClause extends Capabilities

   

2. trait CanReturnClause extends Capabilities

   

3. trait CanReturnField extends Capabilities

   

4. trait CanReturnMultiField extends Capabilities

   

5. trait CannotReturn extends Capabilities

   

6. trait Capabilities extends AnyRef

   

7. sealed trait OutputClauseSupported extends ReturningCapability

   

   An actual OUTPUT clause is supported in the SQL dialect of the specified database e.g.

   An actual OUTPUT clause is supported in the SQL dialect of the specified database e.g. MSSQL Server. this typically means that columns returned from Insert/Update/etc... clauses can have arithmetic operations done on them such as OUTPUT INSERTED.id + 1.

8. sealed trait ReturningCapability extends AnyRef

   

9. sealed trait ReturningClauseSupported extends ReturningCapability

   

   An actual RETURNING clause is supported in the SQL dialect of the specified database e.g.

   An actual RETURNING clause is supported in the SQL dialect of the specified database e.g. Postgres. this typically means that columns returned from Insert/Update/etc... clauses can have other database operations done on them such as arithmetic RETURNING id + 1, UDFs RETURNING udf(id) or others. In JDBC, the following is done: connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)).

10. sealed trait ReturningMultipleFieldSupported extends ReturningCapability

    

    Returning multiple columns from Insert/Update/etc...

    Returning multiple columns from Insert/Update/etc... clauses is supported. This generally means that columns besides auto-incrementing ones can be returned. This is supported by Oracle. In JDBC, the following is done: connection.prepareStatement(sql, Array("column1, column2, ...")).

11. sealed trait ReturningNotSupported extends ReturningCapability

    

    Data cannot be returned Insert/Update/etc...

    Data cannot be returned Insert/Update/etc... clauses in the target database.

12. sealed trait ReturningSingleFieldSupported extends ReturningCapability

    

    Returning a single field from Insert/Update/etc...

    Returning a single field from Insert/Update/etc... clauses is supported. This is the most common databases e.g. MySQL, Sqlite, and H2 (although as of h2database/h2database#1972 this may change. See #1496 regarding this. Typically this needs to be setup in the JDBC connection.prepareStatement(sql, Array("returnColumn")).