CN114529248A

CN114529248A - Data work order issuing method based on JIRA and ink supplier

Info

Publication number: CN114529248A
Application number: CN202111662707.5A
Authority: CN
Inventors: 刘宇
Original assignee: Tianyi Electronic Commerce Co Ltd
Current assignee: Tianyi Electronic Commerce Co Ltd
Priority date: 2021-12-30
Filing date: 2021-12-30
Publication date: 2022-05-24

Abstract

The invention discloses a JIRA and inker-based data work order issuing method, and relates to the field of IT and software development. The invention optimizes the existing work flow, performs data communication on the JIRA and the ink person platform, synchronizes the data work order state in the JIRA to the ink person flow management, reduces the serious consequences caused by manual filling, manual auditing and manual implementation, as well as non-standard SQL format filling and inaccurate library information by a user, and improves the safety because the JIRA and the ink person platform user data are communicated, and finally the executor of the work order needs to be matched with the JIRA work order for comparison, thereby satisfying the auditing.

Description

Data work order issuing method based on JIRA and ink supplier

Technical Field

The invention relates to the field of IT and software development, in particular to a JIRA and inker (database operation and maintenance platform) based data work order issuing method.

Background

The original process user needs to manually write and submit a worksheet in JIRA during data change, and after approval by an approver, a database administrator downloads accessories for implementation and manually executes data change statements. Because manual filling and manual implementation are prone to errors and cause faults, and meanwhile, the possibility that an executor does not match with the JIRA exists, safety audit problems are caused. Therefore, the invention carries out data communication between the JIRA and the ink supplier platform, the ink supplier can automatically pick up the order only by simple clicking operation of the user, and the system executes the data change work order after the system audit is passed, thereby greatly improving the accuracy of the order picking and reducing the communication cost.

Disclosure of Invention

Aiming at the defects in the prior art, the invention aims to provide a data worksheet issuing method based on JIRA and ink supplier, which improves the accuracy of bill extraction and improves the working efficiency and safety.

In order to realize the purpose, the invention is realized by the following technical scheme: a JIRA and inker-based data work order issuing method comprises the following steps:

(3) user creates new data change work order in Jira

(4) Selecting a new work order on the inker platform, selecting a database to be changed, compiling data change statements, and filling in a Jira work order number to verify the validity;

(3) the ink writer platform carries out system audit on the change statements, and backfills the change content and the audit result of the database to the Jira platform;

(4) the ink platform distributes the Jira work order to the user according to the user information;

(5) after the user passes the approval, the work order flow is transferred to a database manager, the database manager clicks an execution button on the ink person platform, whether the ink person is consistent with the execution personnel of the Jira platform is checked, if so, the work order is executed, and the execution result is refilled to the Jira platform.

The invention has the following beneficial effects:

in order to optimize the existing work flow, the data communication is carried out on the Jira and the ink person, and the execution of the data change in the Jira work order is realized by the ink person platform, so that the work efficiency is improved, and the safety is improved;

the invention solves the problems of inaccurate data and low manual auditing efficiency of the original process, realizes systematization of data change process and improves safety and working efficiency.

Drawings

The invention is described in detail below with reference to the drawings and the detailed description;

FIG. 1 is a schematic flow chart of the steps of the present invention;

FIG. 2 is a flow chart illustrating specific steps of the present invention;

FIG. 3 is a schematic flow diagram of an embodiment of the present invention;

FIG. 4 is a diagram illustrating a partially customized audit rule according to an embodiment of the present invention;

FIG. 5 is an exploded view of an automated audit technique according to an embodiment of the present invention;

FIG. 6 is a schematic diagram of an inker work order of an embodiment of the present invention;

FIG. 7 is a schematic diagram of an embodiment of the present invention entering SQL text;

FIG. 8 is a diagram illustrating audit results according to an embodiment of the present invention;

fig. 9 is a diagram showing the contents of the results shown in the JIRA according to the embodiment of the present invention;

FIG. 10 is a flow chart of SQL execution according to the embodiment of the invention.

Detailed Description

In order to make the technical means, the creation characteristics, the achievement purposes and the effects of the invention easy to understand, the invention is further described with the specific embodiments.

Referring to fig. 1 to 10, the following technical solutions are adopted in the present embodiment: a data work order issuing method based on Jira and ink (database operation and maintenance platform) comprises the following steps:

(1) a user creates a data change work order in Jira;

(2) and selecting a new work order on the inker platform as shown in FIG. 6, selecting a database to be changed, writing a data change statement, filling a Jira work order number, verifying the validity and successfully creating, and then performing SQL entry and verification operation. The SQL text is input by the system in a form of manual input and file uploading at present as shown in FIG. 7.

(3) The inker platform performs system automatic audit on the change statement, after the SQL text is input, the submitting audit operation can be executed, and then the automatic audit is performed according to the audit rule as shown in figure 5. And (3) auditing the lexical and syntactic analysis by using an SQL (structured query language) analyzer written by the antlr, traversing and matching all the auditing rules as shown in FIG. 4, continuously increasing auditing contents in the traversal, and finally returning the result, wherein an auditing log is generated at the lowest part of the page in the automatic auditing as shown in FIG. 8:

(5) after the user passes the approval, the work order flow is transferred to a database manager DBA, the database manager clicks an execution button on the ink person platform, whether the ink person is consistent with the execution personnel of the Jira platform is checked at the moment, the work order is executed if the ink person is consistent with the execution personnel of the Jira platform, and the execution result is refilled to the Jira platform.

Specifically, fig. 9 is a schematic diagram displayed on the corresponding Jira after applying the scheme.

In the specific embodiment, the operation or development personnel carries out work order, and when the SQL writing step is reached, the operation or development personnel jumps to the ink writer platform to finish SQL uploading and audit, and submits to the DBA processing stage after the audit is successful. At the moment, the platform inserts the most recorded auditing result into the annotation of the current JIRA work order, and when the JIRA normally flows to the DBA, the relevant SQL statement can be directly executed by clicking an execution button. As shown in fig. 10.

In order to ensure the consistency of data, the ink platform fills in an SQL statement, and the check realizes the butt joint of the ink platform and the JIRA work order data through RESTful API and JIRA. The necessary source of user information required for the bill of lading is user information stored by the inkee, the jiar has the mailbox as the unique identifier of the user, so that the inkee user information contains the mailbox to realize the verification from the inkee user to the JIRA user, and the security is further improved, as shown in fig. 1 and fig. 2.

In order to deal with the optimization of the existing data issuing process, the data communication is carried out on the Jira and the ink user platform, and the implementation of the database changing process is realized by connecting the ink user platform and the Jira in series, so that the data accuracy and the safety are improved, and the working efficiency is improved.

The foregoing shows and describes the general principles and broad features of the present invention and advantages thereof. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are described in the specification and illustrated only to illustrate the principle of the present invention, but that various changes and modifications may be made therein without departing from the spirit and scope of the present invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.

Claims

1. A data worksheet issuing method based on JIRA and inking person, characterized by comprising the following steps:

(1) user creates new data change work order in Jira

(2) Selecting a new work order on the inker platform, selecting a database to be changed, compiling data change statements, and filling in a Jira work order number to verify the validity;