CN117235046B - Account migration data updating method, device, computer equipment and storage medium - Google Patents
Account migration data updating method, device, computer equipment and storage mediumInfo
- Publication number
- CN117235046B CN117235046B CN202311214075.5A CN202311214075A CN117235046B CN 117235046 B CN117235046 B CN 117235046B CN 202311214075 A CN202311214075 A CN 202311214075A CN 117235046 B CN117235046 B CN 117235046B
- Authority
- CN
- China
- Prior art keywords
- migration
- identity
- account
- user
- post
- 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
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
本申请涉及一种账号迁移数据更新方法、装置、计算机设备、存储介质和计算机程序产品，涉及大数据技术领域。所述方法包括：获取账号迁移数据表；请求获取目标用户列表的迁移后身份标识，得到迁移后身份标识数组；针对各目标用户列表中的任一用户，在迁移后身份标识数组中存在与任一用户对应的迁移后身份标识的情况下，更新任一用户在账号迁移数据表中的当前身份标识为迁移后身份标识，并更新任一用户在账号迁移数据表中的处理标识为已迁移。采用本方法能够提升账号迁移的数据迁移效率。
The present application relates to an account migration data update method, apparatus, computer equipment, storage medium, and computer program product, and relates to the field of big data technology. The method comprises: obtaining an account migration data table; requesting to obtain the post-migration identity identifier of the target user list, and obtaining a post-migration identity identifier array; for any user in each target user list, if a post-migration identity identifier corresponding to any user exists in the post-migration identity identifier array, updating the current identity identifier of any user in the account migration data table to the post-migration identity identifier, and updating the processing identifier of any user in the account migration data table to migrated. This method can improve the data migration efficiency of account migration.
Description
Technical Field
The present application relates to the field of big data technologies, and in particular, to a method, an apparatus, a computer device, a storage medium, and a computer program product for updating account migration data.
Background
When the subject name of the service object is changed, the subject of the service handling public number in the instant messaging software also needs to be changed, the service handling public number does not support direct modification of the public number platform subject, and the influence on service propaganda and handling functions is reduced for keeping the concerned users in the service handling public number, so that the public number account number of the service handling public number needs to be migrated, and the stable change of the subject is realized. Wherein the business object comprises a financial institution such as a bank.
During the checking period of the account migration request, if the user who has paid attention to the public number cancels the attention, the conversion interface of the instant messaging software cannot normally return a new identity identifier for the user, such as openid, in the migration process, and further, the conversion task is forcibly stopped by manual intervention, so that the interruption of the migration task is caused, and the data migration efficiency of the account migration by the business handling public number is greatly reduced.
Disclosure of Invention
In view of the foregoing, it is desirable to provide an account migration data updating method, apparatus, computer device, computer readable storage medium and computer program product that can improve the data migration efficiency of account migration.
In a first aspect, the application provides an account migration data updating method. The method comprises the following steps:
The method comprises the steps of obtaining an account migration data table, wherein the account migration data table is used for indicating a concerned user in a service handling public number before migration to a service handling public number after migration, the account migration data table comprises an identification before migration and a processing identification corresponding to each concerned user, the identification before migration is the identification of the concerned user in the service handling public number before migration, and the processing identification is used for representing the migration state of the concerned user;
the method comprises the steps of requesting to acquire a migrated identity of a target user list to obtain a migrated identity array, wherein the target user list comprises a preset batch number of the concerned users which are not migrated by the processing identity;
And updating the current identity of any user in the account migration data table to be the migrated identity and updating the processing identity of any user in the account migration data table to be migrated under the condition that the migrated identity corresponding to the any user exists in the migrated identity array aiming at any user in each target user list.
In one embodiment, the method further comprises:
Acquiring verification preparation data of any user in the account migration data table; the verification preparation data comprise the current identity and the historical identity of the any user in the account migration data table;
consistency verification is carried out on the current identity and the historical identity, and a verification result is obtained;
And updating the processing identification of any user in the account migration data table to be not migrated under the condition that the verification result is that the information of the new user and the old user is inconsistent.
In one embodiment, the method further comprises:
And under the condition that the post-migration identity corresponding to any user exists in the post-migration identity array, updating the historical identity of the any user in the account migration data table to be the pre-migration identity.
In one embodiment, before the step of obtaining the account migration data table, the method further includes:
The data record before migration is used for updating the account migration data table;
under the condition that the data record acquisition before migration is completed, submitting a migration audit request aiming at the service handling public number to a management platform of the service handling public number;
the migration checking request is used for requesting the management platform to check whether the concerned user in the pre-migration business handling public numbers can be migrated to the post-migration business handling public numbers.
In one embodiment, the method further comprises:
Receiving the migration audit passing instruction fed back by the management platform according to the migration audit request;
and responding to the migration audit passing instruction, executing the step of requesting to acquire the migrated identity of the target user list and obtaining a migrated identity array.
In one embodiment, the obtaining the migrated identity of the target user list to obtain the migrated identity array includes:
screening the target user list from the concerned users recorded in the account migration data table according to the preset batch number;
calling a preset identification conversion interface according to the pre-migration identification corresponding to each user in the target user list so as to enable the preset identification conversion interface to return to the post-migration identification corresponding to each user in the target user list;
and obtaining the migrated identity identification array according to the returned result of the preset identity conversion interface.
In one embodiment, the method further comprises:
And under the condition that the migrated identity corresponding to any user does not exist in the migrated identity array, updating the processing identification of any user in the account migration data table to be unnecessary to migrate.
In a second aspect, the application further provides an account migration data updating device. The device comprises:
The system comprises a data table acquisition module, a processing module and a processing module, wherein the data table acquisition module is used for acquiring an account migration data table, the account migration data table is used for indicating that the concerned user in the business handling public numbers before migration is migrated to the business handling public numbers after migration, the account migration data table comprises identification marks before migration and processing identification marks corresponding to the concerned users, the identification marks before migration are identification marks of the concerned user in the business handling public numbers before migration, and the processing identification marks are used for representing migration states of the concerned user;
The post-migration identity identification request module is used for requesting to acquire the post-migration identity identification of a target user list to obtain a post-migration identity identification array, wherein the target user list comprises a preset batch number of the concerned users which are not migrated by the processing identification;
The data table updating module is used for updating the current identity of any user in the account number migration data table to be the migrated identity and updating the processing identity of the any user in the account number migration data table to be migrated when the migrated identity corresponding to the any user exists in the migrated identity array for any user in each target user list.
In one embodiment, the apparatus further comprises:
the system comprises a verification data acquisition module, a verification data storage module and a verification data storage module, wherein the verification data acquisition module is used for acquiring verification preparation data of any user in the account migration data table, wherein the verification preparation data comprises the current identity identifier and the historical identity identifier of the any user in the account migration data table;
The verification module is used for carrying out consistency verification on the current identity mark and the historical identity mark to obtain a verification result;
And the first processing identifier updating module is used for updating the processing identifier of any user in the account migration data table to be not migrated under the condition that the verification result is that the information of the new user is inconsistent with the information of the old user.
In one embodiment, the apparatus further comprises:
and the history identification updating module is used for updating the history identification of the any user in the account number migration data table to be the identification before migration under the condition that the identification after migration corresponding to the any user exists in the identification after migration array.
In one embodiment, the apparatus further comprises:
the data record acquisition module is used for acquiring a data record before migration, wherein the data record before migration is used for updating the account migration data table;
the migration audit request submitting module is used for submitting a migration audit request aiming at the service handling public number to the management platform of the service handling public number under the condition that the data record acquisition before migration is completed;
the migration checking request is used for requesting the management platform to check whether the concerned user in the pre-migration business handling public numbers can be migrated to the post-migration business handling public numbers.
In one embodiment, the apparatus further comprises:
The migration audit passing instruction receiving module is used for receiving the migration audit passing instruction fed back by the management platform according to the migration audit request;
and the migration audit passing instruction execution module is used for responding to the migration audit passing instruction, executing the step of requesting to acquire the migrated identity of the target user list and obtaining a migrated identity array.
In one embodiment, the post-migration identity request module includes:
the target user list batch acquisition module is used for screening the target user list from the concerned users recorded in the account migration data table according to the preset batch number;
The identification conversion interface calling module is used for calling a preset identification conversion interface according to the pre-migration identification corresponding to each user in the target user list so as to enable the preset identification conversion interface to return the post-migration identification corresponding to each user in the target user list;
And the array acquisition module is used for acquiring the migrated identity identification array according to the returned result of the preset identity conversion interface.
In one embodiment, the apparatus further comprises:
and the second processing identifier updating module is used for updating the processing identifier of any user in the account number migration data table to be unnecessary to migrate under the condition that the migrated identity corresponding to any user does not exist in the migrated identity array.
In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor which when executing the computer program performs the steps of:
The method comprises the steps of obtaining an account migration data table, wherein the account migration data table is used for indicating a concerned user in a service handling public number before migration to a service handling public number after migration, the account migration data table comprises an identification before migration and a processing identification corresponding to each concerned user, the identification before migration is the identification of the concerned user in the service handling public number before migration, and the processing identification is used for representing the migration state of the concerned user;
the method comprises the steps of requesting to acquire a migrated identity of a target user list to obtain a migrated identity array, wherein the target user list comprises a preset batch number of the concerned users which are not migrated by the processing identity;
And updating the current identity of any user in the account migration data table to be the migrated identity and updating the processing identity of any user in the account migration data table to be migrated under the condition that the migrated identity corresponding to the any user exists in the migrated identity array aiming at any user in each target user list.
In a fourth aspect, the present application also provides a computer-readable storage medium. The computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:
The method comprises the steps of obtaining an account migration data table, wherein the account migration data table is used for indicating a concerned user in a service handling public number before migration to a service handling public number after migration, the account migration data table comprises an identification before migration and a processing identification corresponding to each concerned user, the identification before migration is the identification of the concerned user in the service handling public number before migration, and the processing identification is used for representing the migration state of the concerned user;
the method comprises the steps of requesting to acquire a migrated identity of a target user list to obtain a migrated identity array, wherein the target user list comprises a preset batch number of the concerned users which are not migrated by the processing identity;
And updating the current identity of any user in the account migration data table to be the migrated identity and updating the processing identity of any user in the account migration data table to be migrated under the condition that the migrated identity corresponding to the any user exists in the migrated identity array aiming at any user in each target user list.
In a fifth aspect, the present application also provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, implements the steps of:
The method comprises the steps of obtaining an account migration data table, wherein the account migration data table is used for indicating a concerned user in a service handling public number before migration to a service handling public number after migration, the account migration data table comprises an identification before migration and a processing identification corresponding to each concerned user, the identification before migration is the identification of the concerned user in the service handling public number before migration, and the processing identification is used for representing the migration state of the concerned user;
the method comprises the steps of requesting to acquire a migrated identity of a target user list to obtain a migrated identity array, wherein the target user list comprises a preset batch number of the concerned users which are not migrated by the processing identity;
And updating the current identity of any user in the account migration data table to be the migrated identity and updating the processing identity of any user in the account migration data table to be migrated under the condition that the migrated identity corresponding to the any user exists in the migrated identity array aiming at any user in each target user list.
According to the account migration data updating method, the device, the computer equipment, the storage medium and the computer program product, the account migration data table is firstly obtained, then the migrated identity of the target user list is requested to be obtained, the migrated identity array is obtained, finally under the condition that the migrated identity exists in the migrated identity array, the current identity of any user is updated to be the migrated identity, the processing identity of any user is updated to be migrated, the migrated identity is completed according to the state of the processing identity, the processing identity is readjusted after the data updating is completed to change the migration state, the migrated user is accurately distinguished from the user without the migration, the influence of the interrupt of the migration task caused by the cancellation of attention of the user in the migration checking process on batches is avoided, the unprocessed data can be automatically restarted and accurately screened out to continue processing when the task is interrupted, the continuous processing of the task is ensured, and the technical effect of improving the data migration efficiency of the account migration by handling public number is obtained.
Drawings
FIG. 1 is an application environment diagram of an account migration data update method in one embodiment;
FIG. 2 is a flowchart of a method for updating account migration data in one embodiment;
Fig. 3 is a flowchart of a method for updating account migration data in another embodiment;
fig. 4 is a flowchart of a method for updating account migration data in another embodiment;
FIG. 5 is a schematic flow chart of an account migration data updating method in one embodiment;
FIG. 6 is a block diagram of an account migration data update apparatus in one embodiment;
FIG. 7 is an internal block diagram of a computer device in one embodiment;
Fig. 8 is an internal structural view of a computer device in another embodiment.
Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
It should be noted that, the user information (including but not limited to user equipment information, user personal information, etc.) and the data (including but not limited to data for analysis, stored data, presented data, etc.) related to the present application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use and processing of the related data need to comply with the related laws and regulations and standards of the related country and region.
It should be noted that the account migration data updating method, the device, the computer equipment, the storage medium and the computer program product disclosed by the application can be applied to the field of financial science and technology, and can also be applied to any field except the field of financial science and technology.
The account migration data updating method provided by the embodiment of the application can be applied to an application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network.
The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices, and portable wearable devices, where the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart vehicle devices, and the like. The portable wearable device may be a smart watch, smart bracelet, headset, or the like. The server 104 may be implemented as a stand-alone server or as a server cluster of multiple servers.
In one embodiment, as shown in fig. 2, an account migration data updating method is provided, and the method is applied to the terminal 102 in fig. 1 for illustration, and includes the following steps:
s201, acquiring an account migration data table.
The account migration data table is used for indicating that the concerned users in the service handling public numbers before migration are migrated to the service handling public numbers after migration, the account migration data table comprises identification marks before migration and processing identification marks corresponding to the concerned users, the identification marks before migration are identification marks of the concerned users in the service handling public numbers before migration, the processing identification marks are used for representing migration states of the concerned users, and the service handling public numbers are used for enabling the concerned users to handle services to service objects in instant messaging software, wherein the service objects comprise financial institutions such as banks.
The account migration data table is a member table in instant messaging software, which may be simply referred to as a member table, and includes fields of public number appid, public number openid, process identifier and original public number openid, wherein the values of the process identifier include, but are not limited to, 0, 1 and 2, wherein 0 represents unprocessed or not migrated, 1 represents migrated, and 2 represents that migration is not required. The identification before migration refers to data in a public number openid field in a table before migration.
S202, requesting to acquire the migrated identity of the target user list, and obtaining a migrated identity array.
The target user list comprises a preset number of batches of concerned users which are not migrated and are identified as non-migrated concerned users, the migrated identity is the identity of the concerned users in the migrated business handling public numbers, and the migrated identity refers to openid of requesting a new public number corresponding to the original public number openid acquired from a data interface of instant messaging software.
For example, according to the primary account appid, 100 pieces of user openid data which are identified as unprocessed under the primary account are obtained from the member table of the instant messaging software in batches, and a openid conversion interface of the instant messaging software is called to obtain a new account openid array corresponding to the batch of users.
S203, updating the current identity of any user in the account migration data table to be the migrated identity and updating the processing identity of any user in the account migration data table to be migrated under the condition that the migrated identity corresponding to any user exists in the migrated identity array aiming at any user in each target user list.
The updating process of the representation data is to update each piece of data in the target user list in sequence for any user in each target user list. The method comprises the steps of obtaining a new public number openid from an interface for a user of an original public number openid, storing the new public number openid in a target user list, updating the current identity of the user in an account number migration data table as a migrated identity, realizing the record of the new public number openid, updating the processing identity of the user in the account number migration data table as a migrated identity, changing the migration state of the data, and avoiding repeated updating for the same data.
The new openid array returned by the interface of the instant messaging software is identified as an ok record, and the user record is newly added in the member list, and the assignment process of each field is that public number appid =new account appid, public number openid =new account openid, processing identifier=0-unprocessed, original public number openid =old account openid, and processing identifier of updating old user record=1-migrated.
The identification ok indicates that the migrated identity corresponding to any user exists in the migrated identity array. In addition, in this embodiment, "=" means assignment, meaning that data on the right of an equal sign is assigned to a field of an equal sign coordinate, and correspondingly, "public number appid = new account appid" means that data of "new account appid" is assigned to "public number appid" of this piece of data in a table.
In the account migration data updating method, firstly, the account migration data table is obtained, then, the migrated identity of the target user list is requested to be obtained, a migrated identity array is obtained, finally, under the condition that the migrated identity exists in the migrated identity array, the current identity of any user is updated to be the migrated identity, the processing identity of any user is updated to be migrated, the migrated identity is completed according to the state condition of the processing identity, the processing identity is readjusted after the data updating is completed to change the migration state, the migrated user is accurately distinguished from the user without being migrated, the original account user is ensured to be not repeatedly migrated in batches, the influence on the migration process caused by the interruption of a migration task due to the cancellation of attention of the user in the migration checking process is avoided, the unprocessed data can be automatically restarted and accurately screened out to continue processing when the task is interrupted, the continuation of the task is ensured, and the technical effect of improving the data migration efficiency of account migration by the service handling public number is obtained.
In one embodiment, the method further comprises the steps of obtaining check preparation data of any user in the account migration data table, conducting consistency check on the current identity and the historical identity to obtain a check result, and updating the processing identification of any user in the account migration data table to be not migrated when the check result is that the information of the new user is inconsistent with the information of the old user.
The verification preparation data comprises a current identity mark and a historical identity mark of any user in an account number migration data table, wherein the current identity mark field stores a pre-migration identity mark, the historical identity mark field stores a post-migration identity mark, and the consistency verification refers to verifying whether the information of the new user and the old user is consistent.
After the batch migration is completed, the member list stores two user lists of new public numbers and old public numbers, the member list is added with an original public number openid field, the field is stored when the user record is newly added after the conversion interface is called openid, the openid of the new account can be conveniently identified, the openid of which original account is concerned about the user is converted, whether the new user information and the old user information are consistent or not is checked, if the new user information and the old user information are inconsistent, the processing identification of the original account openid can be changed back to 0-unprocessed, the user record newly added by the new account openid is deleted, the conversion interface is called openid again in batch mode within 15 days after the account migration verification is completed, and the abnormal user is migrated again.
In this embodiment, first, check preliminary data of any user in an account migration data table is obtained, then consistency check is performed on a current identity identifier and a historical identity identifier to obtain a check result, and in the case that information of new and old users is inconsistent, a processing identifier of any user in the account migration data table is updated to be not migrated, so that complete retention of new and old data before and after migration is ensured, normal completion of migration is ensured through consistency check, and a technical effect of improving data migration accuracy of account migration by service handling public numbers is obtained.
In one embodiment, the method further comprises updating the historical identity of any user in the account number migration data table to be the pre-migration identity under the condition that the post-migration identity corresponding to any user exists in the post-migration identity array.
The original public number field is set in the account migration data table, specifically, the data of the old account openid is assigned to the original public number openid field, so that the identity before migration is ensured to be still well-known after the migration is completed.
In this embodiment, under the condition that the post-migration identity corresponding to any user exists in the post-migration identity array, the historical identity of any user in the account migration data table is updated to be the pre-migration identity, so that complete retention of pre-migration data is ensured, data preparation is provided for a consistency verification process, and the technical effect of improving the accuracy of data migration of account migration by service handling public numbers is obtained.
In one embodiment, before the step of acquiring the account number migration data table, the method further comprises the steps of acquiring a pre-migration data record, and submitting a migration audit request for the service handling public number to a service handling public number management platform when the acquisition of the pre-migration data record is completed.
The migration audit request is used for requesting a management platform to audit whether a concerned user in the service handling public number before migration can be migrated to the service handling public number after migration, and the management platform comprises but is not limited to a platform for managing account migration in instant messaging software.
It should be noted that the pre-migration data record includes an identifier of the public number and a pre-migration identifier of the user in the public number, where the identifier of the public number includes, but is not limited to, public number appid.
For example, before submitting an account migration audit, the user openid list of the original account is obtained by calling the interface of the instant messaging software in multiple times, 10000 pieces of data are obtained at most each time, the data are saved in the member list of the instant messaging software, the field values of the public number appid and the public number openid are the original account appid and the original account openid respectively, and the processing identifier=0-unprocessed.
In this embodiment, the pre-migration data record is first obtained, then, under the condition that the pre-migration data record is obtained, a migration audit request for the service handling public number is submitted to a management platform of the service handling public number, so that the complete preparation of data before the transmission of the migration audit request is ensured, and the public number appid is introduced into the account migration data table, so that the number of new and old account users can be distinguished by using the public number appid after migration, and further, the user loss condition caused by the change of a main body is analyzed, and the technical effect of ensuring the completeness of data migration is obtained.
In one embodiment, the method further comprises the steps of receiving a migration audit passing instruction fed back by the management platform according to the migration audit request, responding to the migration audit passing instruction, executing the request to obtain the migrated identity of the target user list, and obtaining a migrated identity array.
The management platform comprises, but is not limited to, a platform for managing account migration in instant messaging software, and migration audit passing instructions are instructions for the management platform to characterize audit passing instructions.
For example, after the account migration audit is completed, according to the original account appid, 100 pieces of user openid data with the processing identifier=0-unprocessed under the original account are obtained from the member table in batches, and a openid conversion interface of the instant messaging software is called to obtain a new account openid array corresponding to the batch of users.
In this embodiment, firstly, a migration audit passing instruction fed back by a management platform according to a migration audit request is received, then a post-migration identity identifier of a target user list is requested to be obtained, a post-migration identity identifier array is obtained, data preparation is completed before migration audit, a data exchange interface is executed by using a processing identifier after migration audit to convert the identity identifier, and an adaptive omnibearing guarantee mode is set for a specific scene in which a migration process is likely to be interrupted, so that a technical effect of improving data migration stability of account migration is obtained.
In one embodiment, the method comprises the steps of obtaining a migrated identity of a target user list by requesting to obtain a migrated identity array, wherein the method comprises the steps of screening the target user list from concerned users recorded in an account migration data list according to the number of preset batches, calling a preset identity conversion interface according to the pre-migration identities corresponding to all users in the target user list so that the preset identity conversion interface returns to the migrated identities corresponding to all users in the target user list, and obtaining the migrated identity array according to the return result of the preset identity conversion interface.
The preset batch number refers to the batch number of the users in the target user list, the identifier conversion interface comprises an interface for openid conversion in a platform of the instant messaging software, and the migrated identity identification array not only comprises successfully acquired migrated identity identifications, but also comprises a result of whether the migrated identity identifications of the users are successfully acquired.
For example, according to the primary account appid, 100 pieces of user openid data with the primary account processing identifier=0-unprocessed are obtained from the member table in batches, and a openid conversion interface of the instant messaging software is called to obtain a new account openid array corresponding to the batch of users.
In this embodiment, a target user list is first screened out from focused users recorded in an account migration data table according to a preset batch number, and then a preset identifier conversion interface is called to obtain migrated identifiers corresponding to each user in the target user list, so as to obtain a migrated identifier array, and the data batch process and the identifier conversion process of the identifier conversion interface are combined by adopting the thinking of batch processing, so that batch acquisition of migrated identifiers is realized, risks brought by instability of the conversion interface to the migration process are reduced, and the technical effect of improving the data migration stability of account migration is obtained.
In one embodiment, the method further comprises updating the processing identifier of any user in the account number migration data table to be unnecessary to migrate under the condition that the migrated identity corresponding to any user does not exist in the migrated identity array.
The identity after migration corresponding to any user does not exist in the identity after migration array, and indicates that the user aiming at the original public number openid does not successfully acquire the new public number openid from the interface, and does not store the new public number openid in the target user list.
Illustratively, for records identified as not ok, no user records are added, only the old user records are updated processing identification = 2-no migration is required. The meaning of the mark as not ok is that the post-migration identity mark does not exist in the post-migration identity mark array.
In this embodiment, under the condition that no post-migration identity corresponding to any user exists in the post-migration identity array, updating the processing identity of any user in the account migration data table to be migration-free, accurately classifying the data of the user which is not required to be migrated, avoiding the problem of migration interruption in the process of performing identity conversion on such data, and obtaining the technical effect of improving the data migration stability and efficiency of account migration.
In another embodiment, as shown in fig. 3, there is provided an account migration data updating method, including the following steps:
S301, acquiring a data record before migration;
s302, under the condition that data record acquisition before migration is completed, submitting a migration audit request aiming at the service handling public number to a management platform of the service handling public number;
S303, acquiring an account migration data table;
s304, receiving a migration audit passing instruction fed back by the management platform according to the migration audit request;
s305, responding to a migration audit passing instruction, and screening a target user list from the concerned users recorded in the account migration data table according to the preset batch number;
S306, calling a preset identification conversion interface according to the pre-migration identity identifications corresponding to the users in the target user list so as to enable the preset identification conversion interface to return to the post-migration identity identifications corresponding to the users in the target user list;
S307, obtaining the migrated identity identification array according to the returned result of the preset identity conversion interface.
It should be noted that, the specific limitation of the above steps may be referred to the specific limitation of an account migration data updating method, which is not described herein.
In another embodiment, as shown in fig. 4, there is provided an account migration data updating method, including the following steps:
S401, updating the current identity of any user in the account migration data table to be the migrated identity, updating the processing identity of any user in the account migration data table to be migrated and updating the historical identity of any user in the account migration data table to be the pre-migration identity under the condition that the migrated identity corresponding to any user exists in the migrated identity array aiming at any user in each target user list.
S402, updating the processing identification of any user in the account number migration data table to be unnecessary to migrate under the condition that the migrated identity corresponding to any user does not exist in the migrated identity array.
S403, obtaining check preparation data of any user in an account migration data table;
s404, carrying out consistency verification on the current identity and the historical identity to obtain a verification result;
And S405, updating the processing identification of any user in the account migration data table as non-migration under the condition that the verification result is that the information of the new user is inconsistent with the information of the old user.
It should be noted that, the specific limitation of the above steps may be referred to the specific limitation of an account migration data updating method, which is not described herein.
In one embodiment, the account migration process of the business handling public numbers comprises an online submitting and checking process, a two-party manager confirming change and a system automatic starting migration process.
The on-line submitting and checking process specifically comprises the steps that an account A initiates migration, an administrator scans for identity verification, clicks a consent related protocol, fills in a target account B, waits for confirmation of the target administrator B, then the administrator A continues filling in application data comprising public letters, public certificates, administrator information and the like, confirms related names, such as original account names, target account names or custom new names, fills in invoice information and pays migration cost, and waits for 1 to 3 working days to pass after checking, namely a 15-day confirmation period of an AB administrator.
Wherein, the confirmation of the change of the two administrators refers to the confirmation of the change of account information, and specifically includes the synchronization of names.
The system automatically starts the migration flow, specifically, after confirmation of both sides, the account A is frozen immediately, a notification is issued before migration, a vermicelli is notified in advance, after the notification is issued for one day, migration data is started, migrated contents comprise data such as vermicelli, mass-sending materials and the like, then old account is recovered, and after migration, a notification is issued to complete migration.
It should be noted that, the two side administrators must confirm the migration notification within 15 days after the success of the audit, and the automatic invalidation needs to be restarted after the timeout, if the migration notification is not received after the success of the audit, the migration notification can be clicked and sent to the account migration page in the background of the public number, and the migration notification can be only issued once a day.
In the automatic system starting migration flow, the purpose of the method for updating account migration data provided by the application is to convert openid of users with attention paid to an original account into a new account openid, and the method specifically comprises the following steps:
The method comprises the steps of (1) creating a member table of a target object in instant messaging software and comprising public numbers appid and openid fields, (2) calling interfaces of the instant messaging software to obtain a user openid list of an original account number in batches before submitting account migration audit, obtaining 10000 pieces of data at most each time, storing the member table, wherein the public numbers appid and openid fields are respectively the original account number appid and the original account number openid, (3) after the account migration audit is completed, obtaining user openid data of 100 original accounts from the member table in batches according to the original account number appid, calling openid conversion interfaces of the instant messaging software to obtain new account number openid arrays corresponding to the users in batches, and (4) updating the public numbers appid and openid fields of the 100 original user records to be the new account numbers appid and openid in batches, and then repeating the step (3) in the embodiment to obtain the next 100 pieces of data to process until all data are converted. In the step (4) in this embodiment, two fields of the public number appid and the public number openid are directly updated on the original user record, and the data size is not increased after the processing is completed.
In this embodiment, it is not considered that during the account migration audit period, the old public number is cancelled due to the original openid, so that the conversion interface of the instant messaging software does not return to the new openid, then the new openid is not updated and saved in step (3) in this embodiment, the processing of obtaining the user data of which attention is cancelled is repeated later, the conversion task is forcibly stopped by manual intervention, and the number of attention users lost due to the failure to evaluate after the migration is completed, so that the migration efficiency of the account data is reduced.
Based on the method, the application provides a batch and unrepeated account migration data updating method for converting openid of users with attention paid to the original account into the new account openid for the migration of the public account, in the process of migrating the public account, the migrated users are accurately distinguished and are not required to be migrated, the original account users are ensured to be stably migrated in batches and unrepeated, unprocessed data can be accurately screened for continuous processing if the task is restarted, and the consistency of the data of the new and old openid users can be conveniently traced and checked after migration.
The account migration data update method is described in detail below in a specific embodiment with reference to fig. 5. It is to be understood that the following description is exemplary only and is not intended to limit the application to the details of construction and the arrangements of the components set forth herein.
It should be noted that, in this embodiment, the account migration data table is specifically a member table in the instant messaging software of the target object, and the identity of the user who has paid attention to is openid.
In this embodiment, by marking whether each user of the original account has migrated, and storing the new openid new records acquired by the interface of the instant messaging software, and recording the old openid of the source, the conversion data acquired in each batch will not be repeated, and each new openid can trace back the old openid. The method comprises the following specific steps:
(1) The optimized membership table contains fields of public number appid, public number openid, process identification, original public number openid, wherein the process identification includes but is not limited to 0-unprocessed, 1-migrated, 2-no-migration.
It should be noted that, according to the official advice of the instant messaging software, the user list of the original account number needs to be obtained before the migration audit is ready to be submitted. During the migration audit period of 1 to 3 working days, the client may cancel the attention when receiving the migration notification, but the openid conversion interface of the instant messaging software must be the user of the old account currently in attention to normally return, otherwise, the error occurs, so that adding the processing identifier in the member list includes 0-unprocessed, 1-migrated and 2-unnecessary migration fields, and the fields are updated after each invocation openid conversion interface, so that the three types of unprocessed, migrated and cancelled user data can be conveniently distinguished.
(2) Before submitting account migration audit, calling an interface of instant messaging software to obtain a user openid list of the original account in a divided manner, obtaining 10000 pieces of data at most each time, and storing the data into a meeting table, wherein the field values of public numbers appid and openid are respectively the original account appid and openid, and the processing identifier=0-unprocessed;
(3) After the account migration audit is completed, according to the original account appid, acquiring 100 pieces of user openid data which are processed under the original account and have the identification=0-unprocessed from a member table of the instant messaging software in batches, and calling a openid conversion interface of the instant messaging software to acquire a new account openid array corresponding to the batch of users;
(4) The new openid array returned by the interface of the instant messaging software is marked as an ok record, a user record is newly added in the member list, and each field is assigned with a public number appid =a new account appid, a public number openid =a new account openid, a processing identifier=0-unprocessed, an original public number openid =an old account openid, and a processing identifier=1-migrated of the old user record, the record marked as not ok is not newly added, only the old user record processing identifier=2-migration is updated, the step (3) in the embodiment is repeated, and then the next 100 pieces of data processing are acquired until all data are converted.
In the embodiment, step (4) determines a new openid array element returned by the interface of the instant messaging software one by one, and marks as an ok record, which indicates that the user concerned has migrated successfully, and may newly add and save a new openid record, an original public number openid =an original account openid, and update a processing identifier=1 of an old user record-the old user record has migrated, and marks as a not ok record, which indicates that the user has cancelled the attention and does not need to migrate, and does not need to newly add a new openid record, and only updates a processing identifier=2 of an old user record-the old user record does not need to migrate.
It should be noted that, the err_msg=ok condition in fig. 5 is satisfied, which indicates that this openid still focuses on the old public number and the conversion is normal during the data conversion, while the err_msg=ok condition is not satisfied, which indicates that this openid does not focus on the old public number, that is, the conversion fails during the data conversion, and the old_user_list.size=100 condition in fig. 5 is satisfied, which indicates that the user data of the batch is not processed one by one and the update needs to be completed.
In this embodiment, by setting the processing identifier, it is ensured that the to-be-processed data obtained in batches in the public number migration process is not repeated, and the old data is still reserved after the migration is completed, so that the number of users of the new account and the old account can be distinguished according to the field of the public number appid, further the user loss caused by the change of the main body is analyzed, and the old user data can be found according to the association of the field of the original public number openid recorded by the new openid, further the consistency of the user information before and after the migration is verified.
It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides an account migration data updating device for realizing the account migration data updating method. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme described in the above method, so the specific limitation in the embodiment of one or more account migration data updating devices provided below can be referred to the limitation of the account migration data updating method hereinabove, and will not be repeated here.
In one embodiment, as shown in fig. 6, there is provided an account migration data updating apparatus, which includes a data table obtaining module 601, a post-migration identity request module 602, and a data table updating module 603, wherein:
The data table acquisition module 601 is configured to acquire an account number migration data table, where the account number migration data table is configured to indicate that a concerned user in a service handling public number before migration is migrated to a service handling public number after migration, the account number migration data table includes a pre-migration identity identifier and a processing identifier corresponding to each concerned user, where the pre-migration identity identifier is an identity identifier in the service handling public number of the concerned user before migration, and the processing identifier is configured to characterize a migration state of the concerned user;
The post-migration identity request module 602 is configured to request to obtain a post-migration identity of the target user list to obtain a post-migration identity array, where the target user list includes a preset number of batches of the concerned users with processing identities not migrated;
The data table updating module 603 is configured to update, for any user in each target user list, if a post-migration identity corresponding to any user exists in the post-migration identity array, a current identity of any user in the account migration data table as a post-migration identity, and update a processing identity of any user in the account migration data table as migrated.
In one embodiment, the device further comprises a verification data acquisition module for acquiring verification preparation data of any user in the account migration data table, wherein the verification preparation data comprise current identification marks and historical identification marks of any user in the account migration data table, a verification module for carrying out consistency verification on the current identification marks and the historical identification marks to obtain a verification result, and a first processing identification updating module for updating processing identification of any user in the account migration data table to be not migrated under the condition that the verification result is inconsistent with information of new and old users.
In one embodiment, the device further comprises a history identification updating module, and when the post-migration identification corresponding to any user exists in the post-migration identification array, the history identification of any user in the account migration data table is updated to be the pre-migration identification.
In one embodiment, the device further comprises a data record acquisition module for acquiring a data record before migration, the data record before migration is used for updating an account number migration data table, and a migration audit request submitting module for submitting a migration audit request aiming at the service handling public numbers to a management platform of the service handling public numbers under the condition that the data record before migration is acquired, wherein the migration audit request is used for requesting the management platform to audit whether the concerned users in the service handling public numbers before migration can be migrated to the service handling public numbers after migration.
In one embodiment, the device further comprises a migration audit passing instruction receiving module for receiving a migration audit passing instruction fed back by the management platform according to the migration audit request, and a migration audit passing instruction executing module for responding to the migration audit passing instruction and executing the step of requesting to acquire the migrated identity of the target user list and obtaining the migrated identity array.
In one embodiment, the post-migration identity request module comprises a target user list batch acquisition module, an identity conversion interface calling module and an array acquisition module, wherein the target user list batch acquisition module is used for screening a target user list from focused users recorded in an account migration data list according to the preset batch number, the identity conversion interface calling module is used for calling a preset identity conversion interface according to pre-migration identities corresponding to all users in the target user list so that the preset identity conversion interface returns the post-migration identities corresponding to all users in the target user list, and the array acquisition module is used for obtaining a post-migration identity array according to a return result of the preset identity conversion interface.
In one embodiment, the device further comprises a second processing identifier updating module, and the processing identifier of any user in the account number migration data table is updated to be unnecessary to migrate under the condition that the migrated identifier corresponding to any user does not exist in the migrated identifier array.
All or part of the modules in the account migration data updating device can be realized by software, hardware and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 7. The computer device includes a processor, a memory, an Input/Output interface (I/O) and a communication interface. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface is connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device is used for storing the related data of account migration. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for communicating with an external terminal through a network connection. The computer program, when executed by a processor, implements a method for updating account migration data.
In one embodiment, a computer device is provided, which may be a terminal, and the internal structure thereof may be as shown in fig. 8. The computer device includes a processor, a memory, an input/output interface, a communication interface, a display unit, and an input means. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program, when executed by a processor, implements a method for updating account migration data. The display unit of the computer device is used for forming a visual picture, and can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be a key, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by persons skilled in the art that the structures shown in fig. 7 and 8 are block diagrams of only portions of structures associated with the present inventive arrangements and are not limiting of the computer device to which the present inventive arrangements are applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device includes a memory having a computer program stored therein and a processor that when executing the computer program performs the steps of the method embodiments described above.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when executed by a processor, carries out the steps of the method embodiments described above.
In an embodiment, a computer program product is provided, comprising a computer program which, when executed by a processor, implements the steps of the method embodiments described above.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magneto-resistive random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (PHASE CHANGE Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in various forms such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), etc. The databases referred to in the embodiments provided herein may include at least one of a relational database and a non-relational database. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processor referred to in the embodiments provided in the present application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic unit, a data processing logic unit based on quantum computing, or the like, but is not limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The foregoing examples illustrate only a few embodiments of the application and are described in detail herein without thereby limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of the application should be assessed as that of the appended claims.
Claims (17)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311214075.5A CN117235046B (en) | 2023-09-19 | 2023-09-19 | Account migration data updating method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311214075.5A CN117235046B (en) | 2023-09-19 | 2023-09-19 | Account migration data updating method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117235046A CN117235046A (en) | 2023-12-15 |
| CN117235046B true CN117235046B (en) | 2025-09-26 |
Family
ID=89090708
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311214075.5A Active CN117235046B (en) | 2023-09-19 | 2023-09-19 | Account migration data updating method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117235046B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110290232A (en) * | 2019-06-25 | 2019-09-27 | 江苏梦嘉控股集团有限公司 | A kind of public platform management method and system |
| CN114254278A (en) * | 2021-11-19 | 2022-03-29 | 中国建设银行股份有限公司 | User account merging method and device, computer equipment and storage medium |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9842321B2 (en) * | 2013-11-15 | 2017-12-12 | Clickswitch, Llc | Centralized financial account migration system |
| CN109543398B (en) * | 2018-11-28 | 2021-06-11 | 深圳市轱辘车联数据技术有限公司 | Application program account migration method and device and electronic equipment |
| CN112965955B (en) * | 2021-03-17 | 2024-01-12 | 北京奇艺世纪科技有限公司 | Data migration method, device, computer equipment and storage medium |
-
2023
- 2023-09-19 CN CN202311214075.5A patent/CN117235046B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110290232A (en) * | 2019-06-25 | 2019-09-27 | 江苏梦嘉控股集团有限公司 | A kind of public platform management method and system |
| CN114254278A (en) * | 2021-11-19 | 2022-03-29 | 中国建设银行股份有限公司 | User account merging method and device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117235046A (en) | 2023-12-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11556874B2 (en) | Block creation based on transaction cost and size | |
| CN114925084A (en) | Distributed transaction processing method, system, device and readable storage medium | |
| CN111340340A (en) | Event processing method and device | |
| CA2896536A1 (en) | Know your customer exchange system and method | |
| CN114444478A (en) | A credential visualization method, device, electronic device and storage medium | |
| CN117235046B (en) | Account migration data updating method, device, computer equipment and storage medium | |
| CN114254278A (en) | User account merging method and device, computer equipment and storage medium | |
| CN114666116B (en) | Authentication processing method, device, equipment and storage medium based on applet | |
| CN116303510A (en) | Resource transfer transaction processing method, device, computer equipment and storage medium | |
| CN110888874B (en) | A device, method and storage medium for creating a form through Excel | |
| CN115879895B (en) | Protocol admittance method, device, computer equipment and storage medium | |
| CN114238292B (en) | Data cleaning method, device, computer equipment and computer readable storage medium | |
| WO2019023538A1 (en) | Data processing systems for generating and populating a data inventory | |
| CN117573717A (en) | Resource interaction business record processing method, device, computer equipment and storage medium | |
| CN116797189A (en) | Information processing method, apparatus, computer device, and storage medium | |
| CN119652969A (en) | Business capability calling method, device, computer equipment and storage medium | |
| CN118552294A (en) | Resource transfer method, device, computer equipment, storage medium and program product | |
| CN117724806A (en) | Block chain transaction processing method, device, computer equipment and storage medium | |
| CN117271449A (en) | Batch file generation method, apparatus, device, storage medium and program product | |
| CN119621727A (en) | Data mapping method, device, computer equipment and storage medium | |
| CN116681403A (en) | Automatic communication identifier updating method, device, computer equipment and storage medium | |
| CN120579195A (en) | Document resource transfer method, device, computer equipment and storage medium | |
| CN117151841A (en) | Service processing method, device, computer equipment, storage medium and program product | |
| CN116680750A (en) | Interactive data processing method and device and computer equipment | |
| CN120743915A (en) | Project design metadata submitting method adopting metadata read lock |
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 |