Class: ActiveRecordQueryFixer

Inherits:
Object
  • Object
show all
Defined in:
lib/active_record_query_fixer.rb,
lib/active_record_query_fixer/version.rb

Defined Under Namespace

Modules: RelationExtentions

Constant Summary collapse

VERSION = 
"0.0.7".freeze

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(args) ⇒ ActiveRecordQueryFixer

Returns a new instance of ActiveRecordQueryFixer.



10
11
12
13
 
# File 'lib/active_record_query_fixer.rb', line 10

def initialize(args)
  @query = args.fetch(:query)
  @count_select = 0
end

Instance Attribute Details

#query ⇒ Object (readonly)

Returns the value of attribute query.



4
5
6
 
# File 'lib/active_record_query_fixer.rb', line 4

def query
  @query
end

Class Method Details

.fix(query) ⇒ Object 



6
7
8
 
# File 'lib/active_record_query_fixer.rb', line 6

def self.fix(query)
  new(query: query).fix.query
end

Instance Method Details

#fix ⇒ Object 



15
16
17
18
19
20
 
# File 'lib/active_record_query_fixer.rb', line 15

def fix
  fix_reference_group if fix_reference_group?
  fix_order_group if fix_order_group?
  fix_order_select_distinct if fix_order_select_distinct?
  self
end

#fix_order_group ⇒ Object 



22
23
24
25
26
27
28
29
30
 
# File 'lib/active_record_query_fixer.rb', line 22

def fix_order_group
  @query = @query.group(@query.model.arel_table[@query.model.primary_key])

  @query.values[:order]&.each do |order|
    @query = @query.group(extract_table_and_column_from_expression(order)) if group_by_order?(order)
  end

  self
end

#fix_order_select_distinct ⇒ Object 



32
33
34
35
36
37
38
39
40
41
42
 
# File 'lib/active_record_query_fixer.rb', line 32

def fix_order_select_distinct
  changed = false
  @query.values[:order]&.each do |order|
    @query = @query.select("#{extract_table_and_column_from_expression(order)} AS active_record_query_fixer_#{@count_select}")
    changed = true
    @count_select += 1
  end

  @query = @query.select("#{@query.table_name}.*") if changed
  self
end

#fix_reference_group ⇒ Object 



44
45
46
47
48
49
50
 
# File 'lib/active_record_query_fixer.rb', line 44

def fix_reference_group
  @query = @query.group(@query.model.arel_table[@query.model.primary_key])

  @query.values[:references].each do |reference|
    @query = @query.group("#{reference}.id")
  end
end