Hi All, I have a MERGE INTO ... WHEN MATCHED THEN UPDATE SET ... WHEN NOT MATCHED THEN INSERT-style query, that works if I execute it using the couchbase web UI. Although, if I execute the same query using the python SDK, the inserted documents don’t appear in the document lookup page of the UI. M…

Found the solution. There is a lazy-evaluation-like behaviour. I just have to iterate through the query results. Something like this: res = cluster.query(some_query_statement) # this doesn't do anything. res.rows() # this line actually posts the query HTTP request and evaluates the query. # the c…

Is it possible to execute MERGE INTO query statements using the Python SDK?

Python SDK

AV25242 March 10, 2021, 5:44pm 3

Hello @mtannerman great and thanks for posting back your response

How can I insert data without getting the response?

Topic		Replies	Views
MERGE statement Couchbase Server	12	3068	November 3, 2016
Python SDK update query not updating document Python SDK query , n1ql , sdk , python	7	1382	February 16, 2023
MERGE INTO not working as expected SQL++ query , n1ql	8	1181	January 14, 2021
Translate N1QL Query to Java SDK Java SDK java , n1ql , sdk	9	1271	December 18, 2020
Couchbase Merge and Update query not updating consistently SQL++ query	2	833	September 10, 2021

Is it possible to execute MERGE INTO query statements using the Python SDK?

Related topics