Hello! 1) Are you sure that your DELETE actually gets to run? 2) I think you need to stop SELECT iteration before running more queries, including DELETE. Try closing cursor explicitly.
Regards, -- Ilya Kasnacheev вт, 5 мая 2020 г. в 11:12, Jueverhard <[email protected]>: > Ok, I think the problem comes from raw text, it does not appear ... > ``` > self.client = Client() > self.client.connect('127.0.0.1', 10800) > patientID = 5 > IS_DEFINED_QUERY = "SELECT * FROM Patients WHERE PatientID = ?" > result = self.client.sql( > IS_DEFINED_QUERY, > query_args=[patientID] > ) > try: > next(result) > DELETE_QUERY = "DELETE FROM Patients WHERE PatientID = ?" > self.client.sql( > DELETE_QUERY, > query_args=[patientID]) > except StopIteration: > raise KeyDoesNotExist() > ``` > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
