2010/11/26 Eduardo Yáñez Parareda <[email protected]>: > Hello, > > I have custom queries that joins several tables, so I have written a > model class to represent those data. I have extended it from > ActiveRecord::Base in order to be able to use 'find_by_sql'. When I > call 'find_by_sql' it seems to work fine, in the debugger I can see > every record retrieved from DB with their values, but when I try to > access those values through some accessors, they don't give me > anything.
Are you absolutely sure you cannot do it using normal rails relationships and avoid find_by_sql? Colin > > This is my class: > > class ProjectsReport < ActiveRecord::Base > > attr_accessor :total_hours, :group_name, :project_type, :request_type > > def initialize(total_hours, group_name, project_type, request_type) > �...@total_hours = total_hours > �...@group_name = group_name > �...@project_type = project_type > �...@request_type = request_type > end > end > > If I use another class that has a table associated to call > find_by_sql, everything works fine, but that isn't a good design. > > # This doesn't work because ProjectsReport doesn't have any table on > DB? > �...@records = > ProjectsReport.find_by_sql(create_projects_report_query(start_date, > end_date)) > > # This works but TimeEntry doesn't have anything related with > information retrieved by the query > �...@records = > TimeEntry.find_by_sql(create_projects_report_query(start_date, > end_date)) > > What must I add to ProjectsReport to get it working? > > -- > 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. > > -- 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.
