CN117971933A

CN117971933A - Method for data service low code

Info

Publication number: CN117971933A
Application number: CN202311244370.5A
Authority: CN
Inventors: 王刚; 余福荣
Original assignee: Hangzhou Jiuxin Internet Of Things Science & Technology Co ltd
Current assignee: Hangzhou Jiuxin Internet Of Things Science & Technology Co ltd
Priority date: 2023-09-26
Filing date: 2023-09-26
Publication date: 2024-05-03

Abstract

The invention discloses a method for low codes of data service, which comprises the following steps: a1, creating a new data source in the data sources managed by the menu service; a2, inputting basic configuration of a database, clicking to test connectivity, and creating success after saving; a3, the corresponding database can be directly updated or deleted in the database list; b) Newly-built interface: b1, selecting a new tab page in a navigation panel of the menu workbench, and adding the tab page; b2, writing SQL, writing corresponding business SQL in an edit box, and then running to display a query result in the following result tab; c) Configuring attributes; d) Storing and publishing; compared with the prior art, the system can quickly construct the API, is stable in system, easy to integrate and use, low in cost, operation and maintenance and safe in data.

Description

Method for data service low code

Technical Field

The invention relates to a method for low codes in relation to data services.

Background

If the enterprise digital transformation is compared to a bicycle, then the technology and data are the two wheels of the bicycle, and the riding on the bicycle is enterprise strategy, culture and various resources that determine which direction the transformation will go. Regardless of how accurate the digitally converted path is, tactics are apparent, the end result is to land on both wheels.

In the DT era, "big data" is not emphasized in a large amount, but refers to a large number of data sources and dimensions. Many of the system data are not available to third parties and only breaking this barrier will new value be generated. In the digital intelligent transformation process, the open sharing of data is realized, which is the premise of realizing curve overtaking in DT era for enterprises.

The data sharing service can be simply summarized as sharing data of a data center to other systems or sharing data of a certain organization to other organizations, and the manner of providing data is also quite various, such as database reading, file transmission, API interface service, etc.

The data API is used for providing data service to the outside in a RestfulAPI mode, is suitable for a data service scene that a database is not directly opened to the outside and is provided with high concurrency and quick return through an interface, such as the result data of processing a data center in an enterprise, and is provided for upper data application, a data portal, a visual large screen and the like in a data API mode; stock companies provide market data such as stocks, bonds and the like to external clients through a data API; the new media enterprises provide information to external clients and the like in an API mode, and mainly solve the problem of rapid sharing of data to the outside.

Under the age background of digital transformation, the new demands are greatly increased, the new technology is iterated continuously, the process of internetworking and digitalization is continued to be deep, more and more businesses are migrated to the internet, a great amount of business interaction and external service demands are generated, the demands on API interfaces are increased day by day, and how to quickly promote the open sharing capability of enterprise data is a key proposition of enterprises facing digital transformation.

Conventionally, generating an API interface often requires a back-end developer to write in a language such as Java or Python. The whole process is longer from the start of generation to the release to the outside, authentication, current limiting and the like are performed in the middle, and after one interface is developed, test personnel are required to perform test verification, and the input cost is higher in the whole process. It has the following drawbacks: 1. the development period is long: the development of the API is required to go through the processes of demand scheduling, development stage, testing stage, deployment online and the like; 2. the maintenance cost is high: the number of interfaces is geometrically increased, and the management difficulty is high; the interface is not unified and normative, and the integration cost is high; 3. the system stability is poor: the lack of current limiting and other strategies for coping with high concurrency has poor system stability; 4. the data is incomplete: lack of authentication and authentication capability, and limitation on the calling method; the monitoring capability is lacking, and the calling party cannot be traced.

Disclosure of Invention

The object of the present invention is to solve the problems of the prior art and to propose a method for low code for data services, which solves at least one of the above problems.

To achieve the above object, the present invention provides a method for low code for data service, comprising the steps of:

A) Newly added data sources: a1, creating a new data source in the data sources managed by the menu service; a2, inputting basic configuration of a database, clicking to test connectivity, and creating success after saving; a3, the corresponding database can be directly updated or deleted in the database list;

B) Newly-built interface: b1, selecting a new tab page in a navigation panel of the menu workbench, and adding the tab page; b2, writing SQL, writing corresponding business SQL in an editing frame, and then running to display the query result in the following result tab;

C) Configuration attributes: c1 request parameters: filling in the interface request parameter types and descriptions and paging configuration, the program analyzes the parameter fields conforming to grammar in SQL and automatically fills in the parameter fields into the panel; c2 return parameters: filling back parameter types and descriptions, and automatically filling the fields and aliases returned by the query in SQL (structured query language) into a panel by a program; c3 preview test: after the attribute configuration of the interface is completed, testing and verification are carried out;

