Class: Queries::AnatomicalPart::Filter

Inherits:
Query::Filter show all
Includes:
Concerns::Citations, Concerns::PreparationTypes, Concerns::Tags
Defined in:
lib/queries/anatomical_part/filter.rb

Constant Summary collapse

PARAMS = 
[
  :anatomical_part_id,
  :is_material,
  :name,
  :name_exact,
  :origin_object_type,
  :otu_id,
  :uri,
  :uri_exact,
  :uri_label,
  :uri_label_exact,

  anatomical_part_id: [],
  origin_object_type: [],
  otu_id: []
].freeze

Constants inherited from Query::Filter

Query::Filter::FILTER_QUERIES, Query::Filter::SUBQUERIES

Instance Attribute Summary collapse

Attributes inherited from Query::Filter

#anatomical_part_query, #api, #asserted_distribution_query, #biological_association_query, #biological_associations_graph_query, #collecting_event_query, #collection_object_query, #content_query, #controlled_vocabulary_term_query, #conveyance_query, #data_attribute_query, #depiction_query, #descriptor_query, #document_query, #dwc_occurrence_query, #extract_query, #field_occurrence_query, #image_query, #loan_query, #object_global_id, #observation_query, #order_by, #otu_query, #page, #paginate, #params, #per, #person_query, #project_id, #recent, #recent_target, #roll_call, #sound_query, #taxon_name_query, #taxon_name_relationship_query, #venn, #venn_ignore_pagination, #venn_mode

Attributes inherited from Query

#query_string, #terms

Instance Method Summary collapse

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, #apply_venn, #attribute_exact_facet, base_filter, base_query_name, base_query_to_h, #deep_permit, #disable_paging, included_annotator_facets, instantiated_base_filter, inverted_subqueries, #model_id_facet, #object_global_id_facet, #only_project?, #only_project_or_less?, #paging_state, params, #permitted_params, #process_url_into_params, #project_id_facet, query_name, #set_nested_queries, #set_paging, set_paging, #shared_and_clauses, #subquery_vector, #target_and_clauses, #venn_query

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.

Parameters:

  • params (Hash) 


57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
 
# File 'lib/queries/anatomical_part/filter.rb', line 57

def initialize(query_params)
  super

  @anatomical_part_id = params[:anatomical_part_id]
  @is_material = boolean_param(params, :is_material)
  @name = params[:name]
  @name_exact = boolean_param(params, :name_exact)
  @origin_object_type = params[:origin_object_type]
  @otu_id = params[:otu_id]
  @uri = params[:uri]
  @uri_exact = boolean_param(params, :uri_exact)
  @uri_label = params[:uri_label]
  @uri_label_exact = boolean_param(params, :uri_label_exact)

  set_citations_params(params)
  set_tags_params(params)
  set_preparation_types_params(params)
end

Instance Attribute Details

#anatomical_part_id ⇒ Array

Returns:

  • (Array) 


26
27
28
 
# File 'lib/queries/anatomical_part/filter.rb', line 26

def anatomical_part_id
  @anatomical_part_id
end

#is_material ⇒ Boolean?

Returns:

  • (Boolean, nil) 


29
30
31
 
# File 'lib/queries/anatomical_part/filter.rb', line 29

def is_material
  @is_material
end

#name ⇒ Object

Returns String.

Returns:

  • String



32
33
34
 
# File 'lib/queries/anatomical_part/filter.rb', line 32

def name
  @name
end

#name_exact ⇒ Boolean?

Returns:

  • (Boolean, nil) 


35
36
37
 
# File 'lib/queries/anatomical_part/filter.rb', line 35

def name_exact
  @name_exact
end

#origin_object_type ⇒ Array

Returns:

  • (Array) 


38
39
40
 
# File 'lib/queries/anatomical_part/filter.rb', line 38

def origin_object_type
  @origin_object_type
end

#otu_id ⇒ Array

OTU id of the ancestor origin OTU or CO/FO taxon determination.

Returns:

  • (Array) 


42
43
44
 
# File 'lib/queries/anatomical_part/filter.rb', line 42

def otu_id
  @otu_id
end

#uri ⇒ Object

Returns String.

Returns:

  • String



45
46
47
 
# File 'lib/queries/anatomical_part/filter.rb', line 45

def uri
  @uri
end

#uri_exact ⇒ Object

Returns String.

Returns:

  • String



48
49
50
 
# File 'lib/queries/anatomical_part/filter.rb', line 48

def uri_exact
  @uri_exact
end

#uri_label ⇒ Object

Returns String.

Returns:

  • String



51
52
53
 
# File 'lib/queries/anatomical_part/filter.rb', line 51

def uri_label
  @uri_label
end

#uri_label_exact ⇒ Object

Returns String.

Returns:

  • String



54
55
56
 
# File 'lib/queries/anatomical_part/filter.rb', line 54

def uri_label_exact
  @uri_label_exact
end

Instance Method Details

#and_clauses ⇒ Object 



205
206
207
208
209
210
211
212
213
 
# File 'lib/queries/anatomical_part/filter.rb', line 205

def and_clauses
  [
    is_material_facet,
    name_facet,
    uri_facet,
    uri_label_facet,
    original_otu_id_facet
  ]
end

#biological_association_query_facet ⇒ Object 



190
191
192
193
194
195
196
197
198
199
200
201
202
 
# File 'lib/queries/anatomical_part/filter.rb', line 190

def biological_association_query_facet
  return nil if biological_association_query.nil?

  a = ::AnatomicalPart
    .with(ba_query1: biological_association_query.all)
    .joins("JOIN ba_query1 ON ba_query1.biological_association_subject_id = anatomical_parts.id AND ba_query1.biological_association_subject_type = 'AnatomicalPart'")

  b = ::AnatomicalPart
    .with(ba_query2: biological_association_query.all)
    .joins("JOIN ba_query2 ON ba_query2.biological_association_object_id = anatomical_parts.id AND ba_query2.biological_association_object_type = 'AnatomicalPart'")

  referenced_klass_union([a,b])
end

#collection_object_query_facet ⇒ Object 



142
143
144
145
146
147
148
 
# File 'lib/queries/anatomical_part/filter.rb', line 142

def collection_object_query_facet
  return nil if collection_object_query.nil?

  ::AnatomicalPart
    .joins(:related_origin_relationships)
    .where("origin_relationships.old_object_id IN (#{collection_object_query.all.select(:id).to_sql })")
end

#extract_query_facet ⇒ Object 



174
175
176
177
178
179
180
 
# File 'lib/queries/anatomical_part/filter.rb', line 174

def extract_query_facet
  return nil if extract_query.nil?

  ::AnatomicalPart
    .joins(:origin_relationships)
    .where("origin_relationships.new_object_id IN (#{extract_query.all.select(:id).to_sql })")
end

#field_occurrence_query_facet ⇒ Object 



150
151
152
153
154
155
156
 
# File 'lib/queries/anatomical_part/filter.rb', line 150

def field_occurrence_query_facet
  return nil if field_occurrence_query.nil?

  ::AnatomicalPart
    .joins(:related_origin_relationships)
    .where("origin_relationships.old_object_id IN (#{collection_object_query.all.select(:id).to_sql })")
end

#is_material_facet ⇒ Object 



117
118
119
120
121
122
123
124
125
 
# File 'lib/queries/anatomical_part/filter.rb', line 117

def is_material_facet
  return nil if is_material.nil?

  if is_material === false
    table[:is_material].eq(is_material)
  else
    table[:is_material].eq(true).or(table[:is_material].eq(nil))
  end
end

#merge_clauses ⇒ Object 



215
216
217
218
219
220
221
222
223
224
225
226
227
 
# File 'lib/queries/anatomical_part/filter.rb', line 215

def merge_clauses
  [
    collection_object_query_facet,
    extract_query_facet,
    field_occurrence_query_facet,
    otu_query_facet,
    observation_query_facet,
    sound_query_facet,
    biological_association_query_facet,

    origin_object_type_facet
  ]
end

#name_facet ⇒ Object 



88
89
90
91
92
93
94
95
 
# File 'lib/queries/anatomical_part/filter.rb', line 88

def name_facet
  return nil if name.blank?
  if name_exact
    table[:name].eq(name.strip)
  else
    table[:name].matches('%' + name.strip.gsub(/\s/, '%') + '%')
  end
end

#observation_query_facet ⇒ Object 



166
167
168
169
170
171
172
 
# File 'lib/queries/anatomical_part/filter.rb', line 166

def observation_query_facet
  return nil if observation_query.nil?

  ::AnatomicalPart
    .joins(:related_origin_relationships)
    .where("origin_relationships.old_object_id IN (#{observation_query.all.select(:id).to_sql })")
end

#origin_object_type_facet ⇒ Object 



127
128
129
130
131
132
133
134
 
# File 'lib/queries/anatomical_part/filter.rb', line 127

def origin_object_type_facet
  return nil if origin_object_type.empty?

  ::AnatomicalPart
    .joins(:related_origin_relationships)
    .where(related_origin_relationships: { old_object_type: origin_object_type })
    .distinct # remove if model adds validations to make this unnecessary
end

#original_otu_id_facet ⇒ Object 



136
137
138
139
140
 
# File 'lib/queries/anatomical_part/filter.rb', line 136

def original_otu_id_facet
  return nil if otu_id.empty?

  table[:cached_otu_id].in(otu_id)
end

#otu_query_facet ⇒ Object 



158
159
160
161
162
163
164
 
# File 'lib/queries/anatomical_part/filter.rb', line 158

def otu_query_facet
  return nil if otu_query.nil?

  ::AnatomicalPart
    .joins(:related_origin_relationships)
    .where("origin_relationships.old_object_id IN (#{otu_query.all.select(:id).to_sql })")
end

#sound_query_facet ⇒ Object 



182
183
184
185
186
187
188
 
# File 'lib/queries/anatomical_part/filter.rb', line 182

def sound_query_facet
  return nil if sound_query.nil?

  ::AnatomicalPart
    .joins(:origin_relationships)
    .where("origin_relationships.new_object_id IN (#{sound_query.all.select(:id).to_sql })")
end

#uri_facet ⇒ Object 



97
98
99
100
101
102
103
104
105
 
# File 'lib/queries/anatomical_part/filter.rb', line 97

def uri_facet
  return nil if uri.blank?

  if uri_exact
    table[:uri].eq(uri.strip)
  else
    table[:uri].matches('%' + uri.strip.gsub(/\s/, '%') + '%')
  end
end

#uri_label_facet ⇒ Object 



107
108
109
110
111
112
113
114
115
 
# File 'lib/queries/anatomical_part/filter.rb', line 107

def uri_label_facet
  return nil if uri_label.blank?

  if uri_label_exact
    table[:uri_label].eq(uri_label.strip)
  else
    table[:uri_label].matches('%' + uri_label.strip.gsub(/\s/, '%') + '%')
  end
end