Struct Row

Source

pub struct Row { /* private fields */ }

Expand description

A row in a query result.

Implementations§

Source §

impl Row

Source

pub fn raw_values(&self) -> &[Value]

Returns the raw values of the row.

Source

pub fn try_is_null<I: ColumnIndex>(&self, index: I) -> Result<bool>

Returns true if the value at the specified column name or index is null.

§Example

let client = Spanner::builder().build().await?;
let db_client = client.database_client("projects/p/instances/i/databases/d").build().await?;
let transaction = db_client.single_use().build();
let mut result_set = transaction.execute_query(Statement::builder("SELECT NULL AS Age").build()).await?;

if let Some(row) = result_set.next().await {
    let is_null = row?.try_is_null("Age")?;
    println!("Is null: {}", is_null);
}

§Arguments

index - The column name (string) or index (zero-based integer).

§Returns

Ok(bool) if the value is null or not.
Err(Error) if the column name or index is invalid.

Source

pub fn is_null<I: ColumnIndex>(&self, index: I) -> bool

Returns true if the value at the specified column name or index is null, panicking on error.

§Example

let client = Spanner::builder().build().await?;
let db_client = client.database_client("projects/p/instances/i/databases/d").build().await?;
let transaction = db_client.single_use().build();
let mut result_set = transaction.execute_query(Statement::builder("SELECT NULL AS Age").build()).await?;

if let Some(row) = result_set.next().await {
    let is_null = row?.is_null("Age");
    println!("Is null: {}", is_null);
}

This is a convenience wrapper around try_is_null.

§Panics

Panics if the column name or index is invalid.

Source

pub fn try_get<T: FromValue, I: ColumnIndex>(&self, index: I) -> Result<T>

Retrieves a value from the row by column name or zero-based index.

§Example

let client = Spanner::builder().build().await?;
let db_client = client.database_client("projects/p/instances/i/databases/d").build().await?;
let transaction = db_client.single_use().build();
let mut result_set = transaction.execute_query(Statement::builder("SELECT 42 AS Age").build()).await?;

if let Some(row) = result_set.next().await {
    let age: i64 = row?.try_get("Age")?;
    println!("Age: {}", age);
}

§Arguments

index - The column name (string) or index (zero-based integer).

§Returns

Ok(T) if the value was successfully retrieved and converted to type T.
Err(Error) if:
- The column name or index is invalid.
- The column value is incompatible with type T.

Source

pub fn get<T: FromValue, I: ColumnIndex>(&self, index: I) -> T

Retrieves a value from the row by column name or zero-based index, panicking on error.

§Example

let client = Spanner::builder().build().await?;
let db_client = client.database_client("projects/p/instances/i/databases/d").build().await?;
let transaction = db_client.single_use().build();
let mut result_set = transaction.execute_query(Statement::builder("SELECT 42 AS Age").build()).await?;

if let Some(row) = result_set.next().await {
    let age: i64 = row?.get("Age");
    println!("Age: {}", age);
}