From 2a15cec60bc1b58fa1b7d4359bd57fd4d8ad7c44 Mon Sep 17 00:00:00 2001 From: Damyan Ivanov Date: Thu, 24 Sep 2020 18:39:14 +0300 Subject: [PATCH] ordered deletion when wiping profile data needed so that foreigh keys can be enforced --- .../net/ktnx/mobileledger/model/MobileLedgerProfile.java | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java b/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java index 62ab8f4b..6f6e51cb 100644 --- a/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java +++ b/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java @@ -452,12 +452,12 @@ public final class MobileLedgerProfile { db.beginTransactionNonExclusive(); try { Object[] uuid_param = new Object[]{uuid}; - db.execSQL("delete from profiles where uuid=?", uuid_param); - db.execSQL("delete from accounts where profile=?", uuid_param); - db.execSQL("delete from account_values where profile=?", uuid_param); - db.execSQL("delete from transactions where profile=?", uuid_param); db.execSQL("delete from transaction_accounts where profile=?", uuid_param); + db.execSQL("delete from transactions where profile=?", uuid_param); + db.execSQL("delete from account_values where profile=?", uuid_param); + db.execSQL("delete from accounts where profile=?", uuid_param); db.execSQL("delete from options where profile=?", uuid_param); + db.execSQL("delete from profiles where uuid=?", uuid_param); db.setTransactionSuccessful(); } finally { -- 2.39.2