YAML fixture referencing other fixture entries

Hi all,

I'm testing an application with questionnaires and pages in each questionnaire. Suppose I have 3 yaml files (and corresponding tables): questionnaires, pages and questionnaire_pages

In questionnaires.yml I have...

staff_application: title: "Staff Application" id: 1

In pages.yml I have...

intro_page: id: 1 title: "Introduction"

In questionnaire_pages.yml I want to do something like...

staff_application_intro: id: 1 questionnaire_id: staff_application.id <-- substitutes 1 from staff_application: id: in questionnaires.yml page_id: intro_page.id <-- substitutes 1 from intro_page: id: in questionnaire_pages.yml

Any way to do this? Otherwise, I'm sure you could see with a lot of pages in the staff application it would be tough to get any information out of questionnaire_pages with static integer ids.

Solutions I've come up with use irb escapes, either with global hashes or Table.find methods. It's pretty ugly because it introduces load order dependencies (ie staff_application_intro would have to be loaded last). I would think this is something a lot of rails testers would want. Any ideas?

thanks, -Andrew