[feature] apply deletions from server

Sync method to propagate deletions in batch locally.

-- Resolves: #8961

1 files changed, 7 insertions, 0 deletions

diff --git a/src/leap/soledad/client/_db/blobs/sql.py b/src/leap/soledad/client/_db/blobs/sql.py
index c5b0b64b..5337ab87 100644
--- a/src/leap/soledad/client/_db/blobs/sql.py
+++ b/src/leap/soledad/client/_db/blobs/sql.py
@@ -190,6 +190,13 @@ class SQLiteBlobBackend(object):
         query = 'DELETE FROM blobs WHERE blob_id = ? AND namespace = ?'
         return self.dbpool.runQuery(query, (blob_id, namespace,))
 
+    def batch_delete(self, blob_id_list, namespace=''):
+        query = 'DELETE FROM blobs WHERE blob_id IN '
+        size = len(blob_id_list)
+        query += ('(%s)' % ', '.join(['?' for _ in range(size)]))
+        values = tuple(blob_id_list)
+        return self.dbpool.runQuery(query, values)
+
 
 def _init_tables(conn):
     # unified init for running under the same lock