Playlists support about peertube

[Chocobozzz]

Now we use a relational DBMS, the database scheme is changed.

My proposal:

playlistTable:
  {
    name: String,
    description: String,
    visibility: {
      type: String,
      enum: ['PUBLIC', 'PRIVATE']
    },
    createdAt: {
      type: Date,
      default: Date.now
    },
    updatedAt: {
      type: Date,
      default: Date.now
    },
    actorId -> references the actor that owns the playlist
  }

playlistVideoTable:
  {
    // Position of the video in the playlist
    position: {
      type: Number,
      default: 0
    },
    videoId -> references a video
    playlistId -> references a playlist
  }

[Chocobozzz]

I updated my comment to replace userId by actorId. An actor is a user or a channel.

[Chocobozzz]

Implemented in #1708

[Chocobozzz]

@6543 https://github.com/Chocobozzz/PeerTube/tree/feature/playlists

[6543]

@rzr Pre-Release v1.3.0-rc.1

[Chocobozzz]

For the DB model, I would add a playlist visibility: public/private.

I like the reordering API of Spotify: https://developer.spotify.com/web-api/reorder-playlists-tracks/

My opinion:

• A playlist belongs to one user so I would prefix each route with /users/userId/.
• playlist -> playlists to keep coherency
• Add a video to the playlist throught the POST method and body parameters
• Suppress a video from the playlist throught the DELETE method and body parameters
• Rename a playlist is part of the modify playlist route

API route

1. get /accounts/:accountId/playlists/ → get account playlists
2. get /video-channels/:videoChannelId/playlists/ → get video channel playlists (to organize videos inside the channel)
3. get /playlists/:id → get playlist information (+ number of videos)
4. delete /playlists/:id → suppress a playlist
5. get /playlists/:id/videos → get videos of the playlist
6. post /playlists/:id/videos → add video(s) to the playlist
7. put /playlists/:id/videos → reorder playlist
8. delete /playlists/:id/videos/:id → delete video from the playlist
9. put /playlists/:id → change playlist informations (name, visibility?)

Account playlists: just playlists that could be accessed and shared (if public)
Video channel playlists: playlists to organize videos inside a channel

Database schema

#14 (comment)

[christophehenry]

I would use PATCH to reorder the playlists and change informations as it is it's definition:

The PATCH method applies partial modifications to a resource.

[DimitriGilbert]

I was wondering about channel's playlist (or even playlists for videos like what is hacked here https://youtu.be/5NJSCRPeNpU?t=11m0s the annotation link bottom rigth of the video)
For this reason I suggest to replace userId by something like ownerId and ownerType. It would make the playlist system very versatile at a very reasonnable cost (the GUI for it could come later but everything would be in place for it to work in the future)

[DimitriGilbert]

works for me :)

[6543]

Any progress at the moment?

[6543]

Tanks for the great work!

[rzr]

is this feature released in any version ? Apparently not in current version:

https://github.com/Chocobozzz/PeerTube/releases/tag/v1.2.1