Ruby on Rails

Ephracis · 02-23-2009, 07:43 AM

Hi. I am trying to figure out Ruby on Rails and I have this migration file:

Quote:

class AddTable < ActiveRecord::Migration
def self.up
create_table :photos do |t|
t.column :name, :string, :limit => 50, :null => false
t.column :path, :string, :limit => 100, :null => false
t.column :date, :datetime, :null => false
t.column :camera, :string, :limit => 20, :null => false
t.column :resolution, :string, :limit => 20, :null => false
t.column :album, :string, :limit => 30, :null => false
t.column :shutter, :integer, :null => false
t.column :fstop, :float, :null => false
t.column :caption, :string, :limit => 100, :null => false
end
create_table :photoalbums do |t|
t.column :name, :string, :limit => 50, :null => false
t.column :date, :datetime, :null => false
t.column :description :string, :limit => 100, :null => false
end
end
def self.down
drop_table :photos
end
end

When I run "rake db:create" it creates the table schema_migrations but it doesn't create any tables for me. How do I do that?

Am I forced to do it the old fashioned way using SQL?

Telemachos · 02-23-2009, 09:36 AM

What's in your config/database.yml file? That should specify what kind of database to create. My guess is that there is a database created, but it has no data in it yet. To populate it, you need either to enter in test data or fire up the application and add data.

Take a look at this page: http://guides.rails.info/getting_sta...ringa-database

Edit: please use [code][/code] blocks for code, rather than [quote][/quote]. It makes them easier to read.

JMather · 02-23-2009, 09:40 AM

You need to run "rake db:migrate"

Lee_Ball · 02-23-2009, 09:44 AM

See http://guides.rails.info/getting_sta...inga-migration for background on JMathers answer.

Ephracis · 02-23-2009, 09:44 AM

Quote:

Originally Posted by JMather

You need to run "rake db:migrate"

Yeah, I mistyped so that's what I ment. But I found out that I had to create a model before doing the migration.

Now I get a table when I migrate but there's no columns created in it. I tried to change the field to integer, tried removing the limit and null stuff, nothing worked. I don't get any columns in the database when I migrate.