Skip to main content

sql

renox_core::db

Function sql 

Source 
pub fn sql(sql: impl Into<String>) -> Sql
Expand description

A raw SQL statement with ? placeholders.

let rows = renox::db::sql("SELECT name FROM products WHERE price < ?")
    .bind(20_000)
    .fetch_all(&db)
    .await?;
let name: String = rows[0].try_get("name")?;

let total: i64 = renox::db::sql("SELECT COUNT(*) FROM products").scalar(&db).await?;