<div dir="ltr">Hi Jesse<br><br>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? <br><br>Another idea: would passing newest_stat and oldest_stat as arguments to execute make things any simpler?<br><br>Your error seems to be because 'assign_attributes' expects you to pass an array of attributes, but you're not passing it anything: <a href="http://api.rubyonrails.org/classes/ActiveModel/AttributeAssignment.html#method-i-assign_attributes">http://api.rubyonrails.org/classes/ActiveModel/AttributeAssignment.html#method-i-assign_attributes</a><br><br>Best of luck<br><br>Duncan</div><div class="gmail_extra"><br><div class="gmail_quote">On 8 March 2017 at 13:10, Jesse Waites <span dir="ltr"><<a href="mailto:jesse.waites@gmail.com" target="_blank">jesse.waites@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi all--<div><br></div><div>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)</div><div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>At the end of the day, I think I'd like to be able to do ReportCard.create(:user_id => <a href="http://current_user.id" target="_blank">current_user.id</a>, 6, 7)</div><div><br></div><div>with 6 and 7 being the ID number of the reports I want comparisons from.</div><div><br></div><div><br></div><div><br></div><div><br></div><div>I am trying it this way but am getting "wrong number of arguments:</div><div><br></div><div><br></div><div><br></div><div><br></div><div><div>class ReportCard < ActiveRecord::Base</div><div> belongs_to :user</div><div><br></div><div> attr_accessible :user_id, :oldest_report_stat_id, :newest_report_stat_id, :num_active_and_licensed_aeds,</div><div> :num_active_sites, :num_users_logged_in, :aeds_total, :aeds_compliant, :aed_sites_total,</div><div> :aed_sites_compliant, :responders_total, :responders_compliant, :num_active_and_licensed_aeds_<wbr>percentage,</div><div> :num_active_sites_percentage, :num_users_logged_in_<wbr>percentage, :aeds_compliant_percentage,</div><div> :aed_site_compliant_<wbr>percentage, :responders_compliant_<wbr>percentage, :report_start_time, :report_end_time</div><div><br></div><div><br></div><div><br></div><div> def execute</div><div> @newest_stat = ReportStat.find(self.newest_<wbr>report_stat_id)</div><div> @oldest_stat = ReportStat.find(self.oldest_<wbr>report_stat_id)</div><div> #@newest_stat.inspect</div><div> @newest_stat.assign_<wbr>attributes.each do |attr_name, attr_value|</div><div> self.send("#{attr_name}=", "#{attr_value}")</div><div> end</div><div> # calculate_percentage_change</div><div> end</div><div><br></div><div>end</div><div><br></div><div>Here is my rails console output:</div><div><br></div><div><pre style="color:rgb(0,0,0)">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_<wbr>percentage: nil, num_active_sites_percentage: nil, num_users_logged_in_<wbr>percentage: nil, aeds_compliant_percentage: nil, aed_site_compliant_percentage: nil, responders_compliant_<wbr>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/<wbr>2.1.1/lib/ruby/gems/2.1.0/<wbr>gems/activerecord-3.2.17/lib/<wbr>active_record/attribute_<wbr>assignment.rb:66:in `assign_attributes'</pre></div><div><br></div><div><br></div><div>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!</div><span class="HOEnZb"><font color="#888888"><div><br></div><div><br></div><div><br></div><div><br></div>-- <br><div class="m_-4993514936355715488gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div>Jesse Waites</div><div>Web Developer</div><div><a href="http://JesseWaites.com" target="_blank">JesseWaites.com</a></div></div></div></div></div></div></div></div>
</font></span></div></div>
<br>______________________________<wbr>_________________<br>
Chat mailing list<br>
<a href="mailto:Chat@lists.lrug.org">Chat@lists.lrug.org</a><br>
Archives: <a href="http://lists.lrug.org/pipermail/chat-lrug.org" rel="noreferrer" target="_blank">http://lists.lrug.org/<wbr>pipermail/chat-lrug.org</a><br>
Manage your subscription: <a href="http://lists.lrug.org/options.cgi/chat-lrug.org" rel="noreferrer" target="_blank">http://lists.lrug.org/options.<wbr>cgi/chat-lrug.org</a><br>
List info: <a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" rel="noreferrer" target="_blank">http://lists.lrug.org/<wbr>listinfo.cgi/chat-lrug.org</a><br>
<br></blockquote></div><br></div>