English 中文(简体)
图瓦卢铁路公司按照比拉的平衡排列铁路项目。
原标题:HOWTO rank items by balance in Ruby on rails

I am implementing a betting system and each user has a balance , how can i find a rank of a user using activerecord methods? thanks for your help.

最佳回答

a. 获得用户排名,

Users.all(:order => "balance").index(a_particular_user)

这应当给您一个特定用户的指数(等级)。

问题回答

如果用户众多,解决办法就会稍有提高:

Users.order(:balance).pluck(:id).index(a_particular_user_id)`

这样,你们的 app子就不要拉开和瞬间整条记录/标语。 能够更快地结束规模。

几天前,我仅问同一问题。

物体在数据库中的位置

我的解决办法与@Drew Johnson所建议的办法相同(User.all.index current_user)。 但是,我需要“频率解决方案”和“Vlad Zloteanu”给我一个伟大的想法:

User.count(:order => "balance", :conditions => [ balance < (?) , current_user.balance])

这是大数据表的快速解决方案。

如果我理解你想要的东西,那么你就有必要平衡地命令用户。

User.all(:order => "balance")

www.un.org/Depts/DGACM/index_spanish.htm . .

<>Edit#2:, 看到Drew Johnson回答后,我发现我误解了你的问题。 如他所说,您可使用。 你们想要做的事情的方法。

@user = User.first
@rank = User.all(:order => "balance").index(@user)




相关问题
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: ...