Playlist association method and device of audio and video works, electronic equipment and storage medium

Abstract

The invention discloses a playlist association method and device for audio and video works, electronic equipment and a storage medium, and the method and device are applied to the electronic equipment, and specifically comprise the steps: responding to an uploading association request of a user, generating a session management id, and receiving a plurality of audio and video works and playlist ids; storing an association relationship between the session management id and the playlist id and the audio and video id of each audio and video work into a temporary table; initializing all audio and video ids into a full-amount id list, and sorting the normal final state id list according to the auditing state of each audio and video work; and calculating a global sorting number of each audio and video id based on a default sorting mode, and adding all the audio and video ids into the audio and video playlist relationship formal table based on the global sorting numbers. According to the scheme, a user can add the audio and video works to the specified playlist without manual operation, and the uploading of a large number of audio and video works and the association work with the playlist can be quickly and efficiently processed.

Description

Technical Field

[0001] The present application relates to the field of audio and video technology, and more specifically, to a method, device, electronic device, and storage medium for associating playlists of audio and video works. Background Art

[0002] Non-copyrighted audio and video, including non-copyrighted audio and video, are professionally produced and uploaded online for download or playback by users without claiming copyright. Playlists are tools used on audio and video websites to categorize and manage non-copyrighted audio and video, organizing and displaying multiple audio and video works by specific subject or category. When linking audio and video works, a playlist will add approved audio and video works to the designated playlist in a specific order and include them in the playlist's distribution sequence.

[0003] Currently, users manually associate audio and video works with playlists. This means that after a user uploads non-copyrighted audio and video via a publishing page on a PC or other electronic terminal and passes review, they are required to manually add the approved works to a designated playlist, either individually or in batches, in the desired order. The order of distribution within the playlist can then be adjusted using a drag-and-drop method. This method is suitable for processing a small number of audio and video works, but it requires a significant amount of user effort when uploading large quantities of audio and video works, making it difficult to quickly and efficiently process large-scale uploads. Summary of the Invention

[0004] In view of this, the present application provides a playlist association method, device, electronic device and storage medium for audio and video works, which are used to quickly and efficiently process the upload of large quantities of audio and video works to reduce the user's workload.

[0005] In order to achieve the above objectives, the following solutions are proposed:

[0006] A playlist association method for audio and video works is applied to electronic equipment, and the playlist association method comprises the steps of:

[0007] In response to a user's upload association request, a session management ID is generated and multiple audio and video works and playlist IDs are received, and the association relationship between the session management ID and the playlist ID and the audio and video ID of each audio and video work is stored in a temporary table;

[0008] Initialize all the audio and video IDs into a full ID list based on the status of the session management ID, and sort all the audio and video IDs in a default sorting method according to the review status of each audio and video work;

[0009] The global sorting number of each audio and video ID is calculated in sequence based on the default sorting method, and all the audio and video IDs are added to the audio and video playlist relationship formal table based on the global sorting number.

[0010] Optionally, the step of responding to a user's upload association request, generating a session management ID, receiving multiple audio and video works and playlist IDs, and storing the association relationship between the session management ID and the playlist ID and the audio and video ID of each audio and video work in a temporary table includes the following steps:

[0011] In response to the upload association request, generate an ID acquisition request and upload it to the database;

[0012] receiving the session management ID generated by the database based on the ID acquisition request, where the status of the session management ID is unsubmitted or submitted;

[0013] Based on the session management ID, multiple audio and video works and playlist IDs corresponding to the audio and video works are received and uploaded to a database, wherein the status of the session management ID is unsubmitted before the upload is completed, and the status of the session management ID is submitted after the upload is completed;

[0014] The playlist ID, the session management ID and the association relationship are stored in the temporary table.

[0015] Optionally, the step of initializing all the audio and video IDs into a full ID list based on the status of the session management ID, and sorting all the audio and video IDs in a default sorting manner according to the review status of each audio and video work, includes the following steps:

[0016] When the status of the session management ID is submitted, the playlist ID, the session management ID and all the audio and video IDs are initialized into the full ID list;

[0017] Determining the classification of the audio and video work corresponding to each of the audio and video IDs, and determining the classification corresponding to each of the audio and video IDs, wherein the classification is a normal final state, a deleted final state, or an intermediate state;

[0018] According to the playlist ID associated with each audio and video ID, all the audio and video IDs classified as the normal end state are divided to obtain a normal end state ID list corresponding to each playlist ID;

[0019] All audio and video IDs in the normal final state ID list are sorted according to the default sorting method.

[0020] Optionally, the default sorting method is to sort in ascending or descending order according to the upload time of the audio and video works.

[0021] Optionally, the initializing all the audio and video IDs into a full ID list based on the status of the session management ID, and sorting all the audio and video IDs in a default sorting manner according to the review status of each audio and video work also includes the steps of:

[0022] When the state is classified as the intermediate state, detecting the difference between the current time and the upload time of the audio / video work;

[0023] The difference is judged, and if the difference is less than a threshold, the process ends;

[0024] If the difference is greater than or equal to the threshold, an error is reported and the sorting process of the current audio and video work is terminated.

[0025] Optionally, the step of calculating the global sort number of each audio and video ID in sequence based on the default sorting method, and adding all the audio and video IDs to the audio and video playlist relationship formal table based on the global sorting number, includes the following steps:

[0026] According to the playlist ID associated with each audio and video ID, all the audio and video IDs classified as the normal end state are divided to obtain a normal end state ID list corresponding to each playlist ID;

[0027] All audio and video IDs in the normal final state ID list are sorted according to the default sorting method.

[0028] Obtaining the audio and video playlist relationship formal table of the playlist ID corresponding to the normal final state ID list;

[0029] Take out a cardinality sequence number from the formal table of audio and video playlist relationships, where the cardinality sequence number is the sequence number corresponding to any audio and video ID in the formal table of audio and video playlist relationships;

[0030] Determine a global sort number for each of the audio and video IDs in the normal final state ID list based on the default sorting method and the cardinality sort number;

[0031] Each of the audio and video ids is added to the formal table of audio and video playlist relationships based on the global sort number.

[0032] Optionally, also include:

[0033] Delete all information in the temporary table and the full ID list.

[0034] A playlist association device for audio and video works, applied to electronic equipment, comprising:

[0035] The session management module is configured to respond to a user's upload association request, generate a session management ID, receive multiple audio and video works and playlist IDs, and store the association relationship between the session management ID and the playlist ID and the audio and video ID of each audio and video work in a temporary table;

[0036] a local sorting module configured to initialize all the audio and video IDs into a full ID list based on the status of the session management ID, and sort all the audio and video IDs in a default sorting method according to the review status of each audio and video work, so that each audio and video ID corresponds to a cardinality sort number;

[0037] The global sorting module is configured to calculate the global sorting number of each audio and video ID in sequence based on the default sorting method and the cardinality sorting number, and add all the audio and video IDs to the audio and video playlist relationship formal table based on the global sorting number.

[0038] An electronic device comprising at least one processor and a memory connected to the processor, wherein:

[0039] The memory is used to store computer programs or instructions;

[0040] The processor is used to execute the computer program or instruction so that the electronic device implements the playlist association method for audio and video works as described above.

[0041] A computer-readable storage medium is applied to an electronic device, wherein the storage medium carries one or more computer programs, and the one or more computer programs can be executed by the electronic device, thereby enabling the electronic device to implement the playlist association method for audio and video works as described above.

[0042] As can be seen from the above technical solution, the present application discloses a playlist association method, device, electronic device and storage medium for audio and video works. The method and device are applied to electronic devices, specifically to respond to the user's upload association request, generate a session management ID and receive multiple audio and video works and playlist IDs, and store the association relationship between the session management ID and the playlist ID and the audio and video ID of each audio and video work in a temporary table; initialize all audio and video IDs into a full ID list based on the status of the session management ID, and sort the normal final ID list according to the default sorting method according to the review status of each audio and video work so that each audio and video ID corresponds to a cardinality sorting number; calculate the global sorting number of each audio and video ID in turn based on the default sorting method and the cardinality sorting number, and add all audio and video IDs to the audio and video playlist relationship formal table based on the global sorting number. Through this solution, users can add audio and video works to a specified playlist without manual operation, which reduces the workload and can quickly and efficiently handle the upload of large quantities of audio and video works and the association with the playlist. In addition, this solution can also ensure that the order of audio and video works in the playlist meets the requirements. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.

[0044] Figure 1 This is a flow chart of a method for associating playlists of audio and video works according to an embodiment of the present application;

[0045] Figure 2 A flowchart of a session management process according to an embodiment of the present application;

[0046] Figure 3 This is a flowchart of a local sorting process according to an embodiment of the present application;

[0047] Figure 4 This is a flowchart of another local sorting process according to an embodiment of the present application;

[0048] Figure 5 A flowchart of a global sorting process according to an embodiment of the present application;

[0049] Figure 6 This is a flowchart of another global sorting process according to an embodiment of the present application;

[0050] Figure 7 This is a block diagram of a device for associating playlists of audio and video works according to an embodiment of the present application;

[0051] Figure 8 This is a block diagram of an electronic device according to an embodiment of the present application. DETAILED DESCRIPTION

[0052] The following will be combined with the drawings in the embodiments of this application to clearly and completely describe the technical solutions in the embodiments of this application. Obviously, the embodiments described are only part of the embodiments of this application, not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of this application.

[0053] Currently, users manually associate audio and video works with playlists. This means that when users upload non-copyrighted audio and video through the publishing page of an electronic terminal such as a PC, after the non-copyrighted audio and video passes review, users are required to manually add the approved audio and video works one by one or in batches to a designated playlist in the target order, and adjust the distribution order of the audio and video works within the playlist by dragging and dropping. This method is suitable for processing a small number of audio and video works, but it requires users to expend a huge amount of work when uploading large quantities of audio and video works, making it impossible to quickly and efficiently process the upload of large quantities of audio and video works. In view of the above-mentioned technical problems, the following technical solution is proposed in this application.

[0054] Figure 1 This is a flowchart of a playlist association method for audio and video works according to an embodiment of the present application.

[0055] like Figure 1 As shown, the playlist association method provided in this embodiment is applied to an electronic device, which is used to batch upload audio and video works according to user needs and implement playlist association. The electronic device can be understood as a computer, server, or cloud platform with data computing and information processing capabilities. The playlist association method specifically includes the following steps:

[0056] S1. Generate a session management ID based on the user's upload association request, receive multiple audio and video works and playlist IDs, and then store the association relationship between the session management ID and the playlist ID and the audio and video ID of each audio and video work in a temporary table.

[0057] That is, when a user needs to upload one or more audio and video works, he or she can upload the works by sending an upload association request to the system and generate a session management id. After the system receives the audio and video works uploaded by the user, it stores the id of each audio and video work, that is, the audio and video id, and the association between each audio and video id and the playlist id in a temporary table init_vid_relids. The specific operation process is as follows: Figure 2 As shown:

[0058] S101. Respond to an upload association request, generate an ID acquisition request, and upload it to the database.

[0059] That is, when a user uploads audio and video works through the PC audio and video publishing page, descriptive information including each audio and video work is generated, and an ID acquisition request is generated. The request can be understood as a computer instruction. The ID acquisition request is uploaded to a database, and the database generates a unique session management ID (abbreviated as sessionID) according to the auto-increment primary key based on the ID acquisition request, and returns the session management ID to the PC front end.

[0060] The session management ID can be understood as the identifier of a temporary storage unit corresponding to a batch upload task in the database. The temporary storage unit records the audio and video works that need to be uploaded in this task, as well as the playlist ID and its association with each audio and video work.

[0061] S102: Receive a session management ID generated by the database according to the ID acquisition request.

[0062] The session management id includes two states, one is unsubmitted and the other is submitted. Its function is to mark whether the above-mentioned audio and video works have been submitted. If they are not completed at all or only partially submitted, the status of the session management id is unsubmitted. On the contrary, when all audio and video works are submitted, the status of the session management id is set to submitted.

[0063] S103: Accept the audio and video works and playlist ID based on the session management ID.

[0064] That is, based on the user's upload operation, the audio and video works uploaded by the user are sent to the database, and the playlist IDs associated with all audio and video works are also received.

[0065] S104: Store the playlist ID, session management ID and association relationship in a temporary table.

[0066] The association here refers to the correspondence between the audio / video ID of each audio / video work and the descriptive information for that work in the playlist ID. This descriptive information includes, but is not limited to, the title, content description, serial number, and other attachments. This temporary table stores this information in a list format and in a specific order.

[0067] S2. Based on the status of the session management ID, all audio and video IDs are initialized into a full ID list, and the normal final ID list is sorted according to the review status of each audio and video work.

[0068] After completing the storage of the playlist id, audio and video id and related correspondence in the temporary table, first determine the status of the session management id. When it is found that the status is submitted, initialize the above information into a full id list allList and sort the normal final state id list. The specific process is as follows: Figure 3 shown.

[0069] S201. Initialize the playlist ID, session management ID, and audio and video ID into the full ID list.

[0070] That is, after judging that all audio and video works have been uploaded, the playlist ID, session management ID and audio and video ID are initialized to the full ID list.

[0071] S202: Determine whether the classification of the audio / video work is a normal final state.

[0072] This means determining whether the classification of the audio or video work corresponding to each audio or video ID is normal. This classification includes not only the normal final state but also the deleted final state and the intermediate state. The normal final state includes machine review safety and manual review passed. The deleted final state includes upload failure, transcoding failure, manual review deletion, and user deletion. Intermediate states include uploading, transcoding, and machine review high risk.

[0073] S203: Add the audio and video ID to the normal final state ID list.

[0074] That is, when it is determined that the classification of the audio and video work is a normal final state, the audio and video ID of the audio and video work is added to a normal final state ID list normallist.

[0075] Optionally, based on the playlist ID associated with each audio or video ID, a list of normal end-state IDs corresponding to each playlist ID is created. The audio or video IDs associated with the playlist ID and classified as having a normal end-state are assigned to the list of normal end-state IDs corresponding to the playlist ID. The audio or video IDs in the list of normal end-state IDs may be empty. Based on this, a list of normal end-state IDs corresponding to each playlist ID is obtained, and each list of normal end-state IDs contains the audio or video IDs associated with the playlist ID and having a normal end-state.

[0076] S204: Sort the audio and video IDs by a default sorting method.

[0077] After adding the audio and video IDs to the normal final state ID list, all audio and video IDs in the normal final state ID list are sorted based on the default sorting method to obtain a normal final state ID list. The default sorting method here is a property of the corresponding playlist ID, which can be set or changed through configuration. For example, the default sorting method can be set to sort the audio and video works in descending or ascending order by upload time.

[0078] In addition, after determining the classification of the audio and video works, this application also includes the following steps: Figure 4 shown.

[0079] S205: Detect the difference between the current time and the upload time of the audio / video work.

[0080] That is, when a certain audio or video work is found to be in the intermediate state, the difference between the current time and the upload time of the audio or video work is calculated. The length of this difference can indicate whether it has been in the intermediate state for a long time.

[0081] S206: Determine whether the difference is greater than or equal to a preset threshold.

[0082] The purpose of this determination is to confirm whether the audio or video work has been in an intermediate state for a long period of time. If the difference is not greater than the threshold, it indicates that the audio or video work has not been in the intermediate state for a long time, or that the duration of the intermediate state is within a reasonable range. The process ends and returns to the above step of detecting the difference. Conversely, if the difference is greater than or equal to the threshold, the subsequent steps are executed. This threshold can be determined based on experience and adjusted during actual operation to improve its actual accuracy.

[0083] S207: Perform error reporting and end the sorting process.

[0084] That is, if it is determined that the difference is greater than or equal to the above threshold, an error is reported and an alarm log is printed; the sorting process of the current audio and video work is ended, and other audio and video works are continued to be processed.

[0085] Through the above operations, this application can solve the problem that other audio and video works under the same session ID cannot be processed when the audio and video works are always in an intermediate state due to unpredictable factors.

[0086] S3. Calculate the global sort number of each audio and video ID in sequence based on the default sorting method, and add all audio and video IDs to the audio and video playlist relationship formal table based on the global sorting number.

[0087] After sorting the audio and video IDs of all audio and video works by the default sorting method and obtaining a cardinality sort number corresponding to each audio and video ID in the normal final ID list, calculate the global sort number of each audio and video ID and add it to the audio and video playlist relationship formal table to achieve the playlist association of audio and video works. The specific process is as follows Figure 5 shown.

[0088] S301. Take out at least one cardinality sequence number from the formal table of audio and video playlist relationships.

[0089] Obtain the audio and video playlist relationship table for the playlist ID corresponding to the normal final state ID list. From this audio and video playlist relationship table, determine a cardinality sequence number. The cardinality sequence number is the sequence number corresponding to any audio and video ID in the audio and video playlist relationship table. For example, if the audio and video playlist relationship table for the playlist ID corresponding to the normal final state ID list contains five audio and video items sorted by upload time, with the largest sequence number being 5, then 5 can be used as the cardinality sequence number to represent the maximum sequence number in the current audio and video playlist relationship table, facilitating the determination of the global sequence number of the subsequently added audio and video ID in the audio and video playlist relationship table.

[0090] S302: Calculate the global ranking number of each audio and video ID.

[0091] That is, each audio and video id is taken out from the normal final state id list in turn, and the global sort number of each audio and video is calculated based on the aforementioned default sorting method and cardinality sorting number, so that the playlist association can be performed based on the global sorting number in the future. For example, when the cardinality sorting number corresponding to the normal final state id list is 5, the audio and video id is added to the audio and video playlist relationship formal table, and the audio and video id is sorted in the audio and video playlist relationship formal table according to the default sorting method. Assuming that the default sorting method of this example is the time of adding to the audio and video playlist relationship formal table, the sorting number of the audio and video id in the audio and video playlist relationship formal table should be 6, and 6 is the global sorting number.

[0092] S303: Add each audio and video work to the formal table of audio and video playlist relationships based on the global sorting number.

[0093] After obtaining the global sorting number corresponding to each audio and video ID in each normal final state ID list, the description information of the audio and video work corresponding to the audio and video ID is associated with the audio and video playlist relationship formal table in the audio and video playlist relationship formal table broadlistvideo based on the global sorting number.

[0094] In addition, this embodiment also includes the following steps: Figure 6 As shown,

[0095] S304. Delete all information in the temporary table and the full ID list.

[0096] By deleting the information in the temporary table and the full ID list, such as the session management ID, the description information of the audio and video works, the playlist ID and the audio and video ID, it is easier to re-associate in other subsequent operations.

[0097] As can be seen from the above technical solution, this embodiment provides a playlist association method for audio and video works. The method is applied to electronic devices, specifically to respond to the user's upload association request, generate a session management ID and receive multiple audio and video works and playlist IDs, and store the association relationship between the session management ID and the playlist ID and the audio and video ID of each audio and video work in a temporary table; initialize all audio and video IDs into a full ID list based on the status of the session management ID, and sort the normal final ID list according to the default sorting method based on the review status of each audio and video work, so that each audio and video ID corresponds to a cardinality sorting number; calculate the global sorting number of each audio and video ID in turn based on the default sorting method and the cardinality sorting number, and add all audio and video IDs to the audio and video playlist relationship formal table based on the global sorting number. Through this solution, users can add audio and video works to a specified playlist without manual operation, which reduces the workload, and can quickly and efficiently handle the upload of large quantities of audio and video works and the association with the playlist. In addition, this solution can also ensure that the order of audio and video works in the playlist meets the requirements.