D) And storing the release.

Preferably, each database in the step A2 is assigned a connection pool.

Preferably, the default tab in the B2 step is an SQL query preview.

Preferably, the field types in the steps of the C1 request parameter and the C2 return parameter are: string, int, double, array, date.

Preferably, the paging attribute in the step of requesting the parameter by C1 is two configurations of non-paging and paging, and the interface defaults to non-paging.

The application has the beneficial effects that: 1. quick build API: aiming at the traditional mode, a developer is required to conduct customized development according to different apis. According to the application, an operator only needs to perform page configuration, so that a complete and available api can be completed; 2. and (3) system stability: the service is easy to expand and capacity is expanded, so that a high concurrency scene can be solved; 3. easy to integrate and use, low cost operation and maintenance, and safe data.

Drawings

FIG. 1 is a schematic diagram of menu 1;

FIG. 2 is a schematic diagram of menu 2;

FIG. 3 is a schematic diagram of menu 3;

FIG. 4 is a schematic diagram of menu 4;

FIG. 5 is a schematic view of menu 5;

FIG. 6 is a schematic diagram of menu 6;

FIG. 7 is a schematic diagram of menu 7;

fig. 8 is a schematic diagram of menu 8.

Description of the embodiments

Referring to fig. 1, 2,3, 4, 5, 6, 7 and 8, a method for data service low codes according to the present invention comprises the steps of:

a) Newly added data sources: a1, in the data sources managed by the menu service, newly establishing a data source, see menu 1:

A2, after inputting basic configuration of databases, clicking to test connectivity, and creating successfully after saving, wherein each database is distributed with a connection pool, see menu 2:

a3, the corresponding database can be directly updated or deleted in the database list, see menu 3:

B) Newly-built interface: b1, in the menu workbench, the left navigation panel [ database, group ]. Clicking on the right edit box (new) can add a tab page (default tab is SQL query preview), see menu 4:

B2, writing SQL, writing corresponding business SQL in an edit box, and clicking [ running ] to display a query result in the following result tab, wherein the query result is shown in a menu 5:

New addition of ：INSERT INTO t_user(user_name,nick_name,age,create_time) VALUES(#{userName},#{nickName},#{age},now())

Updating: UPDATE t_user set= # { age } whereid= #id }

Deletion: DELETE FROM t_user WHERE id= #id }

C) Configuration attributes: c1 request parameters: in the right panel [ request parameters ], the interface request parameter type and description and paging configuration are filled in. The program can analyze the parameter fields conforming to the grammar [ # { x ] in the SQL and automatically fill the parameter fields into the right panel. Field type: string, int, double, array, date are five types of options. Paging attribute: there are two (non-paged/paged) configurations selectable, the interface defaults to non-paged, see menu 6:

C2 return parameters: in the right panel [ return parameters ], the return parameter type and description are filled in. The program can analyze the fields and aliases returned by the query in SQL (insert/update/delete is not analyzed), automatically fill into the right panel, and the field types are: string, int, double, array, date are five types of options. See menu 7:

C3 preview test: after the attribute configuration of the interface is completed, clicking [ preview ] can be performed for test verification, see menu 8:

D) And storing the release.

The problems which are not solved yet: 1. cross-library queries have not been supported; 2. aiming at multi-table joint query, the query efficiency is low, and service breakdown can be caused by extreme conditions; 3. the supported data sources are limited and cannot cover all databases, e.g. Hive is not supported.

Environment and components:

JDK1.8: a tool bag configured by java running environment;

kafka3.3.0: a high throughput distributed publish-subscribe messaging system that can handle all action flow data of consumers in websites;

sqlite-jdbc: the system is a light database and is a relational database management system which obeys ACID;

CentOS-7.0-1406-x86_64: an operating system.

The above embodiments are illustrative of the present invention, and not limiting, and any simple modifications of the present invention fall within the scope of the present invention.

Claims

1. A method for low code for data services, characterized by: the method comprises the following steps:

D) And storing the release.

2. A method for low code on data services according to claim 1, wherein: each database in the A2 step is assigned a connection pool.

3. A method for low code on data services according to claim 1, wherein: the default tab in step B2 is the SQL query preview.

4. A method for low code on data services according to claim 1, wherein: the field types in the steps of the C1 request parameter and the C2 return parameter are as follows: string, int, double, array, date.

5. A method for low code on data services according to claim 1, wherein: the paging attribute in the step of the C1 request parameter is two configurations of non-paging and paging, and the interface defaults to non-paging.