Rails fixtures -- how do you set foreign keys?

Ethan picture Ethan · Feb 4, 2009 · Viewed 8.6k times · Source

I'm reading about Rails fixtures in this guide (thanks, trevorturk). It appears you define classes in a Yaml file and they're automatically loaded into the test DB -- cool.

But if you want to specify that this recipe belongs to that cookbook (or whatever) how do you do that?

Are you supposed to specify the values for cookbook.id and recipe.cookbook_id by hand in the Yaml code? (Just a guess -- the guide doesn't show anything like that.) Or is there a more suitable way?

Answer

Andrew Vit picture Andrew Vit · Feb 4, 2009

You should use named fixtures, which automatically generate an id number for you where you don't provide one. These id numbers are essentially integer hashes of whatever string you use. Don't add the "_id" if you're referencing the named version:

# recipes.yml
chicken_soup:
  cookbook: my_recipes

# cookbooks.yml
my_recipes:
  title: My Test Cookbook