02_methods.rb

require 'pg'
require 'pry'

conn = PG.connect(dbname: 'chinook')

def add_artist(db_conn, name)
  sql = <<-SQL
    INSERT INTO artists (name)
    VALUES ($1) RETURNING id
  SQL

  db_conn.exec_params(sql, [name]).first["id"]
end

def update_artist(db_conn, id, new_name)
  sql = <<-SQL
    UPDATE artists
    SET name=$1
    WHERE id=$2
  SQL
  db_conn.exec_params(sql, [new_name, id])
end
id = add_artist(conn,"Steven and the t-shirts")

update_artist(conn, id, "S7even && le t-shirts")