ruby-on-rails - 使用 ActiveRecord 更新 Postgres JSON 字段

Question

将 update 与 json 字段一起使用的最佳方法是什么。我希望我的 JSON 字段接受新键或更新现有键，但不覆盖整个字段。 ActiveRecord 在更新更改的字段方面做得很好，但我不明白如何将其应用于 json 记录中的子字段...

it 'can update settings with a plain object' do
  integration = Integration.create(
    name: 'Name',
    json_settings: {
      key1: 1,
      key2: 2
    }
  )
  integration.update(
    settings: { key2: 2 }
  )
  // json_settings is now { "key2": 3 } but I want
  // { "key1": 1, "key2": 3 } 
  expect(integration.json_settings['key1']).to eq('1') // fails
end

Answer 1

您的代码应如下所示:

it 'can update settings with a plain object' do
  integration = Integration.create(
    name: 'Name',
    json_settings: {
      key1: 1,
      key2: 2
    }
  )
  integration.json_settings = integration.json_settings.merge { key2: 3 }
  integration.save
  expect(integration.json_settings['key1']).to eq(1)
end