Database configuration

Rails
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

2008/7/9 Justin To [email protected]:

Do not set this db to the same as development or production.

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

Posted via http://www.ruby-forum.com/.

–

Phil Calder
[email protected]

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.

2008/7/9 Justin To [email protected]:

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.

2008/7/9 Justin To [email protected]:

Thanks!!