Struct arel::sql::Sql

pub struct Sql {
    pub raw_value: String,
    pub bind_indexs: Vec<usize>,
    pub bind_values: Vec<Value>,
}

Fields

raw_value: String

bind_indexs: Vec<usize>

bind_values: Vec<Value>

Implementations

impl Sql

pub fn new<T: ToString>(value: T) -> Self

pub fn push_str<T: AsRef<str>>(&mut self, raw_str: T) -> &mut Self

pub fn push_strs<T: AsRef<str>>( &mut self, raw_strs: Vec<T>, separated_str: &str ) -> &mut Self

pub fn push_bind<V: Into<Value>>(&mut self, bind_value: V) -> &mut Self

pub fn push_binds<V: Into<Value>>( &mut self, bind_values: Vec<V>, separated_str: &str ) -> &mut Self

pub fn push_str_with_bind<T: AsRef<str>, V: Into<Value>>( &mut self, raw_str: T, bind_value: V ) -> &mut Self

pub fn push_sql(&mut self, sql: Sql) -> &mut Self

pub fn push_sqls(&mut self, sqls: Vec<Sql>, separated_str: &str) -> &mut Self

pub fn to_sql_string(&self) -> Result<String>

impl Sql

pub fn range_sql<K: AsRef<str>, V: ToString, R: RangeBounds<V>>( key: K, range: R ) -> Option<Sql>

Examples

let sql = arel::Sql::range_sql("age", ..18).unwrap();
assert_eq!(sql.to_sql_string().unwrap(), r#"age < 18"#);

let sql = arel::Sql::range_sql("age", ..=18).unwrap();
assert_eq!(sql.to_sql_string().unwrap(), r#"age <= 18"#);

let sql = arel::Sql::range_sql("age", 18..20).unwrap();
assert_eq!(sql.to_sql_string().unwrap(), r#"age >= 18 AND age < 20"#);

let sql = arel::Sql::range_sql("age", 18..=20).unwrap();
assert_eq!(sql.to_sql_string().unwrap(), r#"age BETWEEN 18 AND 20"#);

let sql = arel::Sql::range_sql("age", (std::ops::Bound::Excluded(18), std::ops::Bound::Included(20))).unwrap();
assert_eq!(sql.to_sql_string().unwrap(), r#"age > 18 AND age <= 20"#);

let sql = arel::Sql::range_sql("age", 18..).unwrap();
assert_eq!(sql.to_sql_string().unwrap(), r#"age >= 18"#);

impl Sql

pub async fn exec<'a, E>(&self, executor: E) -> Result<DatabaseQueryResult>

where E: Executor<'a, Database = Database>,

pub async fn fetch_one_with_exec<'a, E>( &self, executor: E ) -> Result<DatabaseRow>

where E: Executor<'a, Database = Database>,

pub async fn fetch_one_as_with_exec<'a, T, E>(&self, executor: E) -> Result<T>

where for<'b> T: Send + Unpin + FromRow<'b, DatabaseRow>, E: Executor<'a, Database = Database>,

pub async fn fetch_one_optional_as_with_exec<'a, T, E>( &self, executor: E ) -> Result<Option<T>>

where for<'b> T: Send + Unpin + FromRow<'b, DatabaseRow>, E: Executor<'a, Database = Database>,

Trait Implementations

impl Clone for Sql

fn clone(&self) -> Sql

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for Sql

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

Formats the value using the given formatter.

impl Default for Sql

fn default() -> Self

Returns the “default value” for a type.

impl<T: ToString> From<T> for Sql

fn from(value: T) -> Self

Converts to this type from the input type.

impl<'a> TryFrom<&Sql> for QueryBuilder<'a>

type Error = Error

The type returned in the event of a conversion error.

fn try_from(sql: &Sql) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<Sql> for QueryBuilder<'a>

type Error = Error

The type returned in the event of a conversion error.

fn try_from(sql: Sql) -> Result<Self, Self::Error>

Performs the conversion.

impl TryFrom<Sql> for String

type Error = Error

The type returned in the event of a conversion error.

fn try_from(sql: Sql) -> Result<Self, Self::Error>

Performs the conversion.