Executes this statement ignoring any resulting information.
Executes this statement ignoring any resulting information.
After the operation takes longer time than timeout
, operation
will be aborted. Note however, that it may not be feasible
to abort the operation immediately.
Returned future can fail with:
Executes this statement and returns the first row returned by a database engine.
Executes this statement and returns the first row returned by a database engine.
If no rows are found, None will be returned.
After the operation takes longer time than timeout
, operation
will be aborted. Note however, that it may not be feasible
to abort the operation immediately.
Returned future can fail with:
Executes this statement returning a number of rows that were affected.
Executes this statement returning a number of rows that were affected.
After the operation takes longer time than timeout
, operation
will be aborted. Note however, that it may not be feasible
to abort the operation immediately.
Returned future can fail with:
Executes this statement and returns a ResultSet instance.
Executes this statement and returns a ResultSet instance.
After execution all resulting rows will be pulled from a database and buffered in the resulting object. If expected result set is very big this may cause out of memory errors.
After the operation takes longer time than timeout
, operation
will be aborted. Note however, that it may not be feasible
to abort the operation immediately.
Returned future can fail with:
Executes this statement and returns a single column value from the first row returned by a database engine.
Executes this statement and returns a single column value from the first row returned by a database engine.
If no rows are found, None will be returned.
Example:
for { val id = 10 select <- conn.statement(sql"select name from users where id = $id") name <- select.executeForValue(_.str("name")) } yield name
After the operation takes longer time than timeout
, operation
will be aborted. Note however, that it may not be feasible
to abort the operation immediately.
Returned future can fail with:
function used to extract value from the returned row
Returns a RowPublisher instance that can be used to stream rows from
the database leveraging Reactive Streams specification's Publisher
with
backpressure.
Returns a RowPublisher instance that can be used to stream rows from
the database leveraging Reactive Streams specification's Publisher
with
backpressure.
The statement is not executed until the stream is subscribed to.
After the operation takes longer time than timeout
, operation
will be aborted. Note however, that it may not be feasible
to abort the operation immediately.
This method doesn't throw exceptions on failures. Failures are reported by the returned publisher.
[use case] Executes this statement and returns a single generated key.
Executes this statement and returns a single generated key.
After the operation takes longer time than timeout
, operation
will be aborted. Note however, that it may not be feasible
to abort the operation immediately.
Returned future can fail with:
type of the returned key
Represents an executable statement.
Executable statement is a statement that has all parameters provided and is ready to be executed.