WO2018233037A1 - 数据库集成测试方法、装置、服务器及存储介质 - Google Patents
数据库集成测试方法、装置、服务器及存储介质 Download PDFInfo
- Publication number
- WO2018233037A1 WO2018233037A1 PCT/CN2017/099736 CN2017099736W WO2018233037A1 WO 2018233037 A1 WO2018233037 A1 WO 2018233037A1 CN 2017099736 W CN2017099736 W CN 2017099736W WO 2018233037 A1 WO2018233037 A1 WO 2018233037A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- script
- database
- execution
- baseline
- file
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3688—Test management for test execution, e.g. scheduling of test suites
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
Definitions
- the present invention relates to the field of database integration technologies, and in particular, to a database integration test method, apparatus, server, and storage medium.
- a database integration test method, apparatus, server, and storage medium are provided.
- a database integration testing method comprising the following steps:
- the execution script file is extracted from the new version database file, and the execution script in the execution script file is deployed on the current database after data replacement, and the execution script is executed after the deployment is completed.
- a database integration testing device comprising:
- a file receiving module configured to receive a new version of the database file
- a baseline data search module configured to acquire baseline database information corresponding to the new version database file, and search for database baseline data corresponding to the new version database file according to the baseline database information;
- a data replacement module for replacing data in the current database with the database baseline data
- a script deployment running module configured to extract an execution script file from the new version database file, deploy the execution script in the execution script file on the current database after data replacement, and run the execution after deployment is completed script.
- a server includes a memory and a processor, the memory storing instructions that, when executed by the processor, cause the processor to perform the following steps:
- Extracting a new version execution script file from the new version database file extracting a new version execution script file from the new version database file, deploying the new version execution script file according to a preset rule on the current database, and running the new version execution script file after the deployment is completed.
- One or more non-volatile readable storage media storing computer-executable instructions, the computer-executable instructions being executed by one or more processors, such that the one or more processors perform the steps of:
- Extracting a new version execution script file from the new version database file extracting a new version execution script file from the new version database file, deploying the new version execution script file according to a preset rule on the current database, and running the new version execution script file after the deployment is completed.
- FIG. 1 is an application environment diagram of a database integration test method in an embodiment
- FIG. 2 is a schematic diagram showing the internal structure of a computer device in an embodiment
- FIG. 3 is a flow chart of a database integration test method in an embodiment
- FIG. 5 is a flow chart of a database integration test method in still another embodiment
- FIG. 6 is a schematic structural diagram of a database integration testing device in an embodiment
- FIG. 7 is a schematic structural diagram of a database integration test apparatus in another embodiment
- FIG. 8 is a schematic structural diagram of a database integration test apparatus in still another embodiment
- FIG. 9 is a schematic structural diagram of a database integration test apparatus in still another embodiment.
- server 102 is coupled to production server 104 via a corresponding network.
- Server 102 can receive a new version of the database file sent by production server 104.
- the production server 104 is used to develop a production database, or to update the version of the database of the old version, and the production server 104 sends the relevant file of the developed new version database to the server 102 for testing.
- the new version of the database file includes the data and files necessary for building the database, such as database basic data, object data, and execution script files.
- the server 102 obtains the baseline database information corresponding to the new version database file, searches the database baseline data corresponding to the new version database file according to the baseline database information, replaces the data in the current database with the database baseline data, and extracts and executes the data from the new version database file.
- the script file is used to deploy the execution script in the execution script file on the current database after the data is replaced. After the deployment is completed, the execution script is executed to implement the database rapid integration test.
- the server includes a processor, memory, and network interface connected by a system bus.
- the processor is used to provide computing and control capabilities to support the operation of the entire server.
- the memory is used to store data, instruction code, etc., store baseline database information for all version baseline databases, and database baseline data for each baseline database.
- the network interface is used for external production servers and servers to communicate via a network connection.
- At least one computer executable instruction is stored on the memory, the computer executable instructions being executable by the processor to implement the database integration test method provided in various embodiments of the present application.
- Memory can include disk, CD, read-only memory (Read-Only) A nonvolatile storage medium such as a memory or a ROM, or a random storage memory (Random-Access-Memory, RAM).
- the memory includes a non-volatile storage medium and an internal memory.
- the server's non-volatile storage medium stores operating system, database, and computer executable instructions.
- the database stores data relating to a database integration test method provided by the various embodiments described below.
- the computer executable instructions are executable by a processor for implementing a database integration testing method as provided by various embodiments described below.
- the internal memory in the terminal provides a cached operating environment for operating systems, databases, and computer executable instructions in a non-volatile storage medium.
- FIG. 2 is only a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on the server to which the solution of the present application is applied.
- the specific server may include a ratio. More or fewer components are shown in the figures, or some components are combined, or have different component arrangements.
- a database integration test method is provided. This embodiment is applied to the environment shown in FIG. 1 by the method, and is applied to the server shown in FIG. 2 for illustration.
- the database integration test method includes the following steps:
- Step 310 receiving a new version database file.
- the server receives the new version of the database file submitted from the database production environment.
- the new version of the database file includes the database basic data, object data, and execution script files, etc., and the data and files necessary to build the database.
- the new version of the database in different versions in this embodiment is developed and produced based on the same basic version database, for example, the new version database may be V1.1 version, V1.2 version, V1.3 version, etc. They are all developed based on the V1.0 base version database.
- the new version database refers to the database that needs to be tested.
- the new version database file may be the database file that needs to be tested for the first time, or may be abnormal after the test script, and the developer may correct and re- Submitted database file.
- Step 320 Obtain baseline database information corresponding to the new version database file, and search database baseline data corresponding to the new version database file according to the baseline database information.
- the database files of all the base version databases are stored in the server.
- the server can find the basic version database information based on the new version database according to the new version database information, and the database information can be the database name or the database version number, etc., so that the stored basic version database file can be found according to the basic version database information, from the basic
- the database baseline data extracted to the underlying version database is extracted from the version database file.
- the database baseline data includes the structure data of the database and other basic data, basic scripts, but does not include specific database object content data and execution script files of the new version of the database.
- step 330 the data in the current database is replaced with database baseline data.
- the current database refers to the database in the server's test environment that is being tested or waiting to be tested, and the current database and the new version database are developed based on the same underlying database.
- the server stops the current database operation through the database command.
- the server replaces the data summarized by the current database with the database baseline data of the base database, so as to roll back the data in the current test environment to the baseline data.
- the server restarts the database with a database command.
- Step 340 Extract the execution script file from the new version database file, deploy the execution script in the execution script file on the current database after the data replacement, and run the execution script after the deployment is completed.
- the server extracts the execution script file from the obtained new version database file.
- the execution script file contains multiple execution scripts, and the multiple execution scripts are all the scripts to be deployed and executed in the new version database.
- the execution script is a database SQL script, and the execution script can also be a script of other formats.
- the server extracts the script files one by one from the execution script file according to the preset rules, and deploys the extracted script files in the current database that has been rolled back to the baseline state. After all the execution scripts are deployed, the server is in the test environment. Build a complete new version of the database, after the database is built, the server starts running the execution script and monitors the running results in real time.
- the server when receiving the new version database file submitted by the production environment and needing to be tested, the server obtains the baseline database information corresponding to the new version database file, and searches for the corresponding database baseline data corresponding to the storage, and the current The data in the database that completed the test is replaced with the found database baseline data to roll back the data in the current database to the baseline state, without having to build the database from scratch, and extract and automatically deploy new from the new version database file according to the preset rules.
- the version of the execution script file requires less scripts to be deployed, which improves the efficiency of the new version of the database build work and the database execution script deployment work, and reduces the execution time of the script and improves the test efficiency due to the small amount of scripts.
- the database integration test method further includes the following steps:
- Step 350 Generate a baseline structure library according to the database structure data in the current database.
- the new version database can go online through the test.
- the server receives the baseline database build instruction, it indicates that the new version of the database needs to be used as the base database, so that the subsequently developed database is designed and developed based on this library.
- the server After the server obtains the baseline database build instruction, it constructs an empty database and copies the database structure data in the current database to the constructed empty database to generate a baseline structure library.
- Step 360 Obtain a baseline data list, extract basic data from the current database according to the baseline data list, and back up the basic data, and import the backed basic data into the baseline structure library to generate a baseline database.
- the server obtains a baseline data list of the new version database, which may be submitted by the developer or pre-stored on the server.
- the server matches the data names listed in the baseline data list with the data in the current database and extracts the successfully matched data from the current database.
- the extracted basic data is backed up and named with the name or version number of the new database, so as to be the database baseline data of several new versions developed in the future.
- the server imports the backed up basic data into the created baseline structure library to generate a baseline database.
- the new version database can deploy the script file to be executed on the baseline database to build the new version database.
- the baseline database is verified by the developer and can be put into use or released after verification.
- the server performs compression processing on the extracted basic data, and performs backup processing after the compression processing. It can be compressed by reducing the table space, deleting unnecessary data, and so on. It can reduce the time of data backup and copying, and improve the efficiency of database construction.
- the server may extract the structural data and the basic data to build the baseline structure library from the current database according to the baseline database construction instruction, so that the current structural library can be used as a new development version in the future.
- the basis of the database Therefore, when the developer wants to build the baseline database according to the needs of the production work, the server can quickly and easily build the baseline database and back up and store the basic data by the method in the embodiment, and the operation is simple. And because the deployment of the baseline database has fewer deployment scripts, it also facilitates the maintenance of the later multi-version database and saves manpower.
- the step of deploying the execution script in the new version execution script file in step 140 on the current database after data replacement includes:
- the script name is read from the first configuration table, the name of the read script is matched with the name of the execution script, and the matching execution script is deployed in the current database;
- the execution script is classified, the executed execution scripts are sorted, and the sorted execution scripts are deployed in the current database.
- the first configuration table may be pre-stored locally on the server, or may be saved in a new version database file, and the server obtains the first configuration table.
- the first configuration table is a script execution order configuration table.
- the first configuration table lists the names of all execution scripts and specifies the order in which all execution scripts are deployed. All execution scripts of the database are uniformly named according to the standard naming standard. The name of the execution script includes the type information of the script, the execution function information, and the sequence code.
- the server reads the execution script name in order from the first configuration table, and matches the read script name with the script name in the execution script file. When the matching is successful, the matching succeeds is extracted from the execution script file. Execute the script and deploy the matching execution scripts in the order in which the script names are read in the current database that has been replaced by the data until all execution scripts are deployed. When the execution script name read from the first configuration table does not match the corresponding execution script in the execution script file, the execution script name is skipped and the execution of the next execution script name is continued.
- the server When the server cannot find the first configuration table from the local or new version database file, the server obtains a preset script classification sort table.
- the terminal classifies the execution script according to the script type information in the execution script name. For example, the first two letters of the names of the scripts of different classifications are different, such as the beginning of the SR is a class, the beginning of the SQ is a class, and the beginning of the SD For another class, etc.
- the execution scripts in each category are sorted according to the number from large to small or from small to large according to the sequence number of the execution script.
- the server After the execution scripts in all categories are sorted, the server obtains the sort order of the script categories in the script sorting table.
- the script at the beginning of SR precedes the script at the beginning of SQ
- the script at the beginning of SQ precedes the script at the beginning of SD.
- the server sorts the execution scripts between different categories according to the sort order of the script sorting table, and finally deploys the sorted execution scripts in the current database.
- the execution script information is included in the script name of the execution script.
- the server extracts the execution user information from the name of the execution script, and compares the two from the user information of the local execution user. If the user information is consistent, the following deployment operations are continued. When the user information is inconsistent, the operation permission reminder is performed, and the current operation is interrupted. Thereby, the operation authority of the execution user can be set to avoid malicious operations by unauthorized persons.
- the server by setting the first configuration table in advance, the server performs name matching according to the script name in the configuration table and the script in the execution script file, and automatically deploys the successfully matched scripts in the current database according to the order in the table.
- the execution script can be sorted by obtaining the script classification sorting table, thereby implementing the automatic deployment of the execution script in the new version database, without manual manual deployment, and improving the deployment work. Work efficiency and save manpower.
- step 140 the following steps are further included:
- Step 370 Obtain a second configuration table, where the second configuration table includes an abnormal keyword.
- the server obtains a pre-stored second configuration table, and the second configuration table includes all abnormal keywords that may appear in all abnormal execution results, such as "SP2-", “CPY-”, “ORA-”, and "Warning". Word, from the exception keyword can determine the specific reason for the execution of the script to run an exception. When these keywords appear in the run script for these execution scripts, it indicates that the execution of the script is abnormal.
- step 380 the running result of the execution script is monitored, and it is determined whether the abnormal keyword is included in the running result.
- the new version database is completed, and the server starts running the execution script of the deployment and monitors the running result of the execution script in real time. After the execution of each execution script, the server obtains the running result, reads the exception keyword in the second configuration table one by one, and matches the obtained running result to determine whether the abnormal keyword is included in the running result.
- Step 390 Obtain a script name of the execution script corresponding to the running result, generate an operation abnormality alarm according to the abnormal keyword and the script name, and send the abnormality alarm to the monitoring terminal.
- the server determines that the running result contains any abnormal keyword in the second configuration table, it indicates that the execution of the script is abnormal, the server obtains the script name of the execution script that runs abnormally, and according to the abnormal keyword included in the running result. And the script name generates a running abnormal alarm, and the server obtains the contact information of the monitoring terminal, the contact information may be a terminal address, a mailbox information, etc., and the server sends an abnormal operation alarm to the monitoring terminal through the contact information, so that the monitoring personnel can obtain the execution of the abnormal operation. The information of the script and the reason for the abnormal operation. When the exception result is not included in the running result, no processing is performed.
- the server can perform an abnormality alarm notification in real time, that is, during the execution of the execution script, as long as one execution script is abnormally monitored, an exception alarm is generated according to the execution script and the running result. And send it to the monitoring terminal in time.
- an abnormality alarm notification in real time, that is, during the execution of the execution script, as long as one execution script is abnormally monitored, an exception alarm is generated according to the execution script and the running result. And send it to the monitoring terminal in time.
- the server detects that there is an abnormal running result
- the execution script and the corresponding running result of the abnormality are recorded, and after all the scripts are executed, all the abnormal results recorded are summarized.
- a running abnormality alarm is generated, and the summarized running abnormality alarm is sent to the monitoring terminal.
- the server can automatically perform the matching of the abnormal keyword in the monitored running result and determine whether the execution result of the execution script is abnormal, without manual verification, and
- the abnormal result generation operation abnormality alarm is sent to the monitoring terminal, so that the monitoring terminal clearly knows which execution scripts of the abnormality occur according to the running abnormality alarm, and is convenient for the developer to correct the database script according to the running abnormality alarm.
- the database integration test method further includes the steps of: monitoring a single script running time of executing the script; determining whether the single script running time exceeds a preset single script running time threshold; if yes, executing the script name and running of the script The time is recorded and added to the abnormal alarm; the total running time of the execution script is detected, and it is judged whether the total running time exceeds the preset running time threshold; if yes, the running of the executing script is interrupted and a running timeout alarm is sent to the monitoring terminal.
- the server obtains a preset single script runtime threshold and a preset script total runtime threshold.
- the server monitors the running time of each script's single script and records the running time of each script. After an execution script is completed, the terminal obtains the running time of the script, and compares the running time of the script with the preset single script running time threshold. When the running time of the script exceeds the preset single script running time threshold, The server gets the script name of the script and adds the script's script name and runtime record to the exception alert, so that the monitor can keep track of the running time of the single script.
- the server also performs monitoring of the total running time of the execution script. After each execution script is completed, the server superimposes the running time of the execution script and the running time of the executed execution script, and judges the total of the superimposed execution. Whether the running time exceeds the preset running time threshold of the script. When the total running time does not exceed the preset running time threshold, continue to run the next execution script. When the total running time exceeds the preset running time threshold, the server is interrupted. Run the script to generate a run timeout alert and send a run timeout alert to the monitoring terminal.
- the server monitors the running time of the single script and records the running time of the single script in the abnormal alarm, so that the monitoring developer can obtain the running time of each script, so that the developer can find the running time. Execute scripts that take too long to run and optimize. By monitoring the total running time of the deployment script, the server can interrupt the running of the script when the running time exceeds the threshold, and avoid the waste of test resources caused by the abnormal situation such as the infinite loop of the script.
- a virtual machine is set up on the server, the current database is installed on the virtual machine, the database environment is set up on the virtual machine, the script is deployed, and the execution of the script is performed.
- the new version database is developed on the host, the new version database file is submitted from the host to the virtual machine.
- the database integration test workflow starts.
- the trigger can be built on the virtual machine, and the trigger mode is set to trigger the database integration test workflow when a new database file is submitted.
- multiple virtual machines can be set up on the server.
- multiple versions of the developed database need to be tested at the same time, multiple versions of the database can be installed on different virtual machines. Synchronous testing, separate database environment construction on each virtual machine, to achieve concurrent testing of multi-version database, improve the efficiency of testing work.
- a database integration testing device which can be run on a server, including: a file receiving module 610, a baseline data lookup module 620, a data replacement module 630, and script deployment. Run module 640. among them:
- the file receiving module 610 is configured to receive a new version database file.
- the baseline data searching module 620 is configured to obtain baseline database information corresponding to the new version database file, and search the database baseline data corresponding to the new version database file according to the baseline database information.
- the data replacement module 630 is configured to replace data in the current database with database baseline data.
- the script deployment running module 640 is configured to extract an execution script file from the new version database file, deploy the execution script in the execution script file on the current database after the data is replaced, and execute the execution script after the deployment is completed.
- the apparatus further includes:
- the structure library generating module 650 is configured to generate a baseline structure library according to the database structure data in the current database.
- the baseline library generating module 660 is configured to obtain a baseline data list, extract basic data from the current database according to the baseline data list, and back up the basic data, and import the backed up basic data into the baseline structure library to generate a baseline database.
- the script deployment run module 640 includes:
- Matching the deployment module when the first configuration table is found, the script name is read from the first configuration table, the name of the read script is matched with the name of the execution script, and the matching execution script is deployed in the current database. in.
- the sorting deployment module is configured to classify the execution scripts when the first configuration table is not found, sort the executed execution scripts, and deploy the sorted execution scripts in the current database.
- the device further includes:
- the configuration table obtaining module 670 is configured to obtain a second configuration table, where the second configuration table includes an abnormal keyword.
- the result detecting module 680 is configured to monitor a running result of the execution script, and determine whether the abnormal keyword is included in the running result.
- the abnormality alarm sending module 690 is configured to acquire a script name of the execution script corresponding to the operation result, generate an operation abnormality alarm according to the abnormal keyword and the script name, and send the abnormality alarm to the monitoring terminal.
- the device further includes:
- a single script time monitoring module 691 configured to monitor a single script running time of the execution script
- the single script time judging module 693 is configured to determine whether the single script running time exceeds a preset single script running time threshold
- a time recording module 695 configured to record and add a script name and a running time of the execution script to the abnormal alarm
- the total time detecting module 697 is configured to detect a total running time of the execution script, and determine whether the total running time exceeds a preset running time threshold of the script;
- the timeout alarm sending module 699 is configured to interrupt the running of the execution script and send a running timeout alarm to the monitoring terminal.
- the various modules in the database integration test device described above may be implemented in whole or in part by software, hardware, and combinations thereof.
- the network interface may be an Ethernet card or a wireless network card.
- the above modules may be embedded in the hardware in the terminal or in the memory in the terminal, or may be stored in the memory in the terminal in a software form, so that the processor calls the execution of the operations corresponding to the above modules.
- the processor can be a central processing unit (CPU), a microprocessor, a microcontroller, or the like.
- the storage medium may be a magnetic disk, an optical disk, or a read-only storage memory (Read-Only) Memory, ROM), etc.
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
- Debugging And Monitoring (AREA)
Abstract
Description
Claims (20)
- 一种数据库集成测试方法,包括:接收新版本数据库文件;获取所述新版本数据库文件对应的基线数据库信息,根据所述基线数据库信息查找所述新版本数据库文件对应的数据库基线数据;将当前数据库中的数据替换为所述数据库基线数据;及从所述新版本数据库文件中抽取执行脚本文件,将所述执行脚本文件中的执行脚本部署在经过数据替换后的所述当前数据库上,部署完成后运行所述执行脚本。
- 根据权利要求1所述的方法,其特征在于,在所述部署完成后运行所述执行脚本之后,所述方法还包括:根据所述当前数据库中的数据库结构数据生成基线结构库;及获取基线数据列表,根据所述基线数据列表从所述当前数据库中抽取基本数据并对所述基本数据进行备份,将备份后的基本数据导入所述基线结构库,生成基线数据库。
- 根据权利要求1所述的方法,其特征在于,所述将所述新版本执行脚本文件中的执行脚本部署在经过数据替换后的所述当前数据库上,包括:当查找到第一配置表时,从所述第一配置表中读取脚本名称,将读取到的脚本名称与所述执行脚本进行名称匹配,将匹配成功的执行脚本部署在所述当前数据库中;及当查找不到第一配置表时,对所述执行脚本进行归类,将归类后的执行脚本进行排序,将排序后的执行脚本部署在所述当前数据库中。
- 根据权利要求1所述的方法,其特征在于,所述部署完成后运行所述执行脚本之后,所述方法还包括:获取第二配置表,所述第二配置表中包括异常关键字;监测所述执行脚本的运行结果,判断所述运行结果中是否包含异常关键字;若是,则获取所述运行结果对应的执行脚本的脚本名称,根据所述异常关键字和所述脚本名称生成运行异常警报,将所述异常警报发送至监控终端。
- 根据权利要求4所述的数据库集成测试方法,其特征在于,所述部署完成后运行所述执行脚本之后,所述方法还包括:监测所述执行脚本的单脚本运行时间;判断所述单脚本运行时间是否超过预设单脚本运行时间阈值;若是,则将所述执行脚本的脚本名称和运行时间进行记录并添加至所述异常警报中;及检测所述执行脚本的总运行时间,判断所述总运行时间是否超过预设脚本总运行时间阈值;若是,则中断所述执行脚本的运行并向所述监控终端发送运行超时警报。
- 一种数据库集成测试装置,包括:文件接收模块,用于接收新版本数据库文件;基线数据查找模块,用于获取所述新版本数据库文件对应的基线数据库信息,根据所述基线数据库信息查找所述新版本数据库文件对应的数据库基线数据;数据替换模块,用于将当前数据库中的数据替换为所述数据库基线数据;及脚本部署运行模块,用于从所述新版本数据库文件中抽取执行脚本文件,将所述执行脚本文件中的执行脚本部署在经过数据替换后的所述当前数据库上,部署完成后运行所述执行脚本。
- 根据权利要求6所述的装置,其特征在于,所述装置还包括:结构库生成模块,用于根据所述当前数据库中的数据库结构数据生成基线结构库;基线库生成模块,用于获取基线数据列表,根据所述基线数据列表从所述当前数据库中抽取基本数据并对所述基本数据进行备份,将备份后的基本数据导入所述基线结构库,生成基线数据库。
- 根据权利要求6所述的装置,其特征在于,所述脚本部署运行模块还包括:匹配部署模块,用于当查找到第一配置表时,从所述第一配置表中读取脚本名称,将读取到的脚本名称与所述执行脚本进行名称匹配,将匹配成功的执行脚本部署在所述当前数据库中;排序部署模块,用于当查找不到第一配置表时,对所述执行脚本进行归类,将归类后的执行脚本进行排序,将排序后的执行脚本部署在所述当前数据库中。
- 根据权利要求6所述的装置,其特征在于,所述装置还包括:配置表获取模块,用于获取第二配置表,所述第二配置表中包括异常关键字;运行监测模块,用于监测所述执行脚本的运行结果,判断所述运行结果中是否包含异常关键字;警报生成模块,用于获取所述运行结果对应的执行脚本的脚本名称,根据所述异常关键字和所述脚本名称生成运行异常警报,将所述异常警报发送至监控终端。
- 根据权利要求9所述的装置,其特征在于,所述装置还包括:时间监测模块,用于监测所述执行脚本的单脚本运行时间;时间阈值判断模块,用于判断所述单脚本运行时间是否超过预设单脚本运行时间阈值;时间记录模块,用于将所述执行脚本的脚本名称和运行时间进行记录并添加至所述异常警报中;及总时间监测模块,用于检测所述执行脚本的总运行时间,判断所述总运行时间是否超过预设脚本总运行时间阈值;警报发送模块,用于中断所述执行脚本的运行并向所述监控终端发送运行超时警报。
- 一种服务器,包括存储器和处理器,所述存储器中存储有指令,所述指令被所述处理器执行时,使得所述处理器执行以下步骤:接收新版本数据库文件;获取所述新版本数据库文件对应的基线数据库信息,根据所述基线数据库信息查找所述新版本数据库文件对应的数据库基线数据;将当前数据库中的数据替换为所述数据库基线数据;从所述新版本数据库文件中抽取新版本执行脚本文件,将所述新版本执行脚本文件根据预设规则部署在所述当前数据库上,部署完成后运行所述新版本执行脚本文件。
- 根据权利要求11所述的服务器,其特征在于,在所述部署完成后运行所述执行脚本之后,还包括执行以下步骤:根据所述当前数据库中的数据库结构数据生成基线结构库;及获取基线数据列表,根据所述基线数据列表从所述当前数据库中抽取基本数据并对所述基本数据进行备份,将备份后的基本数据导入所述基线结构库,生成基线数据库。
- 根据权利要求11所述的服务器,其特征在于,所述将所述新版本执行脚本文件中的执行脚本部署在经过数据替换后的所述当前数据库上,还包括执行以下步骤:当查找到第一配置表时,从所述第一配置表中读取脚本名称,将读取到的脚本名称与所述执行脚本进行名称匹配,将匹配成功的执行脚本部署在所述当前数据库中;及当查找不到第一配置表时,对所述执行脚本进行归类,将归类后的执行脚本进行排序,将排序后的执行脚本部署在所述当前数据库中。
- 根据权利要求11所述的服务器,其特征在于,所述部署完成后运行所述执行脚本之后,还包括执行以下步骤:获取第二配置表,所述第二配置表中包括异常关键字;监测所述执行脚本的运行结果,判断所述运行结果中是否包含异常关键字;若是,则获取所述运行结果对应的执行脚本的脚本名称,根据所述异常关键字和所述脚本名称生成运行异常警报,将所述异常警报发送至监控终端。
- 根据权利要求14所述的服务器,其特征在于,所述部署完成后运行所述执行脚本之后,还包括执行以下步骤:监测所述执行脚本的单脚本运行时间;判断所述单脚本运行时间是否超过预设单脚本运行时间阈值;若是,则将所述执行脚本的脚本名称和运行时间进行记录并添加至所述异常警报中;及检测所述执行脚本的总运行时间,判断所述总运行时间是否超过预设脚本总运行时间阈值;若是,则中断所述执行脚本的运行并向所述监控终端发送运行超时警报。
- 一个或多个存储有计算机可执行指令的非易失性可读存储介质,所述计算机可执行指令被一个或多个处理器执行,使得所述一个或多个处理器执行以下步骤:接收新版本数据库文件;获取所述新版本数据库文件对应的基线数据库信息,根据所述基线数据库信息查找所述新版本数据库文件对应的数据库基线数据;将当前数据库中的数据替换为所述数据库基线数据;从所述新版本数据库文件中抽取新版本执行脚本文件,将所述新版本执行脚本文件根据预设规则部署在所述当前数据库上,部署完成后运行所述新版本执行脚本文件。
- 根据权利要求16所述的存储介质,其特征在于,在所述部署完成后运行所述执行脚本之后,还包括执行以下步骤:根据所述当前数据库中的数据库结构数据生成基线结构库;及获取基线数据列表,根据所述基线数据列表从所述当前数据库中抽取基本数据并对所述基本数据进行备份,将备份后的基本数据导入所述基线结构库,生成基线数据库。
- 根据权利要求16所述的存储介质,其特征在于,所述将所述新版本执行脚本文件中的执行脚本部署在经过数据替换后的所述当前数据库上,还包括执行以下步骤:当查找到第一配置表时,从所述第一配置表中读取脚本名称,将读取到的脚本名称与所述执行脚本进行名称匹配,将匹配成功的执行脚本部署在所述当前数据库中;及当查找不到第一配置表时,对所述执行脚本进行归类,将归类后的执行脚本进行排序,将排序后的执行脚本部署在所述当前数据库中。
- 根据权利要求16所述的存储介质,其特征在于,所述部署完成后运行所述执行脚本之后,还包括执行以下步骤:获取第二配置表,所述第二配置表中包括异常关键字;监测所述执行脚本的运行结果,判断所述运行结果中是否包含异常关键字;若是,则获取所述运行结果对应的执行脚本的脚本名称,根据所述异常关键字和所述脚本名称生成运行异常警报,将所述异常警报发送至监控终端。
- 根据权利要求19所述的存储介质,其特征在于,所述部署完成后运行所述执行脚本之后,还包括执行以下步骤:监测所述执行脚本的单脚本运行时间;判断所述单脚本运行时间是否超过预设单脚本运行时间阈值;若是,则将所述执行脚本的脚本名称和运行时间进行记录并添加至所述异常警报中;及检测所述执行脚本的总运行时间,判断所述总运行时间是否超过预设脚本总运行时间阈值;若是,则中断所述执行脚本的运行并向所述监控终端发送运行超时警报。
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP2019563048A JP6799695B2 (ja) | 2017-06-20 | 2017-08-30 | データベースの統合テスト方法、装置、サーバ、および記録媒体 |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710470644.0 | 2017-06-20 | ||
CN201710470644.0A CN107688531B (zh) | 2017-06-20 | 2017-06-20 | 数据库集成测试方法、装置、计算机设备及存储介质 |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2018233037A1 true WO2018233037A1 (zh) | 2018-12-27 |
Family
ID=61152694
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/CN2017/099736 WO2018233037A1 (zh) | 2017-06-20 | 2017-08-30 | 数据库集成测试方法、装置、服务器及存储介质 |
Country Status (3)
Country | Link |
---|---|
JP (1) | JP6799695B2 (zh) |
CN (1) | CN107688531B (zh) |
WO (1) | WO2018233037A1 (zh) |
Cited By (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110457300A (zh) * | 2019-07-15 | 2019-11-15 | 中国平安人寿保险股份有限公司 | 一种公共测试库的清理方法及装置、电子设备 |
CN111522719A (zh) * | 2020-04-27 | 2020-08-11 | 中国银行股份有限公司 | 大数据任务状态的监控方法及装置 |
CN111651364A (zh) * | 2020-07-01 | 2020-09-11 | 中国银行股份有限公司 | 并行开发下的sql检查方法及装置 |
CN111857752A (zh) * | 2020-07-22 | 2020-10-30 | 浪潮商用机器有限公司 | 一种PostgreSQL数据库安装方法、装置及设备 |
JP2021047806A (ja) * | 2019-09-20 | 2021-03-25 | 富士通株式会社 | 情報処理システム、情報処理装置および情報処理プログラム |
CN113138974A (zh) * | 2021-04-23 | 2021-07-20 | 建信金融科技有限责任公司 | 数据库合规检测的方法和装置 |
CN113297028A (zh) * | 2021-03-18 | 2021-08-24 | 中国平安人寿保险股份有限公司 | 一种脚本执行方法、装置、计算机设备及存储介质 |
CN114625630A (zh) * | 2020-12-14 | 2022-06-14 | 福建天泉教育科技有限公司 | 一种多环境多角色版本发布系统的测试方法及其测试系统 |
CN115757055A (zh) * | 2022-10-19 | 2023-03-07 | 北京新数科技有限公司 | 一种基于Spring Cloud的数据库统一运维及综合性能评分系统 |
Families Citing this family (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108804327A (zh) * | 2018-06-12 | 2018-11-13 | 北京京东金融科技控股有限公司 | 一种自动生成测试数据的方法和装置 |
CN108984408B (zh) * | 2018-07-13 | 2021-11-30 | 中国银行股份有限公司 | 一种应用系统中sql代码的检测方法和装置 |
CN109508356B (zh) * | 2018-11-14 | 2024-05-03 | 平安科技(深圳)有限公司 | 数据异常预警方法、装置、计算机设备及存储介质 |
CN109766124B (zh) * | 2018-12-26 | 2022-05-03 | 深圳左邻永佳科技有限公司 | 业务开发方法、装置、计算机设备和存储介质 |
CN111858352B (zh) * | 2020-07-22 | 2024-04-05 | 中国平安财产保险股份有限公司 | 自动化测试监控的方法、装置、设备及存储介质 |
CN112965905B (zh) * | 2021-03-11 | 2024-06-18 | 京东科技信息技术有限公司 | 数据测试方法、装置、设备及存储介质 |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102289460A (zh) * | 2011-07-13 | 2011-12-21 | 中国工商银行股份有限公司 | 一种向测试环境进行报表元数据同步的方法及系统 |
CN103020149A (zh) * | 2012-11-22 | 2013-04-03 | 用友软件股份有限公司 | 共享数据更新装置和共享数据更新方法 |
CN104572644A (zh) * | 2013-10-10 | 2015-04-29 | 北京大学 | 数据库更新装置和数据库更新方法 |
WO2016015220A1 (en) * | 2014-07-29 | 2016-02-04 | Hewlett-Packard Development Company, L.P. | Executable code abnormality detection |
CN105512017A (zh) * | 2014-09-22 | 2016-04-20 | 阿里巴巴集团控股有限公司 | 一种数据库兼容性检测方法及设备 |
Family Cites Families (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8078655B2 (en) * | 2008-06-04 | 2011-12-13 | Microsoft Corporation | Generation of database deltas and restoration |
CN202121621U (zh) * | 2011-07-13 | 2012-01-18 | 中国工商银行股份有限公司 | 一种向测试环境进行报表元数据同步的系统 |
CN102722436B (zh) * | 2012-05-29 | 2016-03-02 | 百度在线网络技术(北京)有限公司 | 一种增量覆盖信息的统计方法和装置 |
US9659040B1 (en) * | 2013-09-23 | 2017-05-23 | Amazon Technologies, Inc. | Database fleet schema maintenance |
CN105302710B (zh) * | 2014-07-03 | 2019-06-07 | 腾讯科技(深圳)有限公司 | 一种确定需要回归测试的测试用例的方法和装置 |
US9811444B2 (en) * | 2015-08-04 | 2017-11-07 | Salesforce.Com, Inc. | Testing software enhancements in database applications |
CN106445795B (zh) * | 2016-09-26 | 2019-03-22 | 中国工商银行股份有限公司 | 一种数据库sql效率检测方法及装置 |
-
2017
- 2017-06-20 CN CN201710470644.0A patent/CN107688531B/zh active Active
- 2017-08-30 WO PCT/CN2017/099736 patent/WO2018233037A1/zh active Application Filing
- 2017-08-30 JP JP2019563048A patent/JP6799695B2/ja active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102289460A (zh) * | 2011-07-13 | 2011-12-21 | 中国工商银行股份有限公司 | 一种向测试环境进行报表元数据同步的方法及系统 |
CN103020149A (zh) * | 2012-11-22 | 2013-04-03 | 用友软件股份有限公司 | 共享数据更新装置和共享数据更新方法 |
CN104572644A (zh) * | 2013-10-10 | 2015-04-29 | 北京大学 | 数据库更新装置和数据库更新方法 |
WO2016015220A1 (en) * | 2014-07-29 | 2016-02-04 | Hewlett-Packard Development Company, L.P. | Executable code abnormality detection |
CN105512017A (zh) * | 2014-09-22 | 2016-04-20 | 阿里巴巴集团控股有限公司 | 一种数据库兼容性检测方法及设备 |
Cited By (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110457300A (zh) * | 2019-07-15 | 2019-11-15 | 中国平安人寿保险股份有限公司 | 一种公共测试库的清理方法及装置、电子设备 |
CN110457300B (zh) * | 2019-07-15 | 2024-02-02 | 中国平安人寿保险股份有限公司 | 一种公共测试库的清理方法及装置、电子设备 |
JP2021047806A (ja) * | 2019-09-20 | 2021-03-25 | 富士通株式会社 | 情報処理システム、情報処理装置および情報処理プログラム |
CN111522719A (zh) * | 2020-04-27 | 2020-08-11 | 中国银行股份有限公司 | 大数据任务状态的监控方法及装置 |
CN111522719B (zh) * | 2020-04-27 | 2023-12-01 | 中国银行股份有限公司 | 大数据任务状态的监控方法及装置 |
CN111651364B (zh) * | 2020-07-01 | 2023-04-28 | 中国银行股份有限公司 | 并行开发下的sql检查方法及装置 |
CN111651364A (zh) * | 2020-07-01 | 2020-09-11 | 中国银行股份有限公司 | 并行开发下的sql检查方法及装置 |
CN111857752A (zh) * | 2020-07-22 | 2020-10-30 | 浪潮商用机器有限公司 | 一种PostgreSQL数据库安装方法、装置及设备 |
CN111857752B (zh) * | 2020-07-22 | 2023-08-08 | 浪潮商用机器有限公司 | 一种PostgreSQL数据库安装方法、装置及设备 |
CN114625630A (zh) * | 2020-12-14 | 2022-06-14 | 福建天泉教育科技有限公司 | 一种多环境多角色版本发布系统的测试方法及其测试系统 |
CN113297028A (zh) * | 2021-03-18 | 2021-08-24 | 中国平安人寿保险股份有限公司 | 一种脚本执行方法、装置、计算机设备及存储介质 |
CN113138974B (zh) * | 2021-04-23 | 2023-08-22 | 建信金融科技有限责任公司 | 数据库合规检测的方法和装置 |
CN113138974A (zh) * | 2021-04-23 | 2021-07-20 | 建信金融科技有限责任公司 | 数据库合规检测的方法和装置 |
CN115757055A (zh) * | 2022-10-19 | 2023-03-07 | 北京新数科技有限公司 | 一种基于Spring Cloud的数据库统一运维及综合性能评分系统 |
CN115757055B (zh) * | 2022-10-19 | 2023-10-27 | 北京新数科技有限公司 | 一种基于Spring Cloud的数据库统一运维及综合性能评分系统 |
Also Published As
Publication number | Publication date |
---|---|
JP2020520515A (ja) | 2020-07-09 |
CN107688531B (zh) | 2019-02-22 |
CN107688531A (zh) | 2018-02-13 |
JP6799695B2 (ja) | 2020-12-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2018233037A1 (zh) | 数据库集成测试方法、装置、服务器及存储介质 | |
WO2018014582A1 (zh) | 保单数据处理方法、装置、服务器和存储介质 | |
TWI608419B (zh) | 軟體相容性預先檢測方法與其系統 | |
US8140907B2 (en) | Accelerated virtual environments deployment troubleshooting based on two level file system signature | |
US8140905B2 (en) | Incremental problem determination and resolution in cloud environments | |
WO2018014580A1 (zh) | 数据接口测试方法、装置、服务器和存储介质 | |
WO2017177769A1 (zh) | Ogg 版本部署方法、系统、服务器和存储介质 | |
WO2022151776A1 (zh) | 一种云平台虚拟机回收方法及计算机设备 | |
JPH0325629A (ja) | プログラムのエラー検出方法及びシステム | |
US20060235907A1 (en) | Pausable backups of file system items | |
JP2001508894A (ja) | 広域コンピュータネットワークにおいてコンピュータファイルをバックアップするシステム及び方法 | |
JPH07105064A (ja) | ファイル名検出方式 | |
US20150142813A1 (en) | Language tag management on international data storage | |
WO2014029111A1 (zh) | 一种用户行为处理系统及方法 | |
WO2018036168A1 (zh) | 数据处理任务执行方法、装置、执行服务器和存储介质 | |
CN114116322B (zh) | 数据恢复方法、装置、设备及存储介质 | |
CN104123197B (zh) | 未持有iOS设备情况下的离线取证方法 | |
US8290992B2 (en) | File management method, file management device, and program | |
US20210173750A1 (en) | Methods to automatically correct and improve system recovery and replication processes | |
CN113704790A (zh) | 一种异常日志信息汇总方法及计算机设备 | |
CN114238255A (zh) | 同步文件的方法、装置、电子设备及计算机可读存储介质 | |
CN113268206B (zh) | 一种网络靶场资源热插拔实现方法与系统 | |
JP4511047B2 (ja) | 移動通信システムの並列プロセッサを同期化するためのプロトコル | |
Yoshida et al. | Finding similar defects using synonymous identifier retrieval | |
WO2018014581A1 (zh) | 数值转移记录的核对方法、装置、服务器和存储介质 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 17914853 Country of ref document: EP Kind code of ref document: A1 |
|
ENP | Entry into the national phase |
Ref document number: 2019563048 Country of ref document: JP Kind code of ref document: A |
|
NENP | Non-entry into the national phase |
Ref country code: DE |
|
32PN | Ep: public notification in the ep bulletin as address of the adressee cannot be established |
Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 15/05/2020) |
|
122 | Ep: pct application non-entry in european phase |
Ref document number: 17914853 Country of ref document: EP Kind code of ref document: A1 |