class Change::SQL::Query
- Change::SQL::Query
- Reference
- Object
Defined in:
change/sql/query.crConstructors
Instance Method Summary
- #from(source : String) : self
- #froms : Array(Change::SQL::FromExpr)
- #froms=(froms : Array(Change::SQL::FromExpr))
- #limit(number) : self
- #limit : Int32 | Nil
- #limit=(limit : Int32 | Nil)
- #limit? : Int32 | Nil | Nil
- #offset(number) : self
- #offset : Int32 | Nil
- #offset=(offset : Int32 | Nil)
- #offset? : Int32 | Nil | Nil
- #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. - #only_update(updates) : self
- #only_where(conditions) : self
- #order(orders) : self
- #order(**orders) : self
- #orders : Array(Change::SQL::OrderExpr)
- #orders=(orders : Array(Change::SQL::OrderExpr))
- #select(columns : Array) : self
- #selects : Array(Change::SQL::SelectExpr)
- #selects=(selects : Array(Change::SQL::SelectExpr))
- #update(updates) : self
- #update(**conditions) : self
- #updates : Array(Change::SQL::UpdateExpr)
- #updates=(updates : Array(Change::SQL::UpdateExpr))
- #where(conditions) : self
- #where(**conditions) : self
-
#wheres : Array(Change::SQL::WhereExpr)
Currently all
AND
d together -
#wheres=(wheres : Array(Change::SQL::WhereExpr))
Currently all
AND
d together -
#without_limit : self
LIMIT and OFFSET do not have
only_
methods, since they can only contain a single value to start with. - #without_offset : self
Constructor Detail
Instance Method Detail
def 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.
def without_limit : self
#
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