Skip to content

Latest commit

 

History

History
82 lines (51 loc) · 2.6 KB

part2.md

File metadata and controls

82 lines (51 loc) · 2.6 KB
Raw

tunr relationships - M-M

Build relationships into the tunr app.

Add the ability to put songs in a playlist.

Add a table for playlist.

Add a second table to record which songs are in a playlist.

This is a join table between a playlist and songs. (each record in the join table records the adding of one song to the playlist)

GET /playlist - list all the playlists

GET /playlist/new - render the form to create a new playlist

POST /playlist - create a new playlist

GET /playlist/:id/newsong - render the form to add a song to the playlist

GET /playlist/:id - show all the song titles inside this playlist

POST /playlist/:id - for this playlist, put a single song on the playlist

How to Start

  • Create a form: /playlists/new
  • Create an app.post to take in the POST and create a record of a playlist
  • Create a show route /playlists/:id => /playlists/1
  • Create a form to add a song to a playlist /playlist/1/newsong
  • Create an app.post to take in the POST request and add a song to the playlist.
  • this record is an entry in the DB between the song and the playlist.
  • Add the query into the page /playlists/:id that gets all songs in a playlist and lists them on the page (SELECT * FROM playlist_song)
  • Change the query to a JOIN query so that you can get all info about the song.
table playlist
column name type
id primary key (int)
name text
table playlist_song
column name type
id primary key (int)
song_id integer
playlist_id integer

Artist's songs:

(note this functionality does not require any JOIN queries, just a 2nd SQL query)

GET /artist/1/songs This page displays a list of songs for this artist

GET /artist/1/songs/new This page renders a form to create a new song.

The action of the form can be set to send the appropriate artist id needed to create the song.

POST /artist/1/songs This route creates a new song with the appropriate artist.

Further

For the form at /songs/new, add a dropdown of artists to select from when creating a new song.

Further: Playlist

Restrict the user from adding a song to a playlist twice.

Further

Add a button to each song in the lists of songs ( /songs, /artist/:id/songs ) that goes to a new page.

This page will have a list of playlists. Let the user add the song to any playlist.

sub-futher: If a playlist already has the song in it, then don't render that playlist in the list.

Further

Add the ability for the user to add the song to multiple playlists at once. ( this is a checkbox form input )