CN113407261A

CN113407261A - Data configuration method and device and computer equipment

Info

Publication number: CN113407261A
Application number: CN202110819150.5A
Authority: CN
Inventors: 刘蓓霖; 王集然; 王俊焕; 温鸿玮
Original assignee: Tencent Cyber Shenzhen Co Ltd
Current assignee: Tencent Cyber Shenzhen Co Ltd
Priority date: 2021-07-20
Filing date: 2021-07-20
Publication date: 2021-09-17

Abstract

The application relates to a data configuration method, a data configuration device and computer equipment, wherein the method comprises the following steps: loading an aggregation configuration page of the project based on the aggregation configuration base table; generating an aggregation configuration base table based on table names and head fields of all configuration object worksheets of the items; the aggregation configuration page aggregates all configuration object worksheets; responding to the editing operation of the cells on the aggregation configuration page, determining a configuration object according to the table name of the cells, and obtaining configuration records of the configuration object according to the field name of the cells and the field value filled by the editing operation of the cells; and storing the configuration records in an aggregation configuration base table, and pushing the configuration records to a project server to configure the project based on the aggregation configuration base table. According to the method, the configuration object worksheets of the project are aggregated on one configuration page, and during configuration, a configuration person does not need to open a plurality of configuration object worksheets respectively, so that the method has the advantages of intuition and simplified operation, and can effectively improve the configuration efficiency.

Description

Data configuration method and device and computer equipment

Technical Field

The present application relates to the field of computer technologies, and in particular, to a data configuration method and apparatus, and a computer device.

Background

For an application program, there are some operation items in the operation process, and the operation items need to be configured. As the operating duration of the application increases, when the version of the application is upgraded, the configuration of the operating item also needs to be changed accordingly, that is, the configuration needs to be reconfigured, for example, some configuration objects are added, some configuration objects are deleted, or the content of the configuration objects is adjusted.

Taking an application program as an example of a game, configuration data of many games are basically edited and managed based on a file with a certain format, such as a table, a lua file, a json file or other files with certain formats. The operation activity configuration data is edited and managed based on a certain format file, and a specific game activity function is stored in a single table file or a plurality of table files, namely scattered in a plurality of working tables. Therefore, more than 10 form files and more worksheets are often required to be operated when game activity configuration data are edited, the editing operation is complicated, and the efficiency is low.

Disclosure of Invention

In view of the above, it is necessary to provide a data configuration method, an apparatus, a computer device, and a storage medium capable of improving configuration efficiency.

A method of data configuration, comprising:

loading an aggregation configuration page of the project based on the aggregation configuration base table; the aggregation configuration base table is generated based on the table name and the head field of each configuration object worksheet of the project; the aggregation configuration page aggregates all configuration object worksheets;

responding to the editing operation of the cells on the aggregation configuration page, determining a configuration object according to the table name of the cells, and obtaining configuration records of the configuration object according to the field name of the cells and the field value filled by the editing operation of the cells;

and storing the configuration record in the aggregation configuration base table, and pushing the configuration record to a project server to configure the project based on the aggregation configuration base table.

An apparatus for data configuration, the apparatus comprising:

the aggregation management module is used for loading an aggregation configuration page of the project based on an aggregation configuration library table; the aggregation configuration base table is generated based on the table name and the head field of each configuration object worksheet of the project; the aggregation configuration page aggregates all configuration object worksheets;

the editing management module is used for responding to the editing operation on the cells on the aggregation configuration page, determining a configuration object according to the table name of the cells, and obtaining the configuration record of the configuration object according to the field name of the cells and the field value filled by the editing operation on the cells;

and the issuing module is used for storing the configuration records in the aggregation configuration base table and pushing the configuration records to a project server to configure the project based on the aggregation configuration base table.

A computer device comprising a memory and a processor, the memory storing a computer program, the processor implementing the following steps when executing the computer program:

A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:

According to the data configuration method, the data configuration device, the computer equipment and the storage medium, the configuration object worksheets of the project are aggregated on one configuration page, and during configuration, a configuration person does not need to open a plurality of configuration object worksheets respectively, so that the data configuration method, the data configuration device, the computer equipment and the storage medium have the advantages of intuition and simplified operation, and the configuration efficiency can be effectively improved.

Drawings

FIG. 1 is a diagram of an application environment of a data configuration method in one embodiment;

FIG. 2 is a flow diagram illustrating a data configuration method according to one embodiment;

FIG. 3 is an interface diagram of an aggregation configuration page in one embodiment;

FIG. 4 is a schematic flow diagram illustrating the creation of an aggregate configuration table in one embodiment;

FIG. 5 is a flow diagram that illustrates a reference edit operation, in one embodiment;

FIG. 6 is an interface diagram illustrating a reference edit operation, in one embodiment;

FIG. 7 is a flow diagram that illustrates query operations in one embodiment;

FIG. 8 is an interface diagram illustrating a query operation in one embodiment;

FIG. 9 is a flow diagram illustrating configuration of IDs in one embodiment;

FIG. 10 is a schematic diagram of an interface for configuring IDs in one embodiment;

FIG. 11 is a schematic flow diagram of a suture operation in one embodiment;

FIG. 12 is an interface schematic of a suture operation in one embodiment;

FIG. 13 is a schematic flow diagram of the reduction operation in one embodiment;

FIG. 14 is a schematic interface diagram of a reduction operation in one embodiment;

FIG. 15 is a diagram showing the structure of data arrangement in one embodiment;

FIG. 16 is a diagram illustrating an internal structure of a computer device according to an embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

The data configuration method provided by the application can be applied to the application environment shown in fig. 1. Wherein the configuration terminal 102 communicates with the project server 104 via a network. The item server is specifically a server on which the item runs, for example, if the item is an item of a game application, the item server is a game server. Specifically, the configuration terminal loads an aggregation configuration page of the project based on an aggregation configuration library table; the aggregation configuration base table is generated based on the table name and the head field of each configuration object worksheet of the project; the aggregation configuration page aggregates all configuration object worksheets; responding to the editing operation of the cells on the aggregation configuration page, determining a configuration object according to the table name of the cells, and obtaining configuration records of the configuration object according to the field name of the cells and the field value filled by the editing operation of the cells; and storing the configuration record in the aggregation configuration base table, and pushing the configuration record to a project server to configure the project based on the aggregation configuration base table. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.

In an embodiment, as shown in fig. 2, a data configuration method is provided, which is described by taking the example that the method is applied to the configuration terminal in fig. 1, and includes the following steps:

step S202, loading an aggregation configuration page of the project based on an aggregation configuration base table; the aggregation configuration base table is generated based on the table name and the head field of each configuration object worksheet of the project; the aggregation configuration page aggregates configuration object worksheets.

Wherein the configuration object is a project configuration target related to the project. In practical applications, project activities of different applications correspond to different configuration objects. And if the project is the operation activity of the application program, the project configuration parameters are operation activity configuration parameters. Taking an application program as an example of a game, the configuration object is an operation activity configuration parameter in game operation, and comprises a gift, an article, a task and the like.

For each configuration object, the conventional configuration management method adopts related tables for management. In this embodiment, an aggregated configuration base table is generated in the database based on the table name and the header field of each configuration object worksheet. The aggregation configuration base table aggregates the table structures of the configuration objects, and integrates the table structures of the configuration objects into one table structure. In the aggregation configuration base table, the table structure of each configuration object is based on the table structure of the original configuration object worksheet, wherein the header field of each configuration object in the aggregation configuration base table comprises the header field and the table name of the table structure of each configuration object. If one configuration object is an active basis and one configuration object is consumption and exchange, the table name of the configuration object and the table structure of each configuration object are respectively used as the head field of the configuration object in the aggregation configuration table. And aggregating a plurality of originally separated configuration object worksheets into one database table by aggregating the configuration database tables.

