How do i work with two different databases in rails with active records?

by

Add new sections to your database.yml e.g.

other_development:
  adapter: mysql
  database: otherdb_development
  username: root
  password:
  host: localhost

other_production:
  adapter: mysql
  database: otherdb_production
  username: root
  password:
  host: localhost

Add a class in lib/other_database.rb

class OtherDatabase < ActiveRecord::Base
  establish_connection "other_#{RAILS_ENV}"
end

and then for each model which isn’t in the default database subclass from OtherDatabase e.g.:

class MyModel < OtherDatabase
   # my model code...
end

More Related Contents:

  1. Rails ActiveRecord methods in different places [closed]
  2. ActiveRecord.find(array_of_ids), preserving order
  3. Rails model without database
  4. How do I replace accented Latin characters in Ruby?
  5. Using Rails serialize to save hash to database
  6. Rails 3: Get Random Record
  7. Rails 5: ActiveRecord OR query
  8. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  9. Altering the primary key in Rails to be a string
  10. LEFT OUTER joins in Rails 3
  11. Rails: ActiveRecord query based on association value
  12. How to test for (ActiveRecord) object equality
  13. Rails 3, has_one / has_many with lambda condition
  14. Rails ActiveRecord: Find All Users Except Current User
  15. query , can not select column count
  16. How to use ActiveRecord in a ruby script outside Rails?
  17. Regular expressions with validations in RoR 4
  18. Using helpers in model: how do I include helper dependencies?
  19. What are the brackets [5.1] after ActiveRecord Migration and how does it work? [duplicate]
  20. delete_all vs destroy_all?
  21. Converting an array of objects to ActiveRecord::Relation
  22. Rails 3.1 limit user created objects
  23. Store the day of the week and time?
  24. Is there a way to avoid automatically updating Rails timestamp fields?
  25. Rails: Overriding ActiveRecord association method
  26. Rails Object Relationships and JSON Rendering
  27. How to determine if one array contains all elements of another array
  28. Why can’t I install Rails on Lion using RVM?
  29. How to check a checkbox in capybara?
  30. strong parameters permit all attributes for nested attributes

Leave a Comment