Confusion: How does SQLiteOpenHelper onUpgrade() behave? And together with import of an old database backup?

by

What’s the correct way of handling database upgrades of a live app, so the user doesn’t lose his data? Do you have to check all possible (old) versions in the onUpgrade() method and execute different alter table statements based on that version?

By and large, yes.

A common approach to this is to do pair-wise upgrades:

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  if (oldVersion<2) {
    // do upgrade from 1 to 2
  }

  if (oldVersion<3) {
    // do upgrade from 2 to 3, which will also cover 1->3,
    // since you just upgraded 1->2
  }

  // and so on
}

This roughly equates to Rails migrations, for example.

What happens if the user has app version 1, exports the database, upgrades the app (new database structure) and imports the old version 1 backup? –> How will SQLiteOpenHelper behave?

If by “copy the whole database away”, you literally mean a full file copy of the SQLite database file, then when SQLiteOpenHelper goes to open the restored backup, it will that the database has the old schema version and will go through onUpgrade() as normal.

What is the correct way to handle db upgrades together with import/export functionality?

I suspect the answer is: either make your backup by copying the entire file, or also arrange to backup and restore the schema version, which you can get by calling getVersion() on a SQLiteDatabase object. That being said, I haven’t dealt with this scenario much, and there may be more issues that I am not thinking of.

More Related Contents:

  1. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  2. Android Studio suddenly cannot resolve symbols
  3. Android SQLite Example [closed]
  4. Import .csv file to Sqlite in Android
  5. How do you open an Android Studio project in Eclipse?
  6. The import com.google.android.gms cannot be resolved
  7. android exporting to csv and sending as email attachment
  8. How can I write a Drawable resource to a File?
  9. DB File in Assets Folder. Will it be Updated?
  10. SQLiteOpenHelper – creating database on SD card
  11. how to bulk insert in sqlite in android
  12. import android.R in Eclipse : Why?
  13. Backup Room database
  14. Android Fatal signal 11 (SIGSEGV) at 0x636f7d89 (code=1). How can it be tracked down?
  15. How to hang up outgoing call in Android?
  16. How can I style an Android Switch?
  17. How to start Service-only Android app
  18. Android Lollipop, AppCompat ActionBar custom view doesn’t take up whole screen width
  19. Sniffing/logging your own Android Bluetooth traffic
  20. Keyboard not shown when i click on edittextview in android?
  21. problem about sqlite database, no such table:
  22. Can’t put double SharedPreferences
  23. Changing the Screen Brightness System Setting Android
  24. Set zoom for Webview
  25. Inflate a view in a background thread
  26. java.lang.NullPointerException (no error message)
  27. How to enable zoom controls and pinch zoom in a WebView?
  28. android search dialog customization
  29. Google Maps V2 – Error inflating class Fragment
  30. What is the best way of installing new font to android emulator?

Leave a Comment