And loading the aggregation configuration page of the project on the basis of the aggregation configuration base table. The aggregation configuration page is a visual configuration page and aggregates all configuration object worksheets. In terms of visual effect, a plurality of originally separated configuration object worksheets can be comprehensively managed on one aggregation configuration page, and one-page online configuration editing management of activity granularity is realized, namely, data items of a plurality of files or worksheets related to one activity are aggregated on one page for configuration management. As shown in fig. 3, taking an application as an example, in the aggregation configuration page, the information of the aggregation configuration page in the 1 st to 3 rd behaviors and the content of the first configuration object worksheet in the 5 th to 7 th behaviors relate to the first configuration object. Line 12 through line 14 the contents of the second configuration object worksheet relate to the second configuration object. Line 19 through line 21 the contents of the third configuration object worksheet relate to the third configuration object. Line 26 through line 28 the contents of the fourth configuration object worksheet relate to the fourth configuration object. The contents of each configuration object worksheet are exposed with a configuration object worksheet name and header fields. The configuration personnel can intuitively determine the configuration object through the configuration object worksheet name and the header field, and configure relevant parameters for the configuration object based on the header field.

And the aggregation configuration page aggregates a plurality of configuration object tables corresponding to the items. It will be appreciated that the configuration content is stored in the aggregate configuration library table by configuring the relevant configuration objects in the aggregate configuration page. That is to say, the aggregation configuration page is an external display of the aggregation configuration base table, and the data of the aggregation configuration base table is loaded and edited through the aggregation configuration page.

Step S204, responding to the editing operation of the cells on the aggregation configuration page, determining a configuration object according to the table name of the cells, and obtaining the configuration record of the configuration object according to the field name of the cells and the field value filled by the editing operation of the cells.

The aggregation configuration page aggregates a plurality of configuration object worksheets related to project configuration, when editing operation is carried out on one cell, a configuration object is determined according to the table name of the cell, and configuration records of the configuration object are obtained according to the field name of the cell and the field value filled by the editing operation of the cell. If the table name of the currently configured cell is the prize and the field value is the task description, after the cell is edited, the field value of the task description is obtained, and the configuration record of one cell of the prize, which is the configuration object, is obtained. And editing the cells with different table names and field names to obtain the configuration records of the cells with different configuration objects.

That is, the configuration of different configuration objects can be completed in one aggregated configuration page. In the actual configuration process, there is a correlation between the configuration objects, and one configuration content often needs to refer to the configuration of other configuration objects. When the tasks are arranged, the tasks exist in different game chapters, and when the arrangement is arranged, the arrangement of the game chapters needs to be referred to. In the embodiment, when configuration is performed based on the aggregation configuration page, a configuration person does not need to open a plurality of configuration object tables respectively, and the method has the advantages of intuition and simplified operation.

Step S206, storing the configuration record in the aggregation configuration library table, and pushing the configuration record to a project server to configure the project based on the aggregation configuration library table.

After configuration is completed based on the aggregated configuration page, the configuration records are stored in an aggregated configuration library table. And pushing the configuration record to a project server based on the aggregation configuration table, and realizing configuration by the project server. Taking a game as an example, after the configuration of the game activity is completed, the configuration is pushed to the game server, and the game server configures the game activity.

According to the data configuration method, the configuration object worksheets of the project are aggregated on one configuration page, and during configuration, a configuration person does not need to open a plurality of configuration object worksheets respectively, so that the data configuration method has the advantages of intuition and simplified operation, and can effectively improve configuration efficiency.

In another embodiment, the process of creating the aggregated configuration base table, as shown in fig. 4, obtains the configuration object worksheets and the header fields of the configuration object worksheets; converting the configuration object worksheet and the header fields thereof into description files; and establishing an aggregation configuration library table in a database according to the description file.

Specifically, a worksheet (such as each worksheet of an excel sheet) configured by a project and a header field in the worksheet are converted into a description file in a json format, then the description file is uniformly analyzed, a corresponding aggregation configuration table is established in a database, records in the worksheet are imported into data for editing management, a visual web page, namely an aggregation configuration page, is provided, and data in the database table are loaded and edited. The header field is the header of the worksheet. Taking the task configuration as an example, the header fields are shown in table 1:

TABLE 1 head field of task configuration

In the implementation, a configurator only needs to configure the table name of each configuration object worksheet and the head field of the worksheet according to the previous working mode, the system automatically reads the table name and the head field of each configuration object worksheet, constructs the table structure of the aggregated configuration table, and provides an aggregated configuration page on the basis of the table name and the head field, so that a user can complete configuration on one page in the configuration process without switching among a plurality of worksheets, and convenience is provided for configuration.

In another embodiment, the editing operation on the aggregation configuration page is performed on a cell basis, namely, the configuration of the field value of the corresponding field name is realized through the editing operation on the cell. In one embodiment, the input content based on the cell trigger may be obtained, resulting in a field value input at the cell. This approach is configured by manual entry.

In practical application, the configuration object tables are not isolated, but have correlation, and the configuration object worksheets designed by the project configuration can be referred to each other. For example, one configuration object table may be a list of prizes, and one configuration object table may be an activity gift bag, which typically includes one or more lists of prizes. When the activity gift bag needs to be configured, the configuration of the prize list can be quoted, and the articles in the prize list are inserted without manual input.

In the conventional method, the reference is realized by copying and pasting, for example, when the configuration table of the active gift package is configured, the prize list configuration table is opened, the article identifier is found, and the article Identifier (ID) of the prize list is copied to the reward content of the active gift package.

In the embodiment, the configured parameter can be directly searched and referred in the aggregation configuration page without table cutting, so that the configuration efficiency is further improved. Specifically, in response to an editing operation on a cell on the aggregation configuration page, determining a configuration object according to a table name of the cell; if the editing operation is a reference editing operation, acquiring a field name to which the cell belongs, wherein the field name comprises a pre-marked referenceable field name; loading a first mapping relation table corresponding to the field name; selecting a target to be referred to based on the first mapping relation table, and filling a field value serving as the field name; and obtaining the configuration record of the configuration object according to the field name of the cell and the field value filled by the reference editing operation.

Specifically, the aggregation configuration page has correlation in advance, a monitoring event can be added to the quoted cells, when the fact that the quote editing operation is triggered to the cells is monitored, the field names of the cells are obtained, and the first mapping relation table corresponding to the field names is loaded by matching and reading the associated configuration table data in the aggregation configuration table. As shown in fig. 5, triggering of the reference editing operation is specifically that when it is monitored that a configurator right-clicks a certain cell, a field name corresponding to the cell is located. And judging whether the field contains a preset referenceable flag field. And setting a referenceable flag field for the task field in advance, and judging whether the field comprises a task field if the preset referenceable flag field is a task. When the user-triggered field includes a referenceable flag field, a "data reference" function option is displayed. And if the cell does not support the quick reference function, namely the field to which the triggered cell belongs does not have the referenceable mark field which is identified in advance, the function option of 'data reference' is not displayed. And when the configuration user clicks the function option of the data reference, loading the pull-down option table of the first mapping relation table. The first mapping relation table is a mapping relation loaded from a database when the aggregation configuration page is loaded. The configuration user may click or search to select content to write. The writing method includes overwriting and appending writing. When the writing is covered, the content of the selected cell is cleared and then written. When additional writing is performed, the contents of the selected cell are retained, and additional writing is performed.

Taking the preset referenceable flag field as task as an example, the configured task DI can be introduced by adopting a reference mode. Specifically, after a cell position of a task id is wanted to be applied and a corresponding option function is right-clicked, an id drop-down list is displayed. The user can find the id to be written in the id drop-down list. The display items of the drop-down list are characters of which id is connected with Chinese, and the actual value is only the id of the drop-down list, so that in the fuzzy search, both id search and Chinese search are acceptable on the program side, and the id is written finally. When the corresponding id is selected, overwriting or additional writing is possible.

As shown in fig. 6, taking the pre-set referenceable flag field as gifttid (who) as an example, its cell is filled with an item, when "data reference" is provided in the right-click menu, the item list can be queried and displayed by clicking, the item list provides quick selection, the cell filled with the item ID is selected in the list, and its reference is filled into the cell.

In the embodiment, based on the aggregation configuration table, configured contents with correlation can be filled in the correlation table in the aggregation configuration page by an introduction method, and the functions of directly searching and referring to historical configuration can be realized without table cutting, so that the configuration efficiency is further improved.

In the configuration process, if the configuration content represented by a certain unique ID needs to be inquired, the corresponding ID configuration table needs to be opened first, and then the ID is searched for checking, so that the operation is complicated.

Based on this, the present embodiment provides a convenient query method, and specifically, in response to a query request triggered on the aggregated configuration page based on a cell, a field name to which the cell belongs is obtained, where the field name includes a pre-marked queryable field name; and if the field name is the pre-marked inquired field name, loading a second mapping relation table corresponding to the field name for display. Namely, the corresponding mapping relation table can be loaded for viewing on the current page. This approach is particularly suitable for configuration checking.

Specifically, as shown in fig. 7, the triggering of the query operation is, specifically, when it is monitored that a configurator right-clicks a certain cell, the field name corresponding to the cell is located. And judging whether the field contains a preset queryable mark field. For example, a query flag field is set in advance for the task field, and when the field triggered by the user includes the query flag field, a function option of "query" is displayed. And if the cell does not support the query function, namely the field to which the triggered cell belongs does not have the query function identified in advance, the function option of 'query' is not displayed. And when the configuration user clicks the function option of 'query', loading a pull-down option table of the second mapping relation table. And the second mapping relation table is a mapping relation loaded from the database when the aggregation configuration page is loaded. The second mapping table is shown in table form, as shown in fig. 8. It will be appreciated that retraction of the second mapping table may be triggered when the configuration user query is complete.

By taking the inquired field as ID Chinese as an example, the method is adopted to trigger inquiry on the ID field, and the ID Chinese information can be displayed. When a cell is right-clicked, it is determined which field corresponds to the cell, and whether the field contains a flag character (for example, a task character is added after the field for quick query of task id). If the Chinese character is included, the option function of [ id Chinese character check ] is displayed. After clicking the option function, finding out the corresponding item in the id mapping table of the pre-loaded memory, and then displaying the relationship between the id and the related field thereof in a form, namely a second mapping relationship table. The id Chinese mapping table is constructed by reading the contents of a task table, an article table, a gift bag table and the like from a database when a page is loaded, and the mapping relation between the id and the relevant fields is established. For the more complex mapping relationship, the reading process is mainly concerned in development, and the complex mapping relationship can be read by expanding the reading process. If the id grammar of the click query is illegal, a user prompt is given before the display. For example, the field name GiftItemID of the cell is provided with (going) to indicate that the column is configured to add a monitoring event to the cell, click the content configured below the cell, and pop up the menu of the pair by right-clicking, wherein the 'ID Chinese check' appears in the menu to facilitate the query of the information of the item.

The method can realize convenient cross-table lookup of the configuration records on the aggregation configuration page.

In another embodiment, a project configuration designs a plurality of configuration objects, each configuration object needs to be configured with a corresponding Identification (ID), i.e. a configuration ID, which can be used to uniquely identify a certain configuration data record. The traditional mode adopts manual management distribution, is tedious in work, is easy to make mistakes, can cause external network accidents seriously and even, and is inconvenient for cooperation of multiple people.

In this embodiment, in response to a storage instruction, a to-be-configured variable name with an empty identifier on the aggregation configuration page is acquired; and allocating an identifier for the variable name to be allocated according to the type and the index of the variable name to be allocated, and filling the cell where the variable name identifier field is located. That is, in this embodiment, all configuration object IDs are fully automatically allocated without manual management and maintenance.

Since programs need to use unique IDs to represent certain data, many data need to be assigned unique IDs, and therefore in older configuration systems, it was necessary to manually assign a unique ID to each prop, each task, and each activity. If the unique ID is used wrongly, serious external network accidents can be caused.

In order to solve the problem of unique ID allocation, the specific unique ID value is not required to be manually managed and filled, only the ID type and the serial number are concerned, and the occupation and matching corresponding relation of the variable name { type 1ID1} is filled, so that the configuration efficiency and the configuration accuracy are greatly improved.

Specifically, as shown in fig. 9 and 10, the acquisition of the configuration ID is triggered when the edited activity data is saved. When the active data is kept, firstly, the cell containing the variable name identifier in the acquisition table, for example, the cell content of "{ { XXX1} }", is traversed. Where XXX is the type of ID obtained, and sequence number 1 is used to identify the ID index in a single edit, which is used to distinguish between the multiple XXX types of IDs obtained by a word edit (or it can be understood that multiple new configuration IDs are used in a single configuration). And after the front end obtains the ID type and the index, acquiring a specific ID through a rear end interface of the ID generator, and then writing in the cell. And configuring the value range of the ID type, allocating codes to the unique ID, and increasing the value range. The unique ID required by the program in data identification is replaced by the corresponding unique ID distribution code, and the corresponding relation of the data in different tables is correctly configured only by the number at the tail of the distribution code; and when the unique id is saved, the brand-new unique id which conforms to the rule is automatically filled in.

Taking game activities as an example, the unique ID allocation code is composed of a type ID serial number, the current allocation code has 4 types, the activity ID { actityid 1}, the picture ID { PictureID1}, the task ID { task ID1}, and the item or gift ID { ThingID1}, and automatic ID allocation can be realized for the four types.

Specifically, the backend interface is implemented by utilizing the self-increment characteristic of the primary key of the data table, and each time the interface is called, a new row of record is added in the database, and the primary key ID of the record is returned. Considering the possibility of concurrent access of the interface, the interface and the distributed lock design based on Redis ensure that only one user can successfully call due to the atomicity of setnx operation of Redis when a plurality of users call the generator interface. In order to prevent a certain user from holding a lock for a long time for some reason (such as a database downtime) and blocking other users from acquiring the configuration ID, the lock is configured with a certain expiration time.

According to the method, all configuration IDs are fully automatically allocated, and manual management and maintenance are not needed.

In another embodiment, the configuration changes as operational activities are upgraded. In order to compare the difference of the configuration data and check the configuration modification items, the configuration data of the front version and the back version need to be compared. In a traditional mode, the comparison difference needs to be carried out by taking two worksheets before and after modification and using a configuration comparison tool for comparison, for example, the joint line records of dozens of worksheets need to be recorded on a version controller (svn) after one worksheet is opened, the last version configuration is obtained and then compared on the configuration comparison tool, the process is time-consuming, tedious and easy to miss, the tracing is troublesome after combination, each small modification point is inconvenient to trace, and fine-grained restoration recovery is also inconvenient to perform.

In this embodiment, the changed configuration data may be determined by performing a union line on the configuration aggregation pages obtained by the two configurations. The union line refers to merging two configuration aggregation pages, and the two pages are compared to determine the changed configuration data. Taking a game as an example, a new version is externally issued at intervals, and during the operation period of the version, a plurality of new configuration records, such as newly-added in-game activities, are added; when a next new version is to be released after about one month, newly added configuration records on the previous version need to be combined with the new version to be released currently, and the new version is released together, which is a union line.

Specifically, in response to the union operation, loading configuration records of the source line and configuration records of the target line based on an aggregation configuration library table; and determining the changed configuration data of the target line relative to the source line according to the configuration record of the source line and the configuration record of the target line.

As shown in fig. 11 and 12, a source line and a target line are selected, the target line being a new configuration based on the source line. In one embodiment, the source line may be in the old configuration and the target line may be in the new configuration. And comparing the configuration record of the source line with the configuration record of the target line, and determining the target line to be changed relative to the source line as the merged data. If the merging is successful, recording all tables which are successfully merged, if the merging is interrupted, only recording the tables which are successfully merged, recording the merged operation as a merging history every time, and recording a merged source line, a merged target line, an operator, merging time and the most important merging data in the merging history every time. The import data is stored in a JSON format, and the table of the import and the data modification thereof are mainly stored.

The import history is also stored in a database table, similar to the configuration table. Specifically, the common data are separately placed in the common data item, and are separated from the excel configuration table.

The comparison of the configuration data of a plurality of versions can show the configuration difference of two version lines in detail, the line combination is conveniently carried out, the detail operation record is merged under the record during the line combination, and the check after the line combination and the reduction operation of single data dimension can be conveniently carried out.

Specifically, the enrollment history can be viewed after enrollment, and the point entry enrollment details can be used for checking and restoring the enrollment operation. The granularity of reduction is one piece of data of each table, and a plurality of data modifications which do not meet the expectation can be selected for reduction. After the selection and the reduction are carried out, the data which are successfully reduced can be marked, and the data can not be seen when the entry details are checked again, so that the repeated reduction of the entry history is prevented.

Specifically, each change operation involved in the merge is recorded at the time of the merge, and the recovery is to cancel the change operations. The reduction function is as follows: when the configurator finds the merge, some change records are wrong, and the change can be cancelled through the recovery operation.

Specifically, each item of change configuration data is displayed in a strip; and when a restoration instruction for the changed configuration data is acquired, restoring the changed configuration data into a configuration record of the source line. As shown in fig. 13 and 14, the merge history is checked, each item of change configuration data is displayed in a separate manner during checking, when a user restores one of the change configuration data, that is, the merge detail is selected for rollback, the record selected for rollback is marked, and the record is restored to the configuration record of the source line.

In this embodiment, after the operation configuration data is stored in the database table, the operation configuration data of each version corresponds to different databases on the system, and the operation configuration data of different versions are merged, so that the comparison is very convenient, that is, each note book in two aggregation configuration table is compared, so that the difference can be conveniently and clearly found out and exhibited, selective merging is performed, the merged records can be stored, the merged contents can be conveniently previewed and checked subsequently, and if a problem is found, the modified place can be conveniently rolled back for recovery.

By adopting the data configuration method, the overall configuration efficiency is improved by 100%, and half of configuration manpower is reduced for the project group.

It should be understood that, although the steps in the flowcharts are shown in sequence as indicated by the arrows, the steps are not necessarily performed in sequence as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in each of the flowcharts described above may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the steps or stages is not necessarily sequential, but may be performed alternately or alternately with other steps or at least a part of the steps or stages in other steps.

In one embodiment, as shown in fig. 15, there is provided a data configuration apparatus, which may be a part of a computer device using a software module or a hardware module, or a combination of the two, and specifically includes:

the aggregation management module 1101 is configured to load an aggregation configuration page of the item based on an aggregation configuration library table; the aggregation configuration base table is generated based on the table name and the head field of each configuration object worksheet of the project; the aggregation configuration page aggregates all configuration object worksheets;

the editing management module 1102 is configured to, in response to an editing operation on a cell on the aggregation configuration page, determine a configuration object according to a table name of the cell, and obtain a configuration record of the configuration object according to a field name of the cell and a field value filled by the editing operation on the cell;

the publishing module 1103 is configured to store the configuration record in the aggregation configuration library table, and push the configuration record to a project server to configure the project based on the aggregation configuration library table.

According to the data configuration device, the configuration object worksheets of the project are aggregated on one configuration page, and during configuration, a configuration person does not need to open a plurality of configuration object worksheets respectively, so that the data configuration device has the advantages of intuition and simplified operation, and can effectively improve configuration efficiency.

In another embodiment, the system further comprises a data table construction module, configured to obtain each configuration object worksheet and a header field of each configuration object worksheet; converting the configuration object worksheet and the header fields thereof into description files; and establishing an aggregation configuration library table in a database according to the description file.

In another embodiment, the editing management module is configured to determine, in response to an editing operation on a cell on the aggregated configuration page, a configuration object according to a table name of the cell; if the editing operation is a reference editing operation, acquiring a field name to which the cell belongs, wherein the field name comprises a pre-marked referenceable field name; loading a first mapping relation table corresponding to the field name; selecting a target to be referred to based on the first mapping relation table, and filling a field value serving as the field name; and obtaining the configuration record of the configuration object according to the field name of the cell and the field value filled by the reference editing operation.

In another embodiment, the system further comprises a query management module, configured to, in response to a query request triggered on the aggregated configuration page based on a cell, obtain a field name to which the cell belongs, where the field name includes a pre-marked queryable field name; and loading a second mapping relation table display corresponding to the field name.

In another embodiment, the system further includes an allocation module, configured to, in response to a storage instruction, obtain a to-be-allocated variable name that is identified as empty on the aggregation configuration page; and allocating identifiers for the variable names to be allocated according to the types and indexes of the variable names to be allocated, and filling the cells in which the variable name identifier fields are located.

In another embodiment, the system further comprises a union operation module, which is used for responding to the union operation, loading the configuration record of the source line and the configuration record of the target line based on the aggregation configuration library table; and determining the changed configuration data of the target line relative to the source line according to the configuration record of the source line and the configuration record of the target line.

In another embodiment, the system further comprises a restoring operation module for displaying each item of change configuration data in a strip; and when a restoration instruction for one of the changed configuration data is acquired, restoring the changed configuration data into a configuration record of the source line.

For specific limitations of the data configuration device, reference may be made to the above limitations of the data configuration method, which is not described herein again. The modules in the data configuration device can be wholly or partially implemented by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as shown in fig. 12. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing configuration data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data configuration method.

Those skilled in the art will appreciate that the architecture shown in fig. 12 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, a computer device is further provided, which includes a memory and a processor, the memory stores a computer program, and the processor implements the steps of the above method embodiments when executing the computer program.

In an embodiment, a computer-readable storage medium is provided, in which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.

In one embodiment, a computer program product or computer program is provided that includes computer instructions stored in a computer-readable storage medium. The computer instructions are read by a processor of a computer device from a computer-readable storage medium, and the computer instructions are executed by the processor to cause the computer device to perform the steps in the above-mentioned method embodiments.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database or other medium used in the embodiments provided herein can include at least one of non-volatile and volatile memory. Non-volatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical storage, or the like. Volatile Memory can include Random Access Memory (RAM) or external cache Memory. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others.

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims

1. A method of data configuration, comprising:

2. The method of claim 1, further comprising:

acquiring each configuration object worksheet and a header field of each configuration object worksheet;

converting the configuration object worksheet and the header fields thereof into description files;

and establishing an aggregation configuration library table in a database according to the description file.

3. The method according to claim 1, wherein the determining a configuration object according to the table name of the cell in response to the editing operation on the cell on the aggregated configuration page, and obtaining a configuration record of the configuration object according to the field name of the cell and the field value filled by the editing operation on the cell comprises:

responding to the editing operation of the cells on the aggregation configuration page, and determining a configuration object according to the table name of the cells;

if the editing operation is a reference editing operation, acquiring a field name to which the cell belongs, wherein the field name comprises a pre-marked referenceable field name;

loading a first mapping relation table corresponding to the field name;

selecting a target to be referred to based on the first mapping relation table, and filling a field value serving as the field name;

and obtaining the configuration record of the configuration object according to the field name of the cell and the field value filled by the reference editing operation.

4. The method of claim 1, further comprising:

responding to a query request triggered on the aggregation configuration page based on a cell, and acquiring a field name to which the cell belongs, wherein the field name comprises a pre-marked queryable field name;

and loading a second mapping relation table display corresponding to the field name.

5. The method of claim 1, further comprising:

responding to a storage instruction, and acquiring a to-be-configured variable name with an empty identifier on the aggregation configuration page;

and allocating an identifier for the variable name to be allocated according to the type and the index of the variable name to be allocated, and filling the cell where the variable name identifier field is located.

6. The method of claim 1, further comprising:

responding to the union operation, and loading the configuration record of the source line and the configuration record of the target line based on the aggregation configuration library table;

and determining the changed configuration data of the target line relative to the source line according to the configuration record of the source line and the configuration record of the target line.

7. The method of claim 6, further comprising:

displaying each item of change configuration data in a strip manner;

and when a restoration instruction for one of the changed configuration data is acquired, restoring the changed configuration data into a configuration record of the source line.

8. An apparatus for configuring data, the apparatus comprising:

9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 7.

10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 7.