Method and device for controlling automatic expansion of batch table data

Abstract

The invention provides a method for controlling automatic expansion of batch table data. The method comprises the following steps: a, determining all table fields, public fields and all fields of two to-be-expanded tables on the basis of table structures of the to-be-expanded tables; b, filtering all table fields of the to-be-expanded tables according to feature table field data in feature public fields of the to-be-expanded tables, and taking all field data which has a corresponding relation with the feature table field data and is except the feature public fields as a first query result; c, splicing the increment value of the public field by taking a feature expansion strategy as a basic unit to obtain auxiliary table data expanded by N times, determining a public field enumeration value by taking the public fields of the to-be-expanded tables as a group, and determining a second query result after filtering the public field enumeration value in the auxiliary table data; and d, performing Cartesian product on the first query result and the second query result to determine a to-be-inserted virtual table, and inserting the to-be-inserted virtual table into the to-be-expanded tables to form final expanded table data. The method is simple to operate and powerful in function, and has commercial value.

Description

technical field [0001] The invention belongs to the technical field of program development, and in particular relates to a control method and device for automatic expansion of batch table data. Background technique [0002] In ACCESS, a table (TABLE) is an object used to store data in a database, a collection of structured data, and the basis of the entire database system. A facility for storing data in a SQL database. A table is a database object that contains all the data in the database. A table is defined as a collection of columns. Similar to a spreadsheet, data is organized in a table in a row and column format. Each column in a table is designed to store some type of information (such as a date, name, dollar amount, or number). Several controls (constraints, rules, default values, and custom user data types) on tables are used to ensure data validity. [0003] In the process of application system testing, it is often necessary to use a large amount of table data ...

AI Technical Summary

Problems solved by technology

[0003] In the process of application system testing, it is often necessary to use a large amount of table data as a support, but in the actual operation process, there is very little table data available, and it is even unable to meet the test of scenarios such as cross-day, cross-week, cross-month, and cross-year need

At this time, technicians are required to write data expansion SQL. However, such repetitive work requires a lot of manpower and time. Specifically, manual expansion is required one by one, which greatly affects work efficiency.

[0004] How to implement SQL expansion for automatic splicing data, without manually writing SQL; Improving test efficiency and avoiding repetitive work has become a technical problem that needs to be solved urgently. At present, there is no specific method that can effectively solve the above problems in the market, especially a control method and device for automatic expansion of batch table data.

Images