Sounds fine to me. What's the problem? Blog: http://random8.zenunit.com/ Learn rails: http://sensei.zenunit.com/
On 06/02/2009, at 6:02 AM, Ojis <[email protected]> wrote: > > Hello Gurus! > > 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. > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
