Databases
StackOverflow2013
Postsdbo
POSet default database connection Rails
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSet default database connection Rails
    primarykey
    data
    text
    <p>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 </p> <pre><code>$ rails g migration CreateLocations error mongoid [not found] </code></pre> <p>When I generated the Location model it included Mongoid::Document, so Rails obviously thinks it is using the external database as my primary datastore.</p> <p>databse.yml:</p> <pre><code>development: adapter: mysql2 encoding: utf8 reconnect: false database: associalize_development pool: 5 username: root password: socket: /tmp/mysql.sock </code></pre> <p>mongoid.yml:</p> <pre><code>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 </code></pre> <p><strong>UPDATE</strong> Model that uses Mongo</p> <pre><code>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 </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USChris
    1. USChris
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSet default database connection Rails
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSet default database connection Rails
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSet default database connection Rails
      1. USskozz
      1. VTFavorite
    1. COA workaround is comment out 'mongoid' in my Gemfile, create & run the migrations, then uncomment and rebundle. Obviously not legit.
      singulars
      1. POSet default database connection Rails
      1. USChris
    2. COPlease post the relevant model code for the one that uses MongoDB.
      singulars
      1. POSet default database connection Rails
      1. USDean Brundage
    3. CO@DeanBrundage updated
      singulars
      1. POSet default database connection Rails
      1. USChris
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload