Unlock instant, AI-driven research and patent intelligence for your innovation.

CICD-based sql automatic audit online and execution method

An execution method and database technology, applied in the direction of structured data retrieval, inter-program communication, program control design, etc., can solve the problems of audit time lag and achieve the effect of reducing risk and high efficiency

Inactive Publication Date: 2020-12-18
SICHUAN XW BANK CO LTD
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Aiming at the problem that the audit time point of the sql automatic online method lags behind in the prior art, and problems cannot be found in advance and fed back to developers in a timely manner, the present invention provides a CICD-based automatic sql audit online and execution method. Problems are corrected and optimized to reduce production risks

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • CICD-based sql automatic audit online and execution method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] In order to make the purpose, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only It is a part of the embodiments of this application, not all of them. The components of the embodiments of the application generally described and illustrated in the figures herein may be arranged and designed in a variety of different configurations. Accordingly, the following detailed description of the embodiments of the application provided in the accompanying drawings is not intended to limit the scope of the claimed application, but merely represents selected embodiments of the application. Based on the embodiments of the present application, all other embodiments obtained by those skilled in the art without...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention belongs to the technical field of information technology and software development, and particularly relates to a CICD-based sql automatic audit online and execution method. The problemsthat in the prior art, an sql automatic online method lags behind an auditing time point, problems cannot be found in advance and fed back to developers in time, and production risks exist are solved.A database auditing platform is connected to a CICD assembly line, a database auditing platform interface is called in the sql file submitting stage to audit an sql file, a testing environment database auditing platform interface is called in the sql file version sealing and packaging stage to audit the sql file, finally, the sql file is stored in a production environment object, and an online work order is created. According to the invention, from sql development submission to sql automatic auditing to final online, complete automatic management is realized, and the efficiency is higher. Automatic auditing is carried out in the sql submission stage, problems can be found in advance, correction and optimization are carried out in time, and risks are reduced.

Description

technical field [0001] The invention belongs to the technical fields of information technology and software development, and in particular relates to a CICD-based sql automatic audit on-line and execution method. Background technique [0002] Structured Query Language (Structured Query Language), referred to as SQL, is a special-purpose programming language, a database query and programming language, used to access data and query, update and manage relational database systems. The CICD refers to the methods of continuous integration, continuous delivery and continuous deployment formed in the software development process, CI stands for continuous integration (Continuous Integration), CD stands for continuous delivery (Continuous Delivery) and continuous deployment (Continuous Deployment). [0003] In the existing technology, the online sql can be recorded, managed, self-service, and rolled back through the mysql online platform, but the existing sql automatic online method a...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F8/60G06F8/71G06F16/25G06F9/54G06F11/36
CPCG06F8/60G06F8/71G06F9/546G06F11/3672G06F2209/548G06F16/252
Inventor 韩晨阳杨阳谢明阳黄凯
Owner SICHUAN XW BANK CO LTD