method Query.sqlWhere
Adds a raw SQL condition (use bind for values).
Example:
use std.orm { Db }
@table("items")
data Item {
@pk id: i64
name: str
price: i64
}
fn main() io, db {
let db = Db.open("sqlite::memory:")!
db.insert(Item{ id: 1, name: "tea", price: 3 })
db.insert(Item{ id: 2, name: "cake", price: 9 })
print("{db.Item.query().sqlWhere("name = 'cake'").count()}")
db.close()
}Output
1
pub(api) fn sqlWhere(sql: str) -> Query<T>Since. 1.0.0-beta
Parameters
| Name | Type |
|---|---|
sql | str |
Returns
Query<T>
Effects
none declared (pure unless the body says otherwise)
Defined in: std/orm/orm.oxl:772