Method and equipment for describing synchronous database table structure according to model

Abstract

The invention discloses a method and equipment for describing a synchronous database table structure according to a model. The method and equipment are used for solving the technical problem that an existing database table structure description mode cannot effectively manage the database table structure. The method comprises the steps of abstracting a database table structure into a first databaseobject model description; acquiring database connection information and setting information, and constructing a Hibernate service registration constructor; obtaining and analyzing a second database object model description, mapping the second database object model description into an abstract syntax tree, and generating an entity class according to the abstract syntax tree; wherein the second database object model description is obtained by modifying based on the first database object model description; and based on the Hibernate service registration constructor, creating an instance so as togenerate a structured query language according to the difference between the entity class and the database table structure, and synchronizing the database table structure. According to the method, the database table structure is visually and effectively managed and maintained, and it is guaranteed that description of the database table structure and description in the entity class are kept consistent.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular to a method and device for describing a synchronous database table structure according to a model. Background technique [0002] In order to effectively manage the database table structure, the database table structure is often described uniformly to facilitate synchronization of the database table structure. There are three common description methods: [0003] 1. Use an entity mapping framework (such as Hibernate, MyBatis), describe the table structure as an entity in the code, and establish a mapping relationship with the database through annotation or configuration. However, this method does not allow users to directly know how many tables are in the entire product database, nor does it know the specific table structure of each table, which is not intuitive. [0004] 2. Use a separate structure to describe the table structure and manage it. Although this ...

AI Technical Summary

Problems solved by technology

[0006] The embodiment of the present application provides a method and device for describing the structure of the synchronous database table according to the model, to solve the technical problem that the existing method of describing the structure of the database table cannot effectively manage the structure of the database table

Images