Cross-version upgrade method and system for examination system of SaaS software

By counting the number of version iteration upgrades of the production system in the SaaS software examination system, centralized upgrades are carried out when the preset threshold is reached, and the database is migrated through the Apollo configuration management service, the system instability caused by frequent upgrades of the examination system is solved, and a more efficient and stable upgrade process is achieved.

CN119065695BActive Publication Date: 2025-03-07蒲惠智造科技股份有限公司
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411571747.2
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-11-06
Publication Date
2025-03-07
Estimated Expiration
2044-11-06

AI Technical Summary

Technical Problem

When the existing SaaS software examination system is iteratively upgraded, frequent upgrades lead to system instability and increased maintenance costs. How to reduce the number of iterations and upgrades of the examination system and maintain system stability?

Method used

By counting the number of version iteration upgrades of the production system, when the total number exceeds the preset threshold, the latest Jar files and apk files of the production system in the latest version iteration are obtained, the examination system is centrally upgraded, and the full data of the production system database is migrated to the examination system database through the Apollo configuration management service to upgrade the examination system database.

Benefits of technology

It reduces the number of iterations and upgrades of the examination system, reduces the probability of system changes and errors, and improves the stability and upgrade efficiency of the examination system.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119065695B_ABST
    Figure CN119065695B_ABST
Patent Text Reader

Abstract

The present application discloses a method and system for cross-version upgrade of an examination system for SaaS software, the method comprising: counting the total number of version iteration upgrades of the production system between the current moment and the target moment; when the total number is greater than a preset number threshold, obtaining the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade from the current moment, and upgrading the examination system based on the Jar file and the apk file; in the database of the examination system, executing the database script sequence stored in the SQL audit platform according to the version number and change time, obtaining the execution result, and verifying whether the execution result is consistent with the DDL of the production system database; if so, migrating the full amount of data of the production system database to the examination system database through the Apollo configuration management service. Therefore, by adopting the present application, the number of iteration upgrades of the examination system can be reduced, the stability of the examination system can be maintained, and cross-version upgrades of the examination system can be achieved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a method and system for upgrading a test system across versions of SaaS software. Background Art

[0002] In the field of Software as a Service (SaaS), in order to help customers quickly get familiar with and master system functions, especially the experience, understanding and mastery of new functions, developers usually develop a set of simulation software evaluation test questions system (referred to as "examination system"). This examination system complements the production system of SaaS software and is used to simulate the main process of business functions in the production system of SaaS software, so that customers can quickly get started and receive training demonstrations.

[0003] For existing SaaS software, the production system will regularly upgrade its version, usually every two weeks, but the new features of the upgrade are not necessarily required by the examination system (for example, iterative upgrades that do not involve business processes). Currently, if the examination system is upgraded synchronously with the production system, additional maintenance work will be required, and the system will be unstable.

[0004] Therefore, how to reduce the number of iterations and upgrades of the examination system, maintain the stability of the examination system, and avoid system instability and increased maintenance costs caused by frequent upgrades is an issue that needs to be solved urgently. Summary of the invention

[0005] The embodiments of the present application provide a method and system for upgrading the cross-version of the examination system for SaaS software. In order to have a basic understanding of some aspects of the disclosed embodiments, a simple summary is given below. This summary is not a general review, nor is it intended to identify key / important components or describe the scope of protection of these embodiments. Its only purpose is to present some concepts in a simple form as a preface to the detailed description that follows.

[0006] In a first aspect, an embodiment of the present application provides a method for upgrading a test system across versions of SaaS software, the method comprising:

[0007] Count the total number of version iterations and upgrades of the production system between the current time and the target time. The target time is the historical time of the last version upgrade of the examination system. The production system is SaaS software, and the examination system is used to simulate the main process of business functions in the production system.

[0008] When the total number of times is greater than the preset number threshold, the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade from the current moment are obtained, and the historical application programs of the examination system are upgraded based on the Jar file and the apk file;

[0009] In the database of the examination system, the database script sequence stored in the SQL audit platform is executed according to the version number and change time to obtain the execution result, and verify whether the execution result is consistent with the actual database structure DDL of the database of the production system. Each database script in the database script sequence is a database script that is changed in each version iteration update of the production system between the current time and the target time;

[0010] If so, use the Apollo configuration management service to migrate all the data in the production system database to the examination system database to upgrade the examination system database.

[0011] Optionally, the method further includes:

[0012] Obtain updated target question bank from production system;

[0013] Based on the target question bank, create an exam track, which is a record of a series of operations and system responses of the examinee interacting with the exam system during the simulated real exam process;

[0014] According to the test track, multiple tests of the test system are simulated in the playback system to obtain the simulation results of each test; the test track is obtained by pre-recording the entire standard test process using traffic playback technology, and the playback system is obtained by replicating the real test environment of the test system;

[0015] When the simulation results of each exam indicate that there is no abnormality in each exam and the exam results are consistent with the preset scores, the historical question bank of the exam system is replaced with the target question bank to upgrade the question bank of the exam system.

[0016] Optionally, execute the database script sequence stored in the SQL audit platform according to the version number and change time to obtain the execution results, including:

[0017] Calculate the time range between the current time and the target time;

[0018] From the SQL audit platform, obtain the database scripts that are changed during each version iteration update of the production system within the time range, and obtain a database script sequence. Each data script in the database script sequence carries a script identifier. Each data script in the database script sequence is an operation of adding, modifying, and deleting a table structure.

[0019] According to the script identifier carried by each data script, the corresponding version number and change time are obtained from the pre-established mapping relationship between the script identifier and the version number and change time;

[0020] Based on the version number or change time corresponding to the script identifier carried by each data script, the database script sequence is sorted to ensure that the execution order is consistent with the actual version iteration order;

[0021] Execute the sorted database script sequence to obtain the current database structure DDL;

[0022] The current database structure DDL is used as the execution result.

[0023] Optionally, the mapping relationship between the pre-established script identifier and the version number and change time is generated according to the following steps, including:

[0024] Through the preset listener, monitor in real time whether new target database scripts are stored in the SQL audit platform;

[0025] When a new target database script is stored in the SQL audit platform, a script identifier of the target database script is created;

