spanner_postgresql_order_nulls project_id:, instance_id:, database_id:

in spanner/spanner_postgresql_order_nulls.rb [17:77]

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

def spanner_postgresql_order_nulls project_id:, instance_id:, database_id:
  
  
  

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

  row_counts = nil
  client.transaction do |transaction|
    row_counts = transaction.batch_update do |b|
      b.batch_update "INSERT INTO Singers (SingerId, FirstName) VALUES (51, 'Alice')"
      b.batch_update "INSERT INTO Singers (SingerId, FirstName) VALUES (52, 'Bruce')"
      b.batch_update "INSERT INTO Singers (SingerId, FirstName) VALUES ($1, $2)",
                     params: { p1: 53, p2: nil },
                     types: { p2: :STRING }
    end
  end

  
  
  
  
  
  
  
  

  ordered_names = []
  
  results = client.execute "SELECT FirstName FROM Singers ORDER BY FirstName"
  results.rows.each do |row|
    ordered_names << row[:firstname]
  end
  puts "Result 1: #{ordered_names}"

  ordered_names = []
  
  results = client.execute "SELECT FirstName FROM Singers ORDER BY FirstName DESC"
  results.rows.each do |row|
    ordered_names << row[:firstname]
  end
  puts "Result 2: #{ordered_names}"

  ordered_names = []
  
  results = client.execute "SELECT FirstName FROM Singers ORDER BY FirstName NULLS FIRST"
  results.rows.each do |row|
    ordered_names << row[:firstname]
  end
  puts "Result 3: #{ordered_names}"

  ordered_names = []
  
  results = client.execute "SELECT FirstName FROM Singers ORDER BY FirstName NULLS LAST"
  results.rows.each do |row|
    ordered_names << row[:firstname]
  end
  puts "Result 4: #{ordered_names}"
end