Audio and video work broadcasting list association method and device, electronic equipment and storage medium

Abstract

The application discloses an audio and video work broadcast order association method and device, an electronic device and a storage medium. The method and device are applied to the electronic device, specifically, a session management id is generated and a plurality of audio and video works and broadcast order ids are received in response to a user's upload association request, and the association relationship between the session management id and the broadcast order id and the audio and video id of each audio and video work is stored in a temporary table; all audio and video ids are initialized to a full id list, and the normal terminal state id list is sorted according to the audit state of each audio and video work; the global sorting number of each audio and video id is calculated based on the default sorting mode, and all audio and video ids are added to the audio and video broadcast order relationship formal table based on the global sorting number. Through the scheme, the user can add the audio and video work to the specified broadcast order without manual operation, and can realize the quick and efficient processing of the upload of a large number of audio and video works and the association with the broadcast order.

Description

TECHNICAL FIELD

[0001] The present application relates to the field of audio and video technology, and more particularly, to an audio and video work broadcast list association method and device, an electronic device, and a storage medium. BACKGROUND

[0002] Non-copyright audio and video includes non-copyright audio and non-copyright video, which is an audio and video work produced by professional users and uploaded to the network without declaring copyright for users to download or play. A broadcast list is a tool for classifying and managing non-copyright audio and video in an audio and video website, and is used to organize and display multiple audio and video works according to a specific subject or category. When associating audio and video works, the broadcast list will add the audio and video works that have passed the audit to a designated broadcast list in a certain order and include them in the broadcast list distribution sequence.

[0003] Currently, the association of audio and video works with a broadcast list is achieved by manual methods. That is, when a user uploads a non-copyright audio and video work through a publishing page on a PC or other electronic terminal, after the non-copyright audio and video work has passed the audit, the user needs to manually add the audio and video works that have passed the audit to the designated broadcast list in the target order one by one or in batches, and adjust the distribution order of the audio and video works in the broadcast list by dragging and sorting. This method is still applicable when dealing with a small number of audio and video works, but when uploading a large number of audio and video works, the user needs to put in a lot of work, making it impossible to quickly and efficiently handle the uploading of a large number of audio and video works. SUMMARY

[0004] Therefore, the present application provides an audio and video work broadcast list association method and device, an electronic device, and a storage medium, which are used to quickly and efficiently handle the uploading of a large number of audio and video works, thereby reducing the workload of the user.

[0005] To achieve the above-mentioned purpose, the present solution is as follows:

[0006] An audio and video work broadcast list association method applied to an electronic device, the broadcast list association method comprising the steps of:

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

[0008] All audio and video ids are initialized to a full id list based on the state of the session management id, and all audio and video ids are sorted in a default sorting manner according to the audit state of each audio and video work;

[0009] Calculate a global order number of each audio-video id based on the default order mode, and add all the audio-video ids into an audio-video order form relation formal table based on the global order number.

[0010] Optionally, in response to the upload association request of the user, a session management id is generated, and multiple audio-video works and order ids are received, and the association relationship between the session management id and the order id and the audio-video id of each audio-video work is stored in a temporary table, including the steps of:

[0011] In response to the upload association request, an id acquisition request is generated and a database is uploaded;

[0012] The session management id generated by the database based on the id acquisition request is received, and the state of the session management id is unsubmitted or submitted;

[0013] Based on the session management id, multiple audio-video works and order ids corresponding to the audio-video works are received and uploaded to the database, and the state of the session management id is unsubmitted before uploading is completed, and the state of the session management id is submitted after uploading is completed;

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

[0015] Optionally, all the audio-video ids are initialized into a full id list based on the state of the session management id, and all the audio-video ids are sorted according to a default order mode according to the audit state of each audio-video work, including the steps of:

[0016] When the state of the session management id is submitted, the order id, the session management id and all the audio-video ids are initialized into the full id list;

[0017] The classification of the audio-video work corresponding to each audio-video id is judged, and the classification corresponding to each audio-video id is determined, and the classification is normal terminal state, deletion terminal state or intermediate state;

[0018] According to the order id associated with each audio-video id, all the audio-video ids classified as the normal terminal state are divided to obtain a normal terminal state id list corresponding to each order id;

[0019] All the audio-video ids in the normal terminal state id list are sorted according to the default order mode.

[0020] Optionally, the default order mode is ascending order or descending order according to the upload time of the audio-video work.

[0021] Optionally, the state based on the session management id initializes all the audio and video ids to a full id list, and sorts all the audio and video ids according to the default sorting mode according to the review state of each audio and video work, and further comprises the steps of:

[0022] When the classification is the intermediate state, detecting a difference value between a current time and an upload time of the audio and video work;

[0023] Judging the difference value, if the difference value is less than a threshold value, ending the process;

