class

SecretSantaAssignment::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) : T
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_giver(record : SecretSantaAssignment, force : Bool = false) : SecretSantaAssignment
preload_giver(record : SecretSantaAssignment, force : Bool = false, &) : SecretSantaAssignment
preload_giver(record : SecretSantaAssignment, preload_query : Guest::BaseQuery, force : Bool = false) : SecretSantaAssignment
preload_giver(records : Enumerable(SecretSantaAssignment), force : Bool = false) : Array(SecretSantaAssignment)
preload_giver(records : Enumerable(SecretSantaAssignment), force : Bool = false, &) : Array(SecretSantaAssignment)
preload_giver(records : Enumerable(SecretSantaAssignment), preload_query : Guest::BaseQuery, force : Bool = false) : Array(SecretSantaAssignment)
preload_receiver(record : SecretSantaAssignment, force : Bool = false) : SecretSantaAssignment
preload_receiver(record : SecretSantaAssignment, force : Bool = false, &) : SecretSantaAssignment
preload_receiver(record : SecretSantaAssignment, preload_query : Guest::BaseQuery, force : Bool = false) : SecretSantaAssignment
preload_receiver(records : Enumerable(SecretSantaAssignment), force : Bool = false) : Array(SecretSantaAssignment)
preload_receiver(records : Enumerable(SecretSantaAssignment), force : Bool = false, &) : Array(SecretSantaAssignment)
preload_receiver(records : Enumerable(SecretSantaAssignment), preload_query : Guest::BaseQuery, force : Bool = false) : Array(SecretSantaAssignment)
preload_secret_santa(record : SecretSantaAssignment, force : Bool = false) : SecretSantaAssignment
preload_secret_santa(record : SecretSantaAssignment, force : Bool = false, &) : SecretSantaAssignment
preload_secret_santa(record : SecretSantaAssignment, preload_query : SecretSanta::BaseQuery, force : Bool = false) : SecretSantaAssignment
preload_secret_santa(records : Enumerable(SecretSantaAssignment), force : Bool = false) : Array(SecretSantaAssignment)
preload_secret_santa(records : Enumerable(SecretSantaAssignment), force : Bool = false, &) : Array(SecretSantaAssignment)
preload_secret_santa(records : Enumerable(SecretSantaAssignment), preload_query : SecretSanta::BaseQuery, force : Bool = false) : Array(SecretSantaAssignment)
truncate(*, cascade : Bool = false, restart_identity : 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.

created_at(value)
created_at
find(id) : T
full_join_giver(where_giver : Guest::BaseQuery)
full_join_giver
full_join_receiver(where_receiver : Guest::BaseQuery)
full_join_receiver
full_join_secret_santa(where_secret_santa : SecretSanta::BaseQuery)
full_join_secret_santa
giver_id(value)
giver_id
id(value)
id
inner_join_giver(where_giver : Guest::BaseQuery)
inner_join_giver
inner_join_receiver(where_receiver : Guest::BaseQuery)
inner_join_receiver
inner_join_secret_santa(where_secret_santa : SecretSanta::BaseQuery)
inner_join_secret_santa
join_giver(where_giver : Guest::BaseQuery)
join_giver
join_receiver(where_receiver : Guest::BaseQuery)
join_receiver
join_secret_santa(where_secret_santa : SecretSanta::BaseQuery)
join_secret_santa
left_join_giver(where_giver : Guest::BaseQuery)
left_join_giver
left_join_receiver(where_receiver : Guest::BaseQuery)
left_join_receiver
left_join_secret_santa(where_secret_santa : SecretSanta::BaseQuery)
left_join_secret_santa
notes(value)
notes
preload_giver(preload_query : Guest::BaseQuery) : self
preload_giver
preload_giver
preload_receiver(preload_query : Guest::BaseQuery) : self
preload_receiver
preload_receiver
preload_secret_santa(preload_query : SecretSanta::BaseQuery) : self
preload_secret_santa
preload_secret_santa
receiver_id(value)
receiver_id
right_join_giver(where_giver : Guest::BaseQuery)
right_join_giver
right_join_receiver(where_receiver : Guest::BaseQuery)
right_join_receiver
right_join_secret_santa(where_secret_santa : SecretSanta::BaseQuery)
right_join_secret_santa
secret_santa_id(value)
secret_santa_id
status(value)
status
update(id : Int64 | Avram::Nothing = IGNORE, created_at : Time | Avram::Nothing = IGNORE, updated_at : Time | Avram::Nothing = IGNORE, status : SecretSantaAssignment::Status | Avram::Nothing = IGNORE, notes : String | Avram::Nothing | Nil = IGNORE, secret_santa_id : SecretSanta::PrimaryKeyType | Avram::Nothing = IGNORE, giver_id : Guest::PrimaryKeyType | Avram::Nothing = IGNORE, receiver_id : Guest::PrimaryKeyType | Avram::Nothing = IGNORE) : 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_giver(assoc_query : Guest::BaseQuery, auto_inner_join : Bool = true)

DEPRECATED Use any of the join methods with a where_giver argument instead

where_receiver(assoc_query : Guest::BaseQuery, auto_inner_join : Bool = true)

DEPRECATED Use any of the join methods with a where_receiver argument instead

where_secret_santa(assoc_query : SecretSanta::BaseQuery, auto_inner_join : Bool = true)

DEPRECATED Use any of the join methods with a where_secret_santa argument instead

Macros

generate_criteria_method(name, type)