Skip to content

Instantly share code, notes, and snippets.

@crova
Created June 9, 2016 22:01
Show Gist options
  • Save crova/c0540ed2925d4f8e45e422aada0157ec to your computer and use it in GitHub Desktop.
Save crova/c0540ed2925d4f8e45e422aada0157ec to your computer and use it in GitHub Desktop.
Trying to iterate through each row to update if necessary
irb(main):006:0> rst.each do |row|
irb(main):007:1* Shoot = Shoot.find_by_id(row["id"]) || new
irb(main):008:1> Shoot.attributes = row
irb(main):009:1> Shoot.save!
irb(main):010:1> end
Shoot Load (0.9ms) SELECT "shoots".* FROM "shoots" WHERE "shoots"."id" = $1 LIMIT 1 [["id", 274]]
(irb):7: warning: already initialized constant Shoot
/home/crova/Shelter/Dev/dash/app/models/shoot.rb:1: warning: previous definition of Shoot was here
(0.1ms) BEGIN
SQL (0.4ms) UPDATE "shoots" SET "delivered" = $1, "unique_views" = $2, "viewed" = $3, "clicked" = $4, "clicker" = $5, "share_link" = $6, "stats_by_domain" = $7, "updated_at" = $8 WHERE "shoots"."id" = $9 [["delivered", 2830], ["unique_views", 107], ["viewed", 131], ["clicked", 50], ["clicker", 49], ["share_link", 0], ["stats_by_domain", "{\"hotmail.com\"=>{\"sent\"=>745, \"delivered\"=>734, \"viewed\"=>22, \"clicked\"=>21, \"hard_bounce\"=>11, \"unsub\"=>1, \"complaints\"=>0, \"unique_views\"=>21, \"unique_clicks\"=>21, \"soft_bounces\"=>1}, \"yahoo.com.br\"=>{\"sent\"=>500, \"delivered\"=>488, \"viewed\"=>50, \"clicked\"=>5, \"hard_bounce\"=>9, \"unsub\"=>2, \"complaints\"=>0, \"unique_views\"=>35, \"unique_clicks\"=>4, \"soft_bounces\"=>0}, \"gmail.com\"=>{\"sent\"=>1341, \"delivered\"=>1320, \"viewed\"=>21, \"clicked\"=>9, \"hard_bounce\"=>21, \"unsub\"=>1, \"complaints\"=>0, \"unique_views\"=>21, \"unique_clicks\"=>9, \"soft_bounces\"=>0}, \"uol.com.br\"=>{\"sent\"=>25, \"delivered\"=>23, \"viewed\"=>1, \"clicked\"=>1, \"hard_bounce\"=>2, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>1, \"unique_clicks\"=>1, \"soft_bounces\"=>0}, \"terra.com.br\"=>{\"sent\"=>20, \"delivered\"=>20, \"viewed\"=>5, \"clicked\"=>3, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>5, \"unique_clicks\"=>3, \"soft_bounces\"=>0}, \"ymail.com\"=>{\"sent\"=>10, \"delivered\"=>10, \"viewed\"=>1, \"clicked\"=>1, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>1, \"unique_clicks\"=>1, \"soft_bounces\"=>0}, \"yahoo.com\"=>{\"sent\"=>28, \"delivered\"=>25, \"viewed\"=>3, \"clicked\"=>0, \"hard_bounce\"=>3, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>2, \"unique_clicks\"=>0, \"soft_bounces\"=>0}, \"globo.com\"=>{\"sent\"=>15, \"delivered\"=>15, \"viewed\"=>8, \"clicked\"=>1, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>4, \"unique_clicks\"=>1, \"soft_bounces\"=>0}, \"icloud.com\"=>{\"sent\"=>12, \"delivered\"=>2, \"viewed\"=>0, \"clicked\"=>0, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>0, \"unique_clicks\"=>0, \"soft_bounces\"=>0}, \"bol.com.br\"=>{\"sent\"=>110, \"delivered\"=>108, \"viewed\"=>11, \"clicked\"=>4, \"hard_bounce\"=>2, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>10, \"unique_clicks\"=>4, \"soft_bounces\"=>0}, \"oi.com.br\"=>{\"sent\"=>20, \"delivered\"=>19, \"viewed\"=>2, \"clicked\"=>2, \"hard_bounce\"=>1, \"unsub\"=>1, \"complaints\"=>0, \"unique_views\"=>2, \"unique_clicks\"=>2, \"soft_bounces\"=>0}, \"ig.com.br\"=>{\"sent\"=>20, \"delivered\"=>18, \"viewed\"=>4, \"clicked\"=>1, \"hard_bounce\"=>2, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>2, \"unique_clicks\"=>1, \"soft_bounces\"=>0}, \"globomail.com\"=>{\"sent\"=>7, \"delivered\"=>7, \"viewed\"=>2, \"clicked\"=>1, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>2, \"unique_clicks\"=>1, \"soft_bounces\"=>0}, \"hotmail.com.br\"=>{\"sent\"=>7, \"delivered\"=>6, \"viewed\"=>0, \"clicked\"=>0, \"hard_bounce\"=>1, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>0, \"unique_clicks\"=>0, \"soft_bounces\"=>0}, \"gmail.com.br\"=>{\"sent\"=>6, \"delivered\"=>nil, \"viewed\"=>0, \"clicked\"=>0, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>0, \"unique_clicks\"=>0, \"soft_bounces\"=>0}, \"ibest.com.br\"=>{\"sent\"=>4, \"delivered\"=>4, \"viewed\"=>0, \"clicked\"=>0, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>0, \"unique_clicks\"=>0, \"soft_bounces\"=>0}, \"rocketmail.com\"=>{\"sent\"=>1, \"delivered\"=>1, \"viewed\"=>0, \"clicked\"=>0, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>0, \"unique_clicks\"=>0, \"soft_bounces\"=>0}, \"superig.com.br\"=>{\"sent\"=>1, \"delivered\"=>1, \"viewed\"=>0, \"clicked\"=>0, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>0, \"unique_clicks\"=>0, \"soft_bounces\"=>0}, \"live.com\"=>{\"sent\"=>13, \"delivered\"=>13, \"viewed\"=>1, \"clicked\"=>1, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>1, \"unique_clicks\"=>1, \"soft_bounces\"=>0}, \"outlook.com.br\"=>{\"sent\"=>1, \"delivered\"=>1, \"viewed\"=>0, \"clicked\"=>0, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>0, \"unique_clicks\"=>0, \"soft_bounces\"=>0}, \"outlook.com\"=>{\"sent\"=>9, \"delivered\"=>9, \"viewed\"=>0, \"clicked\"=>0, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>0, \"unique_clicks\"=>0, \"soft_bounces\"=>0}, \"msn.com\"=>{\"sent\"=>3, \"delivered\"=>3, \"viewed\"=>0, \"clicked\"=>0, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>0, \"unique_clicks\"=>0, \"soft_bounces\"=>0}, \"itelefonica.com.br\"=>{\"sent\"=>1, \"delivered\"=>nil, \"viewed\"=>0, \"clicked\"=>0, \"hard_bounce\"=>0, \"unsub\"=>0, \"complaints\"=>0, \"unique_views\"=>0, \"unique_clicks\"=>0, \"soft_bounces\"=>0}}"], ["updated_at", "2016-06-09 21:59:20.392749"], ["id", 274]]
(4.4ms) COMMIT
NoMethodError: undefined method `find_by_id' for #<Shoot:0x00000006f167a0>
from /var/lib/gems/2.3.0/gems/activemodel-4.2.6/lib/active_model/attribute_methods.rb:433:in `method_missing'
from (irb):7:in `block in irb_binding'
from (irb):6:in `each'
from (irb):6
from /var/lib/gems/2.3.0/gems/railties-4.2.6/lib/rails/commands/console.rb:110:in `start'
from /var/lib/gems/2.3.0/gems/railties-4.2.6/lib/rails/commands/console.rb:9:in `start'
from /var/lib/gems/2.3.0/gems/railties-4.2.6/lib/rails/commands/commands_tasks.rb:68:in `console'
from /var/lib/gems/2.3.0/gems/railties-4.2.6/lib/rails/commands/commands_tasks.rb:39:in `run_command!'
from /var/lib/gems/2.3.0/gems/railties-4.2.6/lib/rails/commands.rb:17:in `<top (required)>'
from bin/rails:4:in `require'
from bin/rails:4:in `<main>'
irb(main):011:0>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment