OxL Reference
EnglishРусский

method Query.sqlOrder

Adds a raw SQL ORDER BY expression.

Example:

oxl✓ checked in CI
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 })
  let rows = db.Item.query().sqlOrder("price DESC").run()
  print(rows[0].name)
  db.close()
}
Output
cake
pub(api) fn sqlOrder(sql: str) -> Query<T>

Since. 1.0.0-beta

Parameters

NameType
sqlstr

Returns

Query<T>

Effects

none declared (pure unless the body says otherwise)

Defined in: std/orm/orm.oxl:801

See also