Class: Queries::DwcOccurrence::Filter

Inherits:
Query::Filter show all
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

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

#query_string, #terms

Instance Method Summary collapse

Methods included from Helpers

#boolean_param

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