How to create schema in sql

ruby-on-rails ruby-on-rails-3 activerecord ruby-on-rails-3.1
vince picture vince · Aug 12, 2011 · Viewed 15k times · Source

As per http://edgeguides.rubyonrails.org/configuring.html and this post I have this in application.rb

config.active_record.schema_format = :sql

However, it's still creating db/schema.rb (even after I delete it) and more importantly it's not creating the schema in sql when I run "rake db:migrate". Anyone know what I'm doing wrong? I'm on Rails 3.1 pre.

Answer

Maurício Linhares picture Maurício Linhares · Aug 14, 2011

Well, this could be a rails bug, but you can always generate your db structure with this:

rake db:structure:dump

This is going to generate an "#{Rails.env}.sql" file for you with your database structure in SQL.

Related questions

Check if record exists from controller in Rails

In my app a User can create a Business. When they trigger the index action in my BusinessesController I want to check if a Business is related to the current_user.id: If yes: display the business. If no: redirect …

Read More
Can you do greater than comparison on a date in a Rails 3 search?

I have this search in Rails 3: Note.where(:user_id => current_user.id, :notetype => p[:note_type], :date => p[:date]).order('date ASC, created_at ASC') But I need the :date => p[:date] condition to be …

Read More
How to chain scope queries with OR instead of AND?

I'm using Rails3, ActiveRecord Just wondering how can I chain the scopes with OR statements rather than AND. e.g. Person.where(:name => "John").where(:lastname => "Smith") That normally returns: name = 'John' AND lastname = 'Smith' but I'd like: `…

Read More