query

The main Query module that provides a high-level API for building SQL queries It is built on top of the Cake library to provide a more ergonomic interface, but can easily be exported to standard cake-select queries.

Types

Query

</>

pub type Query {
  Query(table: create.Table, select: select.Select)
}

Constructors

Query(table: create.Table, select: select.Select)

Functions

equals

</>

pub fn equals(query: Query, column: String, value: a) -> Query

export

</>

pub fn export(query: Query) -> Select

from_table

</>

pub fn from_table(table: Table) -> Query

greater_than

</>

pub fn greater_than(
  query: Query,
  column: String,
  value: a,
) -> Query

inner_join

</>

pub fn inner_join(query: Query, target_table: Table) -> Query

join

</>

pub fn join(
  query: Query,
  target_table: Table,
  join_type: fn(JoinTarget, Where, String) -> Join,
) -> Query

left_join

</>

pub fn left_join(query: Query, target_table: Table) -> Query

less_than

</>

pub fn less_than(query: Query, column: String, value: a) -> Query

order_by

</>

pub fn order_by(
  query: Query,
  column: String,
  direction: Direction,
) -> Query

select

</>

pub fn select(query: Query, columns: List(String)) -> Query

sql

</>

pub fn sql(query: Query) -> #(String, List(Param))