WO2017045491A1

WO2017045491A1 - Method and system for upgrading sqlite3 embedded database

Info

Publication number: WO2017045491A1
Application number: PCT/CN2016/093106
Authority: WO
Inventors: 范伟; 张聪
Original assignee: 华讯方舟科技有限公司
Priority date: 2015-09-15
Filing date: 2016-08-03
Publication date: 2017-03-23
Also published as: CN105224361B; CN105224361A

Abstract

A method and a system for upgrading an sqlite3 embedded database, relating to the embedded technical field. Said method comprises: loading upgrade application software on a device and re-starting the device; reading the version number of the target database in the upgrade application software and the version number of the source database in a device memory, and determining whether the version number of the target database is consistent with the version number of the source database; if the version numbers are inconsistent with each other, backing up the source database and invoking an upgrade configuration file embedded in the upgrade application software, which matches the version number of the target database and the version number of the source database, and upgrading, according to the upgrade configuration file, the source database in the device memory. This enables most devices using an sqlite3 embedded database to perform non-destructive upgrade operation, protecting, to the greatest extent, data in the source database, simplifying the upgrade steps, shortening the upgrade time, and greatly facilitating the maintenance of the device and reducing the workload of the maintenance staff.

Description

Description: A method and system for upgrading a sqlite3 embedded database

[0001] The present invention belongs to the field of embedded technologies, and in particular, to a method and system for upgrading a sqlite type 3 embedded database.

Background technique

[0002] Wireless manager devices for commercial applications have many functions and complicated configurations. Often, a wireless management device needs to configure data of hundreds or even thousands of APs and other items, and requires a large amount of pre-data before use. Configuration work, for this reason, the wireless organizer device in the prior art generally adopts the sqlite3 embedded database. For post-maintenance of wireless manager devices, such as new features and version upgrades, it is often necessary to maintain the database of the wireless manager device, for example: add or delete data tables in the database, one in the data table The field is modified or deleted, and the existing sqlite3 embedded database uses the sqlite3 command. Because the function of sqlite3 itself is missing, the database table field cannot be deleted and modified by the command, so that the wireless manager device needs To upgrade the device version, you must re-replace the entire database, causing the device to have to reconfigure a large amount of data, which makes the device upgrade process cumbersome and cumbersome.

technical problem

[0003] The purpose of the embodiments of the present invention is to provide a method and system for upgrading an sqlite type 3 embedded database, which is to solve the problem that if the wireless manager device needs to upgrade the device version, the entire database must be replaced again. Reconfiguring a large amount of data can make the device upgrade process cumbersome and cumbersome.

Problem solution

Technical solution

[0004] The embodiment of the present invention is implemented by the method for upgrading an sqlite type 3 embedded database, including:

[0005] completing the loading of the upgrade application software on the device and restarting the device;

Reading a version number of the target database in the upgrade application software and a version of the source database in the device memory The number determines whether the version number of the target database is consistent with the version number of the source database;

[0007] if the inconsistency is, backing up the source database, and calling an upgrade configuration file embedded in the upgrade application software that matches the version number of the target database and the version number of the source database, according to the The upgrade configuration file upgrades the source database in the device memory.

[0008] In the method for upgrading the sqlite type 3 embedded database according to the embodiment of the present invention, the upgrading of the source database in the device memory according to the upgrade configuration file includes:

Obtaining a database structure of the target database, and establishing a database structure of the source database in reverse according to the database structure of the target database and the upgrade configuration file;

[0010] performing a memory space allocation by using a database structure of the source database to read a data stream of the old data table in the source database;

[0011] deleting the old data table, and creating a new data table by using a database structure of the target database; [0012] restoring the data stream to the new data table, and according to the upgrade configuration file The bit offset of the data stream in the new data table is processed to generate a target database.

[0013] In the method for upgrading the sqlite3 type embedded database according to the embodiment of the present invention, the upgrade configuration file includes a database structure in the target database and field change information of the data structure in the source database, where the field changes. Information includes: deleting fields, adding fields, modifying field names, modifying field types, and modifying field lengths.

[0014] In the method for upgrading the sqlite3 type embedded database according to the embodiment of the present invention, the upgrade configuration file is packaged with the upgrade application software in the form of an xml file format, and the upgrade configuration is performed. Each upgrade target in the file is stored as a unit in the form of a linked list so that the upgrade target in the upgrade configuration file is executed in accordance with the linked list order during the database upgrade process.

[0015] In the method for upgrading the sqlite3 type embedded database according to the embodiment of the present invention, the bit offset of the data stream in the new data table is processed according to the upgrade configuration file to generate The target database specifically includes:

[0016] if the upgrade target is a delete field, searching for the data stream according to the bit to obtain a target bit to be deleted, deleting the information stored at the target bit, and performing data bit shift again;

[0017] if the upgrade target is an add field, searching for the data stream according to the bit to obtain an added position of the field to be added, adding a corresponding field length at the added position, and assigning the newly added field Default data;

[0018] if the upgrade target is to modify the field name, no processing is performed;

[0019] if the upgrade target is a modified field type, calculating a bit offset of the data stream at the position of the field to be modified, deleting the data stream at the position of the field to be modified, and then adding the field, and calculating The bit offset of the data stream at the newly added field position, the difference calculation between the two bit offsets to perform the bit offset, and the default value is written at the position of the newly added field;

[0020] If the upgrade target is to modify the length of the field, the bit offset of the data stream is performed according to the length to be changed, and the default value is written.

[0021] Another object of embodiments of the present invention is to provide a system for upgrading a sqlite type 3 embedded database, including:

[0022] an application software upgrade module, configured to complete loading and restarting the upgrade application software on the device; [0023] a determining module, configured to read a version number of the target database and the device memory in the upgrade application software a version number of the middle source database, determining whether the version number of the target database is consistent with the version number of the source database;

[0024] a database upgrade module, configured to back up the source database if inconsistent, and invoke a version number embedded in the upgrade application software that matches a version number of the target database and a version number of the source database Upgrading a configuration file, and upgrading the source database in the device memory according to the upgrade configuration file.

[0025] In the system for upgrading the sqlite type 3 embedded database according to the embodiment of the present invention, the database upgrade module includes:

[0026] a database structure reverse establishing unit, configured to acquire a database structure of the target database, and inversely establish a database structure of the source database according to the database structure of the target database and the upgrade configuration file

[0027] a data stream obtaining unit, configured to perform memory space allocation by using a database structure of the source database, to read a data stream of the old data table in the source database;

[0028] a new data table creating unit, configured to delete the old data table, and create a new data table by using a database structure of the target database;

[0029] a data stream bit offset processing unit, configured to restore the data stream to the new data table, and according to the The upgrade configuration file processes the bit offset of the data stream in the new data table to generate a target database.

[0030] In the system for upgrading the sqlite3 type embedded database according to the embodiment of the present invention, the upgrade configuration file includes a database structure in the target database and field change information of the data structure in the source database, and the field change information These include: deleting fields, adding fields, modifying field names, modifying field types, and modifying field lengths.

[0031] In the system for upgrading the sqlite3 type embedded database according to the embodiment of the present invention, the upgrade configuration file is packaged with the upgrade application software in the form of an xml file format, and the upgrade configuration file is Each upgrade target in the form is stored as a unit in the form of a linked list, so that the upgrade target in the upgrade configuration file is executed according to the linked list order in the database upgrade process.

[0032] In the system for upgrading the sqlite type 3 embedded database in the embodiment of the present invention, the data stream bit offset processing unit is specifically configured to:

[0033] if the upgrade target is a delete field, searching the data stream according to a bit to obtain a target bit stored in the field to be deleted, deleting information stored at the target bit, and performing data bit shift again;

[0034] if the upgrade target is an add field, searching for the data stream according to the bit to obtain an added position of the field to be added, adding a corresponding field length at the added position, and assigning the newly added field Default data;

[0035] if the upgrade target is to modify the field name, no processing is performed;

[0036] if the upgrade target is a modified field type, calculating a bit offset of the data stream at the position of the field to be modified, deleting the data stream at the position of the field to be modified, and then adding the field, and calculating The bit offset of the data stream at the newly added field position, the difference calculation between the two bit offsets to perform the bit offset, and the default value is written at the position of the newly added field;

[0037] If the upgrade target is to modify the field length, the bit offset of the data stream is performed according to the length to be changed, and the default value is written.

Advantageous effects of the invention

Beneficial effect

[0038] A method and system for upgrading an sqlite type 3 embedded database provided by an embodiment of the present invention have the following beneficial effects: [0039] The embodiment of the present invention first completes the loading of the upgrade application software on the device and restarts the device; then reads the version number of the target database in the upgrade application software and the version number of the source database in the device memory, and determines Whether the version number of the target database is consistent with the version number of the source database; if not, backing up the source database, and calling the version number and the embedded version of the target database embedded in the upgrade application software An upgrade configuration file matching the version number of the source database, and finally upgrading the source database in the device memory according to the upgrade configuration file, thereby effectively improving the shortage of the existing sqlite3 embedded database, and supplementing The missing feature of the sqlite3 embedded database enables most devices using the sqlite3 embedded database to perform non-destructive upgrade operations, maximally protecting the data in the source database, simplifying the upgrade steps, and shortening the upgrade time. Greatly facilitates the maintenance of equipment and reduces maintenance personnel For the amount.

Brief description of the drawing

DRAWINGS

1 is a flowchart of a specific implementation of a method for upgrading a sqlite type 3 embedded database according to an embodiment of the present invention;

[0041] FIG. 2 is a flowchart of a specific implementation of upgrading a source database in a device memory according to an upgrade configuration file according to an embodiment of the present invention;

3 is a structural block diagram of a system for upgrading a sqlite type 3 embedded database according to an embodiment of the present invention.

4 is a structural block diagram of a system for upgrading a sqlite type 3 embedded database according to another embodiment of the present invention.

Embodiments of the invention

[0044] In order to make the objects, technical solutions and advantages of the present invention more clear, the following is in conjunction with the accompanying drawings and embodiments.

The present invention will be further described in detail. It is understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

[0045] FIG. 1 shows a specific implementation process of a method for upgrading an sqlite3 embedded database provided by an embodiment of the present invention. Referring to FIG. 1 , a method for upgrading an sqlite type 3 embedded database according to an embodiment of the present invention includes: [0046] In S101, loading of the upgrade application software is completed on the device and the device is restarted.

[0047] In the embodiment of the present invention, for an embedded application software-based device, a sqlite3 type embedded database is generally used to store configuration and status information. After upgrading the application software on the device, the database used after the application software upgrade may be different from the database used before the upgrade. Therefore, after the upgrade program is loaded, the database in the device memory needs to be upgraded. Further, the device includes, but is not limited to, a wireless manager device, for example: a device or any device using a sqlite type database.

[0048] In S102, the version number of the target database in the upgrade application software and the version number of the source database in the device memory are read, and it is determined whether the version number of the target database is consistent with the version number of the source database. .

[0049] In the embodiment of the present invention, the upgraded application software automatically has the version number of the target database, and the device automatically reads the upgraded application software during the process of loading the upgrade application software and restarting the device. The target version number and the version number of the source database in the device memory.

[0050] In S103, if not, the source database is backed up, and the upgrade configuration embedded in the upgrade application software that matches the version number of the target database and the version number of the source database is invoked. File, upgrading the source database in the device memory according to the upgrade configuration file.

[0051] In the embodiment of the present invention, an application software corresponds to multiple upgrade configuration files, and the upgrade configuration file is written according to the version number of the target database of the upgraded application software, for example: if the target of the upgraded application software The database version number is version 3, and the upgrade configuration files packaged with the application software include: an upgrade configuration file upgraded from version 1 to version 3 and an upgrade configuration file upgraded from version 2 to version 3. Specifically, the upgrade configuration file includes a database structure in the target database and field change information of the data structure in the source database, where the field change information includes: deleting a field, adding a field, modifying a field name, modifying a field type, and modifying a field length. And the upgrade configuration file is embedded in the upgrade application software in the form of an xml file format, and each upgrade target in the upgrade configuration file is stored as a unit in a linked list, so as to be The linked list sequentially performs an upgrade target in the upgrade configuration file.

[0052] As a specific implementation example, FIG. 2 shows a specific implementation process of upgrading the source database in the device memory according to the upgrade configuration file in step S103. Referring to FIG. 2, the process includes: [0053] In S201, a database structure of the target database is obtained, and a database structure of the source database is reversely established according to a database structure of the target database and the upgrade configuration file.

[0054] In the embodiment of the present invention, since the table data in the source database is extracted, the corresponding old database structure must be used for memory space allocation and data extraction, and the database structure in the upgraded application software is the target database. The new database structure, so after the upgrade, the old database structure of the source database needs to be reversed according to the new database structure and the corresponding upgrade configuration file, wherein the upgrade configuration file records the difference information between the new database structure and the old database structure.

[0055] In S202, a memory space allocation is performed by using a database structure of the source database to read a data stream of the old data table in the source database. In the embodiment of the present invention, the malloc () function is used for memory space allocation.

[0056] In S203, the old data table is deleted, and a new data table is created by using the database structure of the target database.

[0057] In S204, the data stream is restored to the new data table, and a bit offset of the data stream in the new data table is processed according to the upgrade configuration file to generate a target database.

[0058] wherein, the processing, according to the upgrade configuration file, processing a bit offset of a data stream in the new data table

To generate the target database specifically includes:

[0059] If the upgrade target is a delete field, the data stream is searched according to a bit to obtain a target bit to be deleted, the information stored at the target bit is deleted, and the data bit offset is performed again.

[0060] In the embodiment of the present invention, if more than one target bit information is found, each target bit information that is found needs to be processed, and all the information stored in the corresponding field position is deleted, and the information is re-executed. Data bit offset.

[0061] if the upgrade target is an add field, searching for the data stream according to the bit to obtain an added position of the field to be added, adding a corresponding field length at the added position, and assigning the newly added field The default data. Similarly, in the embodiment of the present invention, if a plurality of added locations are found, it is necessary to process each of the plurality of added locations found.

[0062] If the upgrade target is to modify the field name, no processing is performed.

[0063] if the upgrade target is a modified field type, calculating a bit offset of the data stream at the position of the field to be modified, deleting the data stream at the position of the field to be modified, and then adding the field, and calculating New Add the bit offset of the data stream at the field location, perform a difference calculation on the two bit offsets, perform a bit offset, and write a default value at the location of the newly added field. As a specific implementation example: If the upgrade target is to change the field type from int to char, delete the length of 4 bytes occupied by the original int field, and then add the default value corresponding to the char type field to perform data stream bit shift. shift.

[0064] If the upgrade target is to modify the length of the field, the bit offset of the data stream is performed according to the length to be changed, and the default value is written.

[0065] In the embodiment of the present invention, the modified field length refers specifically to a char string. For example: If the upgrade target is to change the length of the char type field from temp[20] to temp[10], and the extracted data in the old data has more than 10 bytes of content, delete the data. And add the default value of 10 bytes, if the old data is less than or equal to 10 bytes, it will not be modified. Conversely, if the upgrade target is to change the char field length from Temp[10] to temp[20], no modification is required.

[0066] In addition, it should be noted that, since the source database is backed up before the database is upgraded in the embodiment of the present invention, the backup source database may be reversely upgraded to the old version in the event of an error in the database upgrade process. Database.

[0067] As can be seen from the above, the embodiment of the present invention provides a method for upgrading an sqlite type 3 embedded database, which can implement an upgrade of the database by extracting and splitting existing data in the database. Effectively improve the existing sqlite3 embedded database, supplement the missing function of sqlite3 embedded database, can make most of the devices using sqlite3 embedded database can perform non-destructive upgrade operation, maximally protect the source database. The data in the simplifies the upgrade steps, shortens the upgrade time, and greatly facilitates the maintenance of the equipment, reducing the workload of maintenance personnel.

3 is a structural block diagram of a system for upgrading an sqlite3 type embedded database according to an embodiment of the present invention. The system is located in the device according to the embodiment of the present invention, and is used to run the above FIG. 1 to FIG. 2 The method provided by the illustrated embodiment. Only the parts related to the present embodiment are shown for convenience of explanation.

[0069] Referring to FIG. 3, an embodiment of the present invention provides a system for upgrading a sqlite3 embedded database, including:

[0070] The application software upgrade module 1 is configured to complete loading and restarting the upgrade application software on the device. [0071] The determining module 2 is configured to read the version number of the target database in the upgrade application software and the device. Inside a version number of the source database, determining whether the version number of the target database is consistent with the version number of the source database;

[0072] The database upgrade module 3 is configured to perform backup on the source database if inconsistency, and invoke a version number embedded in the upgrade application software to match the version number of the target database and the version number of the source database. The upgrade configuration file, the source database in the device memory is upgraded according to the upgrade configuration file.

[0073] Optionally, the database upgrade module 3 includes:

[0074] a database structure reverse establishing unit 31, configured to acquire a database structure of the target database, and inversely establish a database structure of the source database according to the database structure of the target database and the upgrade configuration file;

[0075] a data stream obtaining unit 32, configured to perform memory space allocation by using a database structure of the source database, to read a data stream of the old data table in the source database;

[0076] a new data table creating unit 33, configured to delete the old data table, and create a new data table by using a database structure of the target database;

[0077] a data stream bit offset processing unit 34, configured to restore the data stream to the new data table, and process a bit offset of the data stream in the new data table according to the upgrade configuration file. To generate the target database.

[0078] Optionally, the upgrade configuration file includes a database structure in the target database and field change information of the data structure in the source database, where the field change information includes: deleting a field, adding a field, modifying a field name, modifying a field type, and Modify the field length.

[0079] Optionally, the upgrade configuration file is embedded in the upgrade application software in an xml file format, and each upgrade target in the upgrade configuration file is stored as a unit in a linked list, so that Performing the upgrade target in the upgrade configuration file according to the linked list sequence during the database upgrade process

[0080] Optionally, the data stream bit offset processing unit 34 is specifically configured to:

[0081] if the upgrade target is a delete field, searching the data stream according to a bit to obtain a target bit stored in the field to be deleted, deleting information stored at the target bit, and performing data bit shift again; [0082] if the upgrade target is an add field, searching for the data stream according to a bit to obtain a word to be added Adding a position of the segment, adding a corresponding field length at the added position, and assigning default data to the newly added field;

[0083] if the upgrade target is to modify the field name, no processing is performed;

[0084] if the upgrade target is a modified field type, calculating a bit offset of the data stream at the position of the field to be modified, deleting the data stream at the position of the field to be modified, and then adding the field, and calculating The bit offset of the data stream at the newly added field position, the difference calculation between the two bit offsets to perform the bit offset, and the default value is written at the position of the newly added field;

[0085] If the upgrade target is to modify the length of the field, the bit offset of the data stream is performed according to the length to be changed, and the default value is written.

[0086] It is to be noted that the respective modules in the foregoing system provided by the embodiments of the present invention are based on the same concept as the method embodiment of the present invention, and the technical effects thereof are the same as the method embodiments of the present invention. The description in the embodiments of the present invention will not be repeated here.

[0087] Therefore, the system for upgrading the sqlite3 embedded database provided by the embodiment of the present invention can also implement the database upgrade by using the extraction and splitting of the existing data in the database. Improve the existing sqlite3 embedded database, supplement the missing function of sqlite3 embedded database, can make most of the devices using sqlite3 embedded database can perform non-destructive upgrade operation, maximally protect the source database The data simplifies the upgrade process, shortens the upgrade time, and greatly facilitates the maintenance of the equipment, reducing the workload of maintenance personnel.

[0088] Please refer to FIG. 4, which is a structural block diagram of a system for upgrading a sqlite3 type embedded database according to another embodiment of the present invention. The system is located in the device according to the embodiment of the present invention, and is used to run the method provided in the embodiment shown in FIG. 1 to FIG. 2 above. Only the parts related to the present embodiment are shown for convenience of explanation.

[0089] Referring to FIG. 4, the embodiment provides a system for upgrading a sqlite3 embedded database, including

[0090] processor 410, communication interface 420, memory

(memory) 430, bus 440.

[0091] The processor 410, the communication interface 420, and the memory 430 complete communication with each other through the bus 440.

[0092] The communication interface 420 is configured to communicate with an external device, such as a personal computer, a server, or the like.

[0093] The processor 410 is configured to execute the program 431. [0094] Specifically, the program 431 may include program code, the program code including computer operation instructions.

[0095] The processor 410 may be a central processing unit CPU, or an application specific integrated circuit (ASIC), or one or more integrated circuits configured to implement embodiments of the present invention.

[0096] The memory 430 is configured to store the program 431. The memory 430 may include a high speed RAM memory and may also include a non-volatile memory such as at least one disk memory. The program 431 may specifically include:

[0097] application software upgrade module 1, used to complete the loading of the upgrade application software on the device and restart the device

[0098] The determining module 2 is configured to read a version number of the target database in the upgrade application software and a version number of the source database in the device memory, and determine a version number of the target database and a version number of the source database. Consistent;

[0099] The database upgrade module 3 is configured to perform backup on the source database if inconsistency, and invoke the version number of the target database embedded in the upgrade application software to match the version number of the source database. The upgrade configuration file, the source database in the device memory is upgraded according to the upgrade configuration file.

[0100] It will be apparent to those skilled in the art that, for the convenience and brevity of the description, the specific working process of the system, the device and the unit described above may refer to the corresponding process in the foregoing method embodiment, and details are not described herein again. .

[0101] In the several embodiments provided by the present application, it should be understood that the disclosed system, apparatus, and method may be implemented in other manners. For example, the device embodiments described above are merely illustrative. For example, the division of the unit is only a logical function division, and the actual implementation may have another division manner, for example, multiple units or components may be combined or Can be integrated into another system, or some features can be ignored, or not executed. Alternatively, the coupling or direct coupling or communication connection shown or discussed may be an indirect coupling or communication connection through some communication interface, device or unit, and may be in electrical, mechanical or other form.

[0102] The unit described as a separate component may or may not be physically distributed. The component displayed as a unit may or may not be a physical unit, that is, may be located in one place, or may be located in one place. Distributed to multiple network elements. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of the embodiment.

[0103] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0104] The functions, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention, which is essential or contributes to the prior art, or a part of the technical solution, may be embodied in the form of a software product, which is stored in a storage medium, including The instructions are used to cause a computer device (which may be a personal computer, server, or network device, etc.) to perform all or part of the steps of the methods described in various embodiments of the present invention. The foregoing storage medium includes: u disk

