Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Addition, deletion, modification and check service interface generation method based on database metadata

A technology of adding, deleting, modifying and checking service interfaces, which is applied in the field of generating, adding, deleting, modifying and checking service interfaces based on database metadata to achieve the effects of ensuring security, saving costs and improving development efficiency.

Pending Publication Date: 2022-05-06
江苏南大先腾信息产业股份有限公司
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention is aimed at the problems existing in the prior art, and provides a method for generating a service interface for adding, deleting, modifying and querying based on database metadata. In scenarios such as relationship and data structure changes, it is necessary to rewrite the SQL to generate additions, deletions, changes, and query service interfaces. At the same time, the user access rights can be controlled by configuring the properties of the interface to ensure the data security of the interface.

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
  • Addition, deletion, modification and check service interface generation method based on database metadata
  • Addition, deletion, modification and check service interface generation method based on database metadata
  • Addition, deletion, modification and check service interface generation method based on database metadata

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0032] Embodiment 1: see figure 1 As shown, a method for generating a CRUD service interface based on database metadata includes the following steps:

[0033] Step 1. Pre-data preparation of metadata,

[0034] Step 1.1 The user configures the business database through the front-end page;

[0035] Step 1.2 Configure a scheduled task on the metadata management page, and automatically read all tables, fields of tables, and data in the table into the metadata list through JDBC;

[0036] Step 1.3 The metadata list displays the tables and table structures in the business database: including table names, field names, field types, and field descriptions;

[0037] Step 1.4 The user selects the data table and configures the field length, accuracy, and type of the data table; business attributes can also be modified, such as primary key generation rules; field generation rules and the use of foreign keys and constraint relationships between tables to configure data association tables ...

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 relates to a method for generating an addition, deletion, modification and check service interface based on database metadata. The method specifically comprises the following steps: step 1, preparing data in the earlier stage of the metadata; 2, determining a table Id corresponding to the main table according to the UUID and the data table name; and step 3, generating a database metadata addition, deletion, modification and check API interface. The technical scheme has the advantages that the method adapts to scenes with complex inter-table relations; the method adapts to data structure change scenes; the user permission can be controlled by configuring the attribute of the API, the safety of the interface is ensured, the workload of manually and repeatedly compiling the SQL statement is reduced, and the development efficiency is improved.

Description

technical field [0001] The invention relates to a generation method, in particular to a method for generating a service interface for adding, deleting, modifying and checking based on database metadata, and belongs to the technical field of database metadata processing. Background technique [0002] With the rapid development of information technology and the continuous increase of data, there are more and more demands for adding, deleting, modifying and querying data between multiple tables. [0003] 1. When there are many data tables and the relationship between the tables is complex, it is necessary to manually match the fields between the tables, and it is difficult to quickly and conveniently combine the data from multiple data tables into one data set for adding, deleting, modifying and querying the database. [0004] 2. When the data structure changes or different query parameters are required, the SQL can only be rewritten to regenerate the interface, which brings 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/30G06F16/25
CPCG06F8/315G06F16/25
Inventor 张宏峰葛鸣明
Owner 江苏南大先腾信息产业股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com