Module: Queries::Concerns::Conveyances

Extended by:
ActiveSupport::Concern
Included in:
Queries::CollectionObject::Filter, Otu::Filter
Defined in:
lib/queries/concerns/conveyances.rb

Overview

Helpers and facets for queries that reference Conveyances/Sounds

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.merge_clauses ⇒ Object 



82
83
84
85
86
87
88
89
 
# File 'lib/queries/concerns/conveyances.rb', line 82

def self.merge_clauses
  [
    :conveyances_facet,
    :sound_id_facet,
    :sound_query_facet,
    :sounds_facet
  ]
end

.params ⇒ Object 



6
7
8
9
10
11
12
13
 
# File 'lib/queries/concerns/conveyances.rb', line 6

def self.params
  [
    :sound_id,
    :sounds,
    :conveyances,
    sound_id: []
  ]
end

Instance Method Details

#conveyances_facet ⇒ Object

!! Duplicate with sounds



51
52
53
54
55
56
57
58
59
 
# File 'lib/queries/concerns/conveyances.rb', line 51

def conveyances_facet
  return nil if conveyances.nil?

  if conveyances
    referenced_klass.joins(:conveyances).distinct
  else
    referenced_klass.where.missing(:conveyances)
  end
end

#set_conveyance_params(params) ⇒ Object 



36
37
38
39
40
 
# File 'lib/queries/concerns/conveyances.rb', line 36

def set_conveyance_params(params)
  @sound_id = params[:sound_id]
  @sounds = boolean_param(params, :sounds)
  @conveyances = boolean_param(params, :conveyances)
end

#sound_id_facet ⇒ Object 



42
43
44
45
46
47
48
 
# File 'lib/queries/concerns/conveyances.rb', line 42

def sound_id_facet
  return nil if sound_id.empty?
  referenced_klass
    .joins(:conveyances)
    .where(conveyances: {sound_id:})
    .distinct
end

#sound_query_facet ⇒ Object 



70
71
72
73
74
75
76
77
78
79
80
 
# File 'lib/queries/concerns/conveyances.rb', line 70

def sound_query_facet
  return nil if sound_query.nil?
  s = 'WITH query_sounds AS (' + sound_query.all.to_sql + ')'

  s << ' ' + referenced_klass
  .joins(:conveyances)
  .joins('JOIN query_sounds as query_sounds1 on conveyances.sound_id = query_sounds1.id')
  .to_sql

  referenced_klass.from('(' + s + ') as ' + referenced_klass.name.tableize).distinct
end

#sounds_facet ⇒ Object 



61
62
63
64
65
66
67
68
 
# File 'lib/queries/concerns/conveyances.rb', line 61

def sounds_facet
  return nil if sounds.nil?
  if sounds
    referenced_klass.joins(:conveyances).distinct
  else
    referenced_klass.where.missing(:conveyances)
  end
end