[0024] If the difference value is greater than or equal to the threshold value, performing error processing, and ending the sorting processing of the current audio and video work.

[0025] Optionally, the global sorting number of each audio and video id is calculated based on the default sorting mode, and all the audio and video ids are added to the audio and video order list formal table based on the global sorting number, comprising the steps of:

[0026] According to the order id associated with each audio and video id, all the audio and video ids classified as the normal terminal state are divided to obtain a normal terminal state id list corresponding to each order id;

[0027] All audio and video ids in the normal terminal state id list are sorted according to the default sorting mode.

[0028] Obtaining the audio and video order list formal table corresponding to the order id of the normal terminal state id list;

[0029] Taking a base sorting number from the audio and video order list formal table, the base sorting number being a sorting number corresponding to any audio and video id in the audio and video order list formal table;

[0030] Based on the default sorting mode and the base sorting number, the global sorting number of each audio and video id in the normal terminal state id list is determined;

[0031] Based on the global sorting number, each audio and video id is added to the audio and video order list formal table.

[0032] Optionally, further comprising:

[0033] Deleting all information in the temporary table and the full id list.

[0034] An audio and video work order association device applied to an electronic device, the order association device comprising:

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

[0036] The local sorting module is configured to initialize all the audio and video IDs to a full ID list based on the state of the session management ID, and sort all the audio and video IDs according to a default sorting mode according to the audit state of each audio and video work, so that each audio and video ID corresponds to a base sorting number;

[0037] The global sorting module is configured to sequentially calculate the global sorting number of each audio and video ID based on the default sorting mode and the base sorting number, and add all the audio and video IDs to the audio and video broadcast order relationship formal table based on the global sorting number.

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

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

[0040] The processor is used to execute the computer programs or instructions, so that the electronic device implements the broadcast order association method of the audio and video works as described above.

[0041] A computer-readable storage medium applied to an electronic device, the storage medium carrying one or more computer programs, the one or more computer programs being executable by the electronic device, so that the electronic device can implement the broadcast order association method of the audio and video works as described above.

[0042] It can be seen from the technical solutions that the application discloses a video and audio work broadcast order association method and device, an electronic device and a storage medium. The method and the device are applied to the electronic device, specifically, in response to a user's upload association request, a session management id is generated, a plurality of video and audio works and a broadcast order id are received, and the association relationship between the session management id and the broadcast order id and the video and audio id of each video and audio work is stored in a temporary table. All video and audio ids are initialized to a full id list based on the state of the session management id, and the normal terminal state id list is sorted in a default sorting mode according to the audit state of each video and audio work, so that each video and audio id corresponds to a base sequence number. The global sequence number of each video and audio id is calculated based on the default sorting mode and the base sequence number, and all video and audio ids are added to a video and audio broadcast order relationship formal table based on the global sequence number. Through the scheme, the user can add the video and audio work to the specified broadcast order without manual operation, the workload is reduced, and the upload of a large number of video and audio works and the association with the broadcast order can be quickly and efficiently processed. In addition, the scheme can also ensure that the order of the video and audio works in the broadcast order meets the requirements. BRIEF DESCRIPTION OF DRAWINGS

[0043] In order to more clearly illustrate the technical solutions in the embodiments of the application or the prior art, the following will briefly introduce the drawings needed to be used in the embodiments or the prior art description. Obviously, the drawings in the following description are only some embodiments of the application, and for those skilled in the art, other drawings can also be obtained without creative labor based on these drawings.

[0044] Figure 1 A flowchart of a video and audio work broadcast order association method according to an embodiment of the application;

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

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

[0047] Figure 4 A flowchart of another local sorting process according to an embodiment of the application;

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

[0049] Figure 6 A flowchart of another global sorting process according to an embodiment of the application;

[0050] Figure 7 A block diagram of a video and audio work broadcast order association device according to an embodiment of the application;

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

[0052] The technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, rather than all the embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by a person of ordinary skill in the art without creative effort belong to the scope of protection of the present application.

[0053] Currently, the association of audio-video works with a broadcast list is realized by a user in a manual manner. That is, when a user uploads a non-copyright audio-video work through a publishing page of an electronic terminal such as a PC, after the non-copyright audio-video work is audited, the user needs to manually add the audited audio-video work to a specified broadcast list in a target order one by one or in batches, and adjust the distribution order of the audio-video works in the broadcast list by a drag-and-drop method. This method is applicable when a small amount of audio-video works is processed, but when a large amount of audio-video works is uploaded, the user needs to spend a great amount of work, so that the uploading of a large amount of audio-video works cannot be processed quickly and efficiently. In view of the above technical problems, the technical solutions of the present application are proposed as follows.

