Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Rails fixtures -- how do you set foreign keys?

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?

like image 371
Ethan Avatar asked Feb 04 '09 05:02

Ethan


2 Answers

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
like image 108
Andrew Vit Avatar answered Oct 04 '22 18:10

Andrew Vit


Additionally, if you wish to have a many to many association ( HABTM ) you just give an array for the association in the fixture:

# recipes.yml
chicken_soup:
  cookbooks: [my_recipes, another_recipe]
like image 22
manosagent Avatar answered Oct 04 '22 17:10

manosagent