activerecord PostgreSQLAdapter override sql_for_insert, query, execute and update_sql

Question

I want to update all sql statements for the queries generated for sql_for_insert, query, execute and update_sql for postgres. I'm using rails 3.2.17. Main aim is to change the column names to lower case. I tried to define a class "class ActiveRecord::ConnectionAdapters::PostgreSQLAdapter" in initializers, methods are called over there, but I can't call super as my class isn't extended from any other class.

Mink · Accepted Answer · 2016-07-25 09:32:26Z

1

I got an alternate solution to just update the column names at one single location. I made a module and included it in Arel:Attributes:Attribute, this module converts the column names into lower case. This code is still under testing for me and not into production. But this seemed to have solved my problem.

module ArelAttributeWrapper
  def self.included base
    @actualname = nil
    base.class_eval do
      def initialize(*args)
        super(*args)
        @actualname = args[1]
      end
      def name=(value)
        @actualname = value.downcase
      end

      def name
        @actualname.downcase
      end
    end
  end
end

Arel::Attributes::Attribute.send(:include, ArelAttributeWrapper)

answered Jul 25, 2016 at 9:32

Mink

1784 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

activerecord PostgreSQLAdapter override sql_for_insert, query, execute and update_sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related