English 中文(简体)
我怎样才能得到记录,而不是在铁路使用主动记录重复?
原标题:How can I just get one record instead of duplicates using ActiveRecord in Rails?

我的模式如下:

Campaign
  has_many :companies, :through => :contacts

与同一公司有许多联系。 我只想一例每家公司。

我尝试如下:

@campaign = Campaign.find(params[:id])
@companies = @campaign.companies

但是,这向我展示了我所相信的所有公司。 至少是产出所看的。

我如何能够确保只增加一个公司的单一案例?

最佳回答

当你使用<条码>时:通过,通常使用<条码>:uniq选项,因此,你不会再重复结果。

has_many :companies, :through => :contacts, :uniq => true
问题回答

目前通过“j>工作”接受的解决办法,但效率很低,因为它删除了Ruby的重复,而不是在Kall。 它实际上只是使用<条码>。

我认为,这样做的有效和适当方式是:

has_many :companies, :through => :contacts, :select => "DISTINCT companies.*"

这也许不像样,但会得到你们的希望,不会使用额外的记忆,而且会更快。





相关问题
rails collection_select vs. select

collection_select and select Rails helpers: Which one should I use? I can t see a difference in both ways. Both helpers take a collection and generates options tags inside a select tag. Is there a ...

SSL slowness in EC2

We ve deployed our rails app to EC2. In our setup, we have two proxies on small instances behind round-robin DNS. These run nginx load balancers for a dynamically growing and shrinking farm of web ...

Auth-code with A-Za-z0-9 to use in an URL parameter

As part of a web application I need an auth-code to pass as a URL parameter. I am currently using (in Rails) : Digest::SHA1.hexdigest((object_id + rand(255)).to_s) Which provides long strings like : ...

RubyCAS-Client question: Rails

I ve installed RubyCAS-Client version 2.1.0 as a plugin within a rails app. It s working, but I d like to remove the ?ticket= in the url. Is this possible?

activerecord has_many :through find with one sql call

I have a these 3 models: class User < ActiveRecord::Base has_many :permissions, :dependent => :destroy has_many :roles, :through => :permissions end class Permission < ActiveRecord::...

Ordering a hash to xml: Rails

I m building an xml document from a hash. The xml attributes need to be in order. How can this be accomplished? hash.to_xml

Text Editor for Ruby-on-Rails

guys which text editor is good for Rubyonrails? i m using Windows and i was using E-Texteditor but its not free n its expired now can anyone plese tell me any free texteditor? n which one is best an ...

How to get SQL queries for each user where env is production

I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...

热门标签