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 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
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.
If extracted value has SQL null
value, a Some instance
containing a null
value will be returned.
This method is not intended to be used for returning values from columns
that can have a SQL null
value. Use executeForValueOpt
for such columns.
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
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.
If row was found but extracted value has SQL null
value, a Some
instance will be returned containing a None.
Example:
val id = 10 for { select <- conn.select(sql"select name from users where id = $id") name <- parametrized.executeForValueOpt(_.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.
Returned future can fail with:
Represents an executable statement.
Executable statement is a statement that has all parameters provided and is ready to be executed.