Struct light_snowflake_connector::Statement

pub struct Statement { /* private fields */ }

A builder for a prepared statement (created by SnowflakeClient)

Implementations

impl Statement

pub fn new(sql: &str, config: &SnowflakeClient) -> Statement

Create a new statement from a SQL string and a SnowflakeClient

Usually you will want to use SnowflakeClient::prepare instead of this method but the difference is merely ergonomic.

pub async fn query(&self) -> Result<QueryResponse, SnowflakeError>

Execute SQL that returns a result set

This supports multiple partitions, which are streamed lazily but the first partition is buffered immediately.

For a single partition, consider using QueryResponse::only_partition.

pub async fn manipulate(&self) -> Result<Changes, SnowflakeError>

Execute SQL that does not return a result set

This is useful for DML statements like INSERT, UPDATE, and DELETE

pub fn with_timeout(self, timeout_seconds: u64) -> Statement

Set the Snowflake-side timeout for the statement

The client-side timeout will automatically be set to this value plus 15 seconds

The default server side timeout is 172800 seconds (2 days), which is far too long for the use cases this library is targeting, so this library defaults to 30 seconds on the server side if not specified, implying a client-side timeout of 45 seconds.

pub fn add_binding<T: Into<Binding>>(self, value: T) -> Statement

Add a binding to the statement

Several types are supported:

• All integers are converted to i128 and bound as NUMBER
• f64 and f32 are bound as REAL
• bool, &str, String, chrono::NaiveDate, chrono::NaiveDateTime, and chrono::NaiveTime are bound as TEXT

More types may be supported in the future.

Text is the most flexible type, and for additional types you can usually workaround by converting to text before binding. Or, you could contribute to this library and add support

Trait Implementations

impl Clone for Statement

fn clone(&self) -> Statement

Returns a copy 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.