Add videos to a playlist in bulk

[StoneEngineer]

This is complex PostgreSQL loop query I wrote to add multiple videos to a playlist.
After creating a playlist by adding first video I know it's id, which is used in the query.

DO $$
BEGIN

WHILE (CAST((SELECT COUNT(*)
            FROM files_media 
            LEFT JOIN files_playlistmedia ON files_media.id = files_playlistmedia.media_id 
            LEFT JOIN files_playlist ON files_playlist.id = files_playlistmedia.playlist_id 
            WHERE files_playlistmedia.playlist_id IS NULL) AS int) > 0) LOOP

INSERT INTO files_playlistmedia (action_date, ordering, media_id, playlist_id) VALUES (

    -- id is PRIMARY KEY with AUTOINCREMENT!

    -- action_date
    NOW(),

    -- ordering (change!)
    CAST((SELECT files_playlistmedia.ordering FROM files_playlistmedia
          WHERE files_playlistmedia.playlist_id = 5 
          ORDER BY files_playlistmedia.ordering DESC LIMIT 1) AS int) + 1,

    -- media_id
    CAST((SELECT files_media.id
          FROM files_media 
          LEFT JOIN files_playlistmedia ON files_media.id = files_playlistmedia.media_id 
          LEFT JOIN files_playlist ON files_playlist.id = files_playlistmedia.playlist_id 
          WHERE files_playlistmedia.playlist_id IS NULL
          ORDER BY files_media.id ASC
          LIMIT 1) AS int),

    -- playlist_id (change!)
    5
);

END LOOP;
END $$;

I wonder if there's more convenient way to achive that or maybe there's functionality in MediaCMS I'm not aware of.

[mgogoulos]

Hi, there is an API call that can be used to add videos in a playlist. What is the use case of using SQL code directly?

[StoneEngineer]

Hi Markos, the SQL query is a workaround to avoid using SAVE button with every video. I have many videos to upload and playlists are convenient way to organize them. Is there other way to add videos to a playlist? Can you direct me to the mentioned API?