class

ProcessLine::BaseQuery

Inherits Avram::PrimaryKeyQueryable < Avram::Queryable < Enumerable < Reference < Object

Constructors

all

Class methods

any?

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

[nil, true, 99].any? # => true
[nil, false].any?    # => false
([] of Int32).any?   # => false
  • #present? does not consider truthiness of elements.
  • #any?(&) and #any(pattern) allow custom conditions.

NOTE: #any? usually has the same semantics as #present?. They only differ if the element type can be falsey (i.e. T <= Nil || T <= Pointer || T <= Bool). It's typically advised to prefer #present? unless these specific truthiness semantics are required.

find(id)
first

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
first?

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

([1, 2, 3]).first?   # => 1
([] of Int32).first? # => nil
last
last?
new_with_existing_query(query : Avram::QueryBuilder)
none?

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?.

preload_company(record : ProcessLine, force : Bool = false) : ProcessLine
preload_company(record : ProcessLine, force : Bool = false, &) : ProcessLine
preload_company(record : ProcessLine, preload_query : Company::BaseQuery, force : Bool = false) : ProcessLine
preload_company(records : Enumerable(ProcessLine), force : Bool = false) : Array(ProcessLine)
preload_company(records : Enumerable(ProcessLine), force : Bool = false, &) : Array(ProcessLine)
preload_company(records : Enumerable(ProcessLine), preload_query : Company::BaseQuery, force : Bool = false) : Array(ProcessLine)
preload_manufactory(record : ProcessLine, force : Bool = false) : ProcessLine
preload_manufactory(record : ProcessLine, force : Bool = false, &) : ProcessLine
preload_manufactory(record : ProcessLine, preload_query : Manufactory::BaseQuery, force : Bool = false) : ProcessLine
preload_manufactory(records : Enumerable(ProcessLine), force : Bool = false) : Array(ProcessLine)
preload_manufactory(records : Enumerable(ProcessLine), force : Bool = false, &) : Array(ProcessLine)
preload_manufactory(records : Enumerable(ProcessLine), preload_query : Manufactory::BaseQuery, force : Bool = false) : Array(ProcessLine)
preload_products(record : ProcessLine, force : Bool = false) : ProcessLine
preload_products(record : ProcessLine, force : Bool = false, &) : ProcessLine
preload_products(record : ProcessLine, preload_query : Product::BaseQuery, force : Bool = false) : ProcessLine
preload_products(records : Enumerable(ProcessLine), force : Bool = false) : Array(ProcessLine)
preload_products(records : Enumerable(ProcessLine), force : Bool = false, &) : Array(ProcessLine)
preload_products(records : Enumerable(ProcessLine), preload_query : Product::BaseQuery, force : Bool = false) : Array(ProcessLine)
preload_reports(record : ProcessLine, force : Bool = false) : ProcessLine
preload_reports(record : ProcessLine, force : Bool = false, &) : ProcessLine
preload_reports(record : ProcessLine, preload_query : Report::BaseQuery, force : Bool = false) : ProcessLine
preload_reports(records : Enumerable(ProcessLine), force : Bool = false) : Array(ProcessLine)
preload_reports(records : Enumerable(ProcessLine), force : Bool = false, &) : Array(ProcessLine)
preload_reports(records : Enumerable(ProcessLine), preload_query : Report::BaseQuery, force : Bool = false) : Array(ProcessLine)
preload_workshop(record : ProcessLine, force : Bool = false) : ProcessLine
preload_workshop(record : ProcessLine, force : Bool = false, &) : ProcessLine
preload_workshop(record : ProcessLine, preload_query : Workshop::BaseQuery, force : Bool = false) : ProcessLine
preload_workshop(records : Enumerable(ProcessLine), force : Bool = false) : Array(ProcessLine)
preload_workshop(records : Enumerable(ProcessLine), force : Bool = false, &) : Array(ProcessLine)
preload_workshop(records : Enumerable(ProcessLine), preload_query : Workshop::BaseQuery, force : Bool = false) : Array(ProcessLine)
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 methods

clone

Returns a copy of self with all instance variables cloned.

company_id(value)
company_id
created_at(value)
created_at
find(id)
full_join_company
full_join_manufactory
full_join_products
full_join_reports
full_join_workshop
id(value)
id
inner_join_company
inner_join_manufactory
inner_join_products
inner_join_reports
inner_join_workshop
join_company
join_manufactory
join_products
join_reports
join_workshop
left_join_company
left_join_manufactory
left_join_products
left_join_reports
left_join_workshop
manufactory_id(value)
manufactory_id
name(value)
name
preload_company(preload_query : Company::BaseQuery) : self
preload_company
preload_company
preload_manufactory(preload_query : Manufactory::BaseQuery) : self
preload_manufactory
preload_manufactory
preload_products(preload_query : Product::BaseQuery) : self
preload_products
preload_products
preload_reports(preload_query : Report::BaseQuery) : self
preload_reports
preload_reports
preload_workshop(preload_query : Workshop::BaseQuery) : self
preload_workshop
preload_workshop
right_join_company
right_join_manufactory
right_join_products
right_join_reports
right_join_workshop
update(id : Int64 | Avram::Nothing = Avram::Nothing.new, created_at : Time | Avram::Nothing = Avram::Nothing.new, updated_at : Time | Avram::Nothing = Avram::Nothing.new, name : String | Avram::Nothing = Avram::Nothing.new, company_id : Company::PrimaryKeyType | Avram::Nothing = Avram::Nothing.new, manufactory_id : Manufactory::PrimaryKeyType | Avram::Nothing = Avram::Nothing.new, workshop_id : Workshop::PrimaryKeyType | Avram::Nothing = Avram::Nothing.new) : Int64

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)
updated_at(value)
updated_at
where_company(assoc_query : Company::BaseQuery, auto_inner_join : Bool = true)
where_manufactory(assoc_query : Manufactory::BaseQuery, auto_inner_join : Bool = true)
where_products(assoc_query : Product::BaseQuery, auto_inner_join : Bool = true)
where_reports(assoc_query : Report::BaseQuery, auto_inner_join : Bool = true)
where_workshop(assoc_query : Workshop::BaseQuery, auto_inner_join : Bool = true)
workshop_id(value)
workshop_id

Macros

generate_criteria_method(name, type)