[0054] Figure 1 A flowchart of a broadcast list association method of an audio-video work according to an embodiment of the present application.

[0055] As shown in Figure 1 , the broadcast list association method provided in the present embodiment is applied to an electronic device, and is used to batch upload audio-video works according to the needs of a user and realize the association of a broadcast list. The electronic device can be understood as a computer, a server or a cloud platform having data calculation and information processing capabilities. The broadcast list association method specifically includes the following steps:

[0056] S1, generating a session management id according to an upload association request of a user, receiving a plurality of audio-video works and a broadcast list id, and then storing the association relationship between the session management id and the broadcast list id and the audio-video id of each audio-video work in a temporary table.

[0057] That is, when the user needs to upload one or more audio-video works, the uploading of the works is realized by sending an upload association request to the system, and a session management id is generated. After the system receives the audio-video works uploaded by the user, the id of each audio-video work, that is, the audio-video id, and the association relationship between each audio-video id and the broadcast list id are stored in a temporary table init_vid_relids. The specific operation process is as follows, as shown in Figure 2 .

[0058] S101, in response to the upload association request, generating an id acquisition request and uploading the database.

[0059] That is, when the user uploads audio and video works through the PC audio and video publishing page, the description information of each audio and video work is generated, and an id acquisition request is generated, which 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 (abbreviation sessionid) according to the id acquisition request according to the self-incrementing primary key, and returns the session management id to the PC front end.

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

[0061] S102, receiving the 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 role is to mark whether the above-mentioned audio and video works have been submitted. If it is not completely completed or only partially submitted, the state of the session management id is unsubmitted. On the contrary, when all audio and video works are submitted, the state of the session management id is set to submitted.

[0063] S103, accepting audio and video works and broadcast order id based on session management id.

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

[0065] S104, storing the broadcast order id, session management id and association relationship in a temporary table.

[0066] The association relationship here refers to the corresponding relationship between the audio and video id of each audio and video work and the description information of the audio and video work in the broadcast order id. The description information includes but is not limited to the theme name, content description information, number, and other attachment information of the audio and video work. The above information is saved in the form of a list in the temporary table in a certain order.

[0067] S2, initializing all audio and video ids to a full id list based on the state of the session management id, and sorting the normal terminal id list according to the audit state of each audio and video work.

[0068] After the insertion of the broadcast order id, audio and video id and the corresponding relationship in the temporary table is completed, the state of the session management id is first judged. When it is found that the state is submitted, the above information is initialized to an all-quantity id list allList, and the normal terminal state id list is sorted. The specific process is as shown in Figure 3

[0069] S201, initialize the broadcast order id, session management id and audio and video id to the all-quantity id list.

[0070] That is, after judging that all audio and video works have been completed uploading, the broadcast order id, session management id and audio and video id are initialized to the all-quantity id list.

[0071] S202, judge whether the classification of the audio and video works is a normal terminal state.

[0072] That is, whether the classification of the audio and video works corresponding to each audio and video id is a normal state is judged. The classification includes not only the normal terminal state, but also the deletion terminal state and the intermediate state. The normal terminal state includes machine review safety and manual review pass, the deletion terminal state includes uploading failure, transcoding failure, manual review deletion and user deletion, and the intermediate state includes uploading, transcoding and machine review high risk.

[0073] S203, add the audio and video id to the normal terminal state id list.

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

[0075] Optionally, according to the broadcast order id associated with each audio and video id, a normal terminal state id list corresponding to each broadcast order id is established. The audio and video id associated with the broadcast order id and classified as a normal terminal state is divided into the normal terminal state id list corresponding to the broadcast order id. The audio and video id in the normal terminal state id list can be empty. Based on this, the normal terminal state id list corresponding to each broadcast order id is obtained. Each normal terminal state id list contains the audio and video id associated with the broadcast order id and classified as a normal terminal state.

[0076] S204, sort the audio and video id according to the default sorting mode.

[0077] ​That is, after adding the audio and video id to the normal terminal state id list, all audio and video ids in the normal terminal state id list are sorted based on the default sorting method to obtain a normal terminal state id list. The default sorting method here is an attribute of the corresponding broadcast order id, which can be set or changed through configuration, for example, the default sorting method can be set to descending or ascending order according to the upload time of the audio and video work.

[0078] In addition, after judging the classification of the audio and video work, the application further includes the following steps, as shown in Figure 4

[0079] S205, detecting the difference between the current time and the upload time of the audio and video work.

[0080] That is, when it is found through judgment that the classification of a certain audio and video work is intermediate, the difference between the current time and the upload time of the audio and video work is calculated. The length of the difference value can represent whether it is in the intermediate state for a long time.

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

[0082] The purpose of the judgment is to confirm whether the audio and video work is in the intermediate state for a long time. If the difference is not greater than the threshold, it means that the audio and video work is not in the intermediate state for a long time, or the time length in the intermediate state is within a reasonable range, then the process is ended and returned to the above step of detecting the difference; on the contrary, if the difference is greater than or equal to the threshold, the subsequent operation steps are executed. The threshold can be determined according to experience, and adjusted through actual operation to improve its actual precision.

[0083] S207, error processing and ending sorting processing.

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

[0085] Through the above operation, the application can solve the problem that other audio and video works under the same sessionid cannot be processed when the audio and video work is in the intermediate state due to unpredictable factors.

[0086] S3, calculating the global ranking number of each audio and video id based on the default sorting method, and adding all audio and video ids to the audio and video broadcast order relationship formal table based on the global ranking number.

[0087] ​After sorting all audio-video works' audio-video ids according to the default sorting mode and obtaining a base sorting number corresponding to each audio-video id in the normal terminal state id list, the global sorting number of each audio-video id is calculated, and the audio-video works are associated with the broadcast list by adding the global sorting number to the audio-video broadcast list formal table. The specific process is as shown in Figure 5

[0088] S301, at least one base sorting number is taken out from the audio-video broadcast list formal table.

[0089] The audio-video broadcast list formal table corresponding to the broadcast id of the normal terminal state id list is obtained, and a base sorting number is determined from the audio-video broadcast list formal table. The base sorting number is the sorting number corresponding to any audio-video id in the audio-video broadcast list formal table. For example, in the audio-video broadcast list formal table corresponding to the broadcast id of the normal terminal state id list, there are 5 audio videos sorted by upload time, and the maximum sorting number is 5. Therefore, 5 can be taken as the base sorting number to represent the maximum sorting number of the current audio-video broadcast list formal table, so as to determine the global sorting number of the audio-video id added subsequently in the audio-video broadcast list formal table.

[0090] S302, the global sorting number of each audio-video id is calculated.

[0091] That is, each audio-video id is taken out from the normal terminal state id list in sequence, and the global sorting number of each audio-video is calculated based on the default sorting mode and the base sorting number, so as to associate the broadcast list based on the global sorting number subsequently. For example, in the case where the base sorting number corresponding to the normal terminal state id list is 5, the audio-video id is added to the audio-video broadcast list formal table, and the default sorting mode is used to sort the audio-video broadcast list formal table. Assuming that the default sorting mode of this example is the time of adding the audio-video broadcast list formal table, the sorting number of the audio-video id in the audio-video broadcast list formal table should be 6, and 6 is the global sorting number.

[0092] S303, each audio-video work is added to the audio-video broadcast list formal table based on the global sorting number.

[0093] After obtaining the global sorting number corresponding to each audio-video id in each normal terminal state id list, the description information of the audio-video work corresponding to the audio-video id is associated with the audio-video broadcast list formal table in the audio-video broadcast list formal table based on the global sorting number.

[0094] In addition, the embodiment also includes the following steps, as shown in Figure 6 ​​

[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 broadcast order id and the audio and video id, etc., it is convenient for subsequent further association in other operations.

[0097] As can be seen from the above technical solution, the embodiment provides a broadcast order association method of audio and video works, which is applied to an electronic device, specifically, in response to a user's upload association request, a session management id is generated, and a plurality of audio and video works and a broadcast order id are received, and the association relationship between the session management id and the broadcast order id and the audio and video id of each audio and video work is stored in a temporary table; all audio and video ids are initialized to a full id list based on the state of the session management id, and the normal terminal state id list is sorted in a default sorting mode according to the audit state of each audio and video work, so that each audio and video id corresponds to a base sorting number; the global sorting number of each audio and video id is calculated based on the default sorting mode and the base sorting number, and all audio and video ids are added to the audio and video broadcast order relationship formal table based on the global sorting number. Through the scheme, the user can realize the addition of the audio and video works to the specified broadcast order without manual operation, which reduces the workload, and can quickly and efficiently process the upload of a large number of audio and video works and the association with the broadcast order. In addition, the scheme can also ensure that the order of the audio and video works in the broadcast order meets the requirements.

[0098] The flowcharts and block diagrams in the accompanying drawings illustrate the possible implementation architectures, functions and operations of the systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowcharts or block diagrams can represent a module, a program segment, or a part of code containing one or more executable instructions for implementing the specified logical functions. It should also be noted that in some alternative implementations, the functions noted in the blocks can occur in different order than that shown in the accompanying drawings. For example, two blocks indicated in succession can actually be executed substantially in parallel, and sometimes they can be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and the combination of blocks in the block diagrams and / or flowcharts, can be implemented by a dedicated hardware-based system that performs the specified functions or operations, or can be implemented by 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 the operations to be performed in the particular order shown or in a sequential order. In certain circumstances, multi-tasking and parallel processing can be advantageous.

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

[0101] Computer program code for carrying out operations of the present disclosure can be written in one or more programming languages or combinations of languages including object oriented programming languages such as Java, Smalltalk, C++ or conventional procedural programming languages such as the "C" programming language or similar programming languages. The program code can execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection can be made to an external computer.

[0102] Figure 7 A block diagram of an audio and video work order association device according to an embodiment of the present application.

[0103] As Figure 7 shown, the audio and video work order association device provided by the present embodiment is applied to an electronic device for batch uploading of audio and video works according to the needs of users and realizing association of work orders. The electronic device can be understood as a computer, server or cloud platform with data calculation and information processing capabilities. The audio and video work order 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 according to the upload association request of the user, receive a plurality of audio and video works and a work order id, and then store the association relationship between the session management id and the work order id and the audio and video id of each audio and video work in a temporary table.

[0105] That is, when the user needs to upload one or more audio and video works, the uploading of the works is realized by sending an upload association request to the system, and a work order and a session management id are generated. After the system receives the audio and video works uploaded by the user, the id of each audio and video work, i.e. the audio and video id, and the association relationship between each audio and video id and the work order are stored in a temporary table init_vid_relids. The specific operation process is as follows, as shown in Figure 2 .

[0106] S101, in response to the upload association request, generating an id acquisition request and uploading a database.

[0107] That is, when the user uploads audio and video works through the PC audio and video publishing page, the description information of each audio and video work is generated, and an id acquisition request is generated, which 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 (referred to as sessionid) according to the id acquisition request according to the self-incrementing primary key, and returns the session management id to the PC front end.

[0108] The session management id can be understood as an identifier of a batch upload task in a corresponding temporary storage unit of the database. The temporary storage unit records the audio and video works to be uploaded this time, and the broadcast order id and the association relationship between each audio and video work.

[0109] S102, receiving the 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 role is to mark whether the above-mentioned audio and video works have been submitted. If it is not completely completed or only partially submitted, the state of the session management id is unsubmitted. On the contrary, when all audio and video works are submitted, the state of the session management id is set to submitted.

[0111] S103, receiving audio and video works and broadcast order id based on session management id.

[0112] That is, based on the user's upload operation, the user's uploaded audio and video works are sent to the database, and the broadcast order id associated with all audio and video works is received.

[0113] S104, storing the broadcast order id, the session management id and the association relationship in a temporary table.

[0114] The association relationship here refers to the corresponding relationship between the audio and video id of each audio and video work and the description information of the audio and video work in the broadcast order id. The description information includes but is not limited to the theme name, content description information, number, and other attachment information of the audio and video work. The temporary table saves the above-mentioned information in the form of a list in a certain order.

[0115] The local session module is used to initialize all audio and video ids to a full id list based on the state of the session management id, and to sort the normal terminal state id list according to the audit state of each audio and video work.

[0116] After the insertion of the broadcast order id, audio and video id and the corresponding relationship in the temporary table is completed, the state of the session management id is first judged. When it is found that the state is submitted, the above information is initialized to an all-quantity id list allList, and the normal terminal state id list is sorted. The specific process is as shown in Figure 3

[0117] S201, initialize the broadcast order id, session management id and audio and video id to the all-quantity id list.

[0118] That is, after it is found that all audio and video works have been completed uploading, the broadcast order id, session management id and audio and video id are initialized to the all-quantity id list.

[0119] S202, judge whether the classification of the audio and video work is a normal terminal state.

[0120] That is, whether the classification of the audio and video work corresponding to each audio and video id is a normal state is judged. The classification includes normal terminal state, deletion terminal state and intermediate state in addition to the normal terminal state. The normal terminal state includes machine review safety and manual review pass, the deletion terminal state includes uploading failure, transcoding failure, manual review deletion and user deletion, and the intermediate state includes uploading, transcoding and machine review high risk.

[0121] S203, add the audio and video id to the normal terminal state id list.

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

[0123] Optionally, according to the broadcast order id associated with each audio and video id, a normal terminal state id list corresponding to each broadcast order id is established. The audio and video id associated with the broadcast order id and classified as a normal terminal state is divided into the normal terminal state id list corresponding to the broadcast order id. The audio and video id in the normal terminal state id list can be empty. Based on this, the normal terminal state id list corresponding to each broadcast order id is obtained. Each normal terminal state id list contains the audio and video id associated with the broadcast order id and classified as a normal terminal state.

[0124] S204, sort the audio and video id according to the default sorting mode.

[0125] ​That is, after adding the audio and video id to the normal terminal state id list, all audio and video ids in the normal terminal state id list are sorted based on the default sorting method to obtain a normal terminal state id list. The default sorting method here is an attribute of the corresponding broadcast order id, which can be set or changed through configuration, for example, the default sorting method can be set to descending or ascending order according to the upload time of the audio and video work.

[0126] In addition, after judging the classification of the audio and video work, the application further includes the following steps, as shown in Figure 4

[0127] S205, detecting the difference between the current time and the upload time of the audio and video work.

[0128] That is, when it is found through judgment that the classification of a certain audio and video work is intermediate, the difference between the current time and the upload time of the audio and video work is calculated. The length of the difference value can represent whether it is in the intermediate state for a long time.

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

[0130] The purpose of the judgment is to confirm whether the audio and video work is in the intermediate state for a long time. If the difference is not greater than the threshold, it means that the audio and video work is not in the intermediate state for a long time, or the time length in the intermediate state is within a reasonable range, then the process is ended and returned to the above step of detecting the difference; on the contrary, if the difference is greater than or equal to the threshold, the subsequent operation step is executed. The threshold can be determined according to experience, and adjusted through actual operation to improve its actual precision.

[0131] S207, error reporting processing and ending sorting processing.

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

[0133] Through the above operation, the application can solve the problem that other audio and video works under the same sessionid cannot be processed when the audio and video work is in the 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 based on the default sorting method, and add all audio and video ids to the audio and video broadcast order relationship formal table based on the global sorting number.

[0135] ​After sorting all audio-video works' audio-video ids according to the default sorting mode and obtaining a base sorting number corresponding to each audio-video id in the normal terminal state id list, a global sorting number of each audio-video id is calculated, and the audio-video id is added to the audio-video order form relation formal table by joining the global sorting number, so as to realize the association of the audio-video works and the order form. The specific process is as shown in Figure 5

[0136] S301, at least one base sorting number is taken out from the audio-video order form relation formal table corresponding to each audio-video.

[0137] The audio-video order form relation formal table corresponding to the order id of the normal terminal state id list is obtained, and a base sorting number is determined from the audio-video order form relation formal table. The base sorting number is a sorting number corresponding to any audio-video id in the audio-video order form relation formal table. For example, in the audio-video order form relation formal table corresponding to the order id of the normal terminal state id list, there are 5 audio videos sorted according to the upload time, and the maximum sorting number is 5. Therefore, 5 can be taken as the base sorting number to represent the maximum sorting number of the current audio-video order form relation formal table, so as to determine the global sorting number of the audio-video id added subsequently in the audio-video order form relation formal table.

[0138] S302, the global sorting number of each audio-video id is calculated.

[0139] That is, each audio-video id is taken out from the normal terminal state id list in turn, and the global sorting number of each audio-video is calculated based on the default sorting mode and the base sorting number, so as to perform order form association based on the global sorting number subsequently. For example, in the case where the base sorting number corresponding to the normal terminal state id list is 5, the audio-video id is added to the audio-video order form relation formal table and sorted in the audio-video order form relation formal table according to the default sorting mode. Assuming that the default sorting mode of this example is the time of adding the audio-video order form relation formal table, the sorting number of the audio-video id in the audio-video order form relation formal table should be 6, and 6 is the global sorting number.

[0140] S303, each audio-video work is added to the audio-video order form relation formal table based on the global sorting number.

[0141] After obtaining the global sorting number corresponding to each audio-video id in each normal terminal state id list, the description information of the audio-video work corresponding to the audio-video id is associated to the audio-video order form relation formal table broadlistvideo based on the global sorting number. The audio-video order form relation formal table can be understood as the global order form of the system.

[0142] In addition, the embodiment also includes the following steps, as shown in Figure 6 ​As 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, the description information of the audio and video works, the broadcast order and the audio and video id, etc., it is convenient for further association in subsequent further operations.

[0145] From the above technical solution, it can be seen that the embodiment provides an audio and video work broadcast order association device, which is applied to an electronic device, specifically, in response to a user's upload association request, a session management id is generated and a plurality of audio and video works are received, and the broadcast order, the session management id and the association relationship between the broadcast order and the audio and video id of each audio and video work are stored in a temporary table; all audio and video ids are initialized to a full id list based on the state of the session management id, and the normal terminal state id list is sorted in a default sorting mode according to the audit state of each audio and video work, so that each audio and video id corresponds to a base sequence number; the global sequence number of each audio and video id is calculated based on the default sorting mode and the base sequence number, and all audio and video ids are added to the audio and video broadcast order relationship formal table based on the global sequence number. Through the scheme, the user can realize the addition of the audio and video works to the specified broadcast order without manual operation, which reduces the workload, and can quickly and efficiently process the upload of a large number of audio and video works and the association with the broadcast order. In addition, the scheme can also ensure that the order of the audio and video works in the broadcast order meets the requirements.

[0146] The units described in the embodiments of the present disclosure can be implemented in a software manner, or can be implemented in a hardware manner. Among them, the name of the unit does not constitute a limitation on the unit itself in some cases, for example, the first acquisition unit can also be described as "a unit for acquiring at least two internet protocol addresses".

[0147] The functions described above in this document can be performed at least in part by one or more hardware logic components. For example, non-limiting example types of hardware logic components that can be used include: field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), system-on-a-chip systems (SOCs), complex programmable logic devices (CPLDs), and the like.

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

