Class: Queries::DwcOccurrence::Filter
- Inherits:
-
Query::Filter
- Object
- Query
- Query::Filter
- Queries::DwcOccurrence::Filter
- Includes:
- Concerns::Users, Helpers
- Defined in:
- lib/queries/dwc_occurrence/filter.rb
Overview
Keep this minimal, in pricinple filtering should be done on the base objects, not the core here.
Constant Summary collapse
- PARAMS =
[ :dwc_occurrence_id, :dwc_occurence_object_type, :dwc_occurence_object_id, dwc_occurence_object_type: [], dwc_occurence_object_id: [], dwc_occurrence_id: [], ].freeze
Constants inherited from Query::Filter
Query::Filter::FILTER_QUERIES, Query::Filter::SUBQUERIES
Instance Attribute Summary collapse
-
#dwc_occurrence_id ⇒ Object
Returns the value of attribute dwc_occurrence_id.
-
#dwc_occurrence_object_id ⇒ Object
Used independantly now, not paired.
-
#dwc_occurrence_object_type ⇒ Object
Returns the value of attribute dwc_occurrence_object_type.
Attributes inherited from Query::Filter
#api, #asserted_distribution_query, #biological_association_query, #biological_associations_graph_query, #collecting_event_query, #collection_object_query, #content_query, #controlled_vocabulary_term_query, #data_attribute_query, #descriptor_query, #extract_query, #image_query, #loan_query, #object_global_id, #observation_query, #otu_query, #page, #paginate, #params, #per, #person_query, #project_id, #recent, #taxon_name_query
Attributes inherited from Query
Instance Method Summary collapse
- #and_clauses ⇒ Object
- #asserted_distribution_query_facet ⇒ Object
- #collection_object_query_facet ⇒ Object
- #dwc_occurrence_id_facet ⇒ Object
- #dwc_occurrence_object_id_facet ⇒ Object
- #dwc_occurrence_object_type_facet ⇒ Object
-
#initialize(query_params) ⇒ Filter
constructor
A new instance of Filter.
- #merge_clauses ⇒ Object
Methods included from Helpers
Methods inherited from Query::Filter
#all, #all_and_clauses, #all_merge_clauses, #annotator_and_clauses, #annotator_merge_clauses, annotator_params, api_except_params, api_excluded_params, #attribute_exact_facet, #deep_permit, included_annotator_facets, inverted_subqueries, #model_id_facet, #object_global_id_facet, params, #permitted_params, #project_id_facet, #set_nested_queries, #shared_and_clauses, #subquery_vector
Methods inherited from Query
#alphabetic_strings, #alphanumeric_strings, base_name, #base_name, #base_query, #build_terms, #cached_facet, #end_wildcard, #levenshtein_distance, #match_ordered_wildcard_pieces_in_cached, #no_terms?, referenced_klass, #referenced_klass, #referenced_klass_except, #referenced_klass_intersection, #referenced_klass_union, #start_and_end_wildcard, #start_wildcard, #table, #wildcard_pieces
Constructor Details
#initialize(query_params) ⇒ Filter
Returns a new instance of Filter.
27 28 29 30 31 32 |
# File 'lib/queries/dwc_occurrence/filter.rb', line 27 def initialize(query_params) super @dwc_occurrence_id = params[:dwc_occurrence_id] @dwc_occurrence_object_id = params[:dwc_occurrence_object_id] @dwc_occurrence_object_type = params[:dwc_occurrence_object_type] end |
Instance Attribute Details
#dwc_occurrence_id ⇒ Object
Returns the value of attribute dwc_occurrence_id.
21 22 23 |
# File 'lib/queries/dwc_occurrence/filter.rb', line 21 def dwc_occurrence_id @dwc_occurrence_id end |
#dwc_occurrence_object_id ⇒ Object
Used independantly now, not paired
24 25 26 |
# File 'lib/queries/dwc_occurrence/filter.rb', line 24 def dwc_occurrence_object_id @dwc_occurrence_object_id end |
#dwc_occurrence_object_type ⇒ Object
Returns the value of attribute dwc_occurrence_object_type.
25 26 27 |
# File 'lib/queries/dwc_occurrence/filter.rb', line 25 def dwc_occurrence_object_type @dwc_occurrence_object_type end |
Instance Method Details
#and_clauses ⇒ Object
91 92 93 94 95 96 |
# File 'lib/queries/dwc_occurrence/filter.rb', line 91 def and_clauses [ dwc_occurrence_id_facet, dwc_occurrence_object_id_facet, dwc_occurrence_object_type_facet, ] end |
#asserted_distribution_query_facet ⇒ Object
61 62 63 64 65 66 67 68 69 70 |
# File 'lib/queries/dwc_occurrence/filter.rb', line 61 def asserted_distribution_query_facet return nil if asserted_distribution_query.nil? s = 'WITH query_ad_dwco AS (' + asserted_distribution_query.all.to_sql + ') ' + ::DwcOccurrence .joins("JOIN query_ad_dwco as query_ad_dwco1 on dwc_occurrences.dwc_occurrence_object_id = query_ad_dwco1.id AND dwc_occurrences.dwc_occurrence_object_type = 'AssertedDistribution'") .to_sql ::DwcOccurrence.from('(' + s + ') as dwc_occurrences').distinct end |
#collection_object_query_facet ⇒ Object
72 73 74 75 76 77 78 79 80 81 |
# File 'lib/queries/dwc_occurrence/filter.rb', line 72 def collection_object_query_facet return nil if collection_object_query.nil? s = 'WITH query_co_dwco AS (' + collection_object_query.all.to_sql + ') ' + ::DwcOccurrence .joins("JOIN query_co_dwco as query_co_dwco1 on dwc_occurrences.dwc_occurrence_object_id = query_co_dwco1.id AND dwc_occurrences.dwc_occurrence_object_type = 'CollectionObject'") .to_sql ::DwcOccurrence.from('(' + s + ') as dwc_occurrences').distinct end |
#dwc_occurrence_id_facet ⇒ Object
46 47 48 49 |
# File 'lib/queries/dwc_occurrence/filter.rb', line 46 def dwc_occurrence_id_facet return nil if dwc_occurrence_id.empty? table[:dwc_occurrence_id].eq_any(dwc_occurrence_id) end |
#dwc_occurrence_object_id_facet ⇒ Object
51 52 53 54 |
# File 'lib/queries/dwc_occurrence/filter.rb', line 51 def dwc_occurrence_object_id_facet return nil if dwc_occurrence_object_id.empty? table[:dwc_occurrence_object_id].eq_any(dwc_occurrence_object_id) end |
#dwc_occurrence_object_type_facet ⇒ Object
56 57 58 59 |
# File 'lib/queries/dwc_occurrence/filter.rb', line 56 def dwc_occurrence_object_type_facet return nil if dwc_occurrence_object_type.empty? table[:dwc_occurrence_object_type].eq_any(dwc_occurrence_object_type) end |
#merge_clauses ⇒ Object
83 84 85 86 87 88 |
# File 'lib/queries/dwc_occurrence/filter.rb', line 83 def merge_clauses [ collection_object_query_facet, asserted_distribution_query_facet, ] end |