[LRUG] Need advice on creating Model Type A with same data from Model type B

Wed Mar 8 06:36:46 PST 2017

Thats awesome, tried that, get same error:

except_keys = [:id, :created_at, :updated_at]
=> [:id, :created_at, :updated_at]
[36] pry(main)>
r.assign_attributes(@newest_stat.attributes.except(*except_keys))

ActiveModel::MassAssignmentSecurity::Error: Can't mass-assign
protected attributes: id, created_at, updated_at
from /Users/enpro/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activemodel-3.2.17/lib/active_model/mass_assignment_security/sanitizer.rb:48:in
`process_removed_attributes'
[37] pry(main)> r.assign_attributes(@newest_stat.attributes.except(except_keys))

ActiveModel::MassAssignmentSecurity::Error: Can't mass-assign
protected attributes: id, created_at, updated_at
from /Users/enpro/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activemodel-3.2.17/lib/active_model/mass_assignment_security/sanitizer.rb:48:in
`process_removed_attributes'

On Wed, Mar 8, 2017 at 9:32 AM, Toby Privett <tobyprivett at gmail.com> wrote:

> I'm working on something similar today :-) and doing something like this:
>
> except_keys = [:id, :created_at, etc.]
>  r.assign_attributes(@newest_stat.attributes.except(*except_keys))
>
> On Wed, 8 Mar 2017 at 14:25 Jesse Waites <jesse.waites at gmail.com> wrote:
>
>> @Duncan:
>>
>> "Is there a reason that ReportCards need to be saved to the database?
>> Would it make sense to instead generate them 'on-demand' based on the data
>> from ReportStats?"
>>
>> I had the same thought, but am told that there is a 99% chance our users
>> will want to see these Report Cards in the web app at some point, so makes
>> sense to just make active record objects out of them, so they can be scoped
>> old to new, new to old, etc. Good thought, though, I was leaning the same
>> way initially.
>>
>> @Toby:
>>
>> You are awesome, your advice got me going in the right direction. I am
>> now at:
>>
>> r.assign_attributes(@newest_stat.attributes)
>> ActiveModel::MassAssignmentSecurity::Error: Can't mass-assign protected attributes: id, created_at, updated_at
>>
>>
>> Just got that error though, havent even started looking up how to fix it yet but Im sure Ill come up with something!
>>
>> Maybe make a new object and strip those from it before calling .attrributes or stripping them from Report Stat first.
>>
>>
>>
>> On Wed, Mar 8, 2017 at 9:12 AM, Toby Privett <tobyprivett at gmail.com>
>> wrote:
>>
>> Correction: "I think you are looking for *something that can iterate*"
>>
>> On Wed, 8 Mar 2017 at 14:10 Toby Privett <tobyprivett at gmail.com> wrote:
>>
>> #assign_attributes expects a hash http://apidock.com/rails/
>> v4.2.7/ActiveRecord/AttributeAssignment/assign_attributes
>>
>> I think you are looking for an iterator
>> e.g. @newest_stat.attributes
>>
>> Hope that helps
>>
>> On Wed, 8 Mar 2017 at 14:01 Jesse Waites <jesse.waites at gmail.com> wrote:
>>
>> Hi all--
>>
>> I have been tasked with building a report card feature. The end goal of
>> this is that the user gets a monthly email with various statistics (Users
>> logged in, Sites activated, things like hat)
>>
>> I have settled on Report Stat model and Report Card models. One a month,
>> Report Stat will run and save that data. I take the last 2 report stats (or
>> any 2 report stats, really - thats why I built it this way) and generate
>> the Report Card.
>>
>> The thing is, most of the data from the Report Card will be the same data
>> from the most recent Report Stat. The users_logged_in from the most recent
>> Report Stat scan will be the number of users_logged_in in the Report Card.
>> There are a few instances where I will want a percentage increase or
>> decrease between Report Stats, I have a integer column ready for that and
>> will just perform simple math on :users_logged_in between my various time
>> frames via various Report Stats.
>>
>> My issue is, how can I most easily transplant the data from ReportStat
>> into the ReportCard. I could so it manually column by column but that seems
>> like the wrong way to do it, I want to do it programmatically. The columns
>> and datatypes are all the same.
>>
>> At the end of the day, I think I'd like to be able to do
>> ReportCard.create(:user_id => current_user.id, 6, 7)
>>
>> with 6 and 7 being the ID number of the reports I want comparisons from.
>>
>>
>>
>>
>> I am trying it this way but am getting "wrong number of arguments:
>>
>>
>>
>>
>> class ReportCard < ActiveRecord::Base
>>   belongs_to :user
>>
>>   attr_accessible :user_id, :oldest_report_stat_id,
>> :newest_report_stat_id, :num_active_and_licensed_aeds,
>>   :num_active_sites, :num_users_logged_in, :aeds_total, :aeds_compliant,
>> :aed_sites_total,
>>   :aed_sites_compliant, :responders_total, :responders_compliant,
>> :num_active_and_licensed_aeds_percentage,
>>   :num_active_sites_percentage, :num_users_logged_in_percentage,
>> :aeds_compliant_percentage,
>>   :aed_site_compliant_percentage, :responders_compliant_percentage,
>> :report_start_time, :report_end_time
>>
>>
>>
>>   def execute
>>     @newest_stat = ReportStat.find(self.newest_report_stat_id)
>>     @oldest_stat = ReportStat.find(self.oldest_report_stat_id)
>>     #@newest_stat.inspect
>>     @newest_stat.assign_attributes.each do |attr_name, attr_value|
>>       self.send("#{attr_name}=", "#{attr_value}")
>>     end
>>     # calculate_percentage_change
>>   end
>>
>> end
>>
>> Here is my rails console output:
>>
>> r = ReportCard.new
>> => #<ReportCard id: nil, user_id: nil, created_at: nil, updated_at: nil, oldest_report_stat_id: nil, newest_report_stat_id: nil, num_active_and_licensed_aeds: nil, num_active_sites: nil, num_users_logged_in: nil, aeds_total: nil, aeds_compliant: nil, aed_sites_total: nil, aed_sites_compliant: nil, responders_total: nil, responders_compliant: nil, num_active_and_licensed_aeds_percentage: nil, num_active_sites_percentage: nil, num_users_logged_in_percentage: nil, aeds_compliant_percentage: nil, aed_site_compliant_percentage: nil, responders_compliant_percentage: nil, report_start_time: nil, report_end_time: nil>
>> [2] pry(main)> r.oldest_report_stat_id = 6
>> => 6
>> [3] pry(main)> r.newest_report_stat_id = 7
>> => 7
>> [4] pry(main)> r.execute
>>   ReportStat Load (1.3ms)  SELECT "report_stats".* FROM "report_stats" WHERE "report_stats"."id" = $1 LIMIT 1  [["id", 7]]
>>   ReportStat Load (0.4ms)  SELECT "report_stats".* FROM "report_stats" WHERE "report_stats"."id" = $1 LIMIT 1  [["id", 6]]
>> ArgumentError: wrong number of arguments (0 for 1..2)
>> from /Users/enpro/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activerecord-3.2.17/lib/active_record/attribute_assignment.rb:66:in `assign_attributes'
>>
>>
>>
>> Any ideas? Maybe syntax error? Ive dumped way too much time into this and
>> need to move on to the rest of the feature. Thank you LRUG!
>>
>>
>>
>>
>> --
>> Jesse Waites
>> Web Developer
>> JesseWaites.com
>> _______________________________________________
>> Chat mailing list
>> Chat at lists.lrug.org
>> Archives: http://lists.lrug.org/pipermail/chat-lrug.org
>> Manage your subscription: http://lists.lrug.org/options.cgi/chat-lrug.org
>> List info: http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>>
>>
>> _______________________________________________
>> Chat mailing list
>> Chat at lists.lrug.org
>> Archives: http://lists.lrug.org/pipermail/chat-lrug.org
>> Manage your subscription: http://lists.lrug.org/options.cgi/chat-lrug.org
>> List info: http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>>
>>
>>
>>
>> --
>> Jesse Waites
>> Web Developer
>> JesseWaites.com
>> _______________________________________________
>> Chat mailing list
>> Chat at lists.lrug.org
>> Archives: http://lists.lrug.org/pipermail/chat-lrug.org
>> Manage your subscription: http://lists.lrug.org/options.cgi/chat-lrug.org
>> List info: http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>>
>
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> Archives: http://lists.lrug.org/pipermail/chat-lrug.org
> Manage your subscription: http://lists.lrug.org/options.cgi/chat-lrug.org
> List info: http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>
>

-- 
Jesse Waites
Web Developer
JesseWaites.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20170308/d397acfc/attachment-0002.html>