SQL publishing method and system based on process engine

The invention provides an SQL publishing method and system based on a process engine, and the method comprises the steps: obtaining an SQL publishing package in a publishing task configured for an application, and obtaining each SQL file according to a separator between SQL files under the SQL publi...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: SHEN SHIXIN
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention provides an SQL publishing method and system based on a process engine, and the method comprises the steps: obtaining an SQL publishing package in a publishing task configured for an application, and obtaining each SQL file according to a separator between SQL files under the SQL publishing package; executing the SQL files one by one, and judging whether the actual execution result of the currently executed SQL files is consistent with the expected execution result of the currently executed SQL files or not, wherein the expected execution result of the currently executed SQL fileis located behind the separator next to the currently executed SQL file. Whether the execution result of the SQL files meets the expectation or not is automatically determined, and the method is simple, easy to use, low in requirement for publishers, high in efficiency and not prone to making mistakes. 本发明提供一种基于流程引擎的SQL发布方法及系统,该方法包括:获取为应用程序配置的发布任务中的SQL发布包,根据所述SQL发布包下的SQL文件之间的分隔符,获取每条SQL文件;逐条执行SQL文件,判断当前执行的SQL文件的实际执行结果与当前