遍历数据库中的每个记录 - Ruby on Rails [英] Iterating through every record in a database - Ruby on Rails

查看:618
本文介绍了遍历数据库中的每个记录 - Ruby on Rails的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

n00b问题。我试图循环遍历我的数据库中的每个用户记录。伪代码可能看起来像这样:

  def send_notifications 

render:nothing => ; true

#从DB中随机选择消息记录
@message = Message.offset(rand(Message.count))。首先

random_message = @ message.content

@user = User.all.entries.each do
@user = User.find(:id)

number_to_text =

@ user.number = number_to_text #number是用户的电话号码
puts @ user.number

end

end

有人可以用最好的方法填充我吗? )

解决方案

感谢大家!

div>

这里是遍历所有User的正确语法:

  User.all.each do | user | 
#这里的代码为每个用户调用一次
#用户可以通过'user'变量
访问
$ b

此外,为了提高性能,您可能需要使用 User.find_each 查看文档)而不是 User.all


n00b question. I'm trying to loop through every User record in my database. The pseudo code might look a little something like this:

def send_notifications

        render :nothing => true

        # Randomly select Message record from DB
        @message = Message.offset(rand(Message.count)).first

        random_message = @message.content

        @user = User.all.entries.each do
            @user = User.find(:id)

            number_to_text = ""

            @user.number = number_to_text #number is a User's phone number
            puts @user.number

        end

    end

Can someone fill me in on the best approach for doing this? A little help with the syntax would be great too :)

Thanks everyone!

解决方案

Here is the correct syntax to iterate over all User :

User.all.each do |user|
  #the code here is called once for each user
  # user is accessible by 'user' variable
end

Also, to improve performance, you may want to use User.find_each (see doc) instead of User.all

这篇关于遍历数据库中的每个记录 - Ruby on Rails的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