[0149] The following will be described with reference to Figure 8FIG. 1 shows a structural diagram of an electronic device suitable for use in implementing the terminal device in the embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure can include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a digital broadcast receiver, a PDA (Personal Digital Assistant), a PAD (Tablet Personal Computer), a PMP (Portable Multimedia Player), a car terminal (e.g., a car navigation terminal), and the like, as well as a stationary terminal such as a digital TV, a desktop computer, and the like. The electronic device is merely an example and should not impose any limitation on the functions and use range of the embodiments of the present disclosure.

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

[0151] Generally, the following devices can be connected to the I / O interface: input devices including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, and the like; output devices 807 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, and the like; storage devices 808 including, for example, a magnetic tape, a hard disk, and the like; and communication devices 809. The communication devices 809 can allow the electronic device to communicate wirelessly or wiredly with other devices to exchange data. Although the electronic device is shown as having various devices, it should be understood that all of the shown devices are not required to be implemented or possessed. More or fewer devices can be alternatively implemented or possessed.

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

[0153] The computer readable storage medium described above 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 generates a session management id and receives a plurality of audio and video works in response to a user uploading an association request, and stores a broadcast order, a session management id and an association relationship between the broadcast order and an audio and video id of each audio and video work in a temporary table; all audio and video ids are initialized to a full id list based on the state of the session management id, and the normal terminal state id list is sorted in a default sorting mode according to the audit state of each audio and video work, so that each audio and video id corresponds to a base sequence number; the global sequence number of each audio and video id is calculated based on the default sorting mode and the base sequence number, and all audio and video ids are added to the audio and video broadcast order relationship formal table based on the global sequence number. Through the scheme, the user can add the audio and video works to the specified broadcast order without manual operation, which reduces the workload, and can quickly and efficiently process the uploading and association of a large number of audio and video works and broadcast orders. In addition, the scheme can also ensure that the order of the audio and video works in the broadcast order meets the requirements.

