CN110781191B - Processing method of layout data and server - Google Patents
Processing method of layout data and server Download PDFInfo
- Publication number
- CN110781191B CN110781191B CN201911041432.6A CN201911041432A CN110781191B CN 110781191 B CN110781191 B CN 110781191B CN 201911041432 A CN201911041432 A CN 201911041432A CN 110781191 B CN110781191 B CN 110781191B
- Authority
- CN
- China
- Prior art keywords
- record
- intermediate table
- original
- target record
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24558—Binary matching operations
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computer Security & Cryptography (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Debugging And Monitoring (AREA)
Abstract
The application provides a processing method and a server for arranging data, wherein the method comprises the following steps: obtaining a first intermediate table based on the original arrangement service and the original table; obtaining a second intermediate table based on the updated new orchestration service and the original table; determining a first target record and a second target record matched with the first intermediate table and the second intermediate table based on a preset joint primary key; and checking the preset field of the second target record based on the first target record to obtain a checking result, and sending the checking result to a terminal for displaying. The method and the device realize that the attribute of the layout data is increased or decreased from the outlet of the layout data refreshing, and the verification process is sunk to the middle table field for refreshing, and then the middle table field is directly verified, so that the verification accuracy is improved, related personnel can accurately judge whether the layout data influenced by the new layout service refreshing of the middle table brings new problems according to the verification result, and the effectiveness and the accuracy of the middle table refreshing are improved.
Description
Technical Field
The present application relates to the field of internet technologies, and in particular, to a method and a server for processing layout data.
Background
At present, in an intelligent terminal, such as a large-screen terminal, a mobile terminal, and the like, data is usually displayed based on terminal front-end and background service logic, such as presentation of a home page, navigation, channels, and columns of an intelligent television, and data is arranged depending on operation. The background service system generally performs services such as arrangement data writing, media asset data acquisition, and media asset integration on media assets required by various terminals based on a micro service architecture.
When operation is performed for arrangement, and arrangement data and media asset data are written into a database, along with diversification of operation arrangement and update iteration of new media assets, refresh dimensions of an intermediate table are changed, media asset attribute fields are correspondingly increased and decreased, and along with improvement of logic complexity of accumulated codes of the media assets, when new functions of arrangement services are developed, the accuracy of refreshing the intermediate table by the new arrangement services is difficult to effectively verify.
Disclosure of Invention
The application provides a processing method and a server for arranging data, which aim to overcome the defects of low verification efficiency, inaccuracy and the like in the prior art.
A first aspect of the present application provides a method for processing layout data, including:
obtaining a first intermediate table based on the original arrangement service and the original table;
obtaining a second intermediate table based on the updated new orchestration service and the original table;
determining a first target record and a second target record matched with the first intermediate table and the second intermediate table based on a preset joint primary key;
verifying a preset field of the second target record based on the first target record to obtain a verification result;
and sending the verification result to a terminal for displaying.
A second aspect of the present application provides a server comprising:
the first refreshing module is used for obtaining a first intermediate table based on the original arrangement service and the original table;
a second refreshing module, configured to obtain a second intermediate table based on the updated new scheduling service and the original table;
the determining module is used for determining a first target record and a second target record which are matched with the first intermediate table and the second intermediate table based on a preset joint primary key;
the processing module is used for verifying the preset field of the second target record based on the first target record to obtain a verification result;
and the sending module is used for sending the checking result to a terminal for displaying.
A third aspect of the present application provides an electronic device, comprising: at least one processor and memory;
the memory stores computer-executable instructions;
the at least one processor executes computer-executable instructions stored by the memory to cause the at least one processor to perform the method as set forth in the first aspect above and in various possible designs of the first aspect.
A fourth aspect of the present application provides a computer-readable storage medium having stored thereon computer-executable instructions that, when executed by a processor, implement a method as set forth in the first aspect and various possible designs of the first aspect.
According to the processing method and the server for the layout data, the first intermediate table and the second intermediate table are respectively obtained according to the same original table based on the original layout service and the new layout service, the first target record and the second target record needing to be verified are determined based on the preset joint main key matching, the preset field of the second target record is verified based on the first target record, the attribute increase and decrease of the layout data from the outlet of the layout data refreshing are achieved, the verification process is sunk to the middle table field refreshing, the middle table field is directly verified, the verification accuracy is improved, related personnel can accurately judge whether the layout data influenced by the new layout service refreshing of the middle table brings new problems according to the verification result, and the effectiveness and the accuracy of the middle table refreshing are improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to these drawings without inventive exercise.
FIG. 1 is a schematic diagram of a processing system according to an embodiment of the present application;
FIG. 2 is a flowchart illustrating a method for processing layout data according to an embodiment of the present application;
FIG. 3 is a flowchart illustrating a method for processing layout data according to another embodiment of the present application;
FIG. 4 is a diagram illustrating a format of data fields of an intermediate table according to an embodiment of the present application;
FIG. 5 is an exemplary diagram of a verification result provided by an embodiment of the present application;
FIG. 6 is a flowchart illustrating a method for processing layout data according to an embodiment of the present disclosure;
fig. 7 is a schematic structural diagram of a server according to an embodiment of the present application;
fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
With the above figures, there are shown specific embodiments of the present application, which will be described in more detail below. These drawings and written description are not intended to limit the scope of the disclosed concepts in any way, but rather to illustrate the concepts of the disclosure to those skilled in the art by reference to specific embodiments.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The terms referred to in this application are explained first:
medium resources: the system comprises a large amount of service data such as characters, pictures, audios and videos and the like to be produced by media unit media such as newspaper agencies, broadcasting stations, television stations, websites, communication agencies and the like, and metadata and copyright information describing the data; the media assets may also include information such as the brand of media, policy advantages, market share, talent group, audience group, customer group, information streams, logistics, funding streams, etc. Such as news, television, etc,
Arranging data: the method refers to arranging description data for describing a media asset display mode, a display style and the like on the media assets for displaying different media assets. For example, the intelligent terminal is an intelligent television, navigation (for example, my application, my television, my channel, my education, and the like) displayed by the intelligent television, a channel (for example, navigation is switched to my education, a channel list under the navigation of my education, such as including a baby, a primary school, a junior middle school, a high school, a university, an old age, and the like) is displayed, a hurdle (when a certain channel is selected, such as a university channel, a specific hurdle list related to the university is displayed, such as a media resource list of a teaching version and the like is displayed when a baby channel is selected), and the like.
pagemaker: the page editing service is an editing service, or typesetting software, can process large-section and long-section characters and characters, can process a plurality of pages, and can carry out page editing and page binding.
The method for processing the layout data is suitable for a processing scene of the layout data for displaying various media assets. Fig. 1 is a schematic structural diagram of a processing system based on an embodiment of the present application. The processing system may include a serving device, at least one operator terminal, and at least one user terminal. An operator arranges through an operation terminal, sends an arrangement request to a service device, the service device writes arrangement data into a database to obtain an original table, and the service device refreshes an intermediate table based on an arrangement service (such as pagemaker service) to provide arrangement data for display of each user terminal. When a new function of the arrangement service is developed, the service equipment refreshes an intermediate table according to the same original table based on the original arrangement service and the new arrangement service respectively to obtain a first intermediate table and a second intermediate table, determines a record needing to be verified based on a preset joint main key to verify, obtains a verification result, and sends the verification result to a terminal to be displayed, so that related personnel can judge whether arrangement data influenced by the new arrangement service refreshing of the intermediate table brings new problems according to the verification result, and the effectiveness and the accuracy of the refreshing of the intermediate table are improved.
Furthermore, the terms "first," "second," and the like are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or to implicitly indicate a number of the indicated technical features. In the description of the following examples, "plurality" means two or more unless specifically limited otherwise.
The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present invention will be described below with reference to the accompanying drawings.
An embodiment of the present application provides a method for processing layout data, which is used for processing layout data of media assets. The execution subject of the embodiment is an electronic device, which may be a server, a desktop computer, a tablet computer, or the like.
As shown in fig. 2, a schematic flow chart of a method for processing layout data provided in this embodiment is shown, where the method includes:
Specifically, the acquisition of the arrangement data and the processing of the media assets in the intelligent terminal product both need to issue the media assets with different dimensions by means of refreshing the intermediate table. The refreshing of the intermediate table requires orchestration services to be implemented. The arrangement service takes pagemaker service as an example, with the continuous upgrade of intelligent terminal products, the required media asset arrangement data also continuously changes, and the corresponding arrangement service for refreshing the intermediate table also needs a continuous updating function. When a new function of the orchestration service is developed, it is necessary to check whether the new function is accurate to the updated content of the intermediate table with respect to the original orchestration service, which may not cause some orchestration data that is not intended to be refreshed. Then, the first intermediate table may be obtained by performing intermediate table refresh based on the original orchestration service and the original table, and used as the reference intermediate table.
The layout service refers to a typesetting software or an application program which can process large-section and long-section characters, process a plurality of pages, and perform functions such as page editing, page binding and the like. The original orchestration service is an orchestration service of a version before update with respect to a new orchestration service after update.
And 102, acquiring a second intermediate table based on the updated new scheduling service and the original table.
Specifically, the intermediate table may be refreshed based on the updated new scheduling service and the original table, so as to obtain the second intermediate table. The updated new orchestration service refers to a version in which an original orchestration service is updated (for example, function update, newly added function, and the like).
It can be understood that, if the intermediate table is refreshed based on the original scheduling service, because the original scheduling service may be in a working state all the time, the intermediate table based on the refresh is already established and refreshed many times, that is, each time an operator performs data scheduling, the original scheduling data enters the database along with the stored action to obtain the original table, when performing scheduling and publishing (for example, the operator clicks a publishing button), the timing task of the pagemaker service scans the tasks not published in the publishing table according to the configuration item information to trigger the intermediate table refreshing process, and the intermediate table refreshing process specifically includes: acquiring layout data (namely, original data) from an original table, splitting layout fields in the original data according to multiple dimensions, extracting relevant fields (the relevant fields to be extracted can be preset) and refreshing the relevant fields to an intermediate table (namely, storing the extracted relevant fields to the intermediate table), and calling and issuing the fields to a user terminal (also called an intelligent terminal) by other APIs (application program interfaces) when the user terminal (also called the intelligent terminal) needs to be displayed.
Illustratively, for a field in one record in the original table, the content may relate to multiple models, multiple versions, multiple license plates, etc., such as (model 1, model 2, model 3, version 1, version 2, license plate 1, license plate 2), and may further include other information, where in a field, in order to more conveniently provide layout data for each intelligent terminal, the field in the original table is split according to multiple dimensions, and the above-mentioned one record may be split into 3 × 2 × 2 ═ 12 records, which are respectively a combination of 12 models, versions, and license plates, namely (model 1, version 1, license plate 1), (model 1, version 1, license plate 2), (model 1, version 2, license plate 1), (model 1, version 2, license plate 2), …, (model 3, version 2, license plate 2). When the user terminal is to be displayed, a service request may be sent to the server, where the service request carries target identification information of the intelligent terminal (i.e., target identification information to be displayed), the target identification information may include an identifier of at least one dimension, and may illustratively include a model identifier, a version identifier, and a license plate identifier, for example, the target identification information includes (model 2, version 1, and license plate 2), and the server may obtain arrangement data corresponding to the intelligent terminal from the intermediate table according to the target identification information, and issue the arrangement data to the intelligent terminal through the API.
And when the intermediate table is refreshed based on the new scheduling service and the same original table, all the issuing tasks need to be added, and the intermediate table is refreshed to obtain a second intermediate table.
Optionally, the newly built intermediate table may also be refreshed based on the original scheduling service and all release tasks added to the original table.
It should be noted that step 101 and step 102 are not in sequence.
And 103, determining a first target record and a second target record which are matched with the first intermediate table and the second intermediate table based on a preset joint primary key.
Specifically, in order to improve the verification efficiency, a joint primary key may be preset, and the records to be verified are matched by the joint primary key.
The joint primary key means that 2 or more than 2 fields form the primary key. The combination is unique in the data table and is indexed by the primary key, using the field contained by the primary key as the primary key.
Exemplarily, the joint primary key is set as id and name, and which records in the first intermediate table and the second intermediate table are corresponding to each other are determined according to the id and the name of the joint primary key. Specifically, when the records satisfying the same id and name in the two tables are corresponding records. And all the records are matched according to the joint main key, and the successfully matched records are used as the first target record and the second target record. The first target record is a record in the first intermediate table that successfully matches and the second target record is a record in the second intermediate table that successfully matches. The successfully matched record is the record needing to be verified.
And 104, verifying the preset field of the second target record based on the first target record to obtain a verification result.
Specifically, for the first target record and the second target record, all fields may be checked, or part of the key fields may be checked. Under the condition that the magnitude of the intermediate table data table is large, each field does not need to be checked, so that a key comparison field (namely a preset field) can be set, and only the key comparison field is checked and compared to obtain a check result.
Alternatively, the verification results may include each field of each record in the second target record marking a miss, an addition, or a change, etc. relative to the first target record.
And 105, sending the verification result to the terminal for displaying.
Specifically, after the verification result is obtained, the verification result is sent to the terminal for display, specifically, the verification result can be sent to the operation terminal, so that operation related personnel can judge whether the updated new orchestration service function meets the requirement or not according to the verification result, whether new problems except the requirement are brought or not, and the like.
According to the processing method for the layout data, the first intermediate table and the second intermediate table are respectively obtained according to the same original table based on the original layout service and the new layout service, the first target record and the second target record needing to be verified are determined based on the preset joint main key matching, the preset field of the second target record is verified based on the first target record, the attribute increase and decrease of the layout data from the outlet of the layout data refreshing are achieved, the verification process is sunk to the middle table field refreshing, the middle table field is directly verified, the verification accuracy is improved, so that related personnel can accurately judge whether the layout data influenced by the new layout service refreshing of the middle table brings new problems according to the verification result, and the effectiveness and the accuracy of the middle table refreshing are improved.
The method provided by the above embodiment is further described in an additional embodiment of the present application.
As shown in fig. 3, a flow chart of the method for processing layout data according to this embodiment is shown.
As a practical manner, on the basis of the foregoing embodiment, optionally, the step 101 specifically includes:
As another implementable manner, on the basis of the foregoing embodiment, optionally, the step 102 may specifically include:
and step 1021, acquiring original data from the original table based on the updated new editing service, and performing intermediate table refreshing processing according to the original data to acquire a second intermediate table.
As another implementable manner, on the basis of the above embodiment, optionally, the first target record is a record in a first intermediate table, and the second target record is a record in a second intermediate table. Step 103 may specifically include:
As another practical way, on the basis of the above embodiment, optionally, the fields of the first target record and the second target record are json format data fields. Step 104 may specifically include:
For example, the following example takes the channel _ layout _ api intermediate table as an example to illustrate:
1. when the operation personnel arranges the operation background data, the original table data can enter a database along with the stored action, such as a channel _ layout original table, when the operation personnel arranges and releases the operation background data, a timing task served by a Pagemaker scans tasks which are not released in the release table according to configuration item information, and triggers the refreshing of an intermediate table, firstly, a large number of arrangement fields are refreshed in the intermediate table according to the dimension required by model versions and the like, secondly, relevant fields are extracted and refreshed in the intermediate table, and other API calls are issued to the intelligent terminal.
2. And releasing the version Pagemaker, triggering the arranged releasing task, refreshing an intermediate table based on the original table at the moment, storing the refreshed intermediate table as a table A (namely a first intermediate table), and similarly refreshing an intermediate table based on the same original table by using the new version Pagemaker to store the intermediate table as a table B (namely a second intermediate table).
3. To perform field checking of table A, B, the corresponding rule in A, B needs to be defined first, i.e., the server needs to know which records in the two tables correspond to each other by means of the concept of a joint primary key. For example: and setting the joint main key as id and name, indicating that the records meeting the condition that the id and the name are the same in the two tables are the same, matching all the records according to the joint main key rule, verifying the successfully matched records, and not verifying the unmatched records.
4. Under the condition that the magnitude of the data table is large, each field is not required to be checked, so that the key comparison field needs to be set continuously, and the server executes check comparison according to the set key comparison field, for example: and setting the comparison field as column _ layout, and checking the same record only aiming at the dimension of the column _ layout field in the database table.
5. When the Python program script (i.e. the data layout processing method of the present application) is executed in the linux environment, data comparison is started one by one. And finally, outputting the result to an excel table under a directory, dividing the excel table according to the records and the fields, marking missing, adding or changing the excel table respectively, and analyzing the data result and recording the problem.
Illustratively, as shown in fig. 4, a data field format diagram of the intermediate table provided for this embodiment is shown. The specific intermediate table data field format may also be other formats, not limited to this one.
Exemplarily, as shown in fig. 5, an exemplary schematic diagram of the verification result provided for this embodiment is provided.
As an exemplary implementation, as shown in fig. 6, an operation flow diagram of the processing method for arranging data provided in this embodiment is shown. The specific process is as follows:
first, data preparation phase
Two sets of intermediate table data are collected (data preparation steps can be set according to actual business logic)
1) A database is newly created, and the original table data is imported (such as a channel _ layout table and a home _ layout table).
2) Intermediate tables channel _ layout _ api and home _ layout _ api are newly created.
3) Copy a Pagemaker service (i.e., a service that refreshes intermediate tables), change the version to an online version, and select the database created in step 1).
4) And adding all the intelligent terminals with the scripts to display the release tasks of the homepage, and triggering the refreshing of the intermediate table.
5) Waiting for pagemaker processing to generate intermediate table data.
6) The generated intermediate table data, channel _ layout _ api and home _ layout _ api, are named as channel _ layout _ api _ old and home _ layout _ api _ old
7) Recreating the intermediate tables channel _ layout _ api and home _ layout _ api
8) The database script between the online version to the current test version is executed.
9) The pagemaker version in the container cloud is changed into a test version, and the database created in the step 1) is selected as the database.
10) The publishing task of all device homepages is added using scripts.
11) Waiting for pagemaker processing to generate intermediate table data.
12) The generated intermediate table data channel _ layout _ api and home _ layout _ api are named channel _ layout _ api _ new and home _ layout _ api _ new to be saved.
Second, program execution stage
1) Executing the python program on the linux environment installs dependencies, such as MySQLdb, with reference to hints information.
2) Py, configuration of the change script
3) Database location setting two data
username＝'XXX'
password＝'XXX'
host＝'xxx.xxx.xxx.xxx'
port＝'xxxx'
db _ name ═ intermediate table old'
The database 'middle table new' is set up in the same way.
4) Table with two data sets
before_upgrate_channel_layout_api_table_name＝'channel_layout_api_old'
after_upgrate_channel_layout_api_table_name＝'channel_layout_api_new'
before_upgrate_home_layout_api_table_name＝'home_layout_api_old'
after_upgrate_home_layout_api_table_name＝'home_layout_api_new'
5) Joint primary key to set record splits
unique_union_key_channel＝['feature_code','sys_version_code','license_code','nav_id','chan_id','default_chan_flag']
6) Setting key comparison fields
channel_layout_api_diff_properties＝['nav_focus','chan_layout','chan_focus','column_layout']
home_layout_api_diff_properties＝['nav_layout','system_param','second_column_layout']
7) The existing results in the file _ channel and file _ home directories are removed before execution
8) Executing a specific piece of test python main, py + to be compared, in the format of python main [ home _ device _ id ] [ home _ id ] [ nav _ id ], such as: py 111222333. Py can be compared against all data by default.
9) After the execution is finished, the test result is generated under the file _ channel and file _ home directory
10) The viewing result is summarized with changed items (divided into add, remove and place), wherein the remove needs to pay attention to the original value, and the place needs to pay attention to the original value and the changed value
11) And summarizing difference data, analyzing and processing, and comparing the intermediate table refreshing logics before and after field verification.
As another practicable manner, on the basis of the foregoing embodiment, optionally before the step 101, the method may further include:
As another practicable manner, on the basis of the foregoing embodiment, optionally, the method further includes:
step 2021, receiving a service request sent by the user terminal, where the service request includes target identification information to be displayed, and the target identification information includes an identifier of at least one dimension.
Step 2022, according to the service request, the layout data corresponding to the target identification information is obtained from the intermediate table.
Step 2023, acquiring corresponding media asset data according to the layout data corresponding to the target identification information.
Step 2024, sending the layout data corresponding to the target identification information and the corresponding media asset data to the user terminal, so that the user terminal performs display processing.
Specifically, the target identification information includes an identification of at least one dimension of the dimensions of a model, a version, a license plate, and the like. When a user terminal needs to be displayed, a service request can be sent to a server, the service request carries target identification information (namely target identification information to be displayed) of an intelligent terminal, the target identification information can include at least one dimension of identification, exemplarily can include a model identification, a version identification and a license plate identification, for example, the included target identification information is (model 2, version 1, license plate 2), the server can acquire arrangement data corresponding to the user terminal from a middle table according to the target identification information, can acquire corresponding media asset data according to the arrangement data corresponding to the target identification information, and sends the arrangement data corresponding to the target identification information and the corresponding media asset data to the user terminal so as to enable the user terminal to perform display processing.
According to the method and the device, the gateway attribute is increased and decreased from the outlet of the editing data refreshing, the verification process is sunk to the field refreshing, the intermediate table field is directly verified, the key field comparison is carried out, and the problem of missing of the issued media asset data is avoided by finding the increase and decrease of the field. According to the characteristics of products in the intelligent terminal-service equipment industry, technologies such as increase of testing dimensionality, division of combined main keys, customization of key comparison fields and the like are added, json structure verification with high complexity and multiple hierarchical structures, namely media asset arrangement data, is carried out, and verification efficiency and coverage rate are improved.
It should be noted that the respective implementable modes in the present embodiment may be implemented individually, or may be implemented in combination in any combination without conflict, and the present application is not limited thereto.
According to the processing method for the layout data, the first intermediate table and the second intermediate table are respectively obtained according to the same original table based on the original layout service and the new layout service, the first target record and the second target record needing to be verified are determined based on the preset joint main key matching, the preset field of the second target record is verified based on the first target record, the attribute increase and decrease of the layout data from the outlet of the layout data refreshing are achieved, the verification process is sunk to the middle table field refreshing, the middle table field is directly verified, the verification accuracy is improved, so that related personnel can accurately judge whether the layout data influenced by the new layout service refreshing of the middle table brings new problems according to the verification result, and the effectiveness and the accuracy of the middle table refreshing are improved. And by increasing the dimensionality of the media asset test, dividing the joint main key and setting the preset field to be verified, the verification of the json format data field with more hierarchical structures is realized, and the verification efficiency and the coverage rate are improved.
Yet another embodiment of the present application provides a server for executing the method of the above embodiment.
As shown in fig. 7, a schematic structural diagram of the server provided in this embodiment is shown. The server 30 comprises a first refresh module 31, a second refresh module 32, a determination module 33, a processing module 34 and a sending module 35.
The first refreshing module is used for obtaining a first intermediate table based on the original arrangement service and the original table; the second refreshing module is used for obtaining a second intermediate table based on the updated new scheduling service and the original table; the determining module is used for determining a first target record and a second target record which are matched with the first intermediate table and the second intermediate table based on a preset joint primary key; the processing module is used for verifying the preset field of the second target record based on the first target record to obtain a verification result; and the sending module is used for sending the checking result to a terminal for displaying.
The specific manner in which each module performs operations has been described in detail in the embodiment of the method with respect to the server in the present embodiment, and will not be elaborated here.
According to the server provided by the embodiment, the first intermediate table and the second intermediate table are respectively obtained according to the same original table based on the original arrangement service and the new arrangement service, the first target record and the second target record which need to be verified are determined based on the preset joint main key matching, the preset field of the second target record is verified based on the first target record, the attribute increase and decrease of the arrangement data from the outlet of the arrangement data refreshing are realized, the verification process is sunk to the middle table field for refreshing, the middle table field is directly verified, the verification accuracy is improved, so that related personnel can accurately judge whether the arrangement data influenced by the new arrangement service refreshing of the middle table brings new problems according to the verification result, and the effectiveness and the accuracy of the middle table refreshing are improved.
The present application further provides a supplementary description of the server provided in the foregoing embodiment.
As a practical manner, on the basis of the foregoing embodiment, optionally, the first refresh module is specifically configured to:
and acquiring original data from the original table based on the original arrangement service, and refreshing the intermediate table according to the original data to acquire a first intermediate table.
As another implementable manner, on the basis of the foregoing embodiment, optionally, the second refresh module is specifically configured to:
and acquiring original data from the original table based on the updated new arrangement service, and refreshing the intermediate table according to the original data to acquire a second intermediate table.
As another implementable manner, on the basis of the above embodiment, optionally, the first target record is a record in a first intermediate table, and the second target record is a record in a second intermediate table;
a determination module specifically configured to:
if the joint primary key in the first record in the first intermediate table is the same as that in the second record in the second intermediate table, determining that the first record is matched with the second record;
the matched first record is taken as a first target record, and the matched second record is taken as a second target record.
As another implementable manner, on the basis of the foregoing embodiment, optionally, the fields of the first target record and the second target record are json format data fields;
the processing module is specifically configured to:
and comparing the preset field in the second target record with the corresponding field in the first target record, and determining the difference of the second target record in the preset field relative to the first target record as a verification result.
As another implementable manner, on the basis of the foregoing embodiment, optionally, the method further includes:
the first receiving module is used for receiving an arrangement request sent by an operation terminal, and the arrangement request comprises arrangement data;
and the storage module is used for storing the arrangement data to obtain an original table.
As another implementable manner, on the basis of the foregoing embodiment, optionally, the method further includes:
the second receiving module is used for receiving a service request sent by the user terminal, wherein the service request comprises target identification information to be displayed;
the acquisition module is used for acquiring the arrangement data corresponding to the target identification information from the intermediate table according to the service request; acquiring corresponding media asset data according to the arrangement data corresponding to the target identification information;
and the transmitting module is used for transmitting the arrangement data corresponding to the target identification information and the corresponding media asset data to the user terminal so as to enable the user terminal to perform display processing.
The specific manner in which each module performs operations has been described in detail in the embodiment of the method with respect to the server in the present embodiment, and will not be elaborated here.
It should be noted that the respective implementable modes in the present embodiment may be implemented individually, or may be implemented in combination in any combination without conflict, and the present application is not limited thereto.
According to the server of the embodiment, the first intermediate table and the second intermediate table are respectively obtained according to the same original table based on the original arrangement service and the new arrangement service, the first target record and the second target record needing to be verified are determined based on the preset joint main key matching, the preset field of the second target record is verified based on the first target record, the increase and decrease of the attribute of the export customs arrangement data refreshed from the arrangement data are achieved, the verification process is sunk to the middle table field for refreshing, the middle table field is directly verified, the verification accuracy is improved, so that related personnel can accurately judge whether new problems are brought to the arrangement data affected by the new arrangement service for refreshing the middle table according to the verification result, and the effectiveness and the accuracy of the middle table refreshing are improved.
Yet another embodiment of the present application provides an electronic device for performing the method provided by the foregoing embodiment. The electronic device may be a server.
As shown in fig. 8, is a schematic structural diagram of the electronic device provided in this embodiment. The electronic device 50 includes: at least one processor 51 and memory 52;
the memory stores computer execution instructions; the at least one processor executes computer-executable instructions stored by the memory to cause the at least one processor to perform a method as provided by any of the embodiments above.
According to the electronic device of the embodiment, the first intermediate table and the second intermediate table are respectively obtained according to the same original table based on the original arrangement service and the new arrangement service, the first target record and the second target record needing to be verified are determined based on the preset joint main key matching, the preset field of the second target record is verified based on the first target record, the attribute increase and decrease of the arrangement data from the outlet of the arrangement data refreshing are realized, the verification process is sunk to the middle table field for refreshing, the middle table field is directly verified, the verification accuracy is improved, so that related personnel can accurately judge whether the arrangement data influenced by the new arrangement service refreshing of the middle table brings new problems according to the verification result, and the effectiveness and the accuracy of the middle table refreshing are improved.
Yet another embodiment of the present application provides a computer-readable storage medium, in which computer-executable instructions are stored, and when the processor executes the computer-executable instructions, the method provided in any one of the above embodiments is implemented.
According to the computer-readable storage medium of the embodiment, the first intermediate table and the second intermediate table are respectively obtained according to the same original table based on the original arrangement service and the new arrangement service, the first target record and the second target record needing to be verified are determined based on the preset joint main key matching, the preset field of the second target record is verified based on the first target record, the attribute increase and decrease of the arrangement data from the outlet of the arrangement data refreshing are realized, the verification process is sunk to the middle table field refreshing, the middle table field is directly verified, the verification accuracy is improved, so that related personnel can accurately judge whether the arrangement data influenced by the new arrangement service refreshing of the intermediate table brings new problems according to the verification result, and the effectiveness and the accuracy of the intermediate table refreshing are improved.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus (such as a server) and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional unit.
The integrated unit implemented in the form of a software functional unit may be stored in a computer readable storage medium. The software functional unit is stored in a storage medium and includes several instructions to enable a computer device (which may be a personal computer, a server, or a network device) or a processor (processor) to execute some steps of the methods according to the embodiments of the present application. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
It is obvious to those skilled in the art that, for convenience and simplicity of description, the foregoing division of the functional modules is merely used as an example, and in practical applications, the above function distribution may be performed by different functional modules as needed, that is, the internal structure of the device is divided into different functional modules to perform all or part of the above described functions. For the specific working process of the device described above, reference may be made to the corresponding process in the foregoing method embodiment, which is not described herein again.
Finally, it should be noted that: the above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present application.
Claims (7)
1. A method of processing layout data, comprising:
acquiring original data from an original table based on original arrangement service, and refreshing an intermediate table according to the original data to obtain a first intermediate table;
acquiring original data from the original table based on the updated new arrangement service, and performing intermediate table refreshing processing according to the original data to acquire a second intermediate table; the intermediate table refresh processing includes: acquiring original data from the original table, splitting an arrangement field in the original data according to multiple dimensions, extracting a relevant field and refreshing the relevant field to an intermediate table;
determining a first target record and a second target record matched with the first intermediate table and the second intermediate table based on a preset joint primary key;
verifying a preset field of the second target record based on the first target record to obtain a verification result;
and sending the verification result to a terminal for displaying.
2. The method of claim 1, wherein the first target record is a record in the first intermediate table and the second target record is a record in the second intermediate table;
the determining, based on a preset joint primary key, a first target record and a second target record that are matched with the first intermediate table and the second intermediate table includes:
if the joint primary key in the first record in the first intermediate table is the same as that in the second record in the second intermediate table, determining that the first record is matched with the second record;
and taking the matched first record as the first target record, and taking the matched second record as the second target record.
3. The method of claim 1, wherein the fields of the first target record and the second target record are json format data fields;
the verifying the preset field of the second target record based on the first target record to obtain a verification result includes:
comparing a preset field in the second target record with a corresponding field in the first target record, and determining the difference of the second target record in the preset field relative to the first target record as the checking result.
4. The method of claim 1, wherein prior to obtaining the first intermediate table based on the original orchestration service and the original table, the method further comprises:
receiving an arrangement request sent by an operation terminal, wherein the arrangement request comprises arrangement data;
and storing the layout data to obtain the original table.
5. The method according to any one of claims 1-4, further comprising:
receiving a service request sent by a user terminal, wherein the service request comprises target identification information to be displayed, and the target identification information comprises at least one dimension identification;
acquiring arrangement data corresponding to the target identification information from an intermediate table according to the service request;
acquiring corresponding media asset data according to the arrangement data corresponding to the target identification information;
and sending the arrangement data corresponding to the target identification information and the corresponding media asset data to the user terminal so as to enable the user terminal to perform display processing.
6. A server, comprising:
the first refreshing module is used for obtaining a first intermediate table based on the original arrangement service and the original table;
a second refreshing module, configured to obtain a second intermediate table based on the updated new scheduling service and the original table;
the determining module is used for determining a first target record and a second target record which are matched with the first intermediate table and the second intermediate table based on a preset joint primary key;
the processing module is used for verifying the preset field of the second target record based on the first target record to obtain a verification result;
the sending module is used for sending the checking result to a terminal for displaying;
the first refresh module is specifically configured to:
acquiring original data from an original table based on original arrangement service, and refreshing an intermediate table according to the original data to acquire a first intermediate table;
the second refresh module is specifically configured to:
acquiring original data from the original table based on the updated new arrangement service, and performing intermediate table refreshing processing according to the original data to acquire a second intermediate table; the intermediate table refresh processing includes: and acquiring original data from the original table, splitting the layout field in the original data according to multiple dimensions, extracting related fields and refreshing the related fields to an intermediate table.
7. The server of claim 6, wherein the first target record is a record in the first intermediate table and the second target record is a record in the second intermediate table;
the determining module is specifically configured to:
the determining a first target record and a second target record that are matched with the first intermediate table and the second intermediate table based on a preset joint primary key includes:
if the joint primary key in the first record in the first intermediate table is the same as that in the second record in the second intermediate table, determining that the first record is matched with the second record;
and taking the matched first record as the first target record and taking the matched second record as the second target record.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911041432.6A CN110781191B (en) | 2019-10-30 | 2019-10-30 | Processing method of layout data and server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911041432.6A CN110781191B (en) | 2019-10-30 | 2019-10-30 | Processing method of layout data and server |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110781191A CN110781191A (en) | 2020-02-11 |
| CN110781191B true CN110781191B (en) | 2022-08-16 |
Family
ID=69387542
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911041432.6A Active CN110781191B (en) | 2019-10-30 | 2019-10-30 | Processing method of layout data and server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110781191B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111459813B (en) * | 2020-03-30 | 2023-08-15 | 北京百度网讯科技有限公司 | Test processing method and device |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8332433B2 (en) * | 2010-10-18 | 2012-12-11 | Verisign, Inc. | Database synchronization and validation |
| CN107122368B (en) * | 2016-02-25 | 2021-05-28 | 阿里巴巴集团控股有限公司 | Data verification method and device and electronic equipment |
| CN107124627A (en) * | 2017-04-28 | 2017-09-01 | 环球智达科技（北京）有限公司 | A kind of update method of interface typesetting |
| CN110309052A (en) * | 2019-05-22 | 2019-10-08 | 梁俊杰 | A kind of data verification method and relevant device |
-
2019
- 2019-10-30 CN CN201911041432.6A patent/CN110781191B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN110781191A (en) | 2020-02-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI739803B (en) | Method and device for placing page resources | |
| CN110716783A (en) | Front-end page generation and deployment method and device, storage medium and equipment | |
| CN109472524B (en) | Information processing method and device | |
| CN107015987B (en) | Method and equipment for updating and searching database | |
| CN108536467B (en) | Code positioning processing method and device, terminal equipment and storage medium | |
| CN104424266A (en) | Web page publishing method and system | |
| CN110427775A (en) | Data query authority control method and device | |
| KR20130005057A (en) | Document link system for aligning copied document onto clipboard based on cloud and displaying document and services linkable with document and method thereof | |
| CN115544183A (en) | Data visualization method and device, computer equipment and storage medium | |
| KR20150144169A (en) | Apparatus and Method for Educational Content Management | |
| CN111046640A (en) | Dynamic generation method and device of certification document | |
| CN110781191B (en) | Processing method of layout data and server | |
| CN109189864B (en) | Method, device and equipment for determining data synchronization delay | |
| US20120131053A1 (en) | Webpage content search method and system | |
| CN116186119A (en) | User behavior analysis method, device, equipment and storage medium | |
| US20230177052A1 (en) | Performance of sql execution sequence in production database instance | |
| CN110515946B (en) | Data extraction method, device, equipment and computer readable storage medium | |
| CN110557414B (en) | Method, device and equipment for downloading service scene | |
| CN109982143B (en) | Method, device, medium and equipment for determining video playing time delay | |
| CN111930927A (en) | Evaluation information display method and device, electronic equipment and readable storage medium | |
| CN113065071B (en) | Product information recommendation method and computer equipment | |
| CN115904380B (en) | Page field creation and assembly method, electronic device and computer readable storage medium | |
| CN115118616B (en) | Display result testing method, device, computer equipment and storage medium | |
| KR20130019176A (en) | Method and system for extracting and providing item having annotation on electronic book | |
| CN112988737A (en) | Data storage method and device, data acquisition method and device, and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |