class Good::BaseQuery

Included Modules

Direct Known Subclasses

Defined in:

Constructors

Class Method Summary

Instance Method Summary

Macro Summary

Constructor Detail

def self.all : self #

Class Method Detail

def self.any? : Bool #
Description copied from module Enumerable(Good)

Returns true if at least one of the collection's members is truthy.

[nil, true, 99].any? # => true
[nil, false].any?    # => false

def self.find(id) #

def self.first : T #
Description copied from module Enumerable(Good)

Returns the first element in the collection. Raises Enumerable::EmptyError if the collection is empty.

([1, 2, 3]).first   # => 1
([] of Int32).first # raises Enumerable::EmptyError

def self.first? : T | Nil #
Description copied from module Enumerable(Good)

Returns the first element in the collection. When the collection is empty, returns nil.

([1, 2, 3]).first?   # => 1
([] of Int32).first? # => nil

def self.last : T #

def self.last? : T | Nil #

def self.new_with_existing_query(query : Avram::QueryBuilder) #

def self.none? : Bool #
Description copied from module Enumerable(Good)

Returns true if all of the elements of the collection are falsey.

[nil, false].none?       # => true
[nil, false, true].none? # => false

It's the opposite of all?.


def self.preload_categories(records : Enumerable, preload_query) #

def self.preload_categories(record, preload_query) #

def self.preload_categories(records : Enumerable) #

def self.preload_categories(record) #

def self.preload_categories(records : Enumerable, &) #

def self.preload_categories(record, &) #

def self.preload_goods_categories(records : Enumerable, preload_query) #

def self.preload_goods_categories(record, preload_query) #

def self.preload_goods_categories(records : Enumerable) #

def self.preload_goods_categories(record) #

def self.preload_goods_categories(records : Enumerable, &) #

def self.preload_goods_categories(record, &) #

def self.preload_goods_in_stores(records : Enumerable, preload_query) #

def self.preload_goods_in_stores(record, preload_query) #

def self.preload_goods_in_stores(records : Enumerable) #

def self.preload_goods_in_stores(record) #

def self.preload_goods_in_stores(records : Enumerable, &) #

def self.preload_goods_in_stores(record, &) #

def self.preload_order_items(records : Enumerable, preload_query) #

def self.preload_order_items(record, preload_query) #

def self.preload_order_items(records : Enumerable) #

def self.preload_order_items(record) #

def self.preload_order_items(records : Enumerable, &) #

def self.preload_order_items(record, &) #

def self.preload_stores(records : Enumerable, preload_query) #

def self.preload_stores(record, preload_query) #

def self.preload_stores(records : Enumerable) #

def self.preload_stores(record) #

def self.preload_stores(records : Enumerable, &) #

def self.preload_stores(record, &) #

def self.preload_unit(records : Enumerable, preload_query) #

def self.preload_unit(record, preload_query) #

def self.preload_unit(records : Enumerable) #

def self.preload_unit(record) #

def self.preload_unit(records : Enumerable, &) #

def self.preload_unit(record, &) #

def self.truncate(*, cascade : Bool = false) #

Removes all data from a table using the TRUNCATE postgres SQL command.

You should run this command with cascade: true if your table columns are referenced by other foreign key constraints. Use delete instead if you don't want to accidentally delete rows referenced elsewhere.

To delete all data referenced by foreign keys as well, set cascade to true.


Instance Method Detail

def categories(&) #

def clone #

Returns a copy of self with all instance variables cloned.


def created_at(value) #

def created_at #

def description(value) #

def description #

def find(id) #

def full_join_categories #

def full_join_goods_categories #

def full_join_goods_in_stores #

def full_join_order_items #

def full_join_stores #

def full_join_unit #

def goods_categories(&) #

def goods_in_stores(&) #

def id(value) #

def id #

def inner_join_categories #

def inner_join_goods_categories #

def inner_join_goods_in_stores #

def inner_join_order_items #

def inner_join_stores #

def inner_join_unit #

def join_categories #

def join_goods_categories #

def join_goods_in_stores #

def join_order_items #

def join_stores #

def join_unit #

def left_join_categories #

def left_join_goods_categories #

def left_join_goods_in_stores #

def left_join_order_items #

def left_join_stores #

def left_join_unit #

def name(value) #

def name #

def order_items(&) #

def preload_categories(preload_query : Category::BaseQuery) #

def preload_categories #

def preload_categories(&) #

def preload_goods_categories(preload_query : GoodsCategory::BaseQuery) #

def preload_goods_categories #

def preload_goods_categories(&) #

def preload_goods_in_stores(preload_query : GoodsInStore::BaseQuery) #

def preload_goods_in_stores #

def preload_goods_in_stores(&) #

def preload_order_items(preload_query : OrderItem::BaseQuery) #

def preload_order_items #

def preload_order_items(&) #

def preload_stores(preload_query : Store::BaseQuery) #

def preload_stores #

def preload_stores(&) #

def preload_unit(preload_query : Unit::BaseQuery) #

def preload_unit #

def preload_unit(&) #

def price(value) #

def price #

def right_join_categories #

def right_join_goods_categories #

def right_join_goods_in_stores #

def right_join_order_items #

def right_join_stores #

def right_join_unit #

def stores(&) #

def unit(&) #

def unit_id(value) #

def unit_id #

def update(id : Int32 | Avram::Nothing = Avram::Nothing.new, created_at : Time | Avram::Nothing = Avram::Nothing.new, updated_at : Time | Avram::Nothing = Avram::Nothing.new, unit_id : Unit::PrimaryKeyType | Avram::Nothing | Nil = Avram::Nothing.new, name : String | Avram::Nothing = Avram::Nothing.new, description : String | Avram::Nothing = Avram::Nothing.new, price : Float64 | Avram::Nothing = Avram::Nothing.new, weight : Float64 | Avram::Nothing = Avram::Nothing.new) : Int64 #
Description copied from module Avram::Queryable(Good)

Update the records using the query's where clauses, or all records if no wheres are added.

Returns the number of records updated as Int64.

# Update all comments with the word "spam" as spam
CommentQuery.new.body.ilike("spam").update(spam: true)

def updated_at(value) #

def updated_at #

def weight(value) #

def weight #

def where_categories(assoc_query : Category::BaseQuery, auto_inner_join : Bool = true) #

def where_goods_categories(assoc_query : GoodsCategory::BaseQuery, auto_inner_join : Bool = true) #

def where_goods_in_stores(assoc_query : GoodsInStore::BaseQuery, auto_inner_join : Bool = true) #

def where_order_items(assoc_query : OrderItem::BaseQuery, auto_inner_join : Bool = true) #

def where_stores(assoc_query : Store::BaseQuery, auto_inner_join : Bool = true) #

def where_unit(assoc_query : Unit::BaseQuery, auto_inner_join : Bool = true) #

Macro Detail

macro generate_criteria_method(name, type) #