Android database version management and its updates

Typically, Android uses Sqllite as a database primarily in two ways

1. Create a database from Databaseoperation (the database created must have root privileges to view)

2. Copy to the specified location via Assetsdatabasemanager

Choose different database creation methods depending on your needs

Database update process

1. The new database is typically 0 (version)

Get version with GetVersion

Also available through

PRAGMA user_version to get

The OnCreate method is automatically called when the version is 0

Set version is greater than the original version call Onupgrade

Conversely call Ondowngrade

1   if(Version = =0) {2 onCreate (db);3}Else {4                         if(Version >mnewversion) {5 Ondowngrade (db, version, mnewversion);6}Else {7 Onupgrade (db, version, mnewversion);8                         }9                     }Ten db.setversion (mnewversion); OneDb.settransactionsuccessful ();

2. Similar to getversion and setversion rewrite can be

Android database version management and its updates