轨道4 / PostgreSQL的9.4 - 查询和更新数组内的Ruby对象 [英] Rails 4 / postgresql 9.4 - Query and update a ruby object inside an array

问题描述

我有一个方法（的find_by_sql）的输出数组内的Ruby对象是这样的：

I have a method (find_by_sql) that outputs a ruby object inside an array like this:

[#<deal id: 66480, opportunity_id: 4, admin_user_id: 1, created_at: "2015-09-20 18:37:29", updated_at: "2015-09-20 18:37:29", deal_available: true>]

我怎么能在我的原材料PostgreSQL数据库内更新对象deal_available'属性？

How can I update the object's 'deal_available' attribute inside my database in raw postgresql ?

我尝试不同的方式来写，但我绊倒的事实，这是非常特殊：它是一个数组，里面有一个Ruby对象，我必须设法告诉PostgreSQL的为修改的deal_available值：真到deal_available：假

I tried different ways to write it but I stumble on the fact that it's very specific: it's an array, and inside there is a ruby object and I must manage to tell postgresql to change the value of deal_available: true to deal_available: false.

在的地方，我想：logger.debug这里是更新生成的对象：

In local, I tried: logger.debug "Here is the resulting object for update:

 #{@deal_question[0]}

但我得到：

#<@deal_question:0x007fd9b3963270>

下面是如何@deal_question创建

Here is how @deal_question is created

@deal_question = Deal.find_by_sql(
      " SELECT \"deals\".*
        FROM \"deals\"
        WHERE (opportunity_id = #{@deal.id}
        AND deal_available = true)
        ORDER BY \"deals\".\"id\" ASC LIMIT 1"
    ) 

我甚至不有PostgreSQL的查询到在这里建议，因为首先我需要了解如何查询数组，这里面的Ruby对象。

I don't even have a postgresql query to suggest here because first I need to understand how to query this ruby object inside the array.

推荐答案

您其实并不需要一个原始SQL查询来更新你的<$ C的 deal_available 属性$ C> @deal_question 对象。

You actually don't need a raw SQL query to update the deal_available attribute of your @deal_question object.

您可以使用 的update_attributes来实现这一目标。

You can use update_attributes to achieve that.

# assuming @deal_question is an array
@deal_question[0].update_attributes(deal_available: false)

如果你真的想使用原始SQL来更新属性，然后做这样的：

If you really want to use raw sql to update the attribute, then do this way:

array = [#<deal id: 66480, opportunity_id: 4, admin_user_id: 1, created_at: "2015-09-20 18:37:29", updated_at: "2015-09-20 18:37:29", deal_available: true>]
# grab the object to be updated
@deal_question = array[0]
# build the sql query string
sql = "UPDATE deals SET deal_available = false WHERE opportunity_id = #{@deal_question.id}"
# execute the sql to update the object
ActiveRecord::Base.connection.execute(sql)

这篇关于轨道4 / PostgreSQL的9.4 - 查询和更新数组内的Ruby对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！