From: "Ara.T.Howard" <ara.t.howard@...>
Date: 2005-11-27T05:26:37+09:00
Subject: supporting/emulating updatable views in a ruby orm



i've got a method to emulate updateable views in postgresql which is rather
simple.  however, i'm wondering if any of the ruby orms out there would
support such a beast.  for example, given:

     create table foo(
       foo text,
       id serial,

       primary key (id)
     );

     create table bar(
       bar text,
       foo_id integer,
       id serial,

       primary key (id),
       foreign key (foo_id) references foo (id)
     );

     create view foobar as
       select
         foo.foo as foo,
         bar.bar as bar
       from foo, bar
       where foo.id = bar.foo_id;

i need to be able to do something like this:

   db = DB::new options

   foo = db.table "foo"
   bar = db.table "bar"

   foobar = db.view "foobar"

   foobar[0]["foo"] = "42"
   foobar[0]["bar"] = "forty-two"

   p foo[0]["foo"] #=> "42"
   p bar[0]["bar"] #=> "forty-two"

i can do this using my code if the view is constructed a certain way, but i'm
wondering of any of the existing orms have addressed this rather common need?

regards.

-a
-- 
===============================================================================
| ara [dot] t [dot] howard [at] noaa [dot] gov
| all happiness comes from the desire for others to be happy.  all misery
| comes from the desire for oneself to be happy.
| -- bodhicaryavatara
===============================================================================