[0154] It should be noted that the computer readable medium described above in the present disclosure can be a computer readable signal medium or a computer readable storage medium or any combination of the above two. The computer readable storage medium may, for example, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or component, or any combination of the above. More specific examples of computer readable storage media can include, but are not limited to, an electrical connection with one or more wires, a portable computer diskette, 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 of the above.

[0155] In this disclosure, a computer readable storage medium can be any tangible medium that can contain, or store computer readable program codes. In this disclosure, a computer readable signal medium can include a data signal that can propagate in baseband or that can propagate in carrier wave. The data signal can include computer readable program codes. The computer program product that can include program codes can be transmitted using any carrier wave, using any transmission medium. The program codes contained in the computer program product can be transmitted using any medium including, but not limited to, wireless, wire line, optical fiber cable, RF, etc., or any suitable combination thereof.

[0156] Each of the embodiments in the present specification is described in a progressive manner, and each embodiment focuses on the difference from other embodiments. The same or similar parts between the embodiments can be understood by referring to each other.

[0157] Although the preferred embodiments of the present application have been described, those skilled in the art can make additional changes and modifications to the embodiments once they know the basic inventive concept. Therefore, the appended claims are intended to cover all the changes and modifications falling within the scope of the embodiments of the present application.

[0158] Finally, it should be noted that the terms such as first and second, etc. are used herein merely to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between such entities or operations. Also, the terms "comprises", "comprising", or any other variations thereof are intended to cover a non-exclusive inclusion, so that a process, method, article, or terminal device including a list of elements does not include only those elements but can include other elements not expressly listed or inherent to such process, method, article, or terminal device. Without more limitations, an element defined by the statement "comprising a" does not exclude the existence of additional identical elements in the process, method, article, or terminal device including the element.

[0159] The technical solutions provided by the present application are described in detail above, and the principles and implementation manners of the present application are described by applying specific examples. The above description of the examples is only used to help understand the method of the present application and its core idea. Meanwhile, for those skilled in the art, according to the idea of the present application, the specific implementation manners and application ranges will be changed, and the above description should not be understood as a limitation on the present application.

Claims

