CN106897444A - A kind of list data update method and device - Google Patents

Abstract

The embodiment of the present application provides a kind of list data update method and device, and by determining the data to be updated of form, the data to be updated include at least one the first data；Compare the initial data in the data to be updated and the form, determine the corresponding action type of every first data, the initial data includes at least one the second data；Each the second data in the initial data in the form are traveled through, the mode of the initial data in the form is updated using the corresponding action type of first data, realize automatically updating for list data.

Description

Method and device for updating form data

technical field

The invention relates to the technical field of data updating, in particular to a table data updating method and device.

Background technique

Table is the most commonly used data display method. The traditional table data display method is to obtain data from the background once and display it directly in the table. Once the display is completed, there is no action on the table. If you want to view the latest data, you need Refresh manually or operate some buttons.

This traditional tabular data display method is very common (for example, in cloud platforms), because most of the data is static, such as virtual machine lists, storage lists, etc. These data can only be displayed after the interface is manually added. There will be changes in the table data. At this time, you only need to refresh the table to see the latest data. Moreover, in the case of no operation, the data will not increase or decrease.

However, some data (such as monitoring data, alarm data, status data, etc.) will change in the background. In the table data display interface, if users want to see the changes of these data, it is impossible for the user to manually refresh the table all the time. At this time, in view of this situation, a form data update method is needed to realize automatic update of form data.

Contents of the invention

In view of this, an embodiment of the present invention provides a method and device for updating table data, so as to realize automatic updating of table data.

In order to achieve the above object, the technical solutions provided by the embodiments of the present invention are as follows:

A form data update method, comprising:

Determine the data to be updated in the table, the data to be updated includes at least one piece of first data;

comparing the data to be updated with the original data in the table, and determining the operation type corresponding to each piece of the first data, the original data including at least one piece of second data;

Traverse each piece of second data in the original data in the table, and update the original data in the table with the operation type corresponding to the first data.

Preferably, the data to be updated in the determination table includes:

Acquiring the initial data to be updated of the table, the initial data to be updated includes at least one piece of third data;

performing data format conversion on the third data whose data format does not meet the preset data format requirements;

The initial data to be updated after data format conversion is determined as data to be updated, and each piece of third data in the initial data to be updated after data format conversion is determined to be a piece of first data.

Preferably, before comparing the data to be updated with the original data in the table and determining the operation type corresponding to each piece of the first data, the method further includes:

determining whether the raw data in said table is empty;

If the original data in the table is empty, load the data to be updated to the table;

The comparing the data to be updated and the original data in the table to determine the operation type corresponding to each piece of the first data includes: if the original data in the table is not empty, comparing the data to be updated Based on the original data in the table, determine the operation type corresponding to each piece of the first data.

Preferably, the comparing the data to be updated with the original data in the table, and determining the operation type corresponding to each piece of the first data includes:

determining whether the first data carries a deletion identifier;

If the first data carries a deletion identifier, determine that the operation type corresponding to the first data is a deletion type;

If the first data does not carry a deletion flag, determine whether there is second data identical to the first data in the original data in the table;

If there is no second data identical to the first data in the original data in the table, determine that the operation type corresponding to the first data is an add type;

If there is second data identical to the first data in the original data in the table, determine whether the data content of the first data is the same as the data content of the second data;

If the data content of the first data is different from the data content of the second data, it is determined that the operation type corresponding to the first data is an update type.

Preferably, traversing each piece of second data in the original data in the table, and using the operation type corresponding to the first data to update the original data in the table includes:

Traverse each piece of second data in the original data in the table;

determining whether there is first data identical to the second data in the data to be updated;

If there is first data that is the same as the second data in the data to be updated, determine whether the operation type corresponding to the first data is a deletion type;

If the operation type corresponding to the first data is a delete type, delete the second data in the original data in the table;

If the operation type corresponding to the first data is not a deletion type, determine whether the operation type corresponding to the first data is an update type;

If the operation type corresponding to the first data is an update type, using the first data to update the second data in the original data in the table;

If the operation type corresponding to the first data is not an update type, determine whether to traverse the original data in the table;

If the original data in the table has not been traversed, traverse the second data next to the second data in the original data in the table;

If the original data in the table has been traversed, all the first data whose operation type is an adding type in the data to be updated are loaded into the table.

Preferably, the method further includes: marking in the table all first data whose loaded operation type is an adding type.

