WO2018202173A1 - Procédé et système d'essai de base de données - Google Patents

Procédé et système d'essai de base de données Download PDF

Info

Publication number
WO2018202173A1
WO2018202173A1 PCT/CN2018/085725 CN2018085725W WO2018202173A1 WO 2018202173 A1 WO2018202173 A1 WO 2018202173A1 CN 2018085725 W CN2018085725 W CN 2018085725W WO 2018202173 A1 WO2018202173 A1 WO 2018202173A1
Authority
WO
WIPO (PCT)
Prior art keywords
database
package
test script
automated test
task
Prior art date
Application number
PCT/CN2018/085725
Other languages
English (en)
Chinese (zh)
Inventor
李国文
Original Assignee
平安科技（深圳）有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 平安科技（深圳）有限公司 filed Critical 平安科技（深圳）有限公司
Publication of WO2018202173A1 publication Critical patent/WO2018202173A1/fr

Links

Images

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/3684—Test management for test design, e.g. generating new test cases
    • 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

Definitions

  • the present application relates to the field of database technologies, and in particular, to a database testing method and system.
  • the purpose of the present application is to provide a database testing method and system to solve the problem of how to automatically perform package testing of an Oracle database.
  • the present application provides a database testing method, the method comprising the steps of:
  • the present application also provides a database testing system, the system comprising:
  • An execution module is configured to run the automated test script to obtain test results.
  • the system further comprises:
  • the execution module is further configured to perform the task according to the set parameter to obtain the test result.
  • the present application further provides a computer readable storage medium, where the database readable storage medium stores a database testing system, and the database testing system includes:
  • An execution module is configured to run the automated test script to obtain test results.
  • the database testing method, system and computer readable storage medium proposed by the present application can build an underlying database testing architecture, use the prepareCall method of ISQLServerConnection to call the package of the background database, set the package automation test script, and then run the job through the job of the Jenkins platform. Automate test scripts and get database package test results to automate the testing of database packages and quickly and intuitively see test results.
  • FIG. 1 is a flowchart of a database testing method according to a first embodiment of the present application
  • FIG. 2 is a flowchart of a database testing method according to a second embodiment of the present application.
  • FIG. 3 is a flowchart of a database testing method according to a third embodiment of the present application.
  • FIG. 4 is a schematic block diagram of a database testing system according to a fourth embodiment of the present application.
  • the first embodiment of the present application provides a database testing method, which includes the following steps:
  • S100 Establish a test structure of a stored procedure or a function in a package of an Oracle database.
  • Oracle Database System is a set of software products based on distributed database provided by Oracle Corporation (Oracle). Specifically, the Oracle database application environment is set up, and the test architecture of the stored procedure or function in the package of the Oracle database is established according to the system architecture of the specific application environment. The specific topology is as close as possible to the actual application.
  • an automated test script is set up, and the stored procedure or function in the package of the back-end Oracle database is invoked by using the prepareCall method of ISQLServerConnection in Java.
  • the prepareCall method invokes a database stored procedure by creating a CallableStatement object.
  • the CallableStatement object provides methods for setting its IN and OUT parameters, as well as methods for executing the stored procedure.
  • the automated test script may be directly run after the automatic test script is set to obtain the test result; or the running time of the automated test script and the running test environment address may be set first, and then set according to the set The runtime runs the automated test script in the set test environment address to obtain the test results.
  • the database testing method proposed in this embodiment can build an underlying database testing architecture, use the prepareCall method of ISQLServerConnection to call the package of the background database, set the package automation test script, and then run the automated test script to obtain the database package test result. This enables automated testing of database packages and quick and intuitive viewing of test results.
  • the second embodiment of the present application provides a database testing method.
  • the steps of the database testing method are similar to those of the first embodiment, the main difference being that step S204 is added to the first embodiment.
  • the method specifically includes the following steps:
  • S200 Establish a test structure of a stored procedure or a function in a package of an Oracle database.
  • the Oracle database application environment is set up, and the test architecture of the stored procedure or function in the package of the Oracle database is established according to the system architecture of the specific application environment.
  • the specific topology is as close as possible to the actual application.
  • an automated test script is set up, and the stored procedure or function in the package of the back-end Oracle database is invoked by using the prepareCall method of ISQLServerConnection in Java.
  • the prepareCall method invokes a database stored procedure by creating a CallableStatement object.
  • the CallableStatement object provides methods for setting its IN and OUT parameters, as well as methods for executing the stored procedure.
  • Jenkins is an open source software project, a continuous integration tool developed in Java to monitor continuous repetitive work.
  • the Jenkins platform is used to monitor ongoing software test projects and external call execution.
  • the job is used to execute the automated test script and perform a database package test. Creating the job on the Jenkins platform and executing the job can automatically monitor the ongoing database package test and automatically obtain the database package test results.
  • the parameters may include: (1) setting an execution time of the job and a running time of the automated test script; and (2) setting a test environment address at which the automated test script runs.
  • the database testing method proposed in this embodiment can build an underlying database testing architecture, use the prepareCall method of ISQLServerConnection to call the package of the background database, set the package automation test script, and then run the automated test script through the job of the Jenkins platform to automatically monitor Continuous database package testing, get database package test results, to achieve automated testing of the database package, and can quickly and intuitively see the test results.
  • the third embodiment of the present application provides a database testing method.
  • the steps of the database testing method are similar to those of the second embodiment, the main difference being that step S303 and step S308 are added on the basis of the second embodiment.
  • the method specifically includes the following steps:
  • S300 Establish a test structure of a stored procedure or function in a package of an Oracle database.
  • the Oracle database application environment is set up, and the test architecture of the stored procedure or function in the package of the Oracle database is established according to the system architecture of the specific application environment.
  • the specific topology is as close as possible to the actual application.
  • an automated test script is set up, and the stored procedure or function in the package of the back-end Oracle database is invoked by using the prepareCall method of ISQLServerConnection in Java.
  • the prepareCall method invokes a database stored procedure by creating a CallableStatement object.
  • the CallableStatement object provides methods for setting its IN and OUT parameters, as well as methods for executing the stored procedure.
  • SVN is short for Subversion and is an open source version control system.
  • the SVN version management tool is configured to perform version management on the automated test script to modify and update the automated test script at any time.
  • the Jenkins platform is used to monitor ongoing software test projects and external call execution.
  • the job is used to execute the automated test script and perform a database package test. Creating the job on the Jenkins platform and executing the job can automatically monitor the ongoing database package test and automatically obtain the database package test results.
  • the parameters may include: (1) downloading an SVN version management tool address of the automated test script; (2) setting an execution time of the job and a running time of the automated test script; and (3) setting an automated test script to run Test environment address.
  • the job is executed according to the set execution time
  • the automated test script is downloaded from the SVN version management tool address
  • the automated test script is run in the set test environment address according to the set running time. Thereby the test result is obtained.
  • an automated database package test result can be directly obtained, a result report is formed according to the test result, and the result report is sent to the tester by mail.
  • the database testing method proposed in this embodiment can build an underlying database testing architecture, use the prepareCall method of ISQLServerConnection to call the package of the background database, set the package automation test script, and then run the automated test script through the job of the Jenkins platform to obtain the database.
  • Package test results thus automated testing of the database package, and can quickly and intuitively see the test results.
  • the automated test script is submitted to the SVN version management tool, and the automated test script can be version-managed to modify and update the automated test script at any time.
  • a fourth embodiment of the present application provides a database testing system 40.
  • the database testing system 40 includes an establishing module 400, a setting module 402, and an executing module 406.
  • the establishing module 400 is configured to establish a test structure of a stored procedure or a function in a package of an Oracle database.
  • the establishing module 400 constructs an Oracle database application environment, and establishes a test architecture of a stored procedure or a function in a package of the corresponding Oracle database for the system architecture of the specific application environment.
  • the specific topology is as close as possible to the actual application.
  • the setting module 402 is configured to set an automated test script, and invoke a stored procedure or function in a package of the backstage Oracle database to perform database testing.
  • an automated test script is set up, and the stored procedure or function in the package of the back-end Oracle database is invoked by using the prepareCall method of ISQLServerConnection in Java.
  • the prepareCall method invokes a database stored procedure by creating a CallableStatement object.
  • the CallableStatement object provides methods for setting its IN and OUT parameters, as well as methods for executing the stored procedure.
  • the execution module 406 is configured to run the automated test script to obtain test results.
  • the execution module 406 can directly run the automated test script after setting the automated test script to obtain the test result.
  • the execution module 406 may also first set the running time of the automated test script and the running test environment address, and then run the automated test script in the set test environment address according to the set running time, thereby obtaining the test result.
  • database testing system 40 may further include:
  • a creation module 404 is configured to create a job on the Jenkins platform to run the automated test script and set relevant parameters of the job.
  • the Jenkins platform is used to monitor ongoing software test projects and external call execution.
  • the job is used to execute the automated test script and perform a database package test. Creating the job on the Jenkins platform and executing the job can automatically monitor the ongoing database package test and automatically obtain the database package test results.
  • the parameters may include: (1) setting an execution time of the job and a running time of the automated test script; and (2) setting a test environment address at which the automated test script runs.
  • the execution module 406 is further configured to execute the job according to the set parameters to obtain a test result.
  • database testing system 40 may further include:
  • the submitting module 403 is configured to submit the automated test script to the SVN version management tool.
  • the SVN version management tool is configured to perform version management on the automated test script to modify and update the automated test script at any time.
  • the creating module 404 sets the related parameters of the job, it is also required to set an SVN version management tool address for downloading the automated test script.
  • the execution module 406 executes the job according to the set execution time, the automatic test script needs to be downloaded from the SVN version management tool address.
  • the sending module 408 is configured to send the obtained test result to the tester.
  • an automated database package test result can be directly obtained, a result report is formed according to the test result, and the result report is sent to the tester by mail.
  • the foregoing embodiment method can be implemented by means of software plus a necessary general hardware platform, and can also be implemented by hardware, but in many cases, the former is A better implementation.
  • the technical solution of the present application which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk,
  • the optical disc includes a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present application.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computer Hardware Design (AREA)
  • Quality & Reliability (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Stored Programmes (AREA)
  • Debugging And Monitoring (AREA)

Abstract

La présente invention concerne un procédé et un système d'essai de base de données. Le procédé comprend : la création d'une architecture d'essai pour un processus de stockage ou une fonction dans un paquetage d'une base de données; la définition d'un script d'essai automatisé, l'invocation du processus de stockage ou de la fonction dans le paquetage de la base de données pour effectuer un essai du paquetage de la base de données; et l'exécution du script d'essai automatisé pour produire un résultat d'essai. Un essai automatisé du paquetage de la base de données est ainsi mis en œuvre.
PCT/CN2018/085725 2017-05-05 2018-05-04 Procédé et système d'essai de base de données WO2018202173A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710312329.5 2017-05-05
CN201710312329.5A CN107885654A (zh) 2017-05-05 2017-05-05 数据库测试方法及系统

Publications (1)

Publication Number Publication Date
WO2018202173A1 true WO2018202173A1 (fr) 2018-11-08

Family

ID=61780489

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/085725 WO2018202173A1 (fr) 2017-05-05 2018-05-04 Procédé et système d'essai de base de données

Country Status (2)

Country Link
CN (1) CN107885654A (fr)
WO (1) WO2018202173A1 (fr)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110147328A (zh) * 2019-05-24 2019-08-20 深圳市网心科技有限公司 一种数据库性能测试方法、系统、电子设备和存储介质
CN111240989A (zh) * 2020-01-17 2020-06-05 众能联合数字技术有限公司 接口自动化测试框架及方法

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107885654A (zh) * 2017-05-05 2018-04-06 平安科技（深圳）有限公司 数据库测试方法及系统
CN112099806A (zh) * 2020-11-05 2020-12-18 四川新网银行股份有限公司 一种基于CICD的sql自动化审核上线及执行方法

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105446825A (zh) * 2014-06-12 2016-03-30 阿里巴巴集团控股有限公司 数据库测试方法及装置
US9542300B1 (en) * 2013-03-15 2017-01-10 Twitter, Inc. System and method for tracking callback functions for error identification
CN106383784A (zh) * 2016-09-20 2017-02-08 上海爱数信息技术股份有限公司 软件自动化测试方法及系统
CN107885654A (zh) * 2017-05-05 2018-04-06 平安科技（深圳）有限公司 数据库测试方法及系统

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101093462B (zh) * 2006-06-22 2011-02-09 上海全成通信技术有限公司 数据库应用集群压力测试自动化方法
US9092500B2 (en) * 2009-09-03 2015-07-28 Commvault Systems, Inc. Utilizing snapshots for access to databases and other applications
CN102486748B (zh) * 2010-12-02 2015-07-15 金蝶软件（中国）有限公司 一种性能测试的方法及装置
CN102254036A (zh) * 2011-08-09 2011-11-23 广东电网公司电力科学研究院 时间序列数据库测试方法及测试系统
CN102254035A (zh) * 2011-08-09 2011-11-23 广东电网公司电力科学研究院 关系数据库测试方法及测试系统
CN103810196B (zh) * 2012-11-09 2017-09-22 阿里巴巴集团控股有限公司 基于业务模型进行数据库性能测试的方法
CN105224458B (zh) * 2015-10-09 2018-02-09 上海瀚银信息技术有限公司 一种数据库测试方法及系统
CN105302729A (zh) * 2015-12-09 2016-02-03 浪潮电子信息产业股份有限公司 一种基于数据库应用的存储系统测试方法

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9542300B1 (en) * 2013-03-15 2017-01-10 Twitter, Inc. System and method for tracking callback functions for error identification
CN105446825A (zh) * 2014-06-12 2016-03-30 阿里巴巴集团控股有限公司 数据库测试方法及装置
CN106383784A (zh) * 2016-09-20 2017-02-08 上海爱数信息技术股份有限公司 软件自动化测试方法及系统
CN107885654A (zh) * 2017-05-05 2018-04-06 平安科技（深圳）有限公司 数据库测试方法及系统

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110147328A (zh) * 2019-05-24 2019-08-20 深圳市网心科技有限公司 一种数据库性能测试方法、系统、电子设备和存储介质
CN111240989A (zh) * 2020-01-17 2020-06-05 众能联合数字技术有限公司 接口自动化测试框架及方法

Also Published As

Publication number Publication date
CN107885654A (zh) 2018-04-06

Similar Documents

Publication Publication Date Title
WO2018202173A1 (fr) Procédé et système d'essai de base de données
US8762187B2 (en) Easy process modeling platform
EP3115902B1 (fr) Cadre pour test automatisé d'applications mobiles
WO2016177124A1 (fr) Procédé et dispositif de mise en œuvre d'un test d'intégration continu
CN109472442B (zh) 一种工单的自动化处理系统和方法
US20210336995A1 (en) Methods and apparatus to provide resource security
CN109324975B (zh) 一种基于移动云测平台的持续集成方法
CN110781089B (zh) 一种设备ui自动化测试方法、装置、电子设备和介质
US8434053B2 (en) Package review process workflow
CN111026411A (zh) 一种软件远程部署管理方法及管理机
CN111651365B (zh) 接口自动化测试方法及装置
CN113706022A (zh) 业务流程的执行方法及装置、存储介质及电子设备
CN113256095A (zh) 可拖拽配置的敏捷流程服务构建方法、系统、设备及介质
CN114782012A (zh) 工装变更方法、装置、设备及存储介质
WO2022095448A1 (fr) Procédé et appareil de réglage de script de plaquette, dispositif, et support d'enregistrement
WO2017167015A1 (fr) Procédé et dispositif destinés à la gestion de sécurité de dispositif serveur et support de mémoire informatique
US20160041898A1 (en) Generation of automated unit tests for a controller layer system and method
WO2017177783A1 (fr) Système et procédé de test faisant appel à un outil de test tiers
CN108400906B (zh) 一种自动化测试方法、装置、存储介质及计算机设备
CN111580853A (zh) 多渠道软件安装包通用生成方法
CN112416791B (zh) 一种测试对象的缺陷信息处理系统和方法
US20190205110A1 (en) Compilation optimization via dynamic server cloning
CN115222363A (zh) 可视化流程编排方法、可读存储介质及计算机设备
CN111930446A (zh) 一种信息处理方法、装置、终端设备及介质
CN115526580B (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: 18793929

Country of ref document: EP

Kind code of ref document: A1

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 18/02/2020)

122 Ep: pct application non-entry in european phase

Ref document number: 18793929

Country of ref document: EP

Kind code of ref document: A1