CN111857672A - Business development method, device, equipment and medium based on SQL configuration - Google Patents
Business development method, device, equipment and medium based on SQL configuration Download PDFInfo
- Publication number
- CN111857672A CN111857672A CN202010756729.7A CN202010756729A CN111857672A CN 111857672 A CN111857672 A CN 111857672A CN 202010756729 A CN202010756729 A CN 202010756729A CN 111857672 A CN111857672 A CN 111857672A
- Authority
- CN
- China
- Prior art keywords
- sql
- configuration
- file
- development
- interface
- Prior art date
- Legal status (The legal status 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 status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/20—Software design
- G06F8/22—Procedural
-
- 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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44505—Configuring for program initiating, e.g. using registry, configuration files
- G06F9/4451—User profiles; Roaming
Abstract
The invention discloses a business development method, a device, terminal equipment and a computer readable storage medium based on configuration SQL, wherein the business development method based on the configuration SQL comprises the following steps: acquiring a file interface of a service system to be developed; configuring the file interface based on the SQL statement and a preset general configuration rule; and acquiring configuration information obtained by configuring the file interface, and generating a development file of the service system to be developed according to the configuration information. According to the method and the device, the SQL sentence does not need to be written in the specific software engineering code, the problems that when the service needs to be modified, the worker needs to modify and adjust the specific software engineering code, the operation is complex and the time consumption is long are solved, the rapid configuration can be carried out to complete delivery and rapid modification maintenance when the service development or service modification needs are met, and the overall working efficiency of the service development is improved.
Description
Technical Field
The present invention relates to the field of business development technologies, and in particular, to a business development method and apparatus based on configuration SQL, a terminal device, and a computer-readable storage medium.
Background
SQL (Structured Query Language) is an important basic tool in the field of software engineering, and based on the simple and efficient application characteristics of the SQL Language, SQL statements are applied to the development process of software services by software development engineers more and more widely.
However, in the development process of the conventional software project, the SQL statements are usually directly written in the engineering codes of the software, and when the software service changes, the corresponding service change can be completed only by modifying the software engineering codes, which is complex in operation and long in time consumption. Thus, in the strong market competition that software business changes frequently and delivery is generally required to be completed in a short time, the traditional mode of writing SQL statements in codes for business development is difficult to meet the development requirement.
Disclosure of Invention
The invention mainly aims to provide a business development method, a business development device, terminal equipment and a computer readable storage medium based on SQL configuration, and aims to solve the technical problems that the traditional mode of writing SQL sentences in codes to develop business is difficult to meet the development requirements of frequent business change and short-term delivery completion.
In order to achieve the above object, an embodiment of the present invention provides a service development method based on configuration SQL, where the service development method based on configuration SQL includes:
acquiring a file interface of a service system to be developed;
configuring the file interface based on the SQL statement and a preset general configuration rule;
and acquiring configuration information obtained by configuring the file interface, and generating a development file of the service system to be developed according to the configuration information.
Preferably, the step of configuring the file interface based on the SQL statement and the preset general configuration rule includes:
and configuring the file interface in a preset database and/or a configuration center based on SQL statements and preset general configuration rules.
Preferably, the step of configuring the file interface based on the SQL statement and the preset general configuration rule in the preset database and/or configuration center includes:
reading SQL query statements to be configured of the file interface, generating a file format and a path, and uploading a file to a server;
and configuring the SQL query statement to be configured, the format and the path of the generated file and the file uploading server mode in a preset database and/or a configuration center based on the SQL statement and a preset general configuration rule.
Preferably, the service development method based on the configuration SQL further includes:
and extracting configuration information obtained by configuring the file interface from the database and/or the configuration center, and adjusting the configuration information.
Preferably, the configuration information includes, but is not limited to: SQL query statements and generate file formats and paths,
the step of obtaining configuration information obtained by configuring the file interface and generating a development file of the service system to be developed according to the configuration information includes:
acquiring an SQL query statement obtained by configuring the file interface and generating a file format and a path;
detecting a field sequence of a query result obtained based on executing the SQL query statement;
and generating a development file of the service system to be developed according to the format and the path of the generated file and the field sequence.
Preferably, after the step of obtaining the file interface of the service system to be developed, the method further includes:
and acquiring the interface characteristics of the file interface, and generating the preset general configuration rule according to the interface characteristics.
Preferably, the service development method based on the configuration SQL further includes:
and acquiring the public information in the SQL statement based on public configuration.
In addition, in order to achieve the above object, the present invention further provides a service development device based on configuration SQL, which includes:
the acquisition module is used for acquiring a file interface of a service system to be developed;
the configuration module is used for configuring the file interface based on SQL sentences and preset general rules;
and the development module is used for acquiring configuration information obtained by configuring the file interface and generating a development file of the service system to be developed according to the configuration information.
In addition, to achieve the above object, the present invention also provides a terminal device, including: a memory, a processor, a communication bus, and a configuration SQL based business development program stored on the memory,
the communication bus is used for realizing communication connection between the processor and the memory;
the processor is used for executing the business development program based on the configuration SQL so as to realize the following steps:
collecting log data generated by the service development device based on the configuration SQL, and caching the log data into a temporary database;
acquiring a file interface of a service system to be developed;
configuring the file interface based on the SQL statement and a preset general configuration rule;
and acquiring configuration information obtained by configuring the file interface, and generating a development file of the service system to be developed according to the configuration information.
Further, to achieve the above object, the present invention also provides a computer-readable storage medium storing one or more programs, the one or more programs being executable by one or more processors for:
acquiring a file interface of a service system to be developed;
configuring the file interface based on the SQL statement and a preset general configuration rule;
and acquiring configuration information obtained by configuring the file interface, and generating a development file of the service system to be developed according to the configuration information.
The invention provides a business development method, a business development device, terminal equipment and a computer-readable storage medium based on SQL configuration, which are characterized in that a file interface of a business system to be developed is obtained; configuring the file interface based on the SQL statement and a preset general configuration rule; and acquiring configuration information obtained by configuring the file interface, and generating a development file of the service system to be developed according to the configuration information.
The invention combines SQL sentences and preset general configuration rules suitable for the characteristics of the file interface of the service system to be developed to configure the file interface of the service system to be developed, and then generates the development file of the service system to be developed correspondingly according to the configuration information of the file interface obtained after the configuration of the file interface, thereby not needing to write the SQL sentences in specific software engineering codes, avoiding the problems of complex operation and long time consumption caused by the fact that workers need to modify and adjust the specific software engineering codes when the service needs to be modified, realizing rapid configuration, completion delivery and rapid modification maintenance when the service development or service modification needs are met, and improving the overall working efficiency of the service development.
Drawings
Fig. 1 is a schematic structural diagram of a hardware operating environment of a terminal device according to a method of an embodiment of the present invention;
FIG. 2 is a schematic flow chart of an embodiment of a SQL configuration-based service development method according to the present invention;
FIG. 3 is a detailed flowchart of step S201 in an embodiment of the method for developing services based on SQL configuration according to the present invention;
FIG. 4 is a detailed flowchart of step S2300 in an embodiment of the SQL configuration-based service development method of the present invention;
FIG. 5 is a schematic flow chart of another embodiment of the SQL configuration-based business development method of the present invention;
FIG. 6 is a schematic view of an application scenario involved in an embodiment of a SQL configuration-based service development method according to the present invention;
fig. 7 is a schematic diagram of functional modules of the SQL-configuration-based service development apparatus according to the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The main solution of the embodiment of the invention is as follows: acquiring a file interface of a service system to be developed; configuring the file interface based on the SQL statement and a preset general configuration rule; and acquiring configuration information obtained by configuring the file interface, and generating a development file of the service system to be developed according to the configuration information.
In the development process of a traditional software project, an SQL statement is usually directly written in an engineering code of software, when a software service changes, the software engineering code needs to be modified to complete a corresponding service change, and the operation is complex and takes a long time. Thus, in the strong market competition that software business changes frequently and delivery is generally required to be completed in a short time, the traditional mode of writing SQL statements in codes for business development is difficult to meet the development requirement.
The solution provided by the invention combines the SQL sentence and the preset general configuration rule suitable for the characteristics of the file interface of the service system to be developed, configures the file interface of the service system to be developed, and then generates the development file of the service system to be developed correspondingly according to the configuration information of the file interface obtained after configuring the file interface, so that the SQL sentence is not required to be compiled in a specific software engineering code, the problems of complex operation and long time consumption caused by the fact that a worker needs to modify and adjust the specific software engineering code when the service needs to be modified are avoided, the rapid configuration can be carried out to complete delivery and rapid modification maintenance when the service development or service modification needs are met, and the overall working efficiency of the service development is improved.
As shown in fig. 1, fig. 1 is a schematic device structure diagram of a hardware operating environment related to a terminal device according to an embodiment of the present invention.
The terminal equipment of the embodiment of the invention can be a PC, and can also be terminal equipment such as a smart phone, a tablet computer, a portable computer and the like.
As shown in fig. 1, the terminal device may include: a processor 1001, such as a CPU, a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface). The memory 1005 may be a high-speed RAM memory or a non-volatile memory (e.g., a magnetic disk memory). The memory 1005 may alternatively be a storage device separate from the processor 1001.
Optionally, the terminal device may further include a camera, a Radio Frequency (RF) circuit, a sensor, an audio circuit, a WiFi module, and the like. Such as light sensors, motion sensors, and other sensors. In particular, the light sensor may include an ambient light sensor that adjusts the brightness of the display screen based on the ambient light level and a proximity sensor that turns off the display screen and/or backlight when the device is moved to the ear. As one of the motion sensors, the gravity acceleration sensor can detect the magnitude of acceleration in each direction (generally, three axes), detect the magnitude and direction of gravity when the device is stationary, and can be used for applications of recognizing the device posture (such as horizontal and vertical screen switching, related games, magnetometer posture calibration), vibration recognition related functions (such as pedometer and tapping), and the like; of course, the mobile terminal may also be configured with other sensors such as a gyroscope, a barometer, a hygrometer, a thermometer, and an infrared sensor, which are not described herein again.
Those skilled in the art will appreciate that the device architecture shown in fig. 1 does not constitute a limitation of the terminal device, and in other embodiments, the terminal device may include more or fewer components than shown, or some components may be combined, or a different arrangement of components.
As shown in fig. 1, a memory 1005, which is a kind of computer storage medium, may include therein an operating system, a network communication module, a user interface module, and a business development program based on configuration SQL.
In the terminal device shown in fig. 1, the network interface 1004 is mainly used for connecting to a backend server and performing data communication with the backend server; the user interface 1003 is mainly used for connecting a client (user side) and performing data communication with the client; and the processor 1001 may be configured to call the configuration SQL-based business development program stored in the memory 1005 and perform the following steps:
acquiring a file interface of a service system to be developed;
configuring the file interface based on the SQL statement and a preset general configuration rule;
and acquiring configuration information obtained by configuring the file interface, and generating a development file of the service system to be developed according to the configuration information.
Further, the processor 1001 may be configured to call a business development program based on configuration SQL stored in the memory 1005, and further perform the following steps:
and configuring the file interface in a preset database and/or a configuration center based on SQL statements and preset general configuration rules.
Further, the processor 1001 may be configured to call a business development program based on configuration SQL stored in the memory 1005, and further perform the following steps:
reading SQL query statements to be configured of the file interface, generating a file format and a path, and uploading a file to a server;
and configuring the SQL query statement to be configured, the format and the path of the generated file and the file uploading server mode in a preset database and/or a configuration center based on the SQL statement and a preset general configuration rule.
Further, the processor 1001 may be configured to call a business development program based on configuration SQL stored in the memory 1005, and further perform the following steps:
and extracting configuration information obtained by configuring the file interface from the database and/or the configuration center, and adjusting the configuration information.
Further, the configuration information includes, but is not limited to: the SQL query statement and the generated file format and path, the processor 1001 may be configured to call the service development program based on the configuration SQL stored in the storage 1005, and further perform the following steps:
acquiring an SQL query statement obtained by configuring the file interface and generating a file format and a path;
detecting a field sequence of a query result obtained based on executing the SQL query statement;
and generating a development file of the service system to be developed according to the format and the path of the generated file and the field sequence.
Further, the processor 1001 may be configured to call the service development program based on the configuration SQL stored in the memory 1005, and after executing the step of acquiring the file interface of the service system to be developed, further execute the following steps:
and acquiring the interface characteristics of the file interface, and generating the preset general configuration rule according to the interface characteristics.
Further, the processor 1001 may be configured to call a business development program based on configuration SQL stored in the memory 1005, and further perform the following steps:
and acquiring the public information in the SQL statement based on public configuration.
And outputting the target structure data to a front-end page of the business development device based on the configuration SQL so as to display the log data associated with the index tag.
The specific embodiment of the terminal device involved in the service development method based on the configuration SQL is basically the same as each specific embodiment of the service development method based on the configuration SQL, and is not described herein again.
The invention provides a business development method based on configuration SQL.
Referring to fig. 2, fig. 2 is a schematic flow chart of a first embodiment of the service development method based on the configuration SQL, which is applied to the terminal device, in this embodiment, the service development method based on the configuration SQL includes:
step S100, acquiring a file interface of a service system to be developed;
and the terminal equipment detects and acquires all file interfaces of the business system to be developed which is applied based on SQL configuration currently.
It should be noted that, in this embodiment, a large number of file interfaces exist in the to-be-developed-service system to which the SQL development tool applied by the worker is actually applied, and when performing service development, the worker may specifically query, based on the compiled SQL query statement, all contents of the file interface, differences between the interface type to which the file interface belongs and file interfaces of different interface types when interfacing with a third-party external system, and features of the uses of the file interfaces (generally, the use is applied to data synchronization).
Further, referring to fig. 5, in an embodiment, after step S100, the method for developing a service based on configured SQL in the present invention may further include:
step S400, acquiring the interface characteristics of the file interface, and generating the preset general configuration rule according to the interface characteristics.
After detecting and acquiring all file interfaces of a to-be-developed service system applied by current SQL configuration, the terminal device further acquires the respective contents of all the file interfaces, the difference between the interface types and the file interfaces of different interface types when the file interfaces are connected with a third-party external system, the application and other interface characteristics, and then correspondingly sets a set of preset general configuration rules which can be suitable for the respective interface characteristics of all the file interfaces so as to directly configure and realize all the file interfaces of the to-be-developed service system according to the preset general configuration rules when SQL development tools are used for service development.
In this embodiment, based on obtaining all the file interfaces of the service system to be developed, which are applied based on the SQL configuration, and the respective contents of all the file interfaces, the differences between the interface types and the file interfaces of different interface types when the third-party external system is docked, and the interface characteristics such as the usage, a set of preset general configuration rules applicable to the respective interface characteristics of all the file interfaces is correspondingly set, and all the file interfaces of the service system to be developed are directly configured according to the preset general configuration rules when the service development is performed, so that it is realized that each file interface can be realized without writing the SQL configuration in the engineering code, thereby avoiding frequent modification of the code in the service project delivery process, greatly simplifying the subsequent service release process, and accelerating the service response.
S200, configuring the file interface based on the SQL statement and a preset general configuration rule;
after acquiring all file interfaces of the business system to be developed, which is applied to be developed and is based on SQL configuration, the terminal equipment sequentially configures and realizes all the file interfaces according to the SQL sentences of the applied SQL development tools and preset general configuration rules which are generated in advance based on the respective interface characteristics of all the file interfaces.
Step S300, obtaining configuration information obtained by configuring the file interface, and generating a development file of the service system to be developed according to the configuration information.
After the terminal device sequentially configures and realizes all file interfaces according to a preset general configuration rule based on an SQL statement, the terminal device further acquires respective configuration information of all the file interfaces after configuring the all the file interfaces, and therefore a development file of a business system to be developed and applied based on the SQL configuration at present is automatically generated based on the configuration information.
Specifically, for example, in the application scenario shown in fig. 6, after the terminal device sequentially configures all the file interfaces of the business system to be developed based on the SQL statement of the SQL development tool used and according to the preset general configuration rule generated by the interface characteristics such as the content of all the file interfaces of the business system to be developed that have been configured and applied in advance based on the current SQL, the difference between the interface types and the file interfaces of different interface types when the external system of the third party is docked, and the usage, the terminal device determines that the business file of the business system to be developed currently starts to be generated if it detects the business file generation instruction triggered by the staff performing the business development, and thus reads all the file interfaces of the business system to be developed that are configured and implemented based on the SQL statement of the SQL development tool used and the preset general configuration rule, the respective SQL configuration and SQL access public information of the file interface, and the file generation format and the directory information are used for obtaining the configuration information of the business system to be developed, and then the business development file of the business system to be developed is automatically generated based on the obtained configuration information.
Further, in an embodiment, the service development method based on the configuration SQL of the present invention may further include:
step S500, acquiring public information in the SQL statement based on public configuration.
After the terminal equipment reads all the file interfaces of the business system to be developed based on the SQL sentences of the applied SQL development tool and the preset general configuration rule configuration, when the respective SQL access public information of the file interfaces, the access public information of the SQL sentences of the file interfaces can be directly obtained from the public configuration of the current business system to be developed. Specifically, for example, when information such as a public holiday of the file interface is obtained, the information can be directly obtained from the public configuration of the current business system to be developed.
In the embodiment, all file interfaces of the currently applied business system to be developed based on SQL configuration are detected and acquired through the terminal equipment; then acquiring the respective contents of all the file interfaces, the difference between the interface types and the file interfaces of different interface types when the file interfaces are connected with a third-party external system, the purpose and other interface characteristics, and then correspondingly setting a set of preset general configuration rules which can be suitable for the respective interface characteristics of all the file interfaces; then, based on SQL sentences of the applied SQL development tools, sequentially configuring all the file interfaces according to preset general configuration rules which are generated in advance based on respective interface characteristics of all the file interfaces; and finally, the terminal equipment further acquires the respective configuration information of all the file interfaces after the configuration is carried out on all the file interfaces, so that the development file of the business system to be developed and applied based on the SQL configuration is automatically generated based on the configuration information.
The method and the device realize that SQL sentences do not need to be written in specific software engineering codes, avoid the problems that when the service needs to be modified, workers need to modify and adjust the specific software engineering codes, the operation is complex and the time consumption is long, can carry out rapid configuration to complete delivery and rapid modification maintenance when the service development or service modification needs are met, and improve the overall working efficiency of the service development.
Further, on the basis of the first embodiment of the service development method based on the configuration SQL, a second embodiment of the service development method based on the configuration SQL is proposed, in this embodiment, the step S200 of configuring the file interface based on the SQL statement and the preset general configuration rule may include:
step S201, configuring the file interface based on the SQL statement and the preset general configuration rule in a preset database and/or a configuration center.
The terminal equipment sequentially configures all file interfaces in a preset database and/or a configuration center according to preset general configuration rules generated by respective interface characteristics of all the file interfaces of the business system to be developed based on the SQL sentences of the applied SQL development tool and on the basis of the acquired interface characteristics.
It should be noted that, in this embodiment, the preset database and the configuration center are any databases and configuration centers that are independent from the service system to be developed, which is applied by the current SQL development tool, and the database and the configuration center are dedicated to record and store the configuration of the file interface of the service system to be developed based on the SQL statements of the applied SQL development tool.
Further, in an embodiment, when the terminal device configures and implements a file interface of the service system to be developed based on SQL statements and according to preset general configuration rules in any database and/or configuration center that is independent from the service system to be developed and applied by the current SQL development tool, distributed parallel configuration may be employed to implement a file interface configuration task in each database and/or configuration center, so as to further promote the response of service development.
Further, referring to fig. 3, fig. 3 is a detailed flowchart illustrating step S201 in the above embodiment, where step S201 may include:
step S2011, reading SQL query statements to be configured of the file interface, generating a file format and a path, and uploading a file to a server;
specifically, in this embodiment, before the terminal device starts to configure and implement all file interfaces based on the SQL statements of the applied SQL development tool according to the preset general configuration rules generated in advance based on the respective interface characteristics of all file interfaces of the to-be-developed service system, the terminal device sequentially reads out the to-be-configured SQL query statements, the generated file formats and paths on all the file interfaces, and the file upload server manner waiting for configuration information from the service development requirements of the current to-be-developed service system.
It should be noted that, in this embodiment, it can be understood that, based on different requirements of actual applications, in other actual application scenarios, the information to be configured on each file interface read by the terminal device from the service development requirement may certainly include other information besides the SQL query statement, the generated file format and path, and the file upload server method listed in this embodiment.
Step S2012, in a preset database and/or configuration center, configuring, based on the SQL statement and a preset general configuration rule, a format and a path of the SQL query statement to be configured, and a file uploading server mode.
Specifically, the terminal device may configure, based on the SQL statements of the applied SQL development tool and according to a preset general configuration rule, the SQL query statements, the generated file format and path, and the file upload server manner of each file interface in sequence only in any database mutually independent from the business system to be developed applied by the current SQL development tool, so as to configure and implement all the file interfaces;
or, the terminal device may also configure the SQL query statement, the generated file format and path, and the file upload server mode of each file interface in sequence based on the SQL statement of the applied SQL development tool and according to the preset general configuration rule only in any configuration center mutually independent from the service system to be developed applied by the current SQL development tool, so as to configure and implement all the file interfaces;
or, the terminal device may configure, in any database independent of the business system to be developed applied by the current SQL development tool, the respective SQL query statements, generated file formats and paths, and the file upload server manner of a part of the file interfaces in sequence based on the SQL statements of the applied SQL development tool and according to a preset general configuration rule, and configure, in any configuration center independent of the business system to be developed applied by the current SQL development tool, the respective SQL query statements, generated file formats and paths, and the file upload server manner of another part of the remaining file interfaces in sequence based on the SQL statements of the applied SQL development tool and according to a preset general configuration rule, thereby configuring and implementing all the file interfaces.
Further, in an embodiment, the service development method based on the configuration SQL of the present invention may further include:
step S600, extracting configuration information obtained by configuring the file interface from the database and/or the configuration center, and adjusting the configuration information.
The terminal equipment extracts SQL sentences based on the applied SQL development tool from any database and/or configuration center which is independent from the service system to be developed and applied by the current SQL development tool, configures configuration information for realizing a file interface of the service system to be developed in the database and/or the configuration center according to a preset general configuration rule, and correspondingly modifies or adjusts the configuration information based on problems or service change requirements in a service release test process.
Specifically, in this embodiment, if the terminal device detects that there is an operation problem in the configuration of any file interface in the service release test process, the terminal device extracts an SQL statement based on the applied SQL development tool from any database and/or configuration center that is independent of the service system to be developed, which is applied by the current SQL development tool, configures, according to a preset general configuration rule, configuration information such as an SQL query statement, a generated file format and path, and a file upload server method for implementing the file interface with the operation problem in the database and/or configuration center, and modifies the configuration information according to the operation problem;
or, in a new service development task detected by the terminal device, a change requirement for the configuration of any file interface exists, the terminal device extracts an SQL statement based on the applied SQL development tool from any database and/or configuration center that is independent of a service system to be developed, which is applied by the current SQL development tool, configures configuration information such as SQL query statements, file formats and paths, file upload server modes, and the like for realizing the file interface with the running problem in the database and/or configuration center according to a preset general configuration rule, and correspondingly adjusts the configuration information according to the change requirement.
In this embodiment, the terminal device sequentially configures, based on an SQL statement of an applied SQL development tool, all file interfaces in a preset database and/or a configuration center according to a preset general configuration rule that has been generated in advance based on the acquired interface characteristics of all file interfaces of the service system to be developed; when detecting that the operation of the file interface has a problem in the service release test and the service has a new change requirement, the terminal device directly extracts the SQL sentence based on the applied SQL development tool from any database and/or configuration center which is independent from the service system to be developed applied by the current SQL development tool, configures the configuration information for realizing the file interface of the service system to be developed in the database and/or configuration center according to the preset general configuration rule, and correspondingly modifies or adjusts the configuration information based on the problem or the service change requirement in the service release test process.
The configuration of the file interface and the service development can be realized without compiling SQL sentences in specific software engineering codes, and the problems of complicated operation and long time consumption caused by the fact that workers need to modify and adjust the specific software engineering codes when the follow-up service release test needs to be modified are solved; in addition, the information such as SQL query statements, generated file formats and paths, file uploading server modes and the like is configured in a database or other configuration centers which are mutually independent from a business system to be developed, rather than being directly written in engineering codes, so that the SQL query statement query logic can be rapidly changed and the information such as the generated file formats and paths, the file uploading server modes and the like can be conveniently adjusted when business changes occur, the development requirements of business of enterprises at present are met to a great extent, and the standardization and configuration capabilities of business development are improved.
Further, on the basis of the first embodiment of the service development method based on the configuration SQL, the third embodiment of the service development method based on the configuration SQL is proposed, and in this embodiment, the configuration information obtained by configuring the file interface includes, but is not limited to: referring to fig. 4, fig. 4 is a detailed flowchart of the step S300, where in the step S300, the obtaining configuration information obtained by configuring the file interface and generating a development file of the service system to be developed according to the configuration information may include:
step S301, obtaining SQL query statements obtained by configuring the file interface and generating a file format and a path;
after the terminal device sequentially configures and realizes all file interfaces of the applied business system to be developed based on the SQL sentences according to the preset general configuration rule, the terminal device further acquires the SQL query sentences and the configuration information such as the generated file format, the path and the like of all the file interfaces after configuring the all the file interfaces.
Step S302, detecting a field sequence of a query result obtained based on the execution of the SQL query statement;
step S303, generating a development file of the service system to be developed according to the format and the path of the generated file and the field sequence.
And the terminal equipment detects the field sequence of the query result obtained by executing the SQL query statement based on the obtained SQL query statement of the file interface, and automatically generates the service development file of the currently applied service system to be developed by taking the field sequence as the field sequence in the finally generated file according to the generated file format and path of the obtained file interface.
Further, in another embodiment, after the terminal device obtains the configuration for all the file interfaces, the respective SQL query statement of all the file interfaces and the configuration information such as the generated file format, the path and the like can be obtained, and simultaneously, the respective file uploading server mode of all the file interfaces can be obtained, therefore, taking the field sequence of the query result obtained based on the SQL query statement of each file interface as the field sequence in the final generated file according to the format and path of the generated file of each file interface, after the service development file of the currently applied service system to be developed is automatically generated, the service development file is uploaded to a server by the service system to be developed according to a file uploading server mode, and therefore the service development work aiming at the service system to be developed is completed.
In this embodiment, after the terminal device sequentially configures all file interfaces of the to-be-developed service system based on the SQL statements and according to the preset general configuration rule, the terminal device further obtains configuration information such as SQL query statements and generated file formats and paths of all the file interfaces after configuring all the file interfaces, and the terminal device detects a field sequence of a query result obtained based on execution of the SQL query statements based on the obtained SQL query statements of each file interface, and automatically generates a service development file of the currently-applied to-be-developed service system with the field sequence as a field sequence in a finally-generated file according to the generated file formats and paths of each obtained file interface.
The configuration of the file interface and the service development can be realized without compiling SQL sentences in specific software engineering codes, the problems that when the subsequent service release test needs to be modified, workers need to modify and adjust the specific software engineering codes, the operation is complex and the time consumption is long are solved, quick response can be carried out aiming at the service development or the service modification so as to complete delivery or quickly complete modification maintenance, and the overall working efficiency of the service development is improved.
In addition, the present invention also provides a service development device based on the configuration SQL referring to fig. 7, fig. 7 is a schematic diagram of a functional module of the service development device based on the configuration SQL according to the present invention, and the service development device based on the configuration SQL includes:
the acquisition module 101 is used for acquiring a file interface of a service system to be developed;
the configuration module 102 is configured to configure the file interface based on an SQL statement and a preset general rule;
the development module 103 is configured to obtain configuration information obtained by configuring the file interface, and generate a development file of the service system to be developed according to the configuration information.
Preferably, the module 102 is further configured to:
and configuring the file interface in a preset database and/or a configuration center based on SQL statements and preset general configuration rules.
Preferably, the configuration module 102 includes:
the reading unit is used for reading SQL query statements to be configured of the file interface, generating a file format and a path and uploading a file to a server;
and the configuration unit is used for configuring the SQL query statement to be configured, the format and the path of the generated file and the file uploading server mode in a preset database and/or a configuration center based on the SQL statement and a preset general configuration rule.
Preferably, the service development device based on the configuration SQL further includes:
and the adjusting module is used for extracting configuration information obtained by configuring the file interface from the database and/or the configuration center and adjusting the configuration information.
Preferably, the configuration information includes, but is not limited to: SQL query statements and generated file formats and paths, the development module 103, comprising:
the acquisition unit is used for acquiring SQL query statements obtained by configuring the file interface and generating a file format and a path;
the detection unit is used for detecting the field sequence of the query result obtained based on the execution of the SQL query statement;
and the file generating unit is used for generating a development file of the service system to be developed according to the format and the path of the generated file and the field sequence.
Preferably, the service development device based on the configuration SQL further includes:
and the rule generating module is used for acquiring the interface characteristics of the file interface and generating the preset general configuration rule according to the interface characteristics.
Preferably, the obtaining module 101 of the service development device based on the configuration SQL is further configured to obtain the public information in the SQL statement based on public configuration.
The specific implementation of the service development device based on the configuration SQL is basically the same as that of the service development method based on the configuration SQL, and the detailed description is omitted here
Furthermore, the present invention also provides a computer readable storage medium storing one or more programs, the one or more programs being executable by one or more processors for:
acquiring a file interface of a service system to be developed;
configuring the file interface based on the SQL statement and a preset general configuration rule;
and acquiring configuration information obtained by configuring the file interface, and generating a development file of the service system to be developed according to the configuration information.
Further, the one or more programs are also executable by the one or more processors to:
and configuring the file interface in a preset database and/or a configuration center based on SQL statements and preset general configuration rules.
Further, the one or more programs are also executable by the one or more processors to:
reading SQL query statements to be configured of the file interface, generating a file format and a path, and uploading a file to a server;
and configuring the SQL query statement to be configured, the format and the path of the generated file and the file uploading server mode in a preset database and/or a configuration center based on the SQL statement and a preset general configuration rule.
Further, the one or more programs are also executable by the one or more processors to:
and extracting configuration information obtained by configuring the file interface from the database and/or the configuration center, and adjusting the configuration information.
Further, the configuration information includes, but is not limited to: SQL query statements and generating file formats and paths, the one or more programs further executable by the one or more processors to:
acquiring an SQL query statement obtained by configuring the file interface and generating a file format and a path;
detecting a field sequence of a query result obtained based on executing the SQL query statement;
and generating a development file of the service system to be developed according to the format and the path of the generated file and the field sequence.
Furthermore, after the step of obtaining the file interface of the business system to be developed is performed, the one or more programs are further executable by the one or more processors to:
and acquiring the interface characteristics of the file interface, and generating the preset general configuration rule according to the interface characteristics.
Further, the one or more programs are also executable by the one or more processors to:
and acquiring the public information in the SQL statement based on public configuration.
The specific implementation manner of the computer-readable storage medium of the present invention is substantially the same as that of each embodiment of the above-mentioned SQL-based service development method, and is not described herein again.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (such as a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A business development method based on configuration SQL is characterized in that the business development method based on configuration SQL comprises the following steps:
acquiring a file interface of a service system to be developed;
configuring the file interface based on the SQL statement and a preset general configuration rule;
and acquiring configuration information obtained by configuring the file interface, and generating a development file of the service system to be developed according to the configuration information.
2. The business development method based on configured SQL according to claim 1, wherein the step of configuring the file interface based on SQL statements and preset general configuration rules comprises:
and configuring the file interface in a preset database and/or a configuration center based on SQL statements and preset general configuration rules.
3. The business development method based on configuration SQL according to claim 2, wherein the step of configuring the file interface based on SQL statements and preset general configuration rules in a preset database and/or configuration center comprises:
reading SQL query statements to be configured of the file interface, generating a file format and a path, and uploading a file to a server;
and configuring the SQL query statement to be configured, the format and the path of the generated file and the file uploading server mode in a preset database and/or a configuration center based on the SQL statement and a preset general configuration rule.
4. The business development method based on configuration SQL according to claim 2 or 3, further comprising:
and extracting configuration information obtained by configuring the file interface from the database and/or the configuration center, and adjusting the configuration information.
5. The method of business development based on configured SQL as claimed in claim 1, where the configuration information includes but is not limited to: SQL query statements and generate file formats and paths,
the step of obtaining configuration information obtained by configuring the file interface and generating a development file of the service system to be developed according to the configuration information includes:
acquiring an SQL query statement obtained by configuring the file interface and generating a file format and a path;
detecting a field sequence of a query result obtained based on executing the SQL query statement;
and generating a development file of the service system to be developed according to the format and the path of the generated file and the field sequence.
6. The business development method based on configuration SQL according to claim 1, after the step of obtaining the file interface of the business system to be developed, further comprising:
and acquiring the interface characteristics of the file interface, and generating the preset general configuration rule according to the interface characteristics.
7. The method for business development based on configuration SQL as claimed in claim 1, further comprising:
and acquiring the public information in the SQL statement based on public configuration.
8. A business development device based on configuration SQL is characterized in that the business development device based on configuration SQL comprises:
the acquisition module is used for acquiring a file interface of a service system to be developed;
the configuration module is used for configuring the file interface based on SQL sentences and preset general rules;
and the development module is used for acquiring configuration information obtained by configuring the file interface and generating a development file of the service system to be developed according to the configuration information.
9. A terminal device, characterized in that the terminal device comprises: a memory, a processor, a communication bus, and a configuration SQL based business development program stored on the memory,
the communication bus is used for realizing communication connection between the processor and the memory;
the processor is used for executing the internet based service development program based on the configuration SQL to realize the steps of the service development method based on the configuration SQL according to any claim 1 to 7.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium has stored thereon a configuration SQL-based business development program, which when executed by a processor implements the steps of the configuration SQL-based business development method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010756729.7A CN111857672A (en) | 2020-07-30 | 2020-07-30 | Business development method, device, equipment and medium based on SQL configuration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010756729.7A CN111857672A (en) | 2020-07-30 | 2020-07-30 | Business development method, device, equipment and medium based on SQL configuration |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111857672A true CN111857672A (en) | 2020-10-30 |
Family
ID=72952681
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010756729.7A Pending CN111857672A (en) | 2020-07-30 | 2020-07-30 | Business development method, device, equipment and medium based on SQL configuration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111857672A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112308431A (en) * | 2020-11-03 | 2021-02-02 | 平安普惠企业管理有限公司 | Big data index management method, device, equipment and storage medium |
| CN113537943A (en) * | 2021-07-30 | 2021-10-22 | 苏州工业园区测绘地理信息有限公司 | Universal workflow engine and construction method thereof |
-
2020
- 2020-07-30 CN CN202010756729.7A patent/CN111857672A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112308431A (en) * | 2020-11-03 | 2021-02-02 | 平安普惠企业管理有限公司 | Big data index management method, device, equipment and storage medium |
| CN112308431B (en) * | 2020-11-03 | 2023-11-21 | 北京国联视讯信息技术股份有限公司 | Big data index management method, device, equipment and storage medium |
| CN113537943A (en) * | 2021-07-30 | 2021-10-22 | 苏州工业园区测绘地理信息有限公司 | Universal workflow engine and construction method thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106970790B (en) | Application program creating method, related equipment and system | |
| CN111078556B (en) | Application testing method and device | |
| CN108415741B (en) | Object serialization and deserialization method and related device | |
| WO2014206055A1 (en) | A method and system for generating a user interface | |
| CN108073495B (en) | Method and device for positioning crash reason of application program | |
| CN109215640B (en) | Speech recognition method, intelligent terminal and computer readable storage medium | |
| CN104281568B (en) | Paraphrasing display method and paraphrasing display device | |
| CN112116690B (en) | Video special effect generation method, device and terminal | |
| WO2021110133A1 (en) | Control operation method and electronic device | |
| CN111857672A (en) | Business development method, device, equipment and medium based on SQL configuration | |
| US9977661B2 (en) | Method and system for generating a user interface | |
| CN111723002A (en) | Code debugging method and device, electronic equipment and storage medium | |
| EP2869604B1 (en) | Method, apparatus and device for processing a mobile terminal resource | |
| CN113377469A (en) | Business interface display method and device for mobile application, terminal and storage medium | |
| CN108984374B (en) | Method and system for testing database performance | |
| CN111783197A (en) | Construction method of three-dimensional building model and related equipment | |
| CN112965832A (en) | Remote Procedure Call (RPC) service calling method and related device | |
| KR20210101583A (en) | Electronic device and method for operating contents using the same | |
| CN114020850B (en) | Database data synchronization method, device, equipment and readable storage medium | |
| CN112987597B (en) | FSU control method, device, equipment and computer readable storage medium | |
| CN110570864A (en) | Communication method and system based on cloud server and cloud server | |
| US11481089B2 (en) | Graphical user interface to configure parameters of an API based on user inputs | |
| CN115686506A (en) | Data display method and device, electronic equipment and storage medium | |
| CN113672311A (en) | Structure assignment method, assigner and computer-readable storage medium | |
| CN113934618A (en) | Interface test case generation method, device, generator and readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |