A user data protection method for database degradation when an app version is updated

Abstract

The invention relates to a user data protection method for database degradation during APP version updating. The method includes the following steps of 1, acquiring the name and version number of a currently-installed database; 2, acquiring the name and version number of a to-be-installed database; 3, judging whether or not the name of the currently-installed database is the same with the name of the to-be-installed database, and if yes, turning to the step 4; 4, judging whether or not the version number of the currently-installed database is the same with the version number of the to-be-installed database, or performing no update operation on the database, or upgrading the database, or degrading the database, wherein the naming rule of tables of the database is as follows: prefix_table name_suffix, and the suffix is equal to the version number of the database. The user data protection method for the database degradation duing APP version updating has the advantages of being simple in application, and capable of effectively protecting user data, and avoiding user data loss caused by the database degradation.

Description

technical field [0001] The invention relates to the technical field of user data protection, in particular to a method for protecting user data in which a database is downgraded when an APP version is updated. Background technique [0002] In the Android system, there is a built-in lightweight database SQLite. SQLite does not even need to install and start the service process. It is just a database file with the suffix .db, but it supports SQL statements. [0003] The use of SQLite requires a SQLiteDataBase class. The bottom layer of this class is a database file. One class represents a database, and the operation on the database must also pass through the SQLiteDataBase class. The SQLiteDatabase class encapsulates some APIs for operating the database. Using this class, you can complete the operations of adding (Create), querying (Retrieve), updating (Update) and deleting (Delete) data. [0004] The SQLiteOpenHelper class is an abstract class used to assist in managing data...

AI Technical Summary

Problems solved by technology

At this time, when the user rolls back from version 3 to version 2, since version 2 cannot predict the table structure of version 3 at the time of development, it is not known whether the data table of version 3 is compatible with version 2 (if version 3 is upgraded, a Table fields that have been used in version 2, and the fallback data structure may not be compatible at this time)

[0014] Therefore, the downgrade operation is likely to lead to the loss of user data, which may bring irreparable losses to the user. This problem obviously needs to be resolved to avoid affecting the user experience and the security of user data.

[0015] Another possible situation is: Sometimes an APP is automatically upgraded, but the user may think that the old version is still easy to use, so he still wants to switch back to the old version, but wants to keep the data, and does not want to switch back to the old version. result in loss of data