, mobile hard disk, read-only memory (ROM, Read-Only

Memory, random access memory (RAM), disk or optical disk, and other media that can store program code.

The above description is only the preferred embodiment of the present invention, and is not intended to limit the present invention, and any modifications, equivalents, and improvements made within the spirit and scope of the present invention should be included in the present invention. Within the scope of protection of the invention.

Claims

Claim

[Claim 1] A method for upgrading an sqlite type 3 embedded database, comprising: loading and restarting the upgrade application software on the device;

And reading a version number of the target database in the upgrade application software and a version number of the source database in the device memory, and determining whether a version number of the target database is consistent with a version number of the source database;

If not, the source database is backed up, and an upgrade configuration file embedded in the upgrade application software that matches the version number of the target database and the version number of the source database is invoked, according to the upgrade configuration. The file upgrades the source database in the device memory.

[Claim 2] The method for upgrading the sqlite type 3 embedded database according to claim 1, wherein the upgrading the source database in the device memory according to the upgrade configuration file includes:

Performing a memory space allocation by using a database structure of the source database to read a data stream of the old data table in the source database;

Deleting the old data table and creating a new data table using the database structure of the target database;

The data stream is restored to the new data table, and the bit offset of the data stream in the new data table is processed according to the upgrade configuration file to generate a target database.

[Claim 3] The method for upgrading an sqlite type 3 embedded database according to claim 2, wherein the upgrade configuration file includes a database structure in a target database and field change information of a data structure in the source database, The field change information includes: deleting a field, adding a field, modifying a field name, modifying a field type, and modifying a field length.

[Claim 4] The method for upgrading an sqlite3 type embedded database according to claim 3, wherein the upgrade configuration file is packaged with the upgrade application software in an xml file format, and Each upgrade target in the upgrade configuration file as a unit Stored in the form of a linked list to perform the upgrade target in the upgrade configuration file according to the linked list order during the database upgrade process.

[Claim 5] The method for upgrading an sqlite3 type embedded database according to claim 4, wherein the processing the bit offset of the data stream in the new data table according to the upgrade configuration file To generate the target database specifically includes:

If the upgrade target is a delete field, the data stream is searched according to a bit to obtain a target bit stored in the field to be deleted, the information stored at the target bit is deleted, and the data bit offset is re-executed;

If the upgrade target is an add field, searching for the data stream according to the bit to obtain an added position of the field to be added, adding a corresponding field length at the added position, and assigning default data to the newly added field. ;

If the upgrade target is to modify the field name, no processing is performed; if the upgrade target is a modified field type, the bit offset of the data stream at the position of the field to be modified is calculated, and the position of the field to be modified is deleted. Data stream, then add the field, and calculate the bit offset of the data stream at the newly added field position, calculate the difference between the two bit offsets, perform bit offset, and position the newly added field Write the default value;

If the upgrade target is to modify the field length, the bit offset of the data stream is performed according to the length to be changed, and the default value is written.

[Claim 6] A system for upgrading a sqlite type 3 embedded database, comprising: an application software upgrade module, configured to complete loading of the upgrade application software on the device and restarting the device;

a judging module, configured to read a version number of the target database in the upgrade application software and a version number of the source database in the device memory, and determine whether the version number of the target database is consistent with the version number of the source database;

a database upgrade module, configured to back up the source database if inconsistency, and invoke an upgrade configuration file embedded in the upgrade application software that matches a version number of the target database and a version number of the source database According to the upgrade configuration file, the device is configured The source database in the standby memory is upgraded.

The system for upgrading a sqlite type 3 embedded database according to claim 6, wherein the database upgrade module comprises:

a database structure reverse establishing unit, configured to acquire a database structure of the target database, and reversely establish a database structure of the source database according to the database structure of the target database and the upgrade configuration file;

a data stream obtaining unit, configured to perform memory space allocation by using a database structure of the source database, to read a data stream of the old data table in the source database;

a new data table creating unit, configured to delete the old data table, and create a new data table by using a database structure of the target database;

a data stream bit offset processing unit, configured to restore the data stream to the new data table, and process a bit offset of the data stream in the new data table according to the upgrade configuration file to generate a target database.

The system for upgrading an sqlite type 3 embedded database according to claim 7, wherein the upgrade configuration file includes a database structure in the target database and field change information of the data structure in the source database, and the field change information includes : Delete fields, add fields, modify field names, modify field types, and modify field lengths.

The system for upgrading an sqlite3 type embedded database according to claim 8, wherein the upgrade configuration file is packaged with the upgrade application software in an xml file format, and the upgrade configuration file is Each upgrade target is stored as a unit in the form of a linked list, so that the upgrade target in the upgrade configuration file is executed according to the linked list order during the database upgrade process.

The system for upgrading a sqlite type 3 embedded database according to claim 9, wherein the data stream bit offset processing unit is specifically configured to:

If the upgrade target is an add field, the data stream is searched by bit to obtain Adding a field to be added, adding a corresponding field length at the added position, and assigning default data to the newly added field;

If the upgrade target is to modify the field name, no processing is performed;

If the upgrade target is to modify the field type, calculate a bit offset of the data stream at the position of the field to be modified, delete the data stream at the position of the field to be modified, and then add the field, and calculate a newly added field. The bit offset of the data stream at the position, the difference between the two bit offsets is calculated to perform the bit offset, and the default value is written at the position of the newly added field;