Sorry it's such a long one, but hopefully you'll find it an interesting problem.
I want to keep track of the versions of several of my tables -- at the moment there are 7, but I may add more as the project develops -- so I need something a little more DRY than acts_as_versioned. I've finally come across a solution which I'm happy with the DRYness of (although it's a little abstract), but the problem is trying to represent some of my relations effectively. Each record in each of the versioned tables represents a page on my site, so I've created a pages table to represent them generically. Here's how the link works:
A Page object belongs to a PageType (such as "employee" or "workplace"), and a Page has many Revisions. The revisions table stores stuff like the user who edited the page, the "status" of the revision and the time. The Revision object is linked polymorphically to all the different different tables, each representing a page type and containing the relevant data. So, in this example, there's an employees table and a workplaces table:
[page_types]--------->[pages]-------->[revisions]<------(polymorphic association with [employees], [workplaces], etc.)
The problem is, I need an employee to belong_to a workplace, so the employees table (which holds the revisions of the emplyee data) should belong_to the pages table. It can't be linked to the workplaces table, because that holds versions too, and I would have to link to a specific version, which I don't want to.
Nearly all the page types are linked to another page in some way, so I thought, rather than make all those belongs_tos, why not just put the belongs_to in the Revision class. You follow? So now I have the Revision class belonging to the Page class /twice/. I want the second association to change name depending on what the page type (or "revisable_type" field... they hold the same information) says. So as well as having myEmployeeRevision.page (which would be used for the first association), I want myEmployee.workplace for the second association, where workplace is the Page object associated with a workplace. I'm sure it can be done, but how?
