Queries And Update Property In JSON Column With Rails

queries_and_update_property_in_json_column_with_rails.rb

# Table Driver
# Id : Integer
# Name : String
# Vehicle Attributes : JSON

# Example:
# {
#   id: 1,
#   name: 'Driver Name',
#   vehicle_attributes: {
#     vehicle_color: 'Black',
#     vehicle_name: 'Honda',
#     vehicle_plate_number: '123456789'
#   }
# }

# Find Drivers who have vehicle with black color
drivers = Driver.where("vehicle_attributes->>'vehicle_color' LIKE ?", "%black%")

# Update Drivers who have vehicle with black color into white
drivers.update_all("vehicle_attributes = jsonb_set(\"vehicle_attributes\"::jsonb, '{vehicle_color}', '\"white\"')")