class Orb::Query
- Orb::Query
- Reference
- Object
Defined in:
query.crquery/combine_clause.cr
query/delete.cr
query/distinct.cr
query/fragment.cr
query/from.cr
query/group_by.cr
query/helpers.cr
query/insert.cr
query/join.cr
query/limit.cr
query/multi_insert.cr
query/offset.cr
query/order_by.cr
query/result.cr
query/select.cr
query/select_distinct.cr
query/update.cr
query/where.cr
Constant Summary
-
CLAUSE_PRIORITY =
{MultiInsert => 1, Insert => 1, Delete => 1, Update => 1, Select => 1, Distinct => 1, SelectDistinct => 1, From => 2, OrderBy => 3, Join => 4, Where => 5, GroupBy => 6, Limit => 7, Offset => 8}
Instance Method Summary
- #commit
- #count : Int64
- #cross_join(table, columns)
- #delete(table)
- #distinct(*columns)
- #from(table)
- #full_join(table, columns)
- #group_by(*columns)
- #inner_join(table, columns)
- #insert(table, values)
- #insert(relation : Orb::Relation)
- #join(table, columns)
- #left_join(table, columns)
- #limit(value)
- #map_to(klass : Nil)
- #multi_insert(table, values)
- #multi_insert(relations : Array(Orb::Relation))
- #offset(value)
- #or_where(column, operator, value)
- #or_where(column, value)
- #or_where(fragment : Fragment)
- #or_where(**conditions)
- #order_by(col : String | Symbol)
- #order_by(order_by : Array(Tuple(String, String)))
- #right_join(table, columns)
- #select(fragment : Fragment)
- #select(columns : Array(String))
- #select(klass : Orb::Relation.class)
- #select(*columns)
- #to_a
- #to_result
- #update(table, values)
- #update(relation : Orb::Relation)
- #where(column, operator, value)
- #where(column, value)
- #where(fragment : Fragment)
- #where(**conditions)