[0026] Obtain the version number and change time assigned to the target database script when the production system version is iteratively updated;

[0027] The mapping relationship between the script identifier of the target database script, the version number of the target database script, and the change time is stored.

[0028] Optionally, the execution result includes the current database structure DDL;

[0029] Verify that the execution results are consistent with the actual database structure DDL of the production system's database, including:

[0030] Use the file reading function in the programming language to open and read the content of the current database structure DDL to obtain the first DDL content;

[0031] Use the file reading function in the programming language to open and read the actual database structure DDL content of the database of the production system to obtain the second DDL content;

[0032] Analyze the data formats of the first DDL content and the second DDL content;

[0033] Based on the data format, the first DDL content and the second DDL content are parsed by a preset parsing library to obtain first parsed data corresponding to the current database structure DDL and second parsed data corresponding to the actual database structure DDL;

[0034] Traversing the object information of each database object in the first parsed data and the second parsed data;

[0035] Based on the object information of each database object, determine whether the execution result is consistent with the actual database structure DDL of the database of the production system.

[0036] Optionally, the preset parsing library includes a JSON parsing library and an XML parsing library, the JSON parsing library is a json module in the Python programming language, and the XML parsing library is an xml.etree.ElementTree module in the Python programming language;

[0037] Based on the data format, the first DDL content and the second DDL content are parsed by a preset parsing library, including:

[0038] When the data format is JSON, initialize the json module;

[0039] The basic initialized json module parses the first DDL content and the second DDL content into a data structure in a programming language; or,

[0040] When the data format is XML, initialize the xml.etree.ElementTree module;

[0041] The first DDL content and the second DDL content are parsed into a tree structure based on the initialized xml.etree.ElementTree module.

[0042] Optionally, traversing the object information of each database object in the first parsed data and the second parsed data includes:

[0043] In the case where the first parsed data or the second parsed data is a data structure, traverse each key-value pair in the first parsed data or the second parsed data as the object information of each database object in the first parsed data and the second parsed data, the key of each key-value pair is used to represent the name of the database object, and the value of the key-value pair is used to represent the DDL definition of the database object; or,

[0044] When the first parsed data or the second parsed data is in a tree structure, traverse each database object node in the first parsed data or the second parsed data;

[0045] The node name and attributes of each database object node are obtained as the object information of each database object in the first parsed data and the second parsed data, wherein the node name is used to represent the name of the database object, and the attributes are used to represent the DDL definition of the database object.

[0046] Optionally, based on the object information of each database object, it is determined whether the execution result is consistent with the actual database structure DDL of the database of the production system, including:

[0047] For each database object in the first parsed data, obtain the first name and the first DDL definition of the database object in the object information;

[0048] For each database object in the second parsed data, obtain the second name and the second DDL definition of the database object in the object information;

[0049] comparing each first name to each second name to determine whether there is a second name that matches each first name;

[0050] If yes, compare each first DDL definition with each second DDL definition to determine whether there is a second DDL definition that matches each first DDL definition;

[0051] If yes, make sure the execution result is consistent with the actual database structure DDL of the production system's database;

[0052] If not, it is determined that the execution result is inconsistent with the actual database structure DDL of the database of the production system.

[0053] Optionally, create an exam track based on the target question bank, including:

[0054] Obtain at least one test process pre-designed for a target question bank, each test process covering various question types and operations in the target question bank;

[0055] Based on at least one examination process, a series of operations of the examinee interacting with the examination system during the actual examination process are simulated by an automated testing tool;

[0056] Record the system response results of each operation step;

[0057] Store the corresponding relationship between each operation step and the system response result of each operation step;

[0058] Sort the corresponding relationships in chronological order to obtain a sorting result;

[0059] The sorting results are used as the test track.

[0060] In a second aspect, an embodiment of the present application provides a cross-version upgrade system for an examination system of SaaS software, the system comprising:

[0061] The statistics module is used to count the total number of version iteration upgrades of the production system corresponding to the current time and the target time. The target time is the historical time of the last version upgrade of the examination system. The production system is a SaaS software, and the examination system is used to simulate the main process of the business functions in the production system;

[0062] The online release module is used to obtain the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade when the total number of times is greater than the preset number threshold, and upgrade the historical application of the examination system based on the Jar file and apk file;

[0063] An execution module is used to execute the database script sequence stored in the SQL audit platform in the database of the examination system according to the version number and change time, obtain the execution result, and verify whether the execution result is consistent with the actual database structure DDL of the database of the production system. Each database script in the database script sequence is a database script that is changed in each version iteration update of the production system between the current time and the target time;

[0064] The migration module is used to migrate all the data of the production system database to the examination system database through the Apollo configuration management service to upgrade the examination system database.

[0065] The technical solution provided by the embodiments of the present application may have the following beneficial effects:

[0066] In the embodiment of the present application, on the one hand, by counting the total number of version iteration upgrades of the production system corresponding to the current moment and the target moment, and comparing it with the preset number threshold, when the total number of version iteration upgrades of the production system exceeds this threshold, the examination system is centrally upgraded once, reducing the number of iteration upgrades of the examination system. The reduction in the number of upgrades leads to fewer system changes and lower error probability, thereby reducing the risk of system instability caused by frequent upgrades. On the other hand, by obtaining the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade from the current moment for upgrading, and upgrading the database of the examination system at the same time, by centrally processing all version iteration changes of the production system between the current moment and the last upgrade moment of the examination system, the examination system realizes cross-version upgrades. The ability of cross-version upgrades greatly improves the upgrade efficiency and flexibility of the examination system.

[0067] It should be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

[0068] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.

[0069] Figure 1 It is a flowchart of a method for upgrading a test system across versions of SaaS software provided in an embodiment of the present application;

[0070] Figure 2 This application provides a data representation of the mapping relationship between the script identifier, version number, and change time.

[0071] Figure 3 This is a schematic diagram of the system response results of each operation step provided by this application;

[0072] Figure 4 This is a structural diagram of a cross-version upgrade system for an examination system of SaaS software provided by this application;

[0073] Figure 5 It is a structural schematic diagram of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0074] The following description and the accompanying drawings sufficiently illustrate specific embodiments of the present application to enable those skilled in the art to practice them.

[0075] It should be clear that the described embodiments are only part of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without creative work are within the scope of protection of the present application.

[0076] When the following description refers to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. Instead, they are only examples of systems and methods consistent with some aspects of the present application as detailed in the attached claims.

[0077] In the description of the present application, it should be understood that the terms "first", "second", etc. are used for descriptive purposes only and should not be understood as indicating or implying relative importance. For those of ordinary skill in the art, the specific meanings of the above terms in the present application can be understood according to the specific circumstances. In addition, in the description of the present application, unless otherwise specified, "multiple" refers to two or more. "And / or" describes the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. The character " / " generally indicates that the objects associated before and after are in an "or" relationship.

[0078] The present application provides a method and system for cross-version upgrade of an examination system for SaaS software to solve the problems existing in the above-mentioned related technical problems. In an embodiment of the present application, on the one hand, by counting the total number of version iteration upgrades of the production system corresponding to the current moment and the target moment, and comparing it with the preset number threshold, when the total number of version iteration upgrades of the production system exceeds this threshold, the examination system is centrally upgraded once, reducing the number of iteration upgrades of the examination system. The reduction in the number of upgrades leads to fewer system changes and a lower probability of error, thereby reducing the risk of system instability caused by frequent upgrades. On the other hand, by obtaining the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade from the current moment, the database of the examination system is upgraded at the same time, and by centrally processing all version iteration changes of the production system between the current moment and the last upgrade moment of the examination system, the examination system realizes cross-version upgrades, and the ability of cross-version upgrades greatly improves the upgrade efficiency and flexibility of the examination system. The following is a detailed description using an exemplary embodiment.

[0079] The following will be combined with the attached Figure 1 -Attached Figure 3 , a method for upgrading the examination system for SaaS software provided by an embodiment of the present application is introduced in detail. The method can be implemented by a computer program and can be run on a system for upgrading the examination system for SaaS software based on the von Neumann system. The computer program can be integrated into an application or run as an independent tool application.

[0080] See also Figure 1 , which is a flowchart of a method for upgrading a SaaS software examination system across versions. Figure 1 As shown, the method of the embodiment of the present application may include the following steps:

[0081] S101, counting the total number of version iteration upgrades of the production system corresponding to the current time and the target time, where the target time is the historical time of the last version upgrade of the examination system, the production system is SaaS software, and the examination system is used to simulate the main process of the business functions in the production system;

[0082] Among them, version iteration and upgrade refers to the process of releasing new versions of software products regularly or as needed during the development process to add new functions, improve performance, fix defects or enhance user experience. The current moment refers to the current time point, which can be the time recorded by the system or the time when the operation is performed. The target moment refers to a specific time point in the past, which is used to compare with the current moment to determine the changes that have occurred within this time range. In this application, the target moment is the time when the examination system was last upgraded. The production system refers to the actual running software system, the system used by users in daily life. For SaaS (Software as a Service) software, the production system is an online platform that provides services to customers. The examination system is a system designed specifically for examinations. It can be used to create, manage and score examinations. In this application, the examination system simulates the business functions in the production system to facilitate user learning and practice.

[0083] In some embodiments, assume that a production system of a SaaS software has undergone 15 version iteration upgrades since the last exam system upgrade. The last upgrade of the exam system was 6 months ago. At this time, it is necessary to count the number of version iteration upgrades of the production system within 6 months and decide whether the exam system needs to be upgraded. First, query the version control system or release management system to count the number of version iteration upgrades of the production system from 6 months ago to the current moment, for example, 6 times.

[0084] S102, when the total number of times is greater than the preset number threshold, obtain the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade from the current moment, and upgrade the historical application of the examination system based on the Jar file and the apk file;

[0085] The total number is the cumulative number of version iteration upgrades performed by the production system within the time range between the current moment and the historical moment of the last version upgrade of the examination system. The preset number threshold is a pre-set value used to determine when the examination system should be upgraded; when the total number of version iteration upgrades exceeds this threshold, the upgrade process of the examination system is triggered. Jar files are Java Archive files, a compressed package format that packages Java class files and related resources, and is used for the deployment of Java applications. apk files are Android Package files, which are installations of applications for the Android operating system.

[0086] In some embodiments of the present application, if the total number of version iteration upgrades exceeds a preset threshold (e.g., 5 times), it is decided to upgrade the examination system to ensure that the examination system is consistent with the production system. Confirm that the total number of version iteration upgrades of the production system in the past 3 months is 6 times. Since 6 times is greater than the preset threshold of 5 times, the conditions for upgrading the examination system are met. Therefore, the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade from the current moment are obtained from the build server or version control system. Use the latest Jar file and apk file obtained to replace the old application in the examination system, deploy the new Jar file to the server, and install the new apk file to the client device to upgrade the historical application of the examination system.

[0087] S103, in the database of the examination system, execute the database script sequence stored in the SQL audit platform according to the version number and change time, obtain the execution result, and verify whether the execution result is consistent with the actual database structure DDL of the database of the production system. Each database script in the database script sequence is a database script that is changed in each version iteration update of the production system between the current time and the target time;

[0088] Among them, the database is a system that can store, retrieve and modify data according to user instructions. Here, it specifically refers to the database of the examination system, which is used to store examination-related data. The version number is a number used to identify different iterations of software or database scripts. The version number helps to track and manage the change history. The change time refers to the specific time point when the database script is modified or updated. Sorting by change time helps to determine the order of script execution. The SQL audit platform is a platform for recording and managing database changes. It can store SQL scripts for each change and provide audit tracking functions. The database script sequence is a collection of a series of database scripts, which is the change history of the database structure from the target moment to the current moment. DDL is the Data Definition Language, which is used to define and modify the structure of the database, such as creating, modifying or deleting tables and indexes. The actual database structure DDL refers to the current database structure definition in the production system.

