I have a problem with legacy database-schema and I would like to get some ideas and suggestions how to handle it with ActiveRecord. First the idea with database is that there can be several versions of the same data. Current data is only one row but the same data can be saved on several rows.
Example: identification varchar2(10) area varchar2(30) owner varchar2(50) effective_date datetime termination_date datetime
The SQL used to get current data is: select * from example_table e where e.identification='123456' and termination_date is null and effective_date=(select max (effective_data) from example_data where identification='123456')
What I would like to achieve is at least partially RESTful wrapper around the datamodel. There are dozens of tables like the example and there aren't any integrity constraints defined (no foreign keys used). Responsibility of the data-integrity is pushed to the application logic.
Yes, if it were up to me the legacy schema would be modified and made more sensible. Unfortunately I cannot affect since my application isn't the only one using it. So I'm stuck with situation where I just have to live with it.
I probably build couple of prototypes for managers with Sinatra before making a full-blown rails-app. What would be the best way to wrap this kind of datamodel under ActiveRecord-umbrella? Loads of custom SQL at least I think.