Deleting Artists

Sometimes you might want to delete records from your database. The HTTP DELETE verb is used for implementing such functionality.

The test we are going to pass for this challenge are:

// tests/artist-delete.js
const { expect } = require('chai')
const request = require('supertest')
const db = require('../src/db')
const app = require('../src/app')
 
describe('Delete Artist', () => {
  let artist
  beforeEach(async () => {
    const { rows } = await db.query('INSERT INTO Artists (name, genre) VALUES( $1, $2) RETURNING *', [
      'Tame Impala',
      'rock',
    ])
 
    artist = rows[0]
  })
 
  describe('DELETE /artists/{id}', () => {
    it('deletes the artist and returns the deleted data', async () => {
      const { status, body } = await request(app).delete(`/artists/${artist.id}`).send()
 
      expect(status).to.equal(200)
 
      expect(body).to.deep.equal({ id: artist.id, name: 'Tame Impala', genre: 'rock' })
    })
 
    it('returns a 404 if the artist does not exist', async () => {
      const { status, body } = await request(app).delete('/artists/999999999').send()
 
      expect(status).to.equal(404)
      expect(body.message).to.equal('artist 999999999 does not exist')
    })
  })
})

Again, these tests and the solutions are very similar to what you have done before.

This time your challenge is to work out how to solve these tests without any guidance.

When you have the tests passing, move on to the next page.

On this page