Create Seed Data for Database

❮❮ ❮ Back

Next ❯ ❯❯

Task

• Write a script for adding seed data to the app’s database.

Steps

Inspect seeds script:

• db/seeds.rb - Ruby code file to open in VS Code.
  • Currently empty, except for some comments.

Add code to seeds.rb to seed database with Person objects:

Person.create!(first_name: 'Homer', last_name: 'Simpson', height_inches: 72, weight_lbs: 241)
Person.create!(first_name: 'Marge', last_name: 'Simpson', height_inches: 102, weight_lbs: 139)
Person.create!(first_name: 'Ned', last_name: 'Flanders', height_inches: 70, weight_lbs: 246)
Person.create!(first_name: 'Edna', last_name: 'Krabappel', height_inches: 67, weight_lbs: 156)

• Always use create! (with !) in seeds.rb to ensure any error messages are displayed.

Reset database (emptying it):

rails db:migrate:reset

Inspect rows in people table to confirm empty:

psql --command="SELECT * FROM people" app_development

• Note: Table empty.
• ⚠️ Press Q key to quit if command locks terminal.

Run seeds script:

rails db:seed

Inspect rows in people table to confirm seed data added:

psql --command="SELECT * FROM people" app_development

• Note: Now has 4 rows.
• ⚠️ Press Q key to quit if command locks terminal.

---

❮❮ ❮ Back

Next ❯ ❯❯