Set default database connection Rails

Question

My rails app has its own MySql database (and requires the mysql2 gem) but also needs to connect with an external MongoDB database for one particular model (and so I've included mongoid and bson_ext in the Gemfile). Now when I try to generate a migration for a new model, it tells me that

$ rails g migration CreateLocations
       error  mongoid [not found]

When I generated the Location model it included Mongoid::Document, so Rails obviously thinks it is using the external database as my primary datastore.

databse.yml:

development:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: associalize_development
  pool: 5
  username: root
  password:
  socket: /tmp/mysql.sock

mongoid.yml:

development:
  host: pearl.mongohq.com
  port: 27019
  username: asfasdf
  password: sadfasdf
  database: app4574678

test:
  host: pearl.mongohq.com
  port: 27019
  username: asdfadhasdfa
  password: hadsadfas
  database: app4574678

production:
  host: pearl.mongohq.com
  port: 27019
  username: asdfdfsasda
  password: afdasdfdasdf
  database: app4574678

UPDATE Model that uses Mongo

class ExternalMongoModel
  include Mongoid::Document

  field :title
  field :long_title
  field :deal_type
  field :merchandise_type
  field :market_id
  field :market_name
  field :market_location, type: Array
  field :featureType
  field :country_code
  field :subtitle
  field :offer_ends_at
  field :price
  field :value
  field :merchant_type
  field :content
  field :merchant

  index(
    [[:division_latlon, Mongo::GEO2D]], background: true
  )

end

A workaround is comment out 'mongoid' in my Gemfile, create & run the migrations, then uncomment and rebundle. Obviously not legit. — Chris
– Chris, Commented Jun 26, 2012 at 17:56
Please post the relevant model code for the one that uses MongoDB. — Dean Brundage
– Dean Brundage, Commented Jun 26, 2012 at 18:21

Hugeen · Accepted Answer · 2020-11-26 10:03:38Z

51

Add this to the Application block in config/application.rb:

config.generators do |g|
  g.orm :active_record
end

(found here)

edited Nov 26, 2020 at 10:03

answered Sep 14, 2012 at 4:44

Hugeen

1,34015 silver badges21 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:10:41Z

33

If you don't want to change the config/application.rb you could use this while generating the model:

rails generate active_record:migration

If you change the application.rb file, to invoke a mongoid generator, say for a model 'contacts', one would use:

rails g mongoid:model contacts

(solution link)

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered Apr 29, 2014 at 6:21

Nanda

4824 silver badges6 bronze badges

Comments

Avijit Majhi · Accepted Answer · 2016-02-08 17:51:37Z

8

First check the below block is present in config/application.rb file in your rails application

config.generators do |g|
  g.orm :active_record
end

If not add then, or else you can run

rails g active_record:migration

answered Feb 8, 2016 at 17:51

Avijit Majhi

5189 silver badges15 bronze badges

Collectives™ on Stack Overflow

Set default database connection Rails

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related