Allow databases to be created from compressed asset files [146911060]

Fixed

Feature Request

androidx-bug-bounty

Status Update

No update yet.

Description

jo...@fueledbycaffeine.com

created issue #1

Dec 27, 2019 09:58PM

Component used: Room
Version used: 2.2.3

We got the ability to create room databases from assets or other files in

b/62185732

which is great. However, in my app I am packaging a GZipped sqlite database to save download space. The database is read-only and contains a moderate amount of data, so the APK size savings is about 1MB. Another app I work on that could benefit from this packages a 10MB sqlite database which gzips down to 3MB.

My current workaround is to manually decompress the gzipped asset into the application's database directory, but there's no reason that the room database builder couldn't handle this step on it's own.

Comments

zh...@gmail.com <zh...@gmail.com> #2Dec 31, 2019 02:22AM

I also have this demand. I modified the SQLiteCopyOpenHelper class, modified the copyDatabaseFile method, and added the logic of decompressing the database in this method.also you need modified SQLiteCopyOpenHelperFactory class to injection SQLiteCopyOpenHelper.
Hope that can help you.

yb...@google.com <yb...@google.com> #3Jul 30, 2020 08:35PM

moving to the bug bounty list as this seems like a very isolated feature that can be implemented.

ah...@gmail.com <ah...@gmail.com> #4Jul 31, 2020 05:11PM

I'd like to try this one - have something working locally, will open a PR soon.

yb...@google.com <yb...@google.com> #5Jul 31, 2020 08:14PM

awesome, thanks a lot!

ah...@gmail.com <ah...@gmail.com> #6Jul 31, 2020 08:46PM

https://github.com/androidx/androidx/pull/49

ap...@google.com <ap...@google.com> #7Aug 5, 2020 04:07AM

Marked as fixed.

Project: platform/frameworks/support
Branch: androidx-master-dev

commit 3e6792c7521cdf41c295a1c0037137ecf9c7a005
Author: Ahmed El-Helw <ahmedre@gmail.com>
Date: Wed Aug 05 00:03:57 2020

[GH] Support opening gzipped databases.

This patch adds a method for creating a database from a gzipped file.
This is only implemented for external files, since assets are
transparently gzipped and extracted by the build tools.

Test: Added a unit test to SQLiteCopyOpenHelperTest.
Fixes:

b/146911060

This is an imported pull request from

https://github.com/androidx/androidx/pull/49.

Resolves #49
Github-Pr-Head-Sha: 568196d7b1800e9055de0dae7f509008cbc64c71
GitOrigin-RevId: 5de26bc6b6107d6aa2079f53d303e1216879ffa9
Change-Id: Ibd6b85f03748062a1ced22daf250944d5f07ef5b

M room/integration-tests/testapp/src/androidTest/java/androidx/room/integration/testapp/test/PrepackageTest.java
A room/integration-tests/testapp/src/main/assets/databases/products_v1.db.zip
M room/runtime/api/current.txt
M room/runtime/api/public_plus_experimental_current.txt
M room/runtime/api/restricted_current.txt
M room/runtime/src/main/java/androidx/room/RoomDatabase.java
M room/runtime/src/main/java/androidx/room/SQLiteCopyOpenHelper.java
M room/runtime/src/main/java/androidx/room/SQLiteCopyOpenHelperFactory.java
M room/runtime/src/test/java/androidx/room/BuilderTest.java
M room/runtime/src/test/java/androidx/room/SQLiteCopyOpenHelperTest.kt

https://android-review.googlesource.com/1388184

ap...@google.com <ap...@google.com> #8Aug 5, 2020 04:07AM

Project: platform/frameworks/support
Branch: androidx-master-dev

commit 1263185ef8c50d4059758e382610345a24f82c53
Author: Daniel Santiago Rivera <danysantiago@google.com>
Date: Fri Jul 31 19:28:39 2020

Minor changes and API files update for aosp/1384212

Additionally add new copyFromInputStream property to
DatabaseConfiguration for consistency.

Fixes:

b/146911060

Relnote: N/A
Test: ./gradlew bOS
Change-Id: I6fca34150c96a7039211ee3db46cf9a714667a9c

M room/integration-tests/testapp/src/androidTest/java/androidx/room/integration/testapp/test/PrepackageTest.java
M room/runtime/api/current.txt
M room/runtime/api/public_plus_experimental_current.txt
M room/runtime/api/restricted_current.txt
M room/runtime/src/main/java/androidx/room/DatabaseConfiguration.java
M room/runtime/src/main/java/androidx/room/RoomDatabase.java
M room/runtime/src/main/java/androidx/room/SQLiteCopyOpenHelper.java
M room/runtime/src/main/java/androidx/room/SQLiteCopyOpenHelperFactory.java
M room/testing/src/main/java/androidx/room/testing/MigrationTestHelper.java

https://android-review.googlesource.com/1384013