update query using psycopg2 execute_values

psycopg2_update_execute_values.py

# Updates are a little tricky using psycopg2.extras.execute_values(), and documentation is a little sparse.
# http://initd.org/psycopg/docs/extras.html

db_connection_string = "dbname=EDITME host=EDITME"

# uuids, as strings
my_data = ['6ef0f42a-63da-4edb-9a11-5e146cb337ac','e7b1e961-0a68-4c4f-a716-e0959593f27d','1f82c9a5-00c3-4bd8-8c50-0ede441b4e91']

query = """update my_table t
          set bool_field = true
          from (VALUES %s) AS d (my_data)
          where t.uuid_field = d.data::uuid"""

with psycopg2.connect(db_connection_string) as conn:
  with conn.cursor() as cur:
    psycopg2.extras.execute_values(cur, insert_query, data)