Method: MassRecord::Actions#query

Defined in:
lib/mass_record.rb

#query(sql, connection: database_connection) ⇒ Object 



740
741
742
743
744
745
746
747
748
749
750
751
752
753
 
# File 'lib/mass_record.rb', line 740

def query sql, connection:database_connection
  sql = sql.gsub /`(.*?)`/,'\1'                            # some queries don't like the "`"s
  if connection.blank?                               # a blank value was passed in or the cached connection is empty
    res = ActiveRecord::Base.connection.execute sql
    ActiveRecord::Base.connection.close
  elsif connection.is_a? Class and connection.ancestors.include? ActiveRecord::Base  # an ActiveRecord Class was passed in
    connection.connection.execute sql
    connection.connection.close
  else
    res = connection.execute sql
  end

  return res
end