Automatically populate database fields?

Hello,

I have a table that holds certain places (cities) in them. Is there a way to pre-populate my database during production with all the cities I want included? My application relies on pre submitted cities to run properly. ( I have about 400 of them)

I looked around the internet, and people have been using different approaches to this problem. I don't want to get steered wrong, so what is the best way to do this?

Thank you.

-David Zhu

Seeds are the way to go I guess. See http://ryandaigle.com/articles/2009/5/13/what-s-new-in-edge-rails-database-seeding and #179 Seed Data - RailsCasts.

Sorry for polluting your inboxes : here’s another technique for directly dumping/loading data from the database (if you’re using mysql).

Arrrgh!!! Seed Data In Ruby On Rails – Agile Web Operations

(time to go to bed… :/)