[0089] In some embodiments of the present application, when executing a database script sequence stored in a SQL audit platform according to a version number and a change time, a specific process for obtaining an execution result includes: calculating a time range between a current moment and a target moment; obtaining from the SQL audit platform a database script that is changed during each version iteration update of a production system within the time range to obtain a database script sequence, wherein each data script in the database script sequence carries a script identifier, and each data script in the database script sequence is an operation for adding, modifying, or deleting a table structure; obtaining the corresponding version number and change time from a pre-established mapping relationship between the script identifier and the version number and the change time according to the script identifier carried by each data script; sorting the database script sequence based on the version number or change time corresponding to the script identifier carried by each data script to ensure that the execution order is consistent with the actual version iteration order; executing the sorted database script sequence to obtain the current database structure DDL; and taking the current database structure DDL as the execution result.

[0090] The script identifier is a unique identifier used to identify and distinguish different database scripts. The mapping relationship refers to a pre-established data table that stores the correspondence between the script identifier and the version number and change time.

[0091] In an embodiment of the present application, by accurately calculating the time range and obtaining the corresponding database change script from the SQL audit platform, and then using the mapping relationship between the script identifier and the preset version number and change time, it is possible to ensure that these scripts are sorted and executed in the correct iteration order, and at the same time, automatically generate a current database structure DDL that is consistent with the actual version iteration update order, thereby ensuring the accuracy and consistency of the database structure, reducing human errors, and improving the efficiency of database management and maintenance.

[0092] Specifically, the mapping relationship between the pre-established script identifier and the version number and change time is generated according to the following steps, including: monitoring in real time through a preset listener whether a new target database script is stored in the SQL audit platform; creating a script identifier of the target database script when a new target database script is stored in the SQL audit platform; obtaining the version number and change time assigned to the target database script when the production system version is iteratively updated; and storing the mapping relationship between the script identifier of the target database script, the version number of the target database script and the change time.

[0093] Wherein, the preset listener is a pre-set listening tool or mechanism for monitoring or listening to the occurrence of a specific event. In this application, the listener is specifically used to monitor the SQL audit platform to detect in real time whether a new database script is stored.

[0094] In the embodiment of the present application, the mapping relationship stores the mapping relationship between these script identifiers and version numbers and change times, so that these scripts can be correctly sorted and executed later. This process helps to automate the management of database scripts, ensure that scripts are executed in the correct order, and maintain the consistency of the database structure. The data table of the mapping relationship is as follows: Figure 2 shown.

[0095] In some embodiments of the present application, the execution result includes the current database structure DDL. The specific process of verifying whether the execution result is consistent with the actual database structure DDL of the database of the production system includes: using the file reading function in the programming language to open and read the content of the current database structure DDL to obtain the first DDL content; using the file reading function in the programming language to open and read the content of the actual database structure DDL of the database of the production system to obtain the second DDL content; analyzing the data format of the first DDL content and the second DDL content; based on the data format, performing content parsing processing on the first DDL content and the second DDL content through a preset parsing library to obtain the first parsed data corresponding to the current database structure DDL and the second parsed data corresponding to the actual database structure DDL; traversing the object information of each database object in the first parsed data and the second parsed data; based on the object information of each database object, determining whether the execution result is consistent with the actual database structure DDL of the database of the production system.

[0096] Among them, the file reading function is a capability provided by the programming language that allows the program to open and read the contents of files stored in the file system (such as a hard disk). In this application, the file reading function is used to obtain DDL files, which contain SQL statements that define the database structure. Data format refers to the way data is stored and represented. The preset parsing library is a set of predefined functions or modules for parsing data in a specific format. The object information of a database object refers to the detailed information of each object in the database (such as tables, views, indexes, etc.), including their definitions and properties.

[0097] Specifically, the preset parsing library includes a JSON parsing library and an XML parsing library. The JSON parsing library is a json module in the Python programming language, and the XML parsing library is an xml.etree.ElementTree module in the Python programming language.

[0098] In some embodiments of the present application, based on the data format, the specific process of performing content parsing processing on the first DDL content and the second DDL content through a preset parsing library includes: when the data format is JSON format, initializing the json module; the basic initialized json module parses the first DDL content and the second DDL content into a data structure in a programming language; or, when the data format is XML format, initializing the xml.etree.ElementTree module; based on the initialized xml.etree.ElementTree module, the first DDL content and the second DDL content are parsed into a tree structure.

[0099] In some embodiments of the present application, the specific process of traversing the object information of each database object in the first parsed data and the second parsed data includes: when the first parsed data or the second parsed data is a data structure, traversing each key-value pair in the first parsed data or the second parsed data as the object information of each database object in the first parsed data and the second parsed data, the key of each key-value pair is used to represent the name of the database object, and the value of the key-value pair is used to represent the DDL definition of the database object; or, when the first parsed data or the second parsed data is a tree structure, traversing each database object node in the first parsed data or the second parsed data; obtaining the node name and attributes of each database object node as the object information of each database object in the first parsed data and the second parsed data, the node name is used to represent the name of the database object, and the attribute is used to represent the DDL definition of the database object.

[0100] In some embodiments of the present application, based on the object information of each database object, the specific process of determining whether the execution result is consistent with the actual database structure DDL of the database of the production system includes: for the object information of each database object in the first parsed data, obtaining the first name and the first DDL definition of the database object of the object information; for the object information of each database object in the second parsed data, obtaining the second name and the second DDL definition of the database object of the object information; comparing each first name with each second name to determine whether there is a second name that matches each first name; if so, comparing each first DDL definition with each second DDL definition to determine whether there is a second DDL definition that matches each first DDL definition; if so, determining that the execution result is consistent with the actual database structure DDL of the database of the production system; if not, determining that the execution result is inconsistent with the actual database structure DDL of the database of the production system.

[0101] S104, if yes, migrate all the data of the production system database to the database of the examination system through the Apollo configuration management service to upgrade the database of the examination system.

[0102] Among them, Apollo is an open source configuration management service that supports unified management of configurations of different environments and different clusters, and provides functions such as configuration modification, release, and real-time update. In this application, the Apollo configuration management service is used to perform full data migration from the production system database to the examination system database.

[0103] In some embodiments, the configuration items of the production system database (such as database connection string, database version, etc.) are updated to the examination system through the Apollo configuration management service. The full amount of data in the production system database can be migrated to the examination system database through the data migration function supported by Apollo.

