class

Change::SQL::Query

Inherits Reference < Object

Constructors

new

Instance methods

from(source : String) : self

froms

froms=(froms : Array(Change::SQL::FromExpr))

limit(number) : self

limit

limit=(limit : Int32 | Nil)

limit?

offset(number) : self

offset

offset=(offset : Int32 | Nil)

offset?

only_from(source : String) : self

only_order(orders) : self

only_select(columns : Array) : self

The only_ methods are clones of all the other methods, but clear out any other existing entries in that expression list beforehand.

Using these methods can guarantee that values are controlled and not composed with any previous values.

only_update(updates) : self

only_where(conditions) : self

order(orders) : self

order

orders

orders=(orders : Array(Change::SQL::OrderExpr))

select(columns : Array) : self

selects

selects=(selects : Array(Change::SQL::SelectExpr))

update(updates) : self

update

updates

updates=(updates : Array(Change::SQL::UpdateExpr))

where(conditions) : self

where

wheres

Currently all ANDd together

wheres=(wheres : Array(Change::SQL::WhereExpr))

Currently all ANDd together

without_limit

LIMIT and OFFSET do not have only_ methods, since they can only contain a single value to start with. Instead, they have without methods to remove any existing value

without_offset