Database configuration

# 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!!

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

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!

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.

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!!