Rails - generating .sqlite3-databases

Question

My rails app. uses mysql database and I need to generate .sqlite3.databases. Is it possible to use activerecord and rails models for it? We are trying now to use models namespaced by Remote:: module but by this way we can't start concurrent generators.

François Beausoleil · Accepted Answer · 2010-06-27 19:31:44Z

4

In your remote models, you want to connect to a separate database using #establish_connection:

# config/database.yml
remote_development:
  adapter: sqlite3
  database: db/development.sqlite3

remote_production:
  adapter: sqlite3
  database: /usr/local/remote/myapp.sqlite3


# app/models/remote_model.rb
class RemoteModel < ActiveRecord::Base
  establish_connection "remote_#{Rails.env}"
  self.abstract_class = true
end


# app/models/remote_user.rb
class RemoteUser < RemoteModel
end

Note the abstract_class setter: this means the class in question doesn't have an underlying table: it's used for configuration purposes only.

answered Jun 27, 2010 at 19:31

François Beausoleil

16.6k11 gold badges71 silver badges97 bronze badges

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

2 Comments

Andrey Kuznetsov Over a year ago

I need to create different sqlite databases. Generation processes may be concurrent. I need dynamic database names...

François Beausoleil Over a year ago

establish_connection also accepts a Hash, thus you can say "RemoteModel.send(:establish_connection, :adapter => "sqlite3", :database => Rails.root + "tmp/#{Time.to_i}.sqlite3")

Collectives™ on Stack Overflow

Rails - generating .sqlite3-databases

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related