1. A method for associating audio and video works in playlists, applied to electronic devices, characterized in that, The order 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 order ids are received, and the association relationship between the session management id and the order id and the audio and video id of each audio and video work is stored in a temporary table, and the session management id is an identifier of a batch upload task in a corresponding temporary storage unit of a database; Based on the state of the session management id, all the audio and video ids are initialized into a full id list, and according to the audit state of each audio and video work, the audio and video ids of all audio and video works in the normal final state are sorted in a default sorting mode, and the audit state includes the normal final state, the deletion state and the intermediate state; Based on the default sorting mode, the global sorting number of each audio and video id is calculated in sequence, and all the audio and video ids are added to the audio and video order relationship formal table based on the global sorting number.

2. The method of claim 1, wherein, The response to the user's upload association request, the generation of the session management id and the reception of multiple audio and video works and order ids, and the storage of the association relationship between the session management id and the order id and the audio and video id of each audio and video work in a temporary table, comprising the steps of: In response to the upload association request, an id acquisition request is generated and uploaded to the database; Receive the session management id generated by the database based on the id acquisition request, and the state of the session management id is unsubmitted or submitted; Based on the session management id, multiple audio and video works and order ids corresponding to the audio and video works are received and uploaded to the database, and the state of the session management id is unsubmitted before uploading is completed, and the state of the session management id is submitted after uploading is completed; The order id, the session management id and the association relationship are stored in the temporary table.

3. The method of claim 1, wherein, The initialization of all the audio and video ids into a full id list based on the state of the session management id, and the sorting of all the audio and video ids in a default sorting mode according to the audit state of each audio and video work, comprising the steps of: When the state of the session management id is submitted, the order id, the session management id and all the audio and video ids are initialized into the full id list; Determine the classification of each audio and video id corresponding to the audio and video work, and the classification is the normal final state, the deletion final state or the intermediate state; According to the order id associated with each audio and video id, all the audio and video ids classified as the normal final state are divided to obtain a normal final state id list corresponding to each order id; All the audio and video ids in the normal final state id list are sorted in the default sorting mode.

4. The method of claim 3, wherein the association of the bid is based on the bid type. The default sorting mode is ascending or descending sorting according to the upload time of the audio and video work.

5. The method of claim 3, wherein the association of the bid is determined by a bid association module. The state based on the session management id initializes all the audio and video ids into a full id list, and sorts all the audio and video ids in a default sorting mode according to the audit state of each audio and video work. The method further comprises the steps of: When the classification is the intermediate state, detecting a difference between a current time and an upload time of the audio and video work; If the difference is less than a threshold value, ending the process; If the difference is greater than or equal to the threshold value, performing error processing and ending the sorting processing of the current audio and video work.

6. The method of claim 3, wherein the step of associating the bid with the bid request comprises: The global sorting number of each audio and video id is calculated in sequence based on the default sorting mode, and all the audio and video ids are added to an audio and video order form relationship formal table based on the global sorting number. The method comprises the steps of: Obtaining an audio and video order form relationship formal table corresponding to the broadcast id of the normal terminal state id list; Taking a base sorting number from the audio and video order form relationship formal table, the base sorting number being a sorting number corresponding to any audio and video id in the audio and video order form relationship formal table; Based on the default sorting mode and the base sorting number, the global sorting number of each audio and video id in the normal terminal state id list is determined; Based on the global sorting number, each audio and video id is added to the audio and video order form relationship formal table.

7. The method of claim 6, wherein the step of associating the bid with the bid request comprises the step of: Further comprising: ​ Deleting all information in the temporary table and the full id list.

8. An audio-video work play list association device applied to an electronic device, characterized in that, The order form association device comprises: A session management module configured to generate a session management id and receive a plurality of audio and video works and a broadcast id in response to a user's upload association request, and store the association relationship between the session management id and the broadcast id and the audio and video id of each audio and video work in a temporary table, the session management id being an identifier of a batch upload task in a temporary storage unit corresponding to a database; A local sorting module configured to initialize all the audio and video ids to a full id list based on the state of the session management id, and sort the audio and video ids of the audio and video works in the normal terminal state in a default sorting mode according to the audit state of each audio and video work, the audit state including the normal terminal state, the deletion state and the intermediate state; A global sorting module configured to calculate the global sorting number of each audio and video id in sequence based on the default sorting mode, and add all the audio and video ids to an audio and video order form relationship formal table based on the global sorting number.

9. An electronic device, comprising: 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 programs or instructions to enable the electronic device to implement the audio and video work order form association method of any one of claims 1-7. 10.A storage medium readable by a computer, applied to an electronic device, and having stored thereon a plurality of instructions which, when executed by the electronic device, cause the electronic device to perform the method of any one of claims 1 to 9. The storage medium carries one or more computer programs, which can be executed by the electronic device, so that the electronic device can implement the audio and video work order form association method of any one of claims 1-7.

Images