class

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

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

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

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

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

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

preload_poll_options(record : Poll, force : Bool = false) : Poll

preload_poll_options(record : Poll, force : Bool = false, &) : Poll

preload_poll_options(record : Poll, preload_query : PollOption::BaseQuery, force : Bool = false) : Poll

preload_poll_options(records : Enumerable(Poll), force : Bool = false) : Array(Poll)

preload_poll_options(records : Enumerable(Poll), force : Bool = false, &) : Array(Poll)

preload_poll_options(records : Enumerable(Poll), preload_query : PollOption::BaseQuery, force : Bool = false) : Array(Poll)

preload_poll_votes(record : Poll, force : Bool = false) : Poll

preload_poll_votes(record : Poll, force : Bool = false, &) : Poll

preload_poll_votes(record : Poll, preload_query : PollVote::BaseQuery, force : Bool = false) : Poll

preload_poll_votes(records : Enumerable(Poll), force : Bool = false) : Array(Poll)

preload_poll_votes(records : Enumerable(Poll), force : Bool = false, &) : Array(Poll)

preload_poll_votes(records : Enumerable(Poll), preload_query : PollVote::BaseQuery, force : Bool = false) : Array(Poll)

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

event_id(value)

event_id

find(id) : T

full_join_event(where_event : Event::BaseQuery)

full_join_event

full_join_poll_options(where_poll_options : PollOption::BaseQuery)

full_join_poll_options

full_join_poll_votes(where_poll_votes : PollVote::BaseQuery)

full_join_poll_votes

id(value)

inner_join_event(where_event : Event::BaseQuery)

inner_join_event

inner_join_poll_options(where_poll_options : PollOption::BaseQuery)

inner_join_poll_options

inner_join_poll_votes(where_poll_votes : PollVote::BaseQuery)

inner_join_poll_votes

is_locked(value)

is_locked

join_event(where_event : Event::BaseQuery)

join_event

join_poll_options(where_poll_options : PollOption::BaseQuery)

join_poll_options

join_poll_votes(where_poll_votes : PollVote::BaseQuery)

join_poll_votes

left_join_event(where_event : Event::BaseQuery)

left_join_event

left_join_poll_options(where_poll_options : PollOption::BaseQuery)

left_join_poll_options

left_join_poll_votes(where_poll_votes : PollVote::BaseQuery)

left_join_poll_votes

preload_event(preload_query : Event::BaseQuery) : self

preload_event

preload_poll_options(preload_query : PollOption::BaseQuery) : self

preload_poll_options

preload_poll_votes(preload_query : PollVote::BaseQuery) : self

preload_poll_votes

question(value)

question

right_join_event(where_event : Event::BaseQuery)

right_join_event

right_join_poll_options(where_poll_options : PollOption::BaseQuery)

right_join_poll_options

right_join_poll_votes(where_poll_votes : PollVote::BaseQuery)

right_join_poll_votes

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_event(assoc_query : Event::BaseQuery, auto_inner_join : Bool = true)

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

where_poll_options(assoc_query : PollOption::BaseQuery, auto_inner_join : Bool = true)

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

where_poll_votes(assoc_query : PollVote::BaseQuery, auto_inner_join : Bool = true)

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

Macros

generate_criteria_method(name, type)