I think possibly the biggest issue with bringing views into AR's
schema notation is that most (useful) views don't just contain columns
from other tables; they often perform functions (SUM, AVG). From
looking at the current plugin, it seems like you'd end up having to
write that as a fairly explicit SQL statement, and I'm not sure in
such cases how great the value in using Ruby to declare the columns.
In a nutshell, is
create_view :v_stuff, %{
SELECT thing_id, other_thing_id, SUM(stuff) as blah
FROM things, other things
WHERE thing_attribute LIKE "wibble"
GROUP BY other_things.cost
} do |v|
v.column :thing_id
v.column :other_thing_id
v.column :blah
end
really that much better than
SomeModel.connection.execute %{
CREATE VIEW v_stuff AS (
SELECT thing_id, other_thing_id, SUM(stuff) as blah
FROM things, other things
WHERE thing_attribute LIKE "wibble"
GROUP BY other_things.cost )
}
... I'm not sure. Convince me, because we're using views with
legacy-style databases at the moment, and if anything can be done make
this simpler, I'm definitely interested.
- James
On 1/12/07, Anthony Eden <[EMAIL PROTECTED]> wrote:
>
> One of the items which has come out of the ActiveWarehouse plugin
> development is the Rails SQL Views plugin. It adds support for
> create_view and drop_view statements in migrations and also supports
> extracting those elements to the schema.rb dump. Currently it is
> implemented for MySQL and PostgreSQL. Is there any interest in
> eventually moving this code into ActiveRecord or should it just remain
> as an extension gem/plugin?
>
> If there is interest to bring it into the AR core then I can create
> the patches for it.
>
> Thoughts?
>
> V/r
> Anthony Eden
>
> --
> Cell: 808 782-5046
> Current Location: Melbourne, FL
>
> >
>
--
* J *
~
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" 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-core?hl=en
-~----------~----~----~----~------~----~------~--~---
