Rails - Feb 2008 - database setup > a good startingpoint?

Hi,

I am a newbie to RoR, so i hope for that someone can reply with some
anwsers or url''s for futher reading.


My new project is to develop a travel-guide with some web 2.0 features.
I was just wondering how my database-schema must look like..i just want
to start basic...

Basic concept.

domain.com/
domain.com/europe/
domain.com/europe/netherlands/amsterdam
domain.com/europe/netherlands/amsterdam/hotels
domain.com/europe/netherlands/amsterdam/things-to-do
domain.com/europe/netherlands/amsterdam/restaurants
domain.com/europe/belgium/brussel
ect

domain.com/north-america/
domain.com/north-america/united-states/new-york/hotels
domain.com/north-america/united-states/los-angeles

domain.com/south-america/
domain.com/south-america/brazil/los-angeles
ect....

Each continent, country, city, hotels ect has is one page..with content

What is a good startingpoint??

Grtz..remco
-- 
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
-~----------~----~----~----~------~----~------~--~---

Remco Swoany wrote:
> 
> Each continent, country, city, hotels ect has is one page..with content
> 
> What is a good startingpoint??
> 
> Grtz..remco
Work backwards from your problem domain

script/generate model Continent
script/generate model City
(etc.. I think you can do them all in one line but I always do my models 
by hand)

class Continent < ActiveRecord::Base
  has_many :countries
end

class Country < ActiveRecord::Base
  has_many :cities
  belongs_to :continent
end

etc..

meanwhile, back on the farm: db/migration/001_create_countries.rb
def self_up
  create_table :continents do |t|
    t.column :name
    t.column :number_of_shark_species_in_coastal_areas
  end

etc..

that should get you started..

hth

ilan
-- 
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
-~----------~----~----~----~------~----~------~--~---