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.11".freeze

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(args) ⇒ ActiveRecordQueryFixer

Returns a new instance of ActiveRecordQueryFixer.



13
14
15
16
 
# File 'lib/active_record_query_fixer.rb', line 13

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

Instance Attribute Details

#query ⇒ Object (readonly)

Returns the value of attribute query.



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

def query
  @query
end

Class Method Details

.fix(query) ⇒ Object 



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

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

Instance Method Details

#fix ⇒ Object 



18
19
20
21
22
23
24
25
 
# File 'lib/active_record_query_fixer.rb', line 18

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?
  fix_select_group if @query.values[:select] && @query.values[:group]

  self
end

#fix_order_group ⇒ Object 



47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
 
# File 'lib/active_record_query_fixer.rb', line 47

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

  sort_targets.each do |sort_target|
    fields = sort_target.dig("SortBy", "node", "ColumnRef", "fields")
    next if !fields || fields.length != 2

    table = fields.dig(0, "String", "str")
    column = fields.dig(1, "String", "str")

    @query = @query.group("#{table}.#{column}") if table && column
  end

  self
end

#fix_order_select_distinct ⇒ Object 



63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
 
# File 'lib/active_record_query_fixer.rb', line 63

def fix_order_select_distinct
  changed = false
  select_defined = @query.values[:select].present?

  sort_targets.each do |sort_target|
    fields = sort_target.dig("SortBy", "node", "ColumnRef", "fields")
    next if !fields || fields.length != 2

    table = fields.dig(0, "String", "str")
    column = fields.dig(1, "String", "str")

    next if !table || !column

    @query = @query.select("#{table}.#{column} AS active_record_query_fixer_#{@count_select}")
    changed = true
    @count_select += 1
  end

  @query = @query.select("#{@query.table_name}.*") if changed && !select_defined

  self
end

#fix_reference_group ⇒ Object 



86
87
88
89
90
91
92
93
94
 
# File 'lib/active_record_query_fixer.rb', line 86

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

  self
end

#fix_select_group ⇒ Object 



27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
 
# File 'lib/active_record_query_fixer.rb', line 27

def fix_select_group
  select_targets.each do |select_target|
    fields = select_target.dig!("ResTarget", "val", "ColumnRef", "fields")
    next if fields.length != 2

    table = fields[0].dig("String", "str")
    column = fields[1].dig("String", "str")

    if column
      # A table and a column has been selected - make sure to group by that
      @query = @query.group("#{table}.#{column}")
    elsif fields[1].key?("A_Star")
      # A table and a star has been selected - assume the primary key is called "id" and group by that
      @query = @query.group("#{table}.id")
    end
  end

  self
end