We're going to be building Tunr, the worlds #1 music catalog / player (those Spotify haters can't keep up with us).
In this repo are two files artist_data.sql
and songs.sql
.
Create a postgres database called tunr_db
. Make sure to use that exact
name, or you'll have trouble later on!
Inside the db folder, create a tables.sql
file, and then load it into your
tunr_db
database.
Here's what our data model looks like:
Artists
column name | type |
---|---|
id | primary key (int) |
name | text |
photo_url | text |
nationality | text |
Songs
column name | type |
---|---|
id | primary key (int) |
title | text |
album | text |
preview_link | text |
artwork | text |
artist_id | foreign key (int) |
- Seed your tables with
artist_data.sql
andsongs.sql
.
- Define a route with view defined at
/
. For now it should sayHello World
when you visit that url.
Make sure to commit after completing each feature. Don't move to the next feature without first finishing a feature.
Build the index feature for artists
Build the show feature for an artist
Build a feature that creates a new artist
in the database.
Build a feature that allows a user to edit an existing artist
in the database
Build a feature that allows users to delete an existing artist
from the database.
- create the 7 RESTful Routes for
songs
- make routes for
songs
that are nested under artists:/artist/1/songs
/artist/1/songs/new