API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 24th, 2017
381
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.32 KB | None | 0 0
raw download clone embed print report
  1. production> u = User.where(email: 'kibel.maria@gmail.com').first
  2. User Load (5.9ms) SELECT "users".* FROM "users" WHERE "users"."email" = 'kibel.maria@gmail.com' LIMIT 1
  3. => #<User id: 1355678, email: "kibel.maria@gmail.com", created_at: "2016-10-26 07:42:11", updated_at: "2017-10-24 08:42:17", encrypted_password: "527af44f3a0112ecd1612d106a549c38ce19b88c", salt: "gAoIeSTrOB5RkVmQ1vQ5", persistence_token: "1360ba30df93617f59c2cb99638ab610058883b58ce90e331c6...", remember_token_expires_at: nil, email_confirmed: true, perishable_token: "WHbvKUp4Jpf4G6y1cp", state: "active", is_pcim_user: false, url_auth_token: "378dd2ee49c77dbb30c179ffeb19d625", spam_complaints_count: 0, spam_state: "clean", terms_agree: true, last_signed_in: nil, sso_token: "f988f28b1ede9ccded7bd4c8f42c5a9b6eb601e4bc02f5d1b6b...", sso_token_updated_at: "2017-10-24 08:42:17", unused_email: false, phone: nil, email_is_unreachable: false, primary_provider: "email", sid: nil, unsubscription_reason: nil, registration_ip: nil>
  4. production> c = Company.find 14094574
  5. Company Load (1.2ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 14094574 LIMIT 1
  6. => #<Company id: 14094574, name: "Enterprise NCC-1701", name_rest: nil, synonym: "", description: nil, created_at: "2016-10-26 07:42:12", updated_at: "2017-10-18 13:52:48", rubrics_denorm: nil, regions: "0,1", title_ord: 96438267578254.0, first_letter_ord: 101, packet: 0, state: "pending", name_alt: nil, oferta_sync_id: nil, oferta_online_flag: nil, moderated_at: nil, moderator_message: nil, moderated_by: nil, updated_by: nil, updated_issues: nil, annonce: nil, has_email: nil, pricelist_actualized_at: nil, csv_id: nil, tmp: false, is_paid: false, paid_till: nil, is_pricelist_online: true, products_count: 1, products_limit: 30, products_region_id: 1, regions_with_comm: "0,1", b_types_denorm: nil, is_price_notification_visible: nil, main_region_id: 1, industries_denorm: nil, thematic_rubrics_denorm: "31023,30902,33192,33194,33196,33199,33193,33198,331...", is_online_store: false, news_count: 0, images_count: 1, showcases_count: 0, main_company_id: nil, videos_count: 0, online_store_type: nil, original_id: nil, original_state: nil, actualized_at: nil, deleted_at: nil, no_public_products_count: 2, pricelist_mass_actualized_at: nil, has_regional_product_properties: false>
  7. production> attrs = {title: "Новинка", start_date: "3.10.2017", end_date: "30.10.2017", state: "published", type: 'Apress::Deals::Offers::MarketingLabel', description: "Новинка", for_home_page: "0", offer_regions_attributes: [{region_id: c.main_region_id}], priority: "default"}
  8. => {:title=>"Новинка", :start_date=>"3.10.2017", :end_date=>"30.10.2017", :state=>"published", :type=>"Apress::Deals::Offers::MarketingLabel", :description=>"Новинка", :for_home_page=>"0", :offer_regions_attributes=>[{:region_id=>1}], :priority=>"default"}
  9. production> s = Apress::Deals::Offers::UpdateService.new(Apress::Deals::Offer.new, attrs, user: u, company: c)
  10. => #<Apress::Deals::Offers::UpdateService:0x00000017ee6f30 @offer=#<Apress::Deals::Offer id: nil, title: nil, company_id: nil, type: nil, description: nil, start_date: nil, end_date: nil, publication_at: nil, activity: "message", priority: nil, state: nil, properties: {}, slug: nil, creator_id: nil, created_at: nil, updated_at: nil, products_count: 0>, @params={:title=>"Новинка", :start_date=>"3.10.2017", :end_date=>"30.10.2017", :state=>"published", :type=>"Apress::Deals::Offers::MarketingLabel", :description=>"Новинка", :for_home_page=>"0", :offer_regions_attributes=>[{:region_id=>1}], :priority=>"default"}, @user=#<User id: 1355678, email: "kibel.maria@gmail.com", created_at: "2016-10-26 07:42:11", updated_at: "2017-10-24 08:42:17", encrypted_password: "527af44f3a0112ecd1612d106a549c38ce19b88c", salt: "gAoIeSTrOB5RkVmQ1vQ5", persistence_token: "1360ba30df93617f59c2cb99638ab610058883b58ce90e331c6...", remember_token_expires_at: nil, email_confirmed: true, perishable_token: "WHbvKUp4Jpf4G6y1cp", state: "active", is_pcim_user: false, url_auth_token: "378dd2ee49c77dbb30c179ffeb19d625", spam_complaints_count: 0, spam_state: "clean", terms_agree: true, last_signed_in: nil, sso_token: "f988f28b1ede9ccded7bd4c8f42c5a9b6eb601e4bc02f5d1b6b...", sso_token_updated_at: "2017-10-24 08:42:17", unused_email: false, phone: nil, email_is_unreachable: false, primary_provider: "email", sid: nil, unsubscription_reason: nil, registration_ip: nil>, @company=#<Company id: 14094574, name: "Enterprise NCC-1701", name_rest: nil, synonym: "", description: nil, created_at: "2016-10-26 07:42:12", updated_at: "2017-10-18 13:52:48", rubrics_denorm: nil, regions: "0,1", title_ord: 96438267578254.0, first_letter_ord: 101, packet: 0, state: "pending", name_alt: nil, oferta_sync_id: nil, oferta_online_flag: nil, moderated_at: nil, moderator_message: nil, moderated_by: nil, updated_by: nil, updated_issues: nil, annonce: nil, has_email: nil, pricelist_actualized_at: nil, csv_id: nil, tmp: false, is_paid: false, paid_till: nil, is_pricelist_online: true, products_count: 1, products_limit: 30, products_region_id: 1, regions_with_comm: "0,1", b_types_denorm: nil, is_price_notification_visible: nil, main_region_id: 1, industries_denorm: nil, thematic_rubrics_denorm: "31023,30902,33192,33194,33196,33199,33193,33198,331...", is_online_store: false, news_count: 0, images_count: 1, showcases_count: 0, main_company_id: nil, videos_count: 0, online_store_type: nil, original_id: nil, original_state: nil, actualized_at: nil, deleted_at: nil, no_public_products_count: 2, pricelist_mass_actualized_at: nil, has_regional_product_properties: false>, @temporarily_hidden=nil>
  11. production> s.call
  12. WARNING: Can't mass-assign protected attributes: type
  13. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 14094574 LIMIT 1
  14. (0.4ms) BEGIN
  15. CompanyRegionCommercial Load (0.9ms) SELECT "company_region_commercials".* FROM "company_region_commercials" WHERE "company_region_commercials"."company_id" = 14094574
  16. (1.4ms) SELECT COUNT(*) FROM "deals"."offers" WHERE "deals"."offers"."type" IN ('Apress::Deals::Offers::MarketingLabel') AND "deals"."offers"."company_id" = 14094574 AND "deals"."offers.state" = 'published'
  17. (0.3ms) ROLLBACK
  18. ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: missing FROM-clause entry for table "deals"
  19. LINE 1: ... AND "deals"."offers"."company_id" = 14094574 AND "deals"."o...
  20. ^
  21. : SELECT COUNT(*) FROM "deals"."offers" WHERE "deals"."offers"."type" IN ('Apress::Deals::Offers::MarketingLabel') AND "deals"."offers"."company_id" = 14094574 AND "deals"."offers.state" = 'published'
  22. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/apress-utils-2.4.0/lib/apress/utils/extensions/active_record/connection_adapters/postgre_sql_adapter.rb:27:in `async_exec'
  23. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/apress-utils-2.4.0/lib/apress/utils/extensions/active_record/connection_adapters/postgre_sql_adapter.rb:27:in `exec_no_cache'
  24. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:660:in `block in exec_query'
  25. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
  26. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  27. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
  28. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:659:in `exec_query'
  29. from (eval):9:in `exec_query_with_at_active_record'
  30. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:1262:in `select'
  31. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all'
  32. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'
  33. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:24:in `select_one'
  34. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:30:in `select_value'
  35. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/relation/calculations.rb:250:in `execute_simple_calculation'
  36. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/relation/calculations.rb:215:in `perform_calculation'
  37. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/relation/calculations.rb:159:in `calculate'
  38. ... 18 levels...
  39. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:259:in `block (2 levels) in save'
  40. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:313:in `block in with_transaction_returning_status'
  41. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
  42. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:208:in `transaction'
  43. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:311:in `with_transaction_returning_status'
  44. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:259:in `block in save'
  45. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:270:in `rollback_active_record_state!'
  46. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:258:in `save'
  47. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/active_scaffold-3.3.3/lib/active_scaffold/extensions/unsaved_record.rb:15:in `save_with_unsaved_flag'
  48. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/bundler/gems/apress-deals-9be7bbcc0974/app/services/apress/deals/offers/update_service.rb:29:in `call'
  49. from (irb):14
  50. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/railties-3.2.22.5/lib/rails/commands/console.rb:47:in `start'
  51. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/railties-3.2.22.5/lib/rails/commands/console.rb:8:in `start'
  52. from /home/blizko/static/blizko/local/bundle/ruby/2.2.0/gems/railties-3.2.22.5/lib/rails/commands.rb:41:in `<top (required)>'
  53. from script/rails:6:in `require'
  54. from script/rails:6:in `<main>'
  55. production>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!