How do I update my application through APK without losing my SQLite database?

Question

How do I update my application through APK without losing my SQLite database?

Navigation

#1 by (1 votes)

5

I created an application, made registrations in the Sqlite database, but when I create new functions for the application how do I upgrade without uninstalling it?

android

asked by anonymous 12.09.2016 / 14:10

1 answer

How can I prevent the deletion of relational data through referential integrity in MYSQL? Sorting a list of objects by date [closed]

score 1 · Accepted Answer

When updating your APK in the playstore your database will NOT be deleted. In your databasehelper class you will have a onUpgrade method (SQLiteDatabase db, int oldVersion, int newVersion) where oldVersion is the previous version of your database on the user device and newVersion is the new version.

Example

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    switch (oldVersion){
        case 1;
            //TODO alteras campos da vesao 1 para versão 2
            break;
        case 2;
            //TODO alteras campos da vesao 2 para versão 3
            break;
        case 3;
            //TODO alteras campos da vesao 3 para versão 4
            break;
    }
}

If you need to know the new version of the bank to make the change use the variable newVersion