Executes the prepared statement with the given params
.
Executes the prepared statement with the given params
.
Use Parameters.of for converting the inputs into Parameters.
import com.twitter.finagle.mysql.Client; import com.twitter.finagle.mysql.PreparedStatement.AsJava; import com.twitter.finagle.mysql.Result; import com.twitter.util.Future; import static com.twitter.finagle.mysql.Parameters.of; Client client = ... PreparedStatement.AsJava preparedStatement = client .prepare("SELECT column1 FROM a_table WHERE column2 = ?") .asJava(); Future<Result> result = preparedStatement.execute(of("value1"), of(1234));
Executes the prepared statement DML (e.g.
Executes the prepared statement DML (e.g. INSERT/UPDATE/DELETE) or DDL
(e.g. CREATE TABLE, DROP TABLE, COMMIT, START TRANSACTION, etc) with the
given params
.
Use Parameters.of for converting the inputs into Parameters.
import com.twitter.finagle.mysql.Client; import com.twitter.finagle.mysql.OK; import com.twitter.finagle.mysql.PreparedStatement.AsJava; import com.twitter.util.Future; import static com.twitter.finagle.mysql.Parameters.of; Client client = ... PreparedStatement.AsJava preparedStatement = client .prepare("INSERT INTO a_table (column1, column2) VALUES (?, ?)") .asJava(); Future<OK> ok = preparedStatement.modify(of("value1"), of(1234));
Executes the prepared statement SELECT query with the given params
.
Executes the prepared statement SELECT query with the given params
.
Use Parameters.of for converting the inputs into Parameters.
import com.twitter.finagle.mysql.Client; import com.twitter.finagle.mysql.PreparedStatement.AsJava; import com.twitter.finagle.mysql.ResultSet; import com.twitter.util.Future; import static com.twitter.finagle.mysql.Parameters.of; Client client = ... PreparedStatement.AsJava preparedStatement = client .prepare("SELECT column1 FROM a_table WHERE column2 = ?") .asJava(); Future<ResultSet> resultSet = preparedStatement.read(of("value1"), of(1234));
Executes the prepared statement with the given params
and maps f
to the
rows of the returned ResultSet.
Executes the prepared statement with the given params
and maps f
to the
rows of the returned ResultSet. If no ResultSet is returned, the function
returns an empty List
.
Use Parameters.of for converting the inputs into Parameters.
import com.twitter.finagle.mysql.Client; import com.twitter.finagle.mysql.PreparedStatement.AsJava; import com.twitter.finagle.mysql.Row; import com.twitter.finagle.mysql.StringValue; import com.twitter.util.Future; import java.util.List import static com.twitter.finagle.mysql.Parameters.of; Client client = ... PreparedStatement.AsJava preparedStatement = client .prepare("SELECT column1 FROM a_table WHERE column2 = ?") .asJava(); Future<List<String>> result = preparedStatement.select((Row row) -> { return row.stringOrNull(); }, of(1234) );
A Java-friendly API for PreparedStatements.
These should be constructed via PreparedStatement.asJava but is package exposed for testing.