update_data_with_json_column project_id:, instance_id:, database_id:

in spanner/json_column_type_samples.rb [40:81]

• 26 lines of code
• 1 McCabe index (conditional complexity)

def update_data_with_json_column project_id:, instance_id:, database_id:
  
  
  
  

  require "google/cloud/spanner"

  spanner = Google::Cloud::Spanner.new project: project_id
  client  = spanner.client instance_id, database_id

  rows = [{
    VenueId: 1,
    VenueDetails: { rating: 9, open: true }
  }]
  client.update "Venues", rows

  
  
  
  
  venue_details_string = [
    {
      name: "room 1",
      open: true
    },
    {
      name: "room 2",
      open: false
    }
  ].to_json

  rows = [{
    VenueId: 2,
    VenueDetails: venue_details_string
  }]
  client.update "Venues", rows

  puts "Rows are updated."
  
end