[0104] In the embodiment of the present application, the upgrade of the question bank is also included. The specific process of question bank upgrade includes: obtaining the updated target question bank from the production system; based on the target question bank, creating an examination track, which is a record of a series of operations and system responses of the examinee interacting with the examination system during the simulation of the real examination process; according to the examination track, simulating multiple examinations of the examination system in the playback system to obtain the simulation results of each examination; the examination track is obtained by pre-recording the entire process of the standard examination using the flow playback technology, and the playback system is obtained by copying the real examination environment of the examination system; when the simulation results of each examination indicate that there is no abnormality in each examination and the examination results are consistent with the preset score, the historical question bank of the examination system is replaced with the target question bank to upgrade the question bank of the examination system.

[0105] Among them, the target question bank refers to the question bank that needs to be updated in the examination system, which may contain new questions, updated question content or changes in question structure. The examination trajectory refers to the record of a series of operations and system responses of the examinee's interaction with the examination system in the simulation of the real examination process. The playback system refers to a system that replicates the real examination environment of the examination system and is used to simulate the examination process. Traffic playback technology is a technology used to record and replay network traffic, including user operations and system responses. The simulation results refer to the results obtained after the simulation examination in the playback system. These results reflect the performance of the examination system in processing the simulation examination, including system response time, error rate, scoring accuracy, etc. The preset score refers to the standard answer and corresponding score set for the question before the examination begins. When the simulation test results are consistent with the preset score, it can be considered that the scoring mechanism of the examination system is accurate.

[0106] In an embodiment of the present application, an updated target question bank is obtained from the production system, and then an exam track is created based on this question bank, and multiple exams are simulated in the playback system to verify the correctness of the exam system. If the simulation results show that the exam system performs normally and the exam results are consistent with the preset scores, then the historical question bank of the exam system can be safely replaced with the target question bank to complete the upgrade of the question bank. This process helps to ensure that the update of the question bank of the exam system does not introduce new problems and can maintain the consistency and accuracy of the scoring.

[0107] In some embodiments of the present application, the specific process of creating an examination track based on the target question bank includes: obtaining at least one examination process pre-designed for the target question bank, each examination process covering various question types and operations in the target question bank; based on at least one examination process, simulating a series of operations of the examinee interacting with the examination system during the actual examination through an automated testing tool; recording the system response result of each operation; storing the corresponding relationship between each operation and the system response result of each operation; sorting the corresponding relationship in chronological order to obtain the sorting result; and using the sorting result as the examination track. Among them, recording the system response result of each operation, for example Figure 3 As shown, it includes operation type, operation time, candidate's answer, correct answer, score, and system response time.

[0108] In the embodiment of the present application, on the one hand, by counting the total number of version iteration upgrades of the production system corresponding to the current moment and the target moment, and comparing it with the preset number threshold, when the total number of version iteration upgrades of the production system exceeds this threshold, the examination system is centrally upgraded once, reducing the number of iteration upgrades of the examination system. The reduction in the number of upgrades leads to fewer system changes and lower error probability, thereby reducing the risk of system instability caused by frequent upgrades. On the other hand, by obtaining the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade from the current moment for upgrading, and upgrading the database of the examination system at the same time, by centrally processing all version iteration changes of the production system between the current moment and the last upgrade moment of the examination system, the examination system realizes cross-version upgrades. The ability of cross-version upgrades greatly improves the upgrade efficiency and flexibility of the examination system.

[0109] The following is a system embodiment of the present application, which can be used to execute the method embodiment of the present application. For details not disclosed in the system embodiment of the present application, please refer to the method embodiment of the present application.

[0110] See also Figure 4, which shows a schematic diagram of the structure of a cross-version upgrade system for a test system of SaaS software provided by an exemplary embodiment of the present application. The cross-version upgrade system for a test system of SaaS software can be implemented as all or part of an electronic device through software, hardware, or a combination of both. The system 1 includes a statistics module 10, an online release module 20, an execution module 30, and a migration module 40.

[0111] A statistics module 10 is used to count the total number of version iteration upgrades of the production system corresponding to the current time and the target time, the target time is the historical time of the last version upgrade of the examination system, the production system is a SaaS software, and the examination system is used to simulate the main process of the business function in the production system;

[0112] The online release module 20 is used to obtain the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade when the total number of times is greater than the preset number threshold, and upgrade the historical application program of the examination system based on the Jar file and the apk file;

[0113] An execution module 30 is used to execute the database script sequence stored in the SQL audit platform in the database of the examination system according to the version number and the change time, obtain the execution result, and verify whether the execution result is consistent with the actual database structure DDL of the database of the production system. Each database script in the database script sequence is a database script that is changed in each version iteration update of the production system between the current time and the target time.

[0114] The migration module 40 is used to migrate all the data of the production system database to the database of the examination system through the Apollo configuration management service to upgrade the database of the examination system.

[0115] It should be noted that the cross-version upgrade system for the examination system of SaaS software provided in the above embodiment only uses the division of the above-mentioned functional modules as an example when executing the cross-version upgrade method for the examination system of SaaS software. In actual applications, the above-mentioned functions can be assigned to different functional modules as needed, that is, the internal structure of the device can be divided into different functional modules to complete all or part of the functions described above. In addition, the cross-version upgrade system for the examination system of SaaS software provided in the above embodiment and the cross-version upgrade method embodiment for the examination system of SaaS software belong to the same concept. The implementation process thereof is detailed in the method embodiment and will not be repeated here.

[0116] The serial numbers of the above-mentioned embodiments of the present application are for description only and do not represent the advantages or disadvantages of the embodiments.

[0117] In the embodiment of the present application, on the one hand, by counting the total number of version iteration upgrades of the production system corresponding to the current moment and the target moment, and comparing it with the preset number threshold, when the total number of version iteration upgrades of the production system exceeds this threshold, the examination system is centrally upgraded once, reducing the number of iteration upgrades of the examination system. The reduction in the number of upgrades leads to fewer system changes and lower error probability, thereby reducing the risk of system instability caused by frequent upgrades. On the other hand, by obtaining the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade from the current moment for upgrading, and upgrading the database of the examination system at the same time, by centrally processing all version iteration changes of the production system between the current moment and the last upgrade moment of the examination system, the examination system realizes cross-version upgrades. The ability of cross-version upgrades greatly improves the upgrade efficiency and flexibility of the examination system.

