class CollectPoint::BaseQuery
- CollectPoint::BaseQuery
- Reference
- Object
Included Modules
- Avram::PrimaryKeyQueryable(CollectPoint)
- Avram::Queryable(CollectPoint)
Direct Known Subclasses
Defined in:
Constructors
Class Method Summary
-
.any? : Bool
Returns
true
if at least one of the collection's members is truthy. - .find(id) : T
-
.first : T
Returns the first element in the collection.
-
.first? : T | Nil
Returns the first element in the collection.
- .last : T
- .last? : T | Nil
- .new_with_existing_query(query : Avram::QueryBuilder)
-
.none? : Bool
Returns
true
if all of the elements of the collection are falsey. - .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.
Macro Summary
Instance Method Summary
-
#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 : self
- #preload_collect_points_tour(&) : self
- #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.
- #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)
Constructor Detail
Class Method Detail
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.
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
Returns the first element in the collection.
When the collection is empty, returns nil
.
([1, 2, 3]).first? # => 1
([] of Int32).first? # => nil
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?
.
force is an accepted argument, but is ignored
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.
Macro Detail
Instance Method Detail
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)