Python SDK update query not updating document

Python SDK
, , ,
1

Hi,

I am trying to a field inside a couchbase document, using cluster.query with below code :
print(type(cluster))
query = “update some.bucket set status = ‘Not Processed’ where instance in {} and specification.id=‘{}’ and id LIKE ‘%{}%’;”.format(newCycleMonths,cycleSpecification,cycleYear)
print(“Query before exeuting - {}”.format(query))

bucket = cluster.bucket(bucket_name)

result = cluster.query(query,QueryOptions(metrics=True)).execute

This same code works and returns results if the query is select. but update doesn’t work.