Struct QueryBuilder 

pub struct QueryBuilder { /* private fields */ }

Incrementally build a SQL query with bound parameters.

Implementations

impl QueryBuilder

pub fn new() -> Self

Create a new, empty query builder.

pub fn push_sql(&mut self, sql: &str)

Append raw SQL to the query.

pub fn push_raw(&mut self, raw: &str)

Append raw SQL and mark the query as tainted.

pub fn push_bind<T: Encode>(&mut self, value: &T) -> Result<()>

Add a positional bind parameter and append the placeholder.

pub fn push_bind_named<T: Encode>( &mut self, name: &str, value: &T, ) -> Result<()>

Add a named bind parameter and append the placeholder.

pub fn push_values<I, T>(&mut self, iter: I) -> Result<()>

where I: IntoIterator<Item = T>, T: Encode,

Append a comma-separated list of bound values.

pub fn push_idents<I>(&mut self, iter: I) -> Result<()>

where I: IntoIterator, I::Item: AsRef<str>,

Append a comma-separated list of quoted identifiers.

pub fn push_insert(&mut self, values: &Values) -> Result<()>

Append an INSERT column/value list from provided values.

pub fn push_set(&mut self, values: &Values) -> Result<()>

Append a SET clause from provided values.

pub fn push_where(&mut self, values: &Values) -> Result<()>

Append a WHERE clause from provided values.

pub fn push_upsert(&mut self, values: &Values, exclude: &[&str]) -> Result<()>

Append an UPSERT update clause, excluding the named columns.

pub fn push_query(&mut self, query: Query)

Appends another Query to this builder.

The SQL of the provided query is appended to this builder with a single space in between if needed. All arguments from the other query are merged and indices for named parameters are re-based to ensure they refer to the correct values.

This method panics if the appended query contains numeric positional placeholders such as ?1 or numeric $1. Use QueryBuilder::try_push_query to handle unsupported composition as an error.

pub fn try_push_query(&mut self, query: Query) -> Result<()>

Attempt to append another Query to this builder.

Numeric positional placeholders such as ?1 and numeric $1 are rejected in appended fragments because their absolute SQLite indices cannot be safely rebased by the current composition machinery.

pub fn build(self) -> Query

Finalize the builder into a Query.

Trait Implementations

impl Default for QueryBuilder

fn default() -> QueryBuilder

Returns the “default value” for a type.