class

Guest::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_dependent_guests(record : Guest, force : Bool = false) : Guest

preload_dependent_guests(record : Guest, force : Bool = false, &) : Guest

preload_dependent_guests(record : Guest, preload_query : DependentGuest::BaseQuery, force : Bool = false) : Guest

preload_dependent_guests(records : Enumerable(Guest), force : Bool = false) : Array(Guest)

preload_dependent_guests(records : Enumerable(Guest), force : Bool = false, &) : Array(Guest)

preload_dependent_guests(records : Enumerable(Guest), preload_query : DependentGuest::BaseQuery, force : Bool = false) : Array(Guest)

preload_event(record : Guest, force : Bool = false) : Guest

preload_event(record : Guest, force : Bool = false, &) : Guest

preload_event(record : Guest, preload_query : Event::BaseQuery, force : Bool = false) : Guest

preload_event(records : Enumerable(Guest), force : Bool = false) : Array(Guest)

preload_event(records : Enumerable(Guest), force : Bool = false, &) : Array(Guest)

preload_event(records : Enumerable(Guest), preload_query : Event::BaseQuery, force : Bool = false) : Array(Guest)

preload_tasks(record : Guest, force : Bool = false) : Guest

preload_tasks(record : Guest, force : Bool = false, &) : Guest

preload_tasks(record : Guest, preload_query : Task::BaseQuery, force : Bool = false) : Guest

preload_tasks(records : Enumerable(Guest), force : Bool = false) : Array(Guest)

preload_tasks(records : Enumerable(Guest), force : Bool = false, &) : Array(Guest)

preload_tasks(records : Enumerable(Guest), preload_query : Task::BaseQuery, force : Bool = false) : Array(Guest)

preload_user(record : Guest, force : Bool = false) : Guest

preload_user(record : Guest, force : Bool = false, &) : Guest

preload_user(record : Guest, preload_query : User::BaseQuery, force : Bool = false) : Guest

preload_user(records : Enumerable(Guest), force : Bool = false) : Array(Guest)

preload_user(records : Enumerable(Guest), force : Bool = false, &) : Array(Guest)

preload_user(records : Enumerable(Guest), preload_query : User::BaseQuery, force : Bool = false) : Array(Guest)

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

answered_at(value)

answered_at

cancelled_at(value)

cancelled_at

clone

Returns a copy of self with all instance variables cloned.

confirmed_at(value)

confirmed_at

created_at(value)

created_at

declined_at(value)

declined_at

event_id(value)

event_id

find(id) : T

full_join_dependent_guests(where_dependent_guests : DependentGuest::BaseQuery)

full_join_dependent_guests

full_join_event(where_event : Event::BaseQuery)

full_join_event

full_join_tasks(where_tasks : Task::BaseQuery)

full_join_tasks

full_join_user(where_user : User::BaseQuery)

full_join_user

guest_count(value)

guest_count

id(value)

inner_join_dependent_guests(where_dependent_guests : DependentGuest::BaseQuery)

inner_join_dependent_guests

inner_join_event(where_event : Event::BaseQuery)

inner_join_event

inner_join_tasks(where_tasks : Task::BaseQuery)

inner_join_tasks

inner_join_user(where_user : User::BaseQuery)

inner_join_user

join_dependent_guests(where_dependent_guests : DependentGuest::BaseQuery)

join_dependent_guests

join_event(where_event : Event::BaseQuery)

join_event

join_tasks(where_tasks : Task::BaseQuery)

join_tasks

join_user(where_user : User::BaseQuery)

join_user

left_join_dependent_guests(where_dependent_guests : DependentGuest::BaseQuery)

left_join_dependent_guests

left_join_event(where_event : Event::BaseQuery)

left_join_event

left_join_tasks(where_tasks : Task::BaseQuery)

left_join_tasks

left_join_user(where_user : User::BaseQuery)

left_join_user

notes(value)

notes

preload_dependent_guests(preload_query : DependentGuest::BaseQuery) : self

preload_dependent_guests

preload_event(preload_query : Event::BaseQuery) : self

preload_event

preload_tasks(preload_query : Task::BaseQuery) : self

preload_tasks

preload_user(preload_query : User::BaseQuery) : self

preload_user

right_join_dependent_guests(where_dependent_guests : DependentGuest::BaseQuery)

right_join_dependent_guests

right_join_event(where_event : Event::BaseQuery)

right_join_event

right_join_tasks(where_tasks : Task::BaseQuery)

right_join_tasks

right_join_user(where_user : User::BaseQuery)

right_join_user

status(value)

status

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_id(value)

user_id

where_dependent_guests(assoc_query : DependentGuest::BaseQuery, auto_inner_join : Bool = true)

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

where_event(assoc_query : Event::BaseQuery, auto_inner_join : Bool = true)

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

where_tasks(assoc_query : Task::BaseQuery, auto_inner_join : Bool = true)

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

where_user(assoc_query : User::BaseQuery, auto_inner_join : Bool = true)

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

Macros

generate_criteria_method(name, type)