from sqlalchemy import Column, MetaData, Table, Text, create_engine

project_id = 'foo'
instance_id = 'bar'
database = 'baz'

spanner_uri = f'spanner:///projects/{project_id}/instances/{instance_id}/databases/{database}'

# Create a table with one `Text`-type column
engine = create_engine(spanner_uri)
metadata = MetaData(bind=engine)
t = Table("TestTable", metadata, Column("test_column", Text, nullable=False))
metadata.create_all(engine)

test_value = 'foo1'

with engine.begin() as conn:
    #conn.execute(t.insert(None).values(test_column=test_value))
    res = conn.execute(t.update(None).where(t.c.test_column == test_value).values(test_column='bar2'))

assert res.rowcount == 1, f"Incorrect rowcount. want 1, got {res.rowcount}"