Struct Statement 

pub struct Statement { /* private fields */ }

A SQL statement for execution on Spanner.

Example

let client = Spanner::builder().build().await.unwrap();
let db = client.database_client("projects/p/instances/i/databases/d").build().await.unwrap();

let tx = db.single_use().build();
let stmt = Statement::builder("SELECT * FROM users WHERE id = @id")
    .add_param("id", &42)
    .build();
let mut rs = tx.execute_query(stmt).await?;

while let Some(row) = rs.next().await {
    let row = row?;
    // process row
}

Implementations

impl Statement

pub fn builder(sql: impl Into<String>) -> StatementBuilder

Creates a new statement builder.

pub fn sql(&self) -> &str

Returns the SQL query string of this statement.

pub fn set_query_mode(self, mode: QueryMode) -> Self

Sets the query mode to use for this statement.

Example

let statement = Statement::builder("SELECT * FROM users WHERE id = @id")
    .add_param("id", &42)
    .build();
let mut query_plan = tx.execute_query(statement.clone().set_query_mode(QueryMode::Plan)).await?;

This method consumes the statement and returns a new one with the specified mode.

Trait Implementations

impl Clone for Statement

fn clone(&self) -> Statement

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for Statement

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl From<&str> for Statement

fn from(sql: &str) -> Self

Converts to this type from the input type.

impl From<StatementBuilder> for Statement

fn from(builder: StatementBuilder) -> Self

Converts to this type from the input type.

impl From<String> for Statement

fn from(sql: String) -> Self

Converts to this type from the input type.