Combine polymorphic scopes with or











up vote
1
down vote

favorite












How can I combine two scopes to get both results of them in one query, when they are polymorphic associations? I have this models:



class Vendor < ApplicationRecord
has_many :shipping_method_registers, as: :shipper
has_many :shipping_methods, through: :shipping_method_registers
end

class City < ApplicationRecord
has_many :shipping_method_registers, as: :shipper
has_many :shipping_methods, through: :shipping_method_registers
end

class ShippingMethodRegister < ApplicationRecord
belongs_to :shipping_method
belongs_to :shipper, polymorphic: true
end

class ShippingMethod < ApplicationRecord
has_many :shipping_method_registers, dependent: :destroy, autosave: true
has_many :city_zones, through: :shipping_method_registers, source: :shipper,
source_type: "City"
has_many :vendors, through: :shipping_method_registers, source: :shipper,
source_type: "Vendor"
end


I want to get the shipping methods of a vendor AND a city combined, but only distinct results. I tried it with



> vendor.shipping_methods.or(city.shipping_methods)
ArgumentError: Relation passed to #or must be structurally compatible. Incompatible values: [:joins]
from /usr/local/bundle/gems/activerecord-5.2.0/lib/active_record/relation/query_methods.rb:634:in `or!'


And also with



> vendor.shipping_methods.merge(city.shipping_methods)


But this only returns the shipping methods of the city. I could merge them in Ruby, but I'd like to do it in one query.










share|improve this question


























    up vote
    1
    down vote

    favorite












    How can I combine two scopes to get both results of them in one query, when they are polymorphic associations? I have this models:



    class Vendor < ApplicationRecord
    has_many :shipping_method_registers, as: :shipper
    has_many :shipping_methods, through: :shipping_method_registers
    end

    class City < ApplicationRecord
    has_many :shipping_method_registers, as: :shipper
    has_many :shipping_methods, through: :shipping_method_registers
    end

    class ShippingMethodRegister < ApplicationRecord
    belongs_to :shipping_method
    belongs_to :shipper, polymorphic: true
    end

    class ShippingMethod < ApplicationRecord
    has_many :shipping_method_registers, dependent: :destroy, autosave: true
    has_many :city_zones, through: :shipping_method_registers, source: :shipper,
    source_type: "City"
    has_many :vendors, through: :shipping_method_registers, source: :shipper,
    source_type: "Vendor"
    end


    I want to get the shipping methods of a vendor AND a city combined, but only distinct results. I tried it with



    > vendor.shipping_methods.or(city.shipping_methods)
    ArgumentError: Relation passed to #or must be structurally compatible. Incompatible values: [:joins]
    from /usr/local/bundle/gems/activerecord-5.2.0/lib/active_record/relation/query_methods.rb:634:in `or!'


    And also with



    > vendor.shipping_methods.merge(city.shipping_methods)


    But this only returns the shipping methods of the city. I could merge them in Ruby, but I'd like to do it in one query.










    share|improve this question
























      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite











      How can I combine two scopes to get both results of them in one query, when they are polymorphic associations? I have this models:



      class Vendor < ApplicationRecord
      has_many :shipping_method_registers, as: :shipper
      has_many :shipping_methods, through: :shipping_method_registers
      end

      class City < ApplicationRecord
      has_many :shipping_method_registers, as: :shipper
      has_many :shipping_methods, through: :shipping_method_registers
      end

      class ShippingMethodRegister < ApplicationRecord
      belongs_to :shipping_method
      belongs_to :shipper, polymorphic: true
      end

      class ShippingMethod < ApplicationRecord
      has_many :shipping_method_registers, dependent: :destroy, autosave: true
      has_many :city_zones, through: :shipping_method_registers, source: :shipper,
      source_type: "City"
      has_many :vendors, through: :shipping_method_registers, source: :shipper,
      source_type: "Vendor"
      end


      I want to get the shipping methods of a vendor AND a city combined, but only distinct results. I tried it with



      > vendor.shipping_methods.or(city.shipping_methods)
      ArgumentError: Relation passed to #or must be structurally compatible. Incompatible values: [:joins]
      from /usr/local/bundle/gems/activerecord-5.2.0/lib/active_record/relation/query_methods.rb:634:in `or!'


      And also with



      > vendor.shipping_methods.merge(city.shipping_methods)


      But this only returns the shipping methods of the city. I could merge them in Ruby, but I'd like to do it in one query.










      share|improve this question













      How can I combine two scopes to get both results of them in one query, when they are polymorphic associations? I have this models:



      class Vendor < ApplicationRecord
      has_many :shipping_method_registers, as: :shipper
      has_many :shipping_methods, through: :shipping_method_registers
      end

      class City < ApplicationRecord
      has_many :shipping_method_registers, as: :shipper
      has_many :shipping_methods, through: :shipping_method_registers
      end

      class ShippingMethodRegister < ApplicationRecord
      belongs_to :shipping_method
      belongs_to :shipper, polymorphic: true
      end

      class ShippingMethod < ApplicationRecord
      has_many :shipping_method_registers, dependent: :destroy, autosave: true
      has_many :city_zones, through: :shipping_method_registers, source: :shipper,
      source_type: "City"
      has_many :vendors, through: :shipping_method_registers, source: :shipper,
      source_type: "Vendor"
      end


      I want to get the shipping methods of a vendor AND a city combined, but only distinct results. I tried it with



      > vendor.shipping_methods.or(city.shipping_methods)
      ArgumentError: Relation passed to #or must be structurally compatible. Incompatible values: [:joins]
      from /usr/local/bundle/gems/activerecord-5.2.0/lib/active_record/relation/query_methods.rb:634:in `or!'


      And also with



      > vendor.shipping_methods.merge(city.shipping_methods)


      But this only returns the shipping methods of the city. I could merge them in Ruby, but I'd like to do it in one query.







      mysql ruby-on-rails activerecord polymorphism






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 7 at 8:40









      23tux

      6,345757131




      6,345757131





























          active

          oldest

          votes











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














           

          draft saved


          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53185938%2fcombine-polymorphic-scopes-with-or%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown






























          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















           

          draft saved


          draft discarded



















































           


          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53185938%2fcombine-polymorphic-scopes-with-or%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          這個網誌中的熱門文章

          Xamarin.form Move up view when keyboard appear

          Post-Redirect-Get with Spring WebFlux and Thymeleaf

          Anylogic : not able to use stopDelay()