class Report::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(Report)

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(Report)

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(Report)

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(Report)

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_company(record : Report, force : Bool = false) : Report #

def self.preload_company(record : Report, force : Bool = false, &) : Report #

def self.preload_company(record : Report, preload_query : Company::BaseQuery, force : Bool = false) : Report #

def self.preload_company(records : Enumerable(Report), force : Bool = false) : Array(Report) #

def self.preload_company(records : Enumerable(Report), force : Bool = false, &) : Array(Report) #

def self.preload_company(records : Enumerable(Report), preload_query : Company::BaseQuery, force : Bool = false) : Array(Report) #

def self.preload_manufactory(record : Report, force : Bool = false) : Report #

def self.preload_manufactory(record : Report, force : Bool = false, &) : Report #

def self.preload_manufactory(record : Report, preload_query : Manufactory::BaseQuery, force : Bool = false) : Report #

def self.preload_manufactory(records : Enumerable(Report), force : Bool = false) : Array(Report) #

def self.preload_manufactory(records : Enumerable(Report), force : Bool = false, &) : Array(Report) #

def self.preload_manufactory(records : Enumerable(Report), preload_query : Manufactory::BaseQuery, force : Bool = false) : Array(Report) #

def self.preload_process_line(record : Report, force : Bool = false) : Report #

def self.preload_process_line(record : Report, force : Bool = false, &) : Report #

def self.preload_process_line(record : Report, preload_query : ProcessLine::BaseQuery, force : Bool = false) : Report #

def self.preload_process_line(records : Enumerable(Report), force : Bool = false) : Array(Report) #

def self.preload_process_line(records : Enumerable(Report), force : Bool = false, &) : Array(Report) #

def self.preload_process_line(records : Enumerable(Report), preload_query : ProcessLine::BaseQuery, force : Bool = false) : Array(Report) #

def self.preload_workshop(record : Report, force : Bool = false) : Report #

def self.preload_workshop(record : Report, force : Bool = false, &) : Report #

def self.preload_workshop(record : Report, preload_query : Workshop::BaseQuery, force : Bool = false) : Report #

def self.preload_workshop(records : Enumerable(Report), force : Bool = false) : Array(Report) #

def self.preload_workshop(records : Enumerable(Report), force : Bool = false, &) : Array(Report) #

def self.preload_workshop(records : Enumerable(Report), preload_query : Workshop::BaseQuery, force : Bool = false) : Array(Report) #

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 clone #

Returns a copy of self with all instance variables cloned.


def company_id(value) #

def company_id #

def created_at(value) #

def created_at #

def find(id) #

def full_join_company #

def full_join_manufactory #

def full_join_process_line #

def full_join_workshop #

def id(value) #

def id #

def inner_join_company #

def inner_join_manufactory #

def inner_join_process_line #

def inner_join_workshop #

def join_company #

def join_manufactory #

def join_process_line #

def join_workshop #

def left_join_company #

def left_join_manufactory #

def left_join_process_line #

def left_join_workshop #

def manufactory_id(value) #

def manufactory_id #

def preload_company(preload_query : Company::BaseQuery) : self #

def preload_company : self #

def preload_company(&) : self #

def preload_manufactory(preload_query : Manufactory::BaseQuery) : self #

def preload_manufactory : self #

def preload_manufactory(&) : self #

def preload_process_line(preload_query : ProcessLine::BaseQuery) : self #

def preload_process_line : self #

def preload_process_line(&) : self #

def preload_workshop(preload_query : Workshop::BaseQuery) : self #

def preload_workshop : self #

def preload_workshop(&) : self #

def process_line_id(value) #

def process_line_id #

def processed_total_count(value) #

def processed_total_count #

def qualified_total_count(value) #

def qualified_total_count #

def report_date(value) #

def report_date #

def report_month_num(value) #

def report_month_num #

def report_week_num(value) #

def report_week_num #

def report_year_num(value) #

def report_year_num #

def right_join_company #

def right_join_manufactory #

def right_join_process_line #

def right_join_workshop #

def target_total_count(value) #

def target_total_count #

def update(id : Int64 | Avram::Nothing = Avram::Nothing.new, created_at : Time | Avram::Nothing = Avram::Nothing.new, updated_at : Time | Avram::Nothing = Avram::Nothing.new, target_total_count : Int32 | Avram::Nothing = Avram::Nothing.new, processed_total_count : Int32 | Avram::Nothing = Avram::Nothing.new, qualified_total_count : Int32 | Avram::Nothing = Avram::Nothing.new, report_date : String | Avram::Nothing = Avram::Nothing.new, report_year_num : Int32 | Avram::Nothing = Avram::Nothing.new, report_month_num : Int32 | Avram::Nothing = Avram::Nothing.new, report_week_num : Int32 | Avram::Nothing = Avram::Nothing.new, process_line_id : ProcessLine::PrimaryKeyType | Avram::Nothing = Avram::Nothing.new, workshop_id : Workshop::PrimaryKeyType | Avram::Nothing = Avram::Nothing.new, manufactory_id : Manufactory::PrimaryKeyType | Avram::Nothing = Avram::Nothing.new, company_id : Company::PrimaryKeyType | Avram::Nothing = Avram::Nothing.new) : Int64 #
Description copied from module Avram::Queryable(Report)

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 where_company(assoc_query : Company::BaseQuery, auto_inner_join : Bool = true) #

def where_manufactory(assoc_query : Manufactory::BaseQuery, auto_inner_join : Bool = true) #

def where_process_line(assoc_query : ProcessLine::BaseQuery, auto_inner_join : Bool = true) #

def where_workshop(assoc_query : Workshop::BaseQuery, auto_inner_join : Bool = true) #

def workshop_id(value) #

def workshop_id #

Macro Detail

macro generate_criteria_method(name, type) #