Struct SqlQuery 

pub struct SqlQuery {
    pub sql: String,
    pub params: Vec<Value>,
    pub table: Option<String>,
    pub is_count: bool,
}

SQL query with parameters

Fields

sql: String

SQL statement

params: Vec<Value>

Query parameters

table: Option<String>

Source table

is_count: bool

Is a count query

Implementations

impl SqlQuery

pub fn new(sql: impl Into<String>) -> Self

Create a new SQL query

pub fn param(self, value: Value) -> Self

Add a parameter

pub fn from_table(self, table: impl Into<String>) -> Self

Set the source table

pub fn count(self) -> Self

Mark as count query

pub fn placeholder(index: usize) -> String

Get the parameter placeholder for the given index

Trait Implementations

impl Clone for SqlQuery

fn clone(&self) -> SqlQuery

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SqlQuery

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

Formats the value using the given formatter.