Changeset 595 in code for trunk/db_sqlite.go

Timestamp:

Sep 21, 2021, 4:19:05 PM (4 years ago)

Author:

hubert

Message:

Fix DeliveryReceipt not being cleaned up

File:

• trunk/db_sqlite.go (modified) (2 diffs)

trunk/db_sqlite.go

@@ -290 +290 @@
         defer tx.Rollback()
 
+        _, err = tx.Exec(`DELETE FROM DeliveryReceipt
+                WHERE id IN (
+                        SELECT DeliveryReceipt.id
+                        FROM DeliveryReceipt
+                        JOIN Network ON DeliveryReceipt.network = Network.id
+                        WHERE Network.user = ?
+                )`, id)
+        if err != nil {
+                return err
+        }
+
         _, err = tx.Exec(`DELETE FROM Channel
                 WHERE id IN (
@@ -423 +434 @@
         defer tx.Rollback()
 
+        _, err = tx.Exec("DELETE FROM DeliveryReceipt WHERE network = ?", id)
+        if err != nil {
+                return err
+        }
+
         _, err = tx.Exec("DELETE FROM Channel WHERE network = ?", id)
         if err != nil {