Database configuration

rubyonrails-talk
1

# SQLite version 3.x # gem install sqlite3-ruby (not necessary on OS X Leopard) development:   adapter: sqlite3   database: db/development.sqlite3   timeout: 5000

# Warning: The database defined as "test" will be erased and # re-generated from your development database when you run "rake". # Do not set this db to the same as development or production. test:   adapter: sqlite3   database: db/test.sqlite3   timeout: 5000

production:   adapter: sqlite3   database: db/production.sqlite3   timeout: 5000

This is the database.yml file. I'm very new to RoR and I'm trying to set it up. In this file it has sqlite3... I'm using MySQl. What should I do? Also I can see that there are several databases, development, test, production. Do I need to create these databases? Tables?

Thanks!!

2

Create your MySQL database, user, and grant access for that user. Change your database.yml to something like the following:

development: adapter: mysql encoding: utf8 database: my_db_name username: my_username password: my_password host: localhost

You need at least a development database.

Hope this helps.

Phil

3

Ok, I got that part... now I need to try to create the scaffold:

./script/generate scaffold Foo somefieldname:integer anotherfieldname:string whateverfieldsyouwant:text

is what I found on http://wiki.rubyonrails.org/rails/pages/ScaffoldGenerator

What is 'Foo' and what's the stuff after that for?

Thanks!

4

Foo is the model you are creating (app/models/foo.rb). Rails will generate a migration to create a database table based on the parameters you supply. In this case the 2 fields (integer and text).

After generating the scaffold look in: db/migrations/001_create_foo.rb You can add more fields if you want, then run rake db:migrate

This creates the database table.

5

Phil Calder wrote:

Foo is the model you are creating (app/models/foo.rb).

Foo is an arbitrary name, right? What is an example of a real model name?

Rails will generate a migration to create a database table based on the parameters you supply. In this case the 2 fields (integer and text).

I already have a database with two tables created, what do I do now?

After generating the scaffold look in: db/migrations/001_create_foo.rb You can add more fields if you want, then run rake db:migrate

In the command prompt, do I simply type 'rake db:migrate' or do I have to include a path? If I do, how would I specify the path? Using -c ?

This creates the database table.

Thanks!!