commit 9d59ea811c80969c725e6899ce2075d654323435
author Sham Rathod <sham.rathod@ittiam.com> Tue Jul 11 11:15:04 2023 +0530
committer Sham Rathod <sham.rathod@ittiam.com> Tue Jul 11 11:30:13 2023 +0530
tree b07416c544525198330b61924a298e980f12a15f
parent 456192025498e5b4c1207b23acdac440ffcdc7b6

Tvprovider: Change sync mode of tv.db database

When tv.db database is configured with journal_mode=WAL and
synchronous=FULL, channels remain intact in database after a
channel scan is immediately followed by a power failure.

Test: manual

Bug: 283390240
Change-Id: Ibb042ff6bd5ecb08500081a492dccbbb4743b3ee

src/com/android/providers/tv/TvProvider.java

diff --git a/src/com/android/providers/tv/TvProvider.java b/src/com/android/providers/tv/TvProvider.java
index ea9b859..7ba1e29 100644
--- a/src/com/android/providers/tv/TvProvider.java
+++ b/src/com/android/providers/tv/TvProvider.java
@@ -817,7 +817,8 @@
 
         @VisibleForTesting
         DatabaseHelper(Context context, String databaseName, int databaseVersion) {
-            super(context, databaseName, null, databaseVersion);
+            super(context, databaseName, databaseVersion,
+                new SQLiteDatabase.OpenParams.Builder().setSynchronousMode("FULL").build());
             mContext = context;
             setWriteAheadLoggingEnabled(true);
         }