gmane.comp.lang.ruby.rails

Justin To | 8 Jul 22:03

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

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

(Continue reading)

headers

Phil Calder | 8 Jul 22:41

Re: Database configuration

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 <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>:

# 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!!
--
Posted via http://www.ruby-forum.com/.

--
----------------------------------------
Phil Calder
philcalder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
----------------------------------------
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

headers

Justin To | 8 Jul 23:00

Re: Database configuration


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

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

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

headers

Phil Calder | 8 Jul 23:12

Re: Database configuration

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 <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>:

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!
--
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

headers

Justin To | 8 Jul 23:44

Re: Database configuration


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 <rails-mailing-list@...>:

Thanks!!
--

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

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---