Preferably, the determining the data to be updated of the table includes: determining the data to be updated of the table when the current system time satisfies the update condition of the table data.

A form data updating device, comprising:

The data to be updated determining unit is used to determine the data to be updated in the table, and the data to be updated includes at least one piece of first data;

An operation type determining unit, configured to compare the data to be updated with the original data in the table, and determine the operation type corresponding to each piece of the first data, the original data including at least one piece of second data;

The table data updating unit is configured to traverse each piece of second data in the original data in the table, and update the original data in the table by using the operation type corresponding to the first data.

Preferably, the unit for determining the data to be updated includes:

An acquisition unit, configured to acquire initial data to be updated in the table, where the initial data to be updated includes at least one piece of third data;

A data format conversion unit, configured to perform data format conversion on the third data whose data format does not meet the preset data format requirements;

The data to be updated determination subunit is used to determine the initial data to be updated after data format conversion as the data to be updated, and determine each piece of third data in the initial data to be updated after data format conversion as a piece of first data .

Preferably, a loading unit is also included, and the loading unit includes:

A determination unit is used to determine whether the original data in the table is empty;

a loading subunit, configured to load the data to be updated to the table if the original data in the table is empty;

The comparing the data to be updated and the original data in the table to determine the operation type corresponding to each piece of the first data includes: if the original data in the table is not empty, comparing the data to be updated Based on the original data in the table, determine the operation type corresponding to each piece of the first data.

The embodiment of the present application provides a method and device for updating table data. By determining the data to be updated in the table, the data to be updated includes at least one piece of first data; comparing the data to be updated with the original data in the table, determine The operation type corresponding to each piece of the first data, the original data includes at least one piece of second data; traverse each piece of second data in the original data in the table, and use the operation type corresponding to the first data to update The way of the original data in the table realizes the automatic update of the table data.

Description of drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments described in the present invention. Those skilled in the art can also obtain other drawings based on these drawings without creative work.

FIG. 1 is a flow chart of a method for updating table data provided by an embodiment of the present application;

FIG. 2 is a flow chart of a method for determining data to be updated in a table provided by an embodiment of the present application;

FIG. 3 is a flow chart of another form data update method provided by the embodiment of the present application;

FIG. 4 is a flow chart of a method for comparing the data to be updated with the original data in the table and determining the operation type corresponding to each piece of the first data provided by the embodiment of the present application;

FIG. 5 is a flow chart of a method for traversing each piece of second data in the original data in the table and using the operation type corresponding to the first data to update the original data in the table provided by the embodiment of the present application;

FIG. 6 is a schematic structural diagram of an apparatus for updating table data provided by an embodiment of the present application.

detailed description

In order to enable those skilled in the art to better understand the technical solutions in the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described The embodiments are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

Example:

FIG. 1 is a flow chart of a method for updating table data provided by an embodiment of the present application.

As shown in Figure 1, the method includes:

S101. Determine data to be updated in the table, where the data to be updated includes at least one piece of first data;

Optionally, refer to FIG. 2 for the manner of determining the data to be updated in the table.

As shown in Figure 2, the method includes:

S201. Acquire initial data to be updated in the table, where the initial data to be updated includes at least one piece of third data;

Optionally, the initial data to be updated of the table is obtained from the background, and the initial data to be updated includes at least one piece of third data.

Optionally, the background collects the initial data to be updated by means of data collection, and stores the collected initial data to be updated in the cache of the background, so that a data update method provided in the embodiment of the present application can be obtained from the The initial data to be updated of the table is obtained from the buffer in the background described above.

S202. Perform data format conversion on the third data whose data format does not meet the preset data format requirements;

Optionally, the initial data to be updated includes at least one piece of third data, and the third data that does not meet the preset data format requirements are determined from the initial data to be updated, and each determined piece of third data is respectively processed. Format conversion, so that the third data after data format conversion meets the data format requirements.

S203. Determine the initial data to be updated after data format conversion as data to be updated, and determine each piece of third data in the initial data to be updated after data format conversion as a piece of first data.

Optionally, the data to be updated is obtained after the data format conversion is completed on the initial data to be updated; Each piece of third data in the data after data format conversion is also a piece of first data.

Optionally, the above is only the preferred mode of the embodiment of the present application, and the inventor can arbitrarily set the specific implementation mode of the data to be updated in the determination table according to his own needs (for example, not directly for the data format that does not meet the preset data format requirements The data format conversion of the third data is carried out, but the third data whose data format does not meet the preset data format requirements is judged, and if the third data meets the preset deletion rules, the third data is deleted from the The initial data to be updated is deleted, and the deleted third data does not perform steps S202-S203), which is not limited here.

Optionally, the third data satisfying the preset deletion rule includes: the data content of the third data corresponds to the data content indicated by the preset deletion rule.

The above are only the preferred methods provided by the embodiments of the present application, and the inventors can arbitrarily set the specific implementation methods for the third data to meet the preset deletion rules according to their own needs, which are not limited here.

S102. Compare the data to be updated with the original data in the table, and determine the operation type corresponding to each piece of the first data, where the original data includes at least one piece of second data;

S103. Traverse each piece of second data in the original data in the table, and update the original data in the table by using the operation type corresponding to the first data.

FIG. 3 is a flow chart of another method for updating table data provided by the embodiment of the present application.

As shown in Figure 3, the method includes:

S301. Determine data to be updated in the table, where the data to be updated includes at least one piece of first data;

S302. Determine whether the original data in the table is empty; if the original data in the table is empty, execute step S303; if the original data in the table is not empty, execute step S304;

S303. Load the data to be updated to the table;

S304. Compare the data to be updated with the original data in the table, and determine the operation type corresponding to each piece of the first data, where the original data includes at least one piece of second data;

S305. Traverse each piece of second data in the original data in the table, and use the operation type corresponding to the first data to update the original data in the table.

Fig. 4 is a flow chart of a method for comparing the data to be updated with the original data in the table and determining the operation type corresponding to each piece of first data provided by the embodiment of the present application.

As shown in Figure 4, the method includes:

S401. Determine whether the first data carries a deletion identifier; if the first data carries a deletion identifier, perform step S402; if the first data does not carry a deletion identifier, perform step S403;

S402. Determine that the operation type corresponding to the first data is a deletion type;

S403. Determine whether there is second data that is the same as the first data in the original data in the table; if there is no second data that is the same as the first data in the original data in the table, execute the step S404: If there is second data identical to the first data in the original data in the table, execute step S405;

Optionally, the first data is the same as the second data, indicating that the data attribute of the first data is the same as the data attribute of the second data. For example, the first data includes name 29, gender female; the second data includes name 20, gender male; it can be considered that the data attributes (name and gender) of the first data are the same as the data attributes (name and gender) of the second data, and the second data The first data is the same as the second data. Among them, 29 and female can be considered as the data content of the first data, and 20 and male can be considered as the data content of the second data.

S404. Determine that the operation type corresponding to the first data is an adding type;

S405. Determine whether the data content of the first data is the same as the data content of the second data; if the data content of the first data is not the same as the data content of the second data, perform step S406;

For example, the first data includes name 29, gender female; the second data includes name 20, gender male; it can be considered that the data content (29, female) of the first data is different from the data content (20, male) of the second data.

S406. Determine that the operation type corresponding to the first data is an update type.

Further, the method for comparing the data to be updated with the original data in the table and determining the operation type corresponding to each piece of the first data provided by the embodiment of the present application further includes: if the first The data content of the data is the same as that of the second data, and it is determined that the operation type corresponding to the first data is an empty type, and the empty type indicates that the first data is invalid data, and it is not necessary to use the first data The data updates the original data of the table.

For example, the first data includes name 29, gender female; the second data includes name 29, gender female; it can be considered that the data content (29, female) of the first data is the same as the data content (29, female) of the second data.

Optionally, using the first data to update the original data of the table includes: using the first data to update the data content of the second data in the original data of the table.

Fig. 5 is a flow chart of a method for traversing each piece of second data in the original data in the table and using the operation type corresponding to the first data to update the original data in the table provided by the embodiment of the present application.

As shown in Figure 5, the method includes:

S501. Traverse each piece of second data in the original data in the table;

S502. Determine whether there is first data that is the same as the second data in the data to be updated; if there is first data that is the same as the second data in the data to be updated, perform step S503;

S503. Determine whether the operation type corresponding to the first data is a deletion type; if the operation type corresponding to the first data is a deletion type, perform step S504; if the operation type corresponding to the first data is not a deletion type, Execute step S505;

S504. Delete the second data in the original data in the table;

