Data table creating method, device and equipment and computer readable storage medium

A data table and data row technology, applied in the database field, can solve problems such as spending time for developers and testers

Pending Publication Date: 2019-04-26
PING AN TECH (SHENZHEN) CO LTD
View PDF3 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The main purpose of the present invention is to provide a data table creation method, device, equipment and computer-readable storage medium, aiming at solving the problem of creating a data table in a database according to the code developed by a developer in the prior art, which requires Issues with high developer and tester time

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
  • Data table creating method, device and equipment and computer readable storage medium
  • Data table creating method, device and equipment and computer readable storage medium
  • Data table creating method, device and equipment and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0048] The invention provides a method for creating a data table.

[0049] Please refer to figure 1 , figure 1 It is a schematic flowchart of the first embodiment of the data table creation method of the present invention. In this embodiment, the data table creation method includes:

[0050] Step S10, when receiving the table creation file, read the owner information and name information in the table creation file, and transmit the owner information and the name information to the preset sentence to generate a sentence prefix code ;

[0051] The method for creating a data table of the invention is applied to a server, and is suitable for creating a data table in a database through the server. Specifically, when the developer of the database development needs to create a data table in the database, he first writes t...

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 discloses a data table creation method and device, equipment and a computer readable storage medium, and the method comprises the steps: reading the owner information and name information in a table building file when the table building file is received, transmitting the owner information and the name information to a preset statement, and generating a sentence first code; Traversingall the data lines in the table building file, reading character strings of all the cells in all the data lines one by one, and splicing all the character strings based on the data lines to generatemain body codes; And generating a table building code by using the sentence head code and the main body code, and controlling the table building code to run so as to create the data table. According to the scheme, the table building codes are generated by splicing the character strings in the table building file, so that compiling by developers is avoided; Meanwhile, updating of the table structure is achieved through updating of the character strings in the table building file, synchronous updating between the table building codes and the table building file is guaranteed, and the developmentand test efficiency of the data table is improved.

Description

technical field [0001] The present invention mainly relates to the technical field of databases, in particular to a data table creation method, device, equipment and computer-readable storage medium. Background technique [0002] The data table in the database is created through the table building code, and the table building code is written by the developer; and the process of creating a new data table in the database is relatively fixed. The developer first writes the development document, and then writes the corresponding document based on the development document. SQL (Structured Query Language, Structured Query Language) statement, and then create a data table from the table-building code formed by the written SQL statement. [0003] Although the syntax of the written SQL statement is simple, the process is cumbersome, developers have different styles, and are prone to errors, which require a lot of time for developers and testers to develop and test; at the same time, ...

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): G06F16/22G06F8/30
CPCG06F8/31
Inventor 文玎玲
Owner PING AN TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products