class

Merchant::BaseQuery

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

Class methods

all
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)
preload_user(records : Enumerable, preload_query)
preload_user(record, preload_query)
preload_user(records : Enumerable)
preload_user(record)
preload_user(records : Enumerable, &)
preload_user(record, &)
truncate

Instance methods

clone

Returns a copy of self with all instance variables cloned.

created_at(value)
created_at
description(value)
description
find(id)
full_join_user
id(value)
id
inner_join_user
join_user
left_join_user
name(value)
name
preload_user(preload_query : User::BaseQuery)
preload_user
preload_user
right_join_user
update(id : UUID | Nothing = Nothing.new, created_at : Time | Nothing = Nothing.new, updated_at : Time | Nothing = Nothing.new, name : String | Nothing = Nothing.new, description : String | Nothing = Nothing.new, user_id : User::PrimaryKeyType | Nothing = 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
user
user_id(value)
user_id
where_user(assoc_query : User::BaseQuery, auto_inner_join : Bool = true)

Macros

generate_criteria_method(name, type)