S505. Determine whether the operation type corresponding to the first data is an update type; if the operation type corresponding to the first data is an update type, perform step S506; if the operation type corresponding to the first data is not an update type, Execute step S507;

S506. Utilize the first data to update the second data in the original data in the table;

S507. Determine whether the original data in the table has been traversed; if the original data in the table has not been traversed, perform step S508; if the original data in the table has been traversed, perform step S509;

S508. Traverse the next piece of second data of the second data among the original data in the table;

S509. Load all the first data in the data to be updated whose operation type is an adding type into the table.

Further, in a method for updating table data provided in an embodiment of the present application, the method further includes: marking in the table all first data whose loaded operation type is an add type.

Optionally, after traversing each piece of second data in the original data in the table and updating the original data in the table with the operation type corresponding to the first data, mark the loaded The operation type of is the method of adding all the first data of the type, which can facilitate the user to understand the newly loaded content in the table.

Optionally, the determining the data to be updated of the table includes: determining the data to be updated of the table when the current system time satisfies a condition for updating the table data.

Optionally, the table data update condition includes: table data update period. For example, the table data update cycle is 2 hours, if the table is opened and displayed for the first time at 2:00, then when the current system time is 4:00, it is determined that the current system time meets the table data update cycle; the current system time is 6:00 , determine that the current system time satisfies the table data update cycle; and so on, when the time interval between the current system time and the last determined table data to be updated is 2 hours, determine that the current system time satisfies the table data update cycle.

The above is only the preferred method of the embodiment of the present application. The inventor can arbitrarily set the specific implementation method of determining the data to be updated in the table under the condition that the current system time meets the table data update condition according to his own needs, which is not limited here.

An embodiment of the present application provides a method for updating table data. By determining the data to be updated in the table, the data to be updated includes at least one piece of first data; comparing the data to be updated with the original data in the table, and determining each The operation type corresponding to the first data, the original data includes at least one piece of second data; traverse each piece of second data in the original data in the table, and use the operation type corresponding to the first data to update the The way of the original data in the table realizes the automatic update of the table data.

FIG. 6 is a schematic structural diagram of an apparatus for updating table data provided by an embodiment of the present application.

As shown in Figure 6, the device includes:

The data to be updated determining unit 61 is configured to determine the data to be updated of the table, the data to be updated includes at least one piece of first data;

An operation type determining unit 62, configured to compare the data to be updated with the original data in the table, and determine the operation type corresponding to each piece of the first data, and the original data includes at least one piece of second data;

The table data updating unit 63 is configured to traverse each piece of second data in the original data in the table, and update the original data in the table by using the operation type corresponding to the first data.

Optionally, the unit for determining the data to be updated includes:

An acquisition unit, configured to acquire initial data to be updated in the table, where the initial data to be updated includes at least one piece of third data;

A data format conversion unit, configured to perform data format conversion on the third data whose data format does not meet the preset data format requirements;

The data to be updated determination subunit is used to determine the initial data to be updated after data format conversion as the data to be updated, and determine each piece of third data in the initial data to be updated after data format conversion as a piece of first data .

Further, a table data updating device provided in an embodiment of the present application further includes a loading unit, and the loading unit includes:

A determination unit is used to determine whether the original data in the table is empty;

a loading subunit, configured to load the data to be updated to the table if the original data in the table is empty;

The comparing the data to be updated and the original data in the table to determine the operation type corresponding to each piece of the first data includes: if the original data in the table is not empty, comparing the data to be updated Based on the original data in the table, determine the operation type corresponding to each piece of the first data.

An embodiment of the present application provides a table data update device, by determining the data to be updated in the table, the data to be updated includes at least one piece of first data; comparing the data to be updated with the original data in the table, determine the The operation type corresponding to the first data, the original data includes at least one piece of second data; traverse each piece of second data in the original data in the table, and use the operation type corresponding to the first data to update the The way of the original data in the table realizes the automatic update of the table data.

Each embodiment of the present invention is described in a progressive manner, each embodiment focuses on the difference from other embodiments, and the same and similar parts of each embodiment can be referred to each other. As for the device disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and for the related information, please refer to the description of the method part.

The above are only preferred embodiments of the present invention, so that those skilled in the art can understand or realize the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the invention. Therefore, the present invention will not be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (10)

1. A tabular data update method, characterized in that, comprising: Determine the data to be updated in the table, the data to be updated includes at least one piece of first data; comparing the data to be updated with the original data in the table, and determining the operation type corresponding to each piece of the first data, the original data including at least one piece of second data; Traverse each piece of second data in the original data in the table, and update the original data in the table with the operation type corresponding to the first data. 2. The method according to claim 1, wherein the determining the data to be updated of the form comprises: Acquiring the initial data to be updated of the table, the initial data to be updated includes at least one piece of third data; performing data format conversion on the third data whose data format does not meet the preset data format requirements; The initial data to be updated after data format conversion is determined as data to be updated, and each piece of third data in the initial data to be updated after data format conversion is determined to be a piece of first data. 3. The method according to claim 2, wherein, before comparing the data to be updated with the original data in the table and determining the operation type corresponding to each piece of the first data, the method further comprises: determining whether the raw data in said table is empty; If the original data in the table is empty, load the data to be updated to the table; The comparing the data to be updated and the original data in the table to determine the operation type corresponding to each piece of the first data includes: if the original data in the table is not empty, comparing the data to be updated Based on the original data in the table, determine the operation type corresponding to each piece of the first data. 4. The method according to claim 3, wherein the comparing the data to be updated with the original data in the table to determine the operation type corresponding to each piece of the first data includes: determining whether the first data carries a deletion identifier; If the first data carries a deletion identifier, determine that the operation type corresponding to the first data is a deletion type; If the first data does not carry a deletion flag, determine whether there is second data identical to the first data in the original data in the table; If there is no second data identical to the first data in the original data in the table, determine that the operation type corresponding to the first data is an add type; If there is second data identical to the first data in the original data in the table, determine whether the data content of the first data is the same as the data content of the second data; If the data content of the first data is different from the data content of the second data, it is determined that the operation type corresponding to the first data is an update type. 5. The method according to claim 4, characterized in that traversing each piece of second data in the original data in the table, using the operation type corresponding to the first data to update the original data in the table data, including: Traverse each piece of second data in the original data in the table; determining whether there is first data identical to the second data in the data to be updated; If there is first data that is the same as the second data in the data to be updated, determine whether the operation type corresponding to the first data is a deletion type; If the operation type corresponding to the first data is a delete type, delete the second data in the original data in the table; If the operation type corresponding to the first data is not a deletion type, determine whether the operation type corresponding to the first data is an update type; If the operation type corresponding to the first data is an update type, using the first data to update the second data in the original data in the table; If the operation type corresponding to the first data is not an update type, determine whether to traverse the original data in the table; If the original data in the table has not been traversed, traverse the second data next to the second data in the original data in the table; If the original data in the table has been traversed, all the first data whose operation type is an adding type in the data to be updated are loaded into the table. 6 . The method according to claim 5 , further comprising: marking in the table all first data whose operation type is added. 7. The method according to any one of claims 1-6, wherein the determining the data to be updated of the table comprises: determining the data to be updated of the table when the current system time satisfies the update condition of the table data . 8. A form data updating device, characterized in that, comprising: The data to be updated determining unit is used to determine the data to be updated in the table, and the data to be updated includes at least one piece of first data; An operation type determining unit, configured to compare the data to be updated with the original data in the table, and determine the operation type corresponding to each piece of the first data, the original data including at least one piece of second data; The table data updating unit is configured to traverse each piece of second data in the original data in the table, and update the original data in the table by using the operation type corresponding to the first data. 9. The device according to claim 8, wherein the unit for determining the data to be updated comprises: An acquisition unit, configured to acquire initial data to be updated in the table, where the initial data to be updated includes at least one piece of third data; A data format conversion unit, configured to perform data format conversion on the third data whose data format does not meet the preset data format requirements; The data to be updated determination subunit is used to determine the initial data to be updated after data format conversion as the data to be updated, and determine each piece of third data in the initial data to be updated after data format conversion as a piece of first data . 10. The method according to claim 9, further comprising a loading unit, the loading unit comprising: A determination unit is used to determine whether the original data in the table is empty; a loading subunit, configured to load the data to be updated to the table if the original data in the table is empty; The comparing the data to be updated and the original data in the table to determine the operation type corresponding to each piece of the first data includes: if the original data in the table is not empty, comparing the data to be updated Based on the original data in the table, determine the operation type corresponding to each piece of the first data.