[0118] The present application also provides a computer-readable medium having program instructions stored thereon, which, when executed by a processor, implement the cross-version upgrade method for an examination system for SaaS software provided by the above-mentioned various method embodiments.

[0119] The present application also provides a computer program product including instructions, which, when executed on a computer, enables the computer to execute the cross-version upgrade method for an examination system of SaaS software of each of the above-mentioned method embodiments.

[0120] See also Figure 5 , is a schematic diagram of the structure of an electronic device provided in an embodiment of the present application. Figure 5 As shown, the electronic device 1000 may include: at least one processor 1001 , at least one network interface 1004 , a user interface 1003 , a memory 1005 , and at least one communication bus 1002 .

[0121] The communication bus 1002 is used to realize the connection and communication between these components.

[0122] The user interface 1003 may include a display screen (Display) and a camera (Camera). Optionally, the user interface 1003 may also include a standard wired interface and a wireless interface.

[0123] The network interface 1004 may optionally include a standard wired interface or a wireless interface (such as a WI-FI interface).

[0124] Among them, the processor 1001 may include one or more processing cores. The processor 1001 uses various interfaces and lines to connect various parts of the entire electronic device 1000, and executes various functions and processes data of the electronic device 1000 by running or executing instructions, programs, code sets or instruction sets stored in the memory 1005, and calling data stored in the memory 1005. Optionally, the processor 1001 can be implemented in at least one hardware form of digital signal processing (Digital Signal Processing, DSP), field programmable gate array (Field-Programmable Gate Array, FPGA), and programmable logic array (Programmable Logic Array, PLA). The processor 1001 can integrate one or a combination of a central processing unit (Central Processing Unit, CPU), a graphics processing unit (Graphics Processing Unit, GPU) and a modem. Among them, the CPU mainly processes the operating system, user interface and application programs; the GPU is responsible for rendering and drawing the content to be displayed on the display screen; the modem is used to process wireless communications. It can be understood that the above-mentioned modem may not be integrated into the processor 1001, and it can be implemented separately through a chip.

[0125] Among them, the memory 1005 may include a random access memory (Random Access Memory, RAM) and may also include a read-only memory (Read-Only Memory). Optionally, the memory 1005 includes a non-transitory computer-readable storage medium. The memory 1005 can be used to store instructions, programs, codes, code sets or instruction sets. The memory 1005 may include a program storage area and a data storage area, wherein the program storage area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playback function, an image playback function, etc.), instructions for implementing the above-mentioned various method embodiments, etc.; the data storage area may store data involved in the above-mentioned various method embodiments, etc. The memory 1005 may also be optionally at least one storage system located away from the aforementioned processor 1001. As Figure 5 As shown, the memory 1005 as a computer storage medium may include an operating system, a network communication module, a user interface module, and a cross-version upgrade application for the examination system of the SaaS software.

[0126] exist Figure 5In the electronic device 1000 shown, the user interface 1003 is mainly used to provide an input interface for the user and obtain the data input by the user; and the processor 1001 can be used to call the cross-version upgrade application for the examination system of the SaaS software stored in the memory 1005, and specifically perform the following operations:

[0127] Count the total number of version iterations and upgrades of the production system between the current time and the target time. The target time is the historical time of the last version upgrade of the examination system. The production system is SaaS software, and the examination system is used to simulate the main process of business functions in the production system.

[0128] When the total number of times is greater than the preset number threshold, the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade from the current moment are obtained, and the historical application programs of the examination system are upgraded based on the Jar file and the apk file;

[0129] In the database of the examination system, the database script sequence stored in the SQL audit platform is executed according to the version number and change time to obtain the execution result, and verify whether the execution result is consistent with the actual database structure DDL of the database of the production system. Each database script in the database script sequence is a database script that is changed in each version iteration update of the production system between the current time and the target time;

[0130] If so, use the Apollo configuration management service to migrate all the data in the production system database to the examination system database to upgrade the examination system database.

[0131] In one embodiment, the processor 1001 further performs the following operations:

[0132] Obtain updated target question bank from production system;

[0133] Based on the target question bank, create an exam track, which is a record of a series of operations and system responses of the examinee interacting with the exam system during the simulated real exam process;

[0134] According to the test track, multiple tests of the test system are simulated in the playback system to obtain the simulation results of each test; the test track is obtained by pre-recording the entire standard test process using traffic playback technology, and the playback system is obtained by replicating the real test environment of the test system;

[0135] When the simulation results of each exam indicate that there is no abnormality in each exam and the exam results are consistent with the preset scores, the historical question bank of the exam system is replaced with the target question bank to upgrade the question bank of the exam system.

[0136] In one embodiment, when the processor 1001 executes the database script sequence stored in the SQL audit platform according to the version number and the change time and obtains the execution result, the processor 1001 specifically performs the following operations:

[0137] Calculate the time range between the current time and the target time;

[0138] From the SQL audit platform, obtain the database scripts that are changed during each version iteration update of the production system within the time range, and obtain a database script sequence. Each data script in the database script sequence carries a script identifier. Each data script in the database script sequence is an operation of adding, modifying, and deleting a table structure.

[0139] According to the script identifier carried by each data script, the corresponding version number and change time are obtained from the pre-established mapping relationship between the script identifier and the version number and change time;

[0140] Based on the version number or change time corresponding to the script identifier carried by each data script, the database script sequence is sorted to ensure that the execution order is consistent with the actual version iteration order;

[0141] Execute the sorted database script sequence to obtain the current database structure DDL;

[0142] The current database structure DDL is used as the execution result.

[0143] In one embodiment, when the processor 1001 generates a mapping relationship between a pre-established script identifier and a version number and a change time, the processor 1001 specifically performs the following operations:

[0144] Through the preset listener, monitor in real time whether new target database scripts are stored in the SQL audit platform;

[0145] When a new target database script is stored in the SQL audit platform, a script identifier of the target database script is created;

[0146] Obtain the version number and change time assigned to the target database script when the production system version is iteratively updated;

[0147] The mapping relationship between the script identifier of the target database script, the version number of the target database script, and the change time is stored.

[0148] In one embodiment, when the processor 1001 verifies whether the execution result is consistent with the actual database structure DDL of the database of the production system, it specifically performs the following operations:

[0149] Use the file reading function in the programming language to open and read the content of the current database structure DDL to obtain the first DDL content;

[0150] Use the file reading function in the programming language to open and read the actual database structure DDL content of the database of the production system to obtain the second DDL content;

[0151] Analyze the data formats of the first DDL content and the second DDL content;

[0152] Based on the data format, the first DDL content and the second DDL content are parsed by a preset parsing library to obtain first parsed data corresponding to the current database structure DDL and second parsed data corresponding to the actual database structure DDL;

[0153] Traversing the object information of each database object in the first parsed data and the second parsed data;

[0154] Based on the object information of each database object, determine whether the execution result is consistent with the actual database structure DDL of the database of the production system.

[0155] In one embodiment, when the processor 1001 performs content parsing processing on the first DDL content and the second DDL content based on the data format by using a preset parsing library, the processor 1001 specifically performs the following operations:

[0156] When the data format is JSON, initialize the json module;

[0157] The basic initialized json module parses the first DDL content and the second DDL content into a data structure in a programming language; or,

[0158] When the data format is XML, initialize the xml.etree.ElementTree module;

[0159] The first DDL content and the second DDL content are parsed into a tree structure based on the initialized xml.etree.ElementTree module.

[0160] In one embodiment, when traversing the object information of each database object in the first parsed data and the second parsed data, the processor 1001 specifically performs the following operations:

[0161] In the case where the first parsed data or the second parsed data is a data structure, traverse each key-value pair in the first parsed data or the second parsed data as the object information of each database object in the first parsed data and the second parsed data, the key of each key-value pair is used to represent the name of the database object, and the value of the key-value pair is used to represent the DDL definition of the database object; or,

[0162] When the first parsed data or the second parsed data is in a tree structure, traverse each database object node in the first parsed data or the second parsed data;

[0163] The node name and attributes of each database object node are obtained as the object information of each database object in the first parsed data and the second parsed data, wherein the node name is used to represent the name of the database object, and the attributes are used to represent the DDL definition of the database object.

[0164] In one embodiment, when the processor 1001 determines whether the execution result is consistent with the actual database structure DDL of the database of the production system based on the object information of each database object, the processor 1001 specifically performs the following operations:

[0165] For each database object in the first parsed data, obtain the first name and the first DDL definition of the database object in the object information;

[0166] For each database object in the second parsed data, obtain the second name and the second DDL definition of the database object in the object information;

[0167] comparing each first name to each second name to determine whether there is a second name that matches each first name;

[0168] If yes, compare each first DDL definition with each second DDL definition to determine whether there is a second DDL definition that matches each first DDL definition;

[0169] If yes, make sure the execution result is consistent with the actual database structure DDL of the production system's database;

[0170] If not, it is determined that the execution result is inconsistent with the actual database structure DDL of the database of the production system.

[0171] In one embodiment, when the processor 1001 creates a test track based on the target question bank, the processor 1001 specifically performs the following operations:

[0172] Obtain at least one test process pre-designed for a target question bank, each test process covering various question types and operations in the target question bank;

[0173] Based on at least one examination process, a series of operations of the examinee interacting with the examination system during the actual examination process are simulated by an automated testing tool;

[0174] Record the system response results of each operation step;

[0175] Store the corresponding relationship between each operation step and the system response result of each operation step;

[0176] Sort the corresponding relationships in chronological order to obtain a sorting result;

[0177] The sorting results are used as the test track.

[0178] In the embodiment of the present application, on the one hand, by counting the total number of version iteration upgrades of the production system corresponding to the current moment and the target moment, and comparing it with the preset number threshold, when the total number of version iteration upgrades of the production system exceeds this threshold, the examination system is centrally upgraded once, reducing the number of iteration upgrades of the examination system. The reduction in the number of upgrades leads to fewer system changes and lower error probability, thereby reducing the risk of system instability caused by frequent upgrades. On the other hand, by obtaining the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade from the current moment for upgrading, and upgrading the database of the examination system at the same time, by centrally processing all version iteration changes of the production system between the current moment and the last upgrade moment of the examination system, the examination system realizes cross-version upgrades. The ability of cross-version upgrades greatly improves the upgrade efficiency and flexibility of the examination system.

[0179] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing the relevant hardware through a computer program, and the program for upgrading the SaaS software examination system across versions can be stored in a computer-readable storage medium, and when the program is executed, it can include the processes of the embodiments of the above-mentioned methods. The storage medium of the program for upgrading the SaaS software examination system across versions can be a disk, an optical disk, a read-only storage memory, or a random access memory, etc.

[0180] The above disclosure is only the preferred embodiment of the present application, which certainly cannot be used to limit the scope of rights of the present application. Therefore, equivalent changes made according to the claims of the present application are still within the scope covered by the present application.

Claims

1. A method for upgrading a test system across versions of SaaS software, characterized in that: The method comprises: Count the total number of version iteration upgrades of the production system corresponding to the current time and the target time, where the target time is the historical time of the last version upgrade of the examination system, the production system is SaaS software, and the examination system is used to simulate the main process of the business functions in the production system; When the total number of times is greater than the preset number threshold, the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade from the current moment are obtained, and the historical application of the examination system is upgraded based on the Jar file and the apk file; In the database of the examination system, a database script sequence stored in the SQL audit platform is executed according to the version number and change time to obtain an execution result, and the execution result is verified to be consistent with the actual database structure DDL of the database of the production system. Each database script in the database script sequence is a database script that is changed in each version iteration update of the production system between the current time and the target time; wherein, The database script sequence stored in the SQL audit platform is executed according to the version number and change time to obtain the execution result, including: Calculate the time range between the current time and the target time; Obtain, from the SQL audit platform, database scripts that are changed during each version iteration update of the production system within the time range, and obtain a database script sequence, wherein each data script in the database script sequence carries a script identifier, and each data script in the database script sequence is an operation of adding, modifying, or deleting a table structure; According to the script identifier carried by each data script, the corresponding version number and change time are obtained from the pre-established mapping relationship between the script identifier and the version number and change time; Based on the version number or change time corresponding to the script identifier carried by each data script, the database script sequence is sorted to ensure that the execution order is consistent with the actual version iteration order; Execute the sorted database script sequence to obtain the current database structure DDL; Use the current database structure DDL as the execution result; If so, all data of the production system database is migrated to the database of the examination system through the Apollo configuration management service to upgrade the database of the examination system.

2. The method according to claim 1, characterized in that The method further comprises: Acquire an updated target question bank from the production system; Based on the target question bank, creating an examination track, wherein the examination track is a record of a series of operations and system responses of the examinee interacting with the examination system during a simulated real examination process; According to the test track, multiple tests of the test system are simulated in the playback system to obtain the simulation results of each test; the test track is obtained by pre-recording the entire standard test process using traffic playback technology, and the playback system is obtained by replicating the real test environment of the test system; When the simulation result of each test indicates that there is no abnormality in each test and the test result is consistent with the preset score, the historical question bank of the test system is replaced with the target question bank to upgrade the question bank of the test system.

3. The method according to claim 1, characterized in that The following steps are used to generate a mapping relationship between a pre-established script identifier and a version number and change time, including: Through a preset listener, monitor in real time whether a new target database script is stored in the SQL audit platform; When a new target database script is stored in the SQL audit platform, a script identifier of the target database script is created; Obtaining the version number and change time assigned to the target database script when the production system version is iteratively updated; A mapping relationship between the script identifier of the target database script, the version number of the target database script, and the change time is stored.

4. The method according to claim 1, characterized in that: The verifying whether the execution result is consistent with the actual database structure DDL of the database of the production system includes: Use a file reading function in a programming language to open and read the content of the current database structure DDL to obtain the first DDL content; Use a file reading function in a programming language to open and read the actual database structure DDL content of the database of the production system to obtain a second DDL content; analyzing data formats of the first DDL content and the second DDL content; Based on the data format, the first DDL content and the second DDL content are subjected to content parsing processing by a preset parsing library to obtain first parsed data corresponding to the current database structure DDL and second parsed data corresponding to the actual database structure DDL; Traversing object information of each database object in the first parsed data and the second parsed data; Based on the object information of each database object, it is determined whether the execution result is consistent with the actual database structure DDL of the database of the production system.

5. The method according to claim 4, characterized in that The preset parsing library includes a JSON parsing library and an XML parsing library, wherein the JSON parsing library is a json module in the Python programming language, and the XML parsing library is an xml.etree.ElementTree module in the Python programming language; The performing content parsing processing on the first DDL content and the second DDL content by using a preset parsing library based on the data format includes: When the data format is JSON format, initialize the json module; The basic initialized json module parses the first DDL content and the second DDL content into a data structure in a programming language; or, When the data format is XML format, initializing the xml.etree.ElementTree module; The first DDL content and the second DDL content are parsed into a tree structure based on the initialized xml.etree.ElementTree module.

6. The method according to claim 5, characterized in that The traversing the object information of each database object in the first parsed data and the second parsed data includes: In the case where the first parsed data or the second parsed data is the data structure, traversing each key-value pair in the first parsed data or the second parsed data as object information of each database object in the first parsed data and the second parsed data, the key of each key-value pair is used to represent the name of the database object, and the value of the key-value pair is used to represent the DDL definition of the database object; or When the first parsed data or the second parsed data is in the tree structure, traverse each database object node in the first parsed data or the second parsed data; The node name and attributes of each database object node are obtained as the object information of each database object in the first parsed data and the second parsed data, wherein the node name is used to represent the name of the database object, and the attributes are used to represent the DDL definition of the database object.

7. The method according to claim 4, characterized in that The determining, based on the object information of each database object, whether the execution result is consistent with the actual database structure DDL of the database of the production system includes: For each database object in the first parsed data, obtain the first name and the first DDL definition of the database object in the object information; For each database object in the second parsed data, obtain a second name and a second DDL definition of the database object in the object information; comparing each first name to each second name to determine whether there is a second name that matches each first name; If yes, compare each first DDL definition with each second DDL definition to determine whether there is a second DDL definition matching each first DDL definition; If yes, determining that the execution result is consistent with the actual database structure DDL of the database of the production system; If not, it is determined that the execution result is inconsistent with the actual database structure DDL of the database of the production system.

8. The method according to claim 2, characterized in that: The step of creating an examination track based on the target question bank includes: Obtaining at least one test process pre-designed for the target question bank, each test process covering various question types and operations in the target question bank; Based on the at least one examination process, simulating a series of operations of the examinee interacting with the examination system during the actual examination process through an automated testing tool; Record the system response results of each operation step; Store the corresponding relationship between each operation step and the system response result of each operation step; Sorting the corresponding relationships in chronological order to obtain a sorting result; The sorting result is used as the test track.

9. A cross-version upgrade system for an examination system of SaaS software implemented by the method described in any one of claims 1 to 8, characterized in that: The system comprises: A statistics module, used to count the total number of version iteration upgrades of the production system corresponding to the current time and the target time, wherein the target time is the historical time of the last version upgrade of the examination system, the production system is SaaS software, and the examination system is used to simulate the main process of the business function in the production system; An online release module, used for obtaining the latest Jar file and apk file corresponding to the production system in the most recent version iteration upgrade when the total number of times is greater than a preset number threshold, and upgrading the historical application of the examination system based on the Jar file and the apk file; An execution module is used to execute a database script sequence stored in the SQL audit platform in the database of the examination system according to the version number and the change time, obtain an execution result, and verify whether the execution result is consistent with the actual database structure DDL of the database of the production system, wherein each database script in the database script sequence is a database script that is changed in each version iteration update of the production system between the current moment and the target moment; The migration module is used to migrate all the data of the production system database to the database of the examination system through the Apollo configuration management service to upgrade the database of the examination system.

Citation Information

Patent Citations

  • Software upgrading method and device, electronic equipment and readable storage medium

    CN113741931A

  • Database script management and control method, system and device, storage medium and program product

    CN115408111A