are bulk operations atomic, and
# spicedbf
ficolas
09/17/2024, 10:12 AMare bulk operations atomic, and secuential?
So, if I do a delete all relationships "#member" on a specific resource, then I create a relationship "#member" on that resource, on the same bulk operation, the order matters, and the created one wont be deleted by the filter delete?
And, if one fails, none will be performed?
v
vroldanbet
09/17/2024, 10:23 AMWith bulk operations you refer to a
WriteRelationshipsvroldanbet
09/17/2024, 10:24 AMSpiceDB will return an error if you have the same relationship multiple times as part of the same
WriteRelationshipsf
ficolas
09/17/2024, 10:24 AMYes, I mean the writerelationships
ficolas
09/17/2024, 10:25 AMI thought I could use that one with filter deletes but I think I can't?
ficolas
09/17/2024, 10:26 AMI don't want to delete and create the same one
ficolas
09/17/2024, 10:26 AMI want to delete all and create one
ficolas
09/17/2024, 10:29 AMYeah I think that to use the ``WriteRelationships`` call I have to specify all the specific relationships, no filter delete. That's fine, even though filter delete would have been nice here
v
vroldanbet
09/17/2024, 11:09 AMyou can't delete all because this can't be done transactionally without creating a massive transaction that will halt your database to a grind. For that you should use
DeleteRelationshipsvroldanbet
09/17/2024, 11:09 AMit has filters, and it also allows deleting in batches you can throttle on the client side.
vroldanbet
09/17/2024, 11:10 AMI think eventually we'd want to add the
DeleteRelationshipsWriteRealtionshipsDeleteRelationshipsf
ficolas
09/17/2024, 11:22 AMYeah, I'm only deleting one relationship, but it's as a way for me to not have to make up a query to the postgres database to see what that relationship is
v
vroldanbet
09/17/2024, 11:41 AMI'm not sure I follow. I believe deletes via
DeleteRelationshipst
theconductor
09/17/2024, 12:17 PMhttps://github.com/authzed/spicedb/issues/2033
I made an issue that I believe asks for the same thing, the ability to atomically “set” the subjects of a relationship without needing to explicitly know/delete the previous values
f
ficolas
09/17/2024, 1:42 PMyeah I mean I just dont know the ID, unless I check on the database what that ID is. So deleting every relationship, is a valid option, because that ressource should only have one relationship of that type
ficolas
09/17/2024, 1:42 PMyep, this is what I want basically
15 Views