[0098] The flowcharts and block diagrams in the accompanying drawings illustrate the possible implementation architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each box in the flowchart or block diagram can represent a module, program segment, or a part of code, and the module, program segment, or a part of code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order than that marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram and / or flowchart, and the combination of the boxes in the block diagram and / or flowchart, can be implemented with a dedicated hardware-based system that performs the specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0099] Although the operations are depicted in a particular order, this should not be understood as requiring that the operations be performed in the particular order shown or in a sequential order.Multitasking and parallel processing may be advantageous under certain circumstances.

[0100] It should be understood that the various steps described in the method embodiments of the present disclosure may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present disclosure is not limited in this respect.

[0101] Computer program code for performing the operations of the present disclosure may be written in one or more programming languages, or a combination thereof, including, but not limited to, object-oriented programming languages such as Java, Smalltalk, C++, and conventional procedural programming languages such as C or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a stand-alone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer.

[0102] Figure 7 This is a block diagram of a playlist association device for audio and video works according to an embodiment of the present application.

[0103] like Figure 7 As shown, the playlist association device provided in this embodiment is applied to an electronic device, and is used to batch upload audio and video works according to user needs and associate them with playlists. The electronic device can be understood as a computer, server, or cloud platform with data computing and information processing capabilities. The playlist association device specifically includes a session management module 10, a local sorting module 20, and a global sorting module 30.

[0104] The session management module is used to generate a session management ID based on the user's upload association request, receive multiple audio and video works and playlist IDs, and then store the association relationship between the session management ID and the playlist ID and the audio and video ID of each audio and video work in a temporary table.

[0105] That is, when a user needs to upload one or more audio and video works, the system sends an upload association request to upload the works and generates a playlist and session management id. After the system receives the audio and video works uploaded by the user, it stores the id of each audio and video work, that is, the audio and video id, and the association relationship between each audio and video id and the playlist in a temporary table init_vid_relids. The specific operation process is as follows: Figure 2 As shown:

[0106] S101. Respond to an upload association request, generate an ID acquisition request, and upload it to the database.

[0107] That is, when a user uploads audio and video works through the PC audio and video publishing page, descriptive information including each audio and video work is generated, and an ID acquisition request is generated. The request can be understood as a computer instruction. The ID acquisition request is uploaded to a database, and the database generates a unique session management ID (abbreviated as sessionID) according to the auto-increment primary key based on the ID acquisition request, and returns the session management ID to the PC front end.

[0108] The session management ID can be understood as the identifier of a temporary storage unit corresponding to a batch upload task in the database. The temporary storage unit records the audio and video works that need to be uploaded for this task, as well as the playlist ID and its association with each audio and video work.

[0109] S102: Receive a session management ID generated by the database according to the ID acquisition request.

[0110] The session management id includes two states, one is unsubmitted and the other is submitted. Its function is to mark whether the above-mentioned audio and video works have been submitted. If they are not completed at all or only partially submitted, the status of the session management id is unsubmitted. On the contrary, when all audio and video works are submitted, the status of the session management id is set to submitted.

[0111] S103: Accept the audio and video works and playlist ID based on the session management ID.

[0112] That is, based on the user's upload operation, the audio and video works uploaded by the user are sent to the database, and the playlist IDs associated with all audio and video works are received at the same time.

[0113] S104: Store the playlist ID, session management ID and association relationship in a temporary table.

[0114] The association here refers to the correspondence between the audio / video ID of each audio / video work and the descriptive information for that work in the playlist ID. This descriptive information includes, but is not limited to, the title, content description, serial number, and other attachments. This temporary table stores this information in a list format and in a specific order.

[0115] The local session module is used to initialize all audio and video IDs into a full ID list based on the status of the session management ID, and sort the normal final ID list according to the review status of each audio and video work.

[0116] After completing the storage of the playlist id, audio and video id and related correspondence in the temporary table, first determine the status of the session management id. When it is found that the status is submitted, initialize the above information into a full id list allList and sort the normal final state id list. The specific process is as follows: Figure 3 shown.

[0117] S201. Initialize the playlist ID, session management ID, and audio and video ID into the full ID list.

[0118] That is, after judging that all audio and video works have been uploaded, the playlist, session management ID and audio and video ID are initialized to the full ID list.

[0119] S202: Determine whether the classification of the audio / video work is a normal final state.

[0120] This means determining whether the classification of the audio or video work corresponding to each audio or video ID is normal. This classification includes not only the normal final state but also the deleted final state and the intermediate state. The normal final state includes machine review safety and manual review passed. The deleted final state includes upload failure, transcoding failure, manual review deletion, and user deletion. Intermediate states include uploading, transcoding, and machine review high risk.

[0121] S203: Add the audio and video ID to the normal final state ID list.

[0122] That is, when it is determined that the classification of the audio and video work is a normal final state, the audio and video ID of the audio and video work is added to a normal final state ID list normallist.

[0123] Optionally, based on the playlist ID associated with each audio or video ID, a list of normal end-state IDs corresponding to each playlist ID is created. The audio or video IDs associated with the playlist ID and classified as having a normal end-state are assigned to the list of normal end-state IDs corresponding to the playlist ID. The audio or video IDs in the list of normal end-state IDs may be empty. Based on this, a list of normal end-state IDs corresponding to each playlist ID is obtained, and each list of normal end-state IDs contains the audio or video IDs associated with the playlist ID and having a normal end-state.

[0124] S204: Sort the audio and video IDs by a default sorting method.

[0125] After adding the audio and video IDs to the normal final state ID list, all audio and video IDs in the normal final state ID list are sorted based on the default sorting method to obtain a normal final state ID list. The default sorting method here is a property of the corresponding playlist ID, which can be set or changed through configuration. For example, the default sorting method can be set to sort the audio and video works in descending or ascending order by upload time.

[0126] In addition, after determining the classification of the audio and video works, this application also includes the following steps: Figure 4 shown.

[0127] S205: Detect the difference between the current time and the upload time of the audio / video work.

[0128] That is, when a certain audio or video work is found to be in the intermediate state, the difference between the current time and the upload time of the audio or video work is calculated. The length of this difference can indicate whether it has been in the intermediate state for a long time.

[0129] S206: Determine whether the difference is greater than or equal to a preset threshold.

[0130] The purpose of this determination is to confirm whether the audio or video work has been in an intermediate state for a long period of time. If the difference is not greater than the threshold, it indicates that the audio or video work has not been in the intermediate state for a long time, or that the duration of the intermediate state is within a reasonable range. The process ends and returns to the above step of detecting the difference. Conversely, if the difference is greater than or equal to the threshold, the subsequent steps are executed. This threshold can be determined based on experience and adjusted during actual operation to improve its actual accuracy.

[0131] S207: Perform error reporting and end the sorting process.

[0132] That is, if it is determined that the difference is greater than or equal to the above threshold, an error is reported and an alarm log is printed; the sorting process of the current audio and video work is ended, and other audio and video works are continued to be processed.

[0133] Through the above operations, this application can solve the problem that other audio and video works under the same session ID cannot be processed when the audio and video works are always in an intermediate state due to unpredictable factors.

[0134] The global sorting module is used to calculate the global sorting number of each audio and video ID in sequence based on the default sorting method, and add all audio and video IDs to the audio and video playlist relationship formal table based on the global sorting number.

[0135] After sorting the audio and video IDs of all audio and video works by the default sorting method and obtaining a cardinality sort number corresponding to each audio and video ID in the normal final ID list, calculate the global sort number of each audio and video ID and add it to the audio and video playlist relationship formal table to achieve the playlist association of audio and video works. The specific process is as follows Figure 5 shown.

[0136] S301. Take out at least one cardinality sequence number from the formal table of audio and video playlist relationships corresponding to each audio and video.

[0137] Obtain the audio and video playlist relationship table for the playlist ID corresponding to the normal final state ID list. From this audio and video playlist relationship table, determine a cardinality sequence number. The cardinality sequence number is the sequence number corresponding to any audio and video ID in the audio and video playlist relationship table. For example, if the audio and video playlist relationship table for the playlist ID corresponding to the normal final state ID list contains five audio and video items sorted by upload time, with the largest sequence number being 5, then 5 can be used as the cardinality sequence number to represent the maximum sequence number in the current audio and video playlist relationship table, facilitating the determination of the global sequence number of the subsequently added audio and video ID in the audio and video playlist relationship table.

[0138] S302: Calculate the global ranking number of each audio and video ID.

[0139] That is, each audio and video id is taken out from the normal final state id list in turn, and the global sort number of each audio and video is calculated based on the aforementioned default sorting method and cardinality sorting number, so that the playlist association can be performed based on the global sorting number in the future. For example, when the cardinality sorting number corresponding to the normal final state id list is 5, the audio and video id is added to the audio and video playlist relationship formal table, and the audio and video id is sorted in the audio and video playlist relationship formal table according to the default sorting method. Assuming that the default sorting method of this example is the time of adding to the audio and video playlist relationship formal table, the sorting number of the audio and video id in the audio and video playlist relationship formal table should be 6, and 6 is the global sorting number.

[0140] S303: Add each audio and video work to the formal table of audio and video playlist relationships based on the global sorting number.

[0141] After obtaining the global sorting number corresponding to each audio and video ID in each normal final state ID list, the description information of the audio and video works corresponding to the audio and video ID is associated with the audio and video playlist relationship formal table broadlistvideo based on the global sorting number. The audio and video playlist relationship formal table can be understood as the global playlist of the system.

[0142] In addition, this embodiment also includes the following steps: Figure 6As shown,

[0143] S304. Delete all information in the temporary table and the full ID list.

[0144] By deleting the information in the temporary table and the full ID list, such as the session management ID, description information of the audio and video works, playlists and audio and video IDs, it is easier to re-associate in other subsequent operations.

[0145] As can be seen from the above technical solution, this embodiment provides a playlist association device for audio and video works, which is applied to electronic devices, specifically to respond to the user's upload association request, generate a session management id and receive multiple audio and video works, and store the playlist, session management id and the association relationship between the playlist and the audio and video id of each audio and video work in a temporary table; initialize all audio and video ids into a full id list based on the status of the session management id, and sort the normal final state id list according to the default sorting method according to the review status of each audio and video work, so that each audio and video id corresponds to a cardinality sorting number; calculate the global sorting number of each audio and video id in turn based on the default sorting method and the cardinality sorting number, and add all audio and video ids to the audio and video playlist relationship formal table based on the global sorting number. Through this solution, users do not need manual operation to add audio and video works to a specified playlist, which reduces the workload, and can quickly and efficiently handle the upload of large quantities of audio and video works and the association with the playlist. In addition, this solution can also ensure that the order of audio and video works in the playlist meets the requirements.

[0146] The units involved in the embodiments described in this disclosure may be implemented in software or hardware. In some cases, the name of a unit does not limit the unit itself. For example, the first acquisition unit may also be described as a "unit for acquiring at least two Internet Protocol addresses."

[0147] The functions described above herein may be performed, at least in part, by one or more hardware logic components. For example, and without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like.

[0148] Figure 8 This is a block diagram of an electronic device according to an embodiment of the present application.

[0149] Reference below Figure 8, which shows a schematic diagram of the structure of an electronic device suitable for implementing the embodiments of the present disclosure. The terminal devices in the embodiments of the present disclosure may include, but are not limited to, mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. This electronic device is merely an example and should not limit the functionality or scope of use of the embodiments of the present disclosure.

[0150] The electronic device may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 801, which can perform various appropriate actions and processes according to programs stored in a read-only memory (ROM) 802 or programs loaded from an input device 806 into a random access memory (RAM) 803. The RAM also stores various programs and data required for the operation of the electronic device. The processing device, ROM, and RAM are interconnected via a bus 804. An input / output (I / O) interface 805 is also connected to the bus 804.

[0151] Typically, the following devices may be connected to the I / O interface: input devices such as a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; output devices 807 such as a liquid crystal display (LCD), speaker, vibrator, etc.; storage devices 808 such as a magnetic tape, hard disk, etc.; and communication devices 809. Communication devices 809 may allow the electronic device to communicate with other devices wirelessly or by wire to exchange data. Although the figure shows an electronic device with various devices, it should be understood that it is not required to implement or have all of the devices shown. More or fewer devices may alternatively be implemented or have.

[0152] The embodiment of the present application also provides an embodiment of a computer-readable storage medium.

[0153] The computer-readable storage medium is applied to an electronic device and carries one or more computer programs. When the one or more computer programs are executed by the electronic device, the electronic device responds to the user's upload association request, generates a session management ID, receives multiple audio and video works, and stores the association between the playlist, the session management ID, and the playlist and the audio and video ID of each audio and video work in a temporary table; initializes all audio and video IDs into a full ID list based on the status of the session management ID, and sorts the normal final ID list according to the default sorting method based on the review status of each audio and video work so that each audio and video ID corresponds to a cardinality sort number; calculates the global sort number of each audio and video ID based on the default sorting method and the cardinality sort number, and adds all audio and video IDs to the formal table of audio and video playlist relationships based on the global sorting number. Through this solution, users can add audio and video works to a specified playlist without manual operation, reducing workload, and can quickly and efficiently handle the upload of large quantities of audio and video works and the association work with the playlist. In addition, this solution can also ensure that the order of audio and video works in the playlist meets the requirements.

[0154] It should be noted that the computer-readable medium mentioned above in the present disclosure may be a computer-readable signal medium or a computer-readable storage medium or any combination thereof. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or component, or any combination thereof. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof.

[0155] In this disclosure, a computer-readable storage medium may be any tangible medium that contains or stores a program for use by or in conjunction with an instruction execution system, apparatus, or device. Furthermore, in this disclosure, a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport a program for use by or in conjunction with an instruction execution system, apparatus, or device. Program code embodied on a computer-readable medium may be transmitted using any suitable medium, including but not limited to wire, fiber optic cable, RF (radio frequency), or any suitable combination thereof.

[0156] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.

[0157] Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they become aware of the basic creative concepts. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the embodiments of the present invention.

[0158] Finally, it should be noted that, in this document, relational terms such as first and second, etc., are used only to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any actual relationship or order between these entities or operations. Moreover, the terms "comprises," "comprising," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or terminal device that includes a series of elements includes not only those elements, but also other elements not explicitly listed, or elements inherent to such process, method, article, or terminal device. In the absence of further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article, or terminal device that includes the element.

[0159] The technical solution provided by the present invention is introduced in detail above. Specific examples are used herein to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea. At the same time, for those skilled in the art, according to the idea of the present invention, there may be changes in the specific implementation methods and application scope. In summary, the content of this specification should not be understood as limiting the present invention.

Claims

1. A playlist association method for audio and video works, applied to electronic equipment, characterized in that: The playlist association method comprises the steps of: In response to a user's upload association request, a session management ID is generated and multiple audio and video works and playlist IDs are received, and the association relationship between the session management ID and the playlist ID and the audio and video ID of each audio and video work is stored in a temporary table; Initialize all the audio and video IDs into a full ID list based on the status of the session management ID, and sort all the audio and video IDs in a default sorting method according to the review status of each audio and video work; The global sorting number of each audio and video ID is calculated in sequence based on the default sorting method, and all the audio and video IDs are added to the audio and video playlist relationship formal table based on the global sorting number.

2. The playlist association method according to claim 1, wherein: The method of responding to a user's upload association request, generating a session management ID, receiving multiple audio and video works and playlist IDs, and storing the association relationship between the session management ID, the playlist ID, and the audio and video ID of each audio and video work in a temporary table includes the following steps: In response to the upload association request, generate an ID acquisition request and upload it to the database; receiving the session management ID generated by the database based on the ID acquisition request, where the status of the session management ID is unsubmitted or submitted; Based on the session management ID, multiple audio and video works and playlist IDs corresponding to the audio and video works are received and uploaded to a database, wherein the status of the session management ID is unsubmitted before the upload is completed, and the status of the session management ID is submitted after the upload is completed; The playlist ID, the session management ID and the association relationship are stored in the temporary table.

3. The playlist association method according to claim 1, wherein: The method of initializing all the audio and video IDs into a full ID list based on the status of the session management ID, and sorting all the audio and video IDs in a default sorting method according to the review status of each audio and video work, includes the following steps: When the status of the session management ID is submitted, the playlist ID, the session management ID and all the audio and video IDs are initialized into the full ID list; Determining the classification of the audio / video work corresponding to each of the audio / video IDs, and determining the classification corresponding to each of the audio / video IDs, wherein the classification is a normal final state, a deleted final state, or an intermediate state; According to the playlist ID associated with each audio and video ID, all the audio and video IDs classified as the normal end state are divided to obtain a normal end state ID list corresponding to each playlist ID; All audio and video IDs in the normal final state ID list are sorted according to the default sorting method.

4. The playlist association method according to claim 3, wherein: The default sorting method is to sort in ascending or descending order according to the upload time of the audio and video works.

5. The playlist association method according to claim 3, wherein: The method of initializing all the audio and video IDs into a full ID list based on the status of the session management ID, and sorting all the audio and video IDs in a default sorting method according to the review status of each audio and video work, further includes the steps of: When the state is classified as intermediate, detecting the difference between the current time and the upload time of the audio / video work; The difference is judged, and if the difference is less than a threshold, the process ends; If the difference is greater than or equal to the threshold, an error is reported and the sorting process of the current audio and video work is terminated.

6. The playlist association method according to claim 3, wherein: The method of calculating the global sort number of each audio and video ID in sequence based on the default sorting method, and adding all the audio and video IDs to the audio and video playlist relationship formal table based on the global sorting number, includes the following steps: Obtaining the audio and video playlist relationship formal table of the playlist ID corresponding to the normal final state ID list; Take out a cardinality sequence number from the formal table of audio and video playlist relationships, where the cardinality sequence number is the sequence number corresponding to any audio and video ID in the formal table of audio and video playlist relationships; Determine a global sort number for each of the audio and video IDs in the normal final state ID list based on the default sorting method and the cardinality sort number; Each of the audio and video ids is added to the formal table of audio and video playlist relationships based on the global sort number.

7. The playlist association method according to claim 6, wherein: Also includes: Delete all information in the temporary table and the full ID list.

8. A playlist association device for audio and video works, applied to electronic equipment, characterized in that: The playlist associating device includes: The session management module is configured to respond to a user's upload association request, generate a session management ID, receive multiple audio and video works and playlist IDs, and store the association relationship between the session management ID and the playlist ID and the audio and video ID of each audio and video work in a temporary table; A local sorting module is configured to initialize all the audio and video IDs into a full ID list based on the status of the session management ID, and sort all the audio and video IDs in a default sorting method according to the review status of each audio and video work; The global sorting module is configured to calculate the global sorting number of each audio and video ID in sequence based on the default sorting method, and add all the audio and video IDs to the audio and video playlist relationship formal table based on the global sorting number.

9. An electronic device, characterized in that: The electronic device comprises at least one processor and a memory connected to the processor, wherein: The memory is used to store computer programs or instructions; The processor is used to execute the computer program or instruction so that the electronic device implements the playlist association method for audio and video works as described in any one of claims 1 to 7.

10. A computer-readable storage medium, applied to an electronic device, characterized in that: The storage medium carries one or more computer programs, and the one or more computer programs can be executed by the electronic device, so that the electronic device can implement the playlist association method for audio and video works as described in any one of claims 1 to 7.

Images