Skip to content

Instantly share code, notes, and snippets.

@crova

crova/gist:c4c41538a9dc89248eff074b6c1cac71

Last active June 12, 2016 12:40
Show Gist options
  • Save crova/c4c41538a9dc89248eff074b6c1cac71 to your computer and use it in GitHub Desktop.
Save crova/c4c41538a9dc89248eff074b6c1cac71 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Shoot Load (0.3ms) SELECT "shoots".* FROM "shoots" WHERE "shoots"."campaign_id" = $1 LIMIT 1 [["campaign_id", "136"]]
(0.2ms) BEGIN
SQL (0.3ms) INSERT INTO "shoots" ("campaign_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["campaign_id", "136"], ["created_at", "2016-06-12 12:31:33.265367"], ["updated_at", "2016-06-12 12:31:33.265367"]]
(4.0ms) COMMIT
(0.2ms) BEGIN
SQL (0.7ms) UPDATE "shoots" SET "id" = $1, "campaign_name" = $2, "subject" = $3, "bat_sent" = $4, "type" = $5, "html_content" = $6, "entered" = $7, "modified" = $8, "status" = $9, "sent" = $10, "remaining" = $11, "listid" = $12, "exclude_list" = $13, "scheduled_date" = $14, "filter" = $15, "tags" = $16, "header" = $17, "footer" = $18, "from_name" = $19, "from_email" = $20, "form_name" = $21, "reply_to" = $22, "delivered" = $23, "unique_views" = $24, "viewed" = $25, "clicked" = $26, "clicker" = $27, "hard_bounce" = $28, "soft_bounce" = $29, "unsub" = $30, "mirror_click" = $31, "complaints" = $32, "to_field" = $33, "share_link" = $34, "stats_by_domain" = $35, "updated_at" = $36 WHERE "shoots"."id" = $37 [["id", 136], ["campaign_name", "English Town - Actual Sales - Ativos ALL"], ["subject", "{PRENOM} VÁ PARA ORLANDO e PAGUE 30%OFF NO CURSO DE INGLÊS"], ["bat_sent", "yes"], ["type", "classic"], ["html_content", "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html>\n\n<head>\n <title>Coloque seu ingl&ecirc;s em campo - em Orlando!</title>\n <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"> </head>\n\n<body style=\"font-family:arial;margin-top:0;margin-bottom:0;margin-right:0;margin-left:0;padding-top:0;padding-bottom:0;padding-right:0;padding-left:0;width:100% !important;background-color:#ffffff;-webkit-font-smoothing:antialiased;-ms-font-smoothing:antialiased;-o-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale;\">\n <!-- Header Begins -->\n<center><p style=\"color: #FF161A;\n\tfont-family: Lucida Grande, Lucida Sans Unicode, Lucida Sans, DejaVu Sans, Verdana, sans-serif;\n\tfont-style: italic;\n\tfont-size: 40px;\n\ttext-shadow: 1px 2px 5px;\n\ttext-align:center;\n\tmargign:auto;\">A Boa do Dia !</p></center>\n\t <center><a style=\"\n\t width: 195px;\n background: #0AA7FF;\n background-image: -webkit-linear-gradient(top, #3498db, #2980b9);\n background-image: -moz-linear-gradient(top, #3498db, #2980b9);\n background-image: -ms-linear-gradient(top, #3498db, #2980b9);\n background-image: -o-linear-gradient(top, #3498db, #2980b9);\n background-image: linear-gradient(to bottom, #3498db, #2980b9);\n -webkit-border-radius: 28;\n -moz-border-radius: 28;\n border-radius: 28px;\n font-size: 20px;\n padding: 10px 20px 10px 20px;\n text-decoration: none;\n\tfont-family: Lucida Grande, Lucida Sans Unicode, Lucida Sans, DejaVu Sans, Verdana, sans-serif;\n\tfont-style: normal;\n\tborder-radius: 5px;\n\tfont-weight: bold;\n\tcolor: #F3F3F3;\n\ttext-decoration:none;\n\tmargin-right: 155px;\n\t \" href=\"[MIRROR]\">Navegador</a>\n\t <a style=\"\n\t background-color: #FF161A;\n\twidth: 195px;\n background-image: -webkit-linear-gradient(top, #FF161A, #FF161A);\n background-image: -moz-linear-gradient(top, #FF161A, #FF161A);\n background-image: -ms-linear-gradient(top, #FF161A, #FF161A);\n background-image: -o-linear-gradient(top, #FF161A, #FF161A);\n background-image: linear-gradient(to bottom, #FF161A, #FF161A);\n -webkit-border-radius: 28;\n -moz-border-radius: 28;\n border-radius: 28px;\n color: #f3f3f3;\n font-size: 20px;\n\t\t\tborder-radius: 5px;\n padding: 10px 20px 10px 20px;\n text-decoration: none;\n\tfont-family: Lucida Grande, Lucida Sans Unicode, Lucida Sans, DejaVu Sans, Verdana, sans-serif;\n\tfont-style: normal;\n\tfont-weight: bold;\n\ttext-decoration:none;\n\t \" href=\"[UNSUBSCRIBE]\">Descadastrar</a></center>\n\t\n <br />\n\t<br />\n\t<br />\n\n \n <!-- Header Ends -->\n <table width=\"650\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" valign=\"top\" align=\"center\" bgcolor=\"#ffffff\" style=\"border-left-width:1px;border-left-style:solid;border-left-color:#ebebeb;border-right-width:1px;border-right-style:solid;border-right-color:#ebebeb;background-color:#ffffff;width:650px;\">\n <tr>\n <td width=\"650\" height=\"37\" bgcolor=\"#000000\" align=\"center\" valign=\"middle\">\n\n <!-- Colocar o Link da Landing page com sua ETAG abaixo-->\n<a href=\"http://actualmanager.com/click.php?aspid=57e3097646d556ba82bbba0fffe64efa\" target=\"_blank\" name=\"link1\" style=\"color:#FFFFFF;font-family:Arial;font-size:12px;font-weight:bold;text-decoration:none;\">\n Coloque seu ingl&ecirc;s em campo - em Orlando!\n </a>\n </td>\n </tr>\n <tr>\n <td>\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n <tr>\n <td width=\"480\" height=\"74\" style=\"width:500px;line-height:74px;padding-top:0;padding-bottom:0;padding-right:20px;padding-left:20px;\">\n<!-- ALTERAR O LINK DA IMAGEM AQUI -->\n<img src=\"http://imagensinfo.com/englishtown/copa30/images/ef-et-white.png\" width=\"267\" height=\"35\" alt=\"EF Englishtown\" /> </td>\n <td width=\"190\" height=\"74\" style=\"width:190px;padding-right:10px;text-align:center;\">\n <table width=\"190\" align=\"center\" style=\"margin-right:10px;text-align:center;\">\n <tr>\n <td style=\"width:190px;height:30px;background-color:#fcc504;\">\n\n <!-- Colocar o Link da Landing page com sua ETAG abaixo-->\n<a href=\"http://actualmanager.com/click.php?aspid=57e3097646d556ba82bbba0fffe64efa\" name=\"link2\" target=\"_blank\" class=\"botaoAprender\" style=\"display:block;background-color:#fcc504;text-align:center;padding-top:10px;padding-bottom:10px;padding-right:0;padding-left:0;margin-top:0px;margin-bottom:0px;margin-right:0px;margin-left:0px;color:#266134;text-decoration:none;text-transform:uppercase;font-size:14px;font-weight:bold;width:190px;\">\n Saber mais\n </a>\n </td>\n </tr>\n </table>\n </td>\n </tr>\n </table>\n </td>\n </tr>\n <tr>\n <td style=\"padding-top:0;padding-bottom:0;padding-right:0;padding-left:0;\">\n <table cellpadding=\"0\" cellspacing=\"0\" bgcolor=#ffffff>\n <tr>\n <td align=\"center\">\n\n <!-- Colocar o Link da Landing page com sua ETAG abaixo-->\n<a href=\"http://actualmanager.com/click.php?aspid=57e3097646d556ba82bbba0fffe64efa\" target=\"_blank\" name=\"link3\" style=\"text-decoration:none;\">\n\n <!-- ALTERAR O LINK DA IMAGEM AQUI -->\n <img src=\"http://imagensinfo.com/englishtown/copa30/images/copaamerica.jpg\" style=\"border:none; outline:none; color:#FFFFFF\" width=650 alt=\"A Englishtown quer ver seu ingl&ecirc;s em campo. Por isso, estamos com 30% desconto¹. Aproveite.\" />\n </a>\n </td>\n </tr>\n <tr>\n <td align=center>\n <table width=562 fgcolor=white style=\"margin: 20px;\">\n <tr>\n <td style=\"color:#154072; font-size:21px; text-align: center;\">\n Matricule-se j&aacute;, voc&ecirc; ainda concorre a <b>uma viagem para Orlando</b>&sup2; em junho para ver um jogo da sele&ccedil;&atilde;o.\n <br><br>\n Quer mais? Aqui, tem <b>Englishtown sem Crise</b>&sup3;: adiamos duas mensalidades caso precise se recolocar!\n </td>\n </tr>\n </table>\n </td>\n </tr>\n <tr>\n <td align=\"center\">\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"tableGuia\" style=\"background-color:#266134;text-align:center;padding-top:0px;padding-bottom:0px;padding-right:0;padding-left:0;margin-top:0;margin-bottom:0;margin-right:0;margin-left:0;color:#ffffff;text-decoration:none;text-transform:uppercase;font-size:14px;font-weight:bold;width:424px;height:40px;vertical-align:middle;\">\n <tr>\n <td style=\"width:424px;height:40px;vertical-align:middle;\">\n\n <!-- Colocar o Link da Landing page com sua ETAG abaixo-->\n<a href=\"http://actualmanager.com/click.php?aspid=57e3097646d556ba82bbba0fffe64efa\" name=\"link5\" target=\"_blank\" class=\"botaoGuia\" style=\"display:block;width:424px;font-family:arial;background-color:#266134;text-align:center;padding-top:10px;padding-bottom:10px;padding-right:0;padding-left:0;color:#ffffff;text-decoration:none;text-transform:uppercase;font-size:14px;font-weight:bold;\">\n Quero ir com a Englishtown para Orlando!\n </a>\n </td>\n </tr>\n </table>\n </td>\n </tr>\n <tr>\n <td align=\"center\" style=\"padding-top:20px;padding-bottom:20px;padding-right:30px;padding-left:30px;font-size:12px;color:#154072;\">\n <small>\n &sup1;Desconto v&aacute;lido para alunos novos que fizerem a matr&iacute;cula pela primeira vez em um curso Private Teacher entre 15 e 30 de abril de 2016. &sup2;Promo&ccedil;&atilde;o v&aacute;lida para matr&iacute;culas realizadas de 01 de abril de 2016 a 26 de maio de 2016 no curso Private Teacher. Consulte o regulamento para saber mais. &sup3;Com o programa Englishtown sem crise, nossos alunos têm de três a seis meses de mensalidades postergadas em caso de desemprego, mediante apresentação de documento.\n </small>\n </td>\n </tr>\n </table>\n </td>\n </tr>\n <tr>\n <td>\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-top:1px solid #ebebeb; border-bottom:1px solid #ebebeb; width:650px; \">\n <tr>\n <td width=\"200\" height=\"119\" style=\"width:200px;line-height:119px;padding-left:20px;\">\n\n<!-- ALTERAR O LINK DA IMAGEM AQUI -->\n<img src=\"http://imagensinfo.com/englishtown/copa30/images/ef-linkedin.png\" width=\"194\" height=\"100\" border=\"0\" alt=\"EF Linkedin\" />\n </td>\n <td width=\"200\" height=\"119\" style=\"width:200px;line-height:119px;\">\n\n<!-- ALTERAR O LINK DA IMAGEM AQUI -->\n<img src=\"http://imagensinfo.com/englishtown/copa30/images/ias.png\" width=\"194\" height=\"80\" border=\"0\" alt=\"Instituto Ayrton Senna\" style=\"border-left-width:1px;border-left-style:solid;border-left-color:#e1e1e1;border-right-width:1px;border-right-style:solid;border-right-color:#e1e1e1;margin-top:10px;\"/>\n </td>\n <td width=\"200\" height=\"119\" style=\"width:200px;line-height:119px;\">\n\n<!-- ALTERAR O LINK DA IMAGEM AQUI -->\n<img src=\"http://imagensinfo.com/englishtown/copa30/images/cbf-cob.png\" width=\"194\" height=\"100\" border=\"0\" alt=\"CBF e Rio2016\" />\n </td>\n </tr>\n </table>\n </td>\n </tr>\n </table>\n <br>\n <br>\n <br>\n <br>\n <br>\n <br>\n <br>\n <!-- Footer Begins -->\n <center>\n<table width=\"600\" border=\"0\" margin=\"auto\">\n <tbody>\n <tr style=\"width:540px; text-align:center; margin:auto;\">\n <td><p style=\"color: #FF161A;\n\tfont-family: Lucida Grande, Lucida Sans Unicode, Lucida Sans, DejaVu Sans, Verdana, sans-serif;\n\tfont-style: italic;\n\tfont-size: 24px;\n\ttext-shadow: 1px 2px 5px;\">A Boa do Dia - Informa&ccedil;&otilde;es legais</p></td>\n </tr>\n\n\n <tr>\n <td><span style=\"color: grey;\n\tfont-family: Lucida Grande, Lucida Sans Unicode, Lucida Sans, DejaVu Sans, Verdana, sans-serif;\n\tfont-style: italic;\n\tfont-size: 10px;\n\ttext-align:justify;\">Conforme &agrave; lei de Liberdades e Inform&aacute;tica, voc&ecirc; tem direito de cancelar, modificar, atualizar e acessar suas informa&ccedil;&otilde;es quando quiser !<br />\n <br />\n A Boa do Dia &eacute; editado por Crova Media: 27, Rue Avaul&eacute;e - 92240 - Malakoff - Fran&ccedil;a\n <br />\n RCS Nanterre 802254284\n <br />\n Voc&ecirc; pode nos escrever &agrave; qualquer momento no endere&ccedil;o acima ou pelo email: contato@qualaboa.net !\n\t\n \n </td>\n </tr>\n </tbody>\n</table></center> \n<img src=\"http://actualmanager.com/print.php?aspid=102674\" width=\"1\" height=\"1\" border=\"0\" alt=\"0\" /></body>\n\n</html>\n"], ["entered", "2016-04-25"], ["modified", "2016-04-28"], ["status", "Sent"], ["sent", 6012], ["remaining", 0], ["listid", "[33, 34, 75]"], ["exclude_list", "[5, 14, 37, 80, 81, 84, 85, 60]"], ["scheduled_date", "2016-04-30"], ["filter", "[{\"search\"=>{\"listid.id\"=>{\"$nin\"=>[5, 14, 37, 80, 81, 84, 85, 60], \"$in\"=>[33, 34, 75]}, \"deleteAt\"=>{\"$exists\"=>false}}, \"segment_data\"=>[], \"match\"=>\"or\", \"new\"=>\"true\", \"segments_query_txt\"=>nil, \"type\"=>false}]"], ["tags", "Englishtown ativos actual sales ALL"], ["header", "EXISTS"], ["footer", "EXISTS"], ["from_name", "EF Englishtown - A Boa do Dia !"], ["from_email", ""], ["form_name", ""], ["reply_to", "contato@qualaboa.net"], ["delivered", 5961], ["unique_views", 871], ["viewed", 1165], ["clicked", 9], ["clicker", 8], ["hard_bounce", 1], ["soft_bounce", 50], ["unsub", 7], ["mirror_click", 6], ["complaints", 4], ["to_field", ""], ["share_link", 0], ["stats_by_domain", "{\"yahoo.com.br\":{\"sent\":2328,\"delivered\":2327,\"viewed\":463,\"clicked\":2,\"hard_bounce\":0,\"unsub\":2,\"complaints\":3,\"unique_views\":366,\"unique_clicks\":1,\"soft_bounces\":1},\"ig.com.br\":{\"sent\":63,\"delivered\":62,\"viewed\":1,\"clicked\":0,\"hard_bounce\":1,\"unsub\":0,\"complaints\":0,\"unique_views\":1,\"unique_clicks\":0,\"soft_bounces\":0},\"gmail.com\":{\"sent\":1353,\"delivered\":1353,\"viewed\":340,\"clicked\":2,\"hard_bounce\":0,\"unsub\":1,\"complaints\":0,\"unique_views\":227,\"unique_clicks\":2,\"soft_bounces\":0},\"yahoo.com\":{\"sent\":97,\"delivered\":97,\"viewed\":35,\"clicked\":0,\"hard_bounce\":0,\"unsub\":1,\"complaints\":1,\"unique_views\":22,\"unique_clicks\":0,\"soft_bounces\":0},\"hotmail.com\":{\"sent\":655,\"delivered\":655,\"viewed\":84,\"clicked\":1,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":76,\"unique_clicks\":1,\"soft_bounces\":0},\"usp.br\":{\"sent\":5,\"delivered\":5,\"viewed\":2,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":2,\"unique_clicks\":0,\"soft_bounces\":0},\"hotmail.com.br\":{\"sent\":9,\"delivered\":9,\"viewed\":0,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":0,\"unique_clicks\":0,\"soft_bounces\":0},\"bol.com.br\":{\"sent\":742,\"delivered\":742,\"viewed\":97,\"clicked\":1,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":73,\"unique_clicks\":1,\"soft_bounces\":0},\"outlook.com\":{\"sent\":49,\"delivered\":49,\"viewed\":6,\"clicked\":1,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":6,\"unique_clicks\":1,\"soft_bounces\":0},\"oi.com.br\":{\"sent\":39,\"delivered\":39,\"viewed\":0,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":0,\"unique_clicks\":0,\"soft_bounces\":0},\"globomail.com\":{\"sent\":19,\"delivered\":19,\"viewed\":1,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":1,\"unique_clicks\":0,\"soft_bounces\":0},\"ymail.com\":{\"sent\":41,\"delivered\":41,\"viewed\":7,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":6,\"unique_clicks\":0,\"soft_bounces\":0},\"icloud.com\":{\"sent\":48,\"delivered\":48,\"viewed\":13,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":12,\"unique_clicks\":0,\"soft_bounces\":0},\"uol.com.br\":{\"sent\":249,\"delivered\":249,\"viewed\":68,\"clicked\":1,\"hard_bounce\":0,\"unsub\":3,\"complaints\":0,\"unique_views\":50,\"unique_clicks\":1,\"soft_bounces\":0},\"live.com\":{\"sent\":25,\"delivered\":25,\"viewed\":6,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":2,\"unique_clicks\":0,\"soft_bounces\":0},\"globo.com\":{\"sent\":24,\"delivered\":24,\"viewed\":0,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":0,\"unique_clicks\":0,\"soft_bounces\":0},\"terra.com.br\":{\"sent\":35,\"delivered\":null,\"viewed\":0,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":0,\"unique_clicks\":0,\"soft_bounces\":35},\"brturbo.com.br\":{\"sent\":5,\"delivered\":5,\"viewed\":0,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":0,\"unique_clicks\":0,\"soft_bounces\":0},\"msn.com\":{\"sent\":2,\"delivered\":2,\"viewed\":0,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":0,\"unique_clicks\":0,\"soft_bounces\":0},\"outlook.com.br\":{\"sent\":3,\"delivered\":3,\"viewed\":0,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":0,\"unique_clicks\":0,\"soft_bounces\":0},\"zipmail.com.br\":{\"sent\":7,\"delivered\":7,\"viewed\":0,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":0,\"unique_clicks\":0,\"soft_bounces\":0},\"ibest.com.br\":{\"sent\":10,\"delivered\":8,\"viewed\":0,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":0,\"unique_clicks\":0,\"soft_bounces\":2},\"rocketmail.com\":{\"sent\":6,\"delivered\":6,\"viewed\":3,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":2,\"unique_clicks\":0,\"soft_bounces\":0},\"itelefonica.com.br\":{\"sent\":4,\"delivered\":null,\"viewed\":0,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":0,\"unique_clicks\":0,\"soft_bounces\":4},\"sanepar.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},\"superig.com.br\":{\"sent\":7,\"delivered\":7,\"viewed\":0,\"clicked\":0,\"hard_bounce\":0,\"unsub\":0,\"complaints\":0,\"unique_views\":0,\"unique_clicks\":0,\"soft_bounces\":0},\"iclaro.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}}"], ["updated_at", "2016-06-12 12:31:33.277573"], ["id", 135]]
(4.0ms) COMMIT
Shoot Load (0.4ms) SELECT "shoots".* FROM "shoots" WHERE "shoots"."campaign_id" = $1 LIMIT 1 [["campaign_id", "135"]]
(0.2ms) BEGIN
SQL (0.9ms) INSERT INTO "shoots" ("campaign_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["campaign_id", "135"], ["created_at", "2016-06-12 12:31:33.294400"], ["updated_at", "2016-06-12 12:31:33.294400"]]
(0.1ms) ROLLBACK
Completed 500 Internal Server Error in 26548ms (ActiveRecord: 1337.9ms)
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "shoots_pkey"
DETAIL: Key (id)=(136) already exists.
: INSERT INTO "shoots" ("campaign_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id"):
app/controllers/monet_controller.rb:53:in `block in fetch'
app/controllers/monet_controller.rb:52:in `map'
app/controllers/monet_controller.rb:52:in `each'
app/controllers/monet_controller.rb:52:in `fetch'
Rendered /var/lib/gems/2.3.0/gems/actionpack-4.2.6/lib/action_dispatch/middleware/templates/rescues/_source.erb (4.5ms)
Rendered /var/lib/gems/2.3.0/gems/actionpack-4.2.6/lib/action_dispatch/middleware/templates/rescues/_trace.html.erb (1.7ms)
Rendered /var/lib/gems/2.3.0/gems/actionpack-4.2.6/lib/action_dispatch/middleware/templates/rescues/_request_and_response.html.erb (0.6ms)
Rendered /var/lib/gems/2.3.0/gems/actionpack-4.2.6/lib/action_dispatch/middleware/templates/rescues/diagnostics.html.erb within rescues/layout (16.6ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/_markup.html.erb (0.7ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/_inner_console_markup.html.erb within layouts/inlined_string (0.2ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/_prompt_box_markup.html.erb within layouts/inlined_string (0.2ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/style.css.erb within layouts/inlined_string (0.3ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/console.js.erb within layouts/javascript (12.2ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/main.js.erb within layouts/javascript (0.5ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/error_page.js.erb within layouts/javascript (0.3ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/index.html.erb (26.2ms)
Started GET "/monet/fetch" for 127.0.0.1 at 2016-06-12 14:31:33 +0200
Processing by MonetController#fetch as HTML
Shoot Load (1.0ms) SELECT "shoots".* FROM "shoots" WHERE "shoots"."campaign_id" = $1 LIMIT 1 [["campaign_id", "280"]]
(0.1ms) BEGIN
SQL (0.4ms) UPDATE "shoots" SET "share_link" = $1, "updated_at" = $2 WHERE "shoots"."id" = $3 [["share_link", 0], ["updated_at", "2016-06-12 12:31:40.460869"], ["id", 280]]
(4.2ms) COMMIT
Shoot Load (0.4ms) SELECT "shoots".* FROM "shoots" WHERE "shoots"."campaign_id" = $1 LIMIT 1 [["campaign_id", "136"]]
(0.1ms) BEGIN
SQL (0.3ms) UPDATE "shoots" SET "share_link" = $1, "updated_at" = $2 WHERE "shoots"."id" = $3 [["share_link", 0], ["updated_at", "2016-06-12 12:31:43.285455"], ["id", 136]]
(4.1ms) COMMIT
Shoot Load (0.3ms) SELECT "shoots".* FROM "shoots" WHERE "shoots"."campaign_id" = $1 LIMIT 1 [["campaign_id", "135"]]
(0.1ms) BEGIN
SQL (0.7ms) INSERT INTO "shoots" ("campaign_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["campaign_id", "135"], ["created_at", "2016-06-12 12:31:43.296700"], ["updated_at", "2016-06-12 12:31:43.296700"]]
(0.1ms) ROLLBACK
Completed 500 Internal Server Error in 9849ms (ActiveRecord: 692.3ms)
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "shoots_pkey"
DETAIL: Key (id)=(137) already exists.
: INSERT INTO "shoots" ("campaign_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id"):
app/controllers/monet_controller.rb:53:in `block in fetch'
app/controllers/monet_controller.rb:52:in `map'
app/controllers/monet_controller.rb:52:in `each'
app/controllers/monet_controller.rb:52:in `fetch'
Rendered /var/lib/gems/2.3.0/gems/actionpack-4.2.6/lib/action_dispatch/middleware/templates/rescues/_source.erb (5.4ms)
Rendered /var/lib/gems/2.3.0/gems/actionpack-4.2.6/lib/action_dispatch/middleware/templates/rescues/_trace.html.erb (1.8ms)
Rendered /var/lib/gems/2.3.0/gems/actionpack-4.2.6/lib/action_dispatch/middleware/templates/rescues/_request_and_response.html.erb (0.7ms)
Rendered /var/lib/gems/2.3.0/gems/actionpack-4.2.6/lib/action_dispatch/middleware/templates/rescues/diagnostics.html.erb within rescues/layout (18.7ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/_markup.html.erb (0.4ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/_inner_console_markup.html.erb within layouts/inlined_string (0.2ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/_prompt_box_markup.html.erb within layouts/inlined_string (0.3ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/style.css.erb within layouts/inlined_string (0.5ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/console.js.erb within layouts/javascript (13.4ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/main.js.erb within layouts/javascript (0.2ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/error_page.js.erb within layouts/javascript (0.3ms)
Rendered /var/lib/gems/2.3.0/gems/web-console-2.3.0/lib/web_console/templates/index.html.erb (26.6ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment