class

CollectPoint::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_collect_points_tour(record : CollectPoint, force : Bool = false) : CollectPoint
preload_collect_points_tour(record : CollectPoint, force : Bool = false, &) : CollectPoint
preload_collect_points_tour(record : CollectPoint, preload_query : CollectPointsTour::BaseQuery, force : Bool = false) : CollectPoint
preload_collect_points_tour(records : Enumerable(CollectPoint), force : Bool = false) : Array(CollectPoint)
preload_collect_points_tour(records : Enumerable(CollectPoint), force : Bool = false, &) : Array(CollectPoint)
preload_collect_points_tour(records : Enumerable(CollectPoint), preload_query : CollectPointsTour::BaseQuery, force : Bool = false) : Array(CollectPoint)
preload_tours(record : CollectPoint, force : Bool = false) : CollectPoint
preload_tours(record : CollectPoint, force : Bool = false, &) : CollectPoint
preload_tours(record : CollectPoint, preload_query : Tour::BaseQuery, force : Bool = false) : CollectPoint
preload_tours(records : Enumerable(CollectPoint), force : Bool = false) : Array(CollectPoint)
preload_tours(records : Enumerable(CollectPoint), force : Bool = false, &) : Array(CollectPoint)
preload_tours(records : Enumerable(CollectPoint), preload_query : Tour::BaseQuery, force : Bool = false) : Array(CollectPoint)

force is an accepted argument, but is ignored

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.

contient(value)
contient
coordinate_precision(value)
coordinate_precision
country(value)
country
county(value)
county
created_at(value)
created_at
find(id) : T
full_join_collect_points_tour
full_join_tours
id(value)
id
image1(value)
image1
image2(value)
image2
image3(value)
image3
image4(value)
image4
image5(value)
image5
inner_join_collect_points_tour
inner_join_tours
island(value)
island
island_group(value)
island_group
japanese_place_name(value)
japanese_place_name
japanese_place_name_detail(value)
japanese_place_name_detail
join_collect_points_tour
join_tours
left_join_collect_points_tour
left_join_tours
location(value)
location
maximum_depth(value)
maximum_depth
maximum_elevation(value)
maximum_elevation
minimum_depth(value)
minimum_depth
minimum_elevation(value)
minimum_elevation
municipality(value)
municipality
note(value)
note
preload_collect_points_tour(preload_query : CollectPointsTour::BaseQuery) : self
preload_collect_points_tour
preload_collect_points_tour
preload_tours(preload_query : Tour::BaseQuery, *, through : Avram::Queryable | Nil = nil) : self
preload_tours(*, through : Avram::Queryable | Nil = nil) : self
preload_tours(*, through : Avram::Queryable | Nil = nil, &) : self
right_join_collect_points_tour
right_join_tours
state_provice(value)
state_provice
update(id : UUID | Avram::Nothing = IGNORE, created_at : Time | Avram::Nothing = IGNORE, contient : String | Avram::Nothing = IGNORE, island_group : String | Avram::Nothing = IGNORE, island : String | Avram::Nothing = IGNORE, country : String | Avram::Nothing = IGNORE, state_provice : String | Avram::Nothing = IGNORE, county : String | Avram::Nothing = IGNORE, municipality : String | Avram::Nothing = IGNORE, verbatim_locality : String | Avram::Nothing = IGNORE, japanese_place_name : String | Avram::Nothing = IGNORE, japanese_place_name_detail : String | Avram::Nothing = IGNORE, coordinate_precision : Float64 | Avram::Nothing = IGNORE, location : PostGIS::Point2D | Avram::Nothing = IGNORE, minimum_elevation : Float64 | Avram::Nothing = IGNORE, maximum_elevation : Float64 | Avram::Nothing = IGNORE, minimum_depth : Float64 | Avram::Nothing = IGNORE, maximum_depth : Float64 | Avram::Nothing = IGNORE, note : String | Avram::Nothing = IGNORE, image1 : String | Avram::Nothing | Nil = IGNORE, image2 : String | Avram::Nothing | Nil = IGNORE, image3 : String | Avram::Nothing | Nil = IGNORE, image4 : String | Avram::Nothing | Nil = IGNORE, image5 : String | Avram::Nothing | Nil = IGNORE, user_id : Int32 | Avram::Nothing | Nil = 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)
user_id(value)
user_id
verbatim_locality(value)
verbatim_locality
where_collect_points_tour(assoc_query : CollectPointsTour::BaseQuery, auto_inner_join : Bool = true)
where_tours(assoc_query : Tour::BaseQuery, auto_inner_join : Bool = true)

Macros

generate_criteria_method(name, type)