Heads up! To view this whole video, sign in with your Courses Plus account or enroll in your free 7-day trial. Sign In Enroll

Using SQL and Node.js with Sequelize

Preview

Start a free Courses trial
to watch this video

Sign up for Treehouse

Deleting Entries from a Table

2:13 with Andrew Chalkley

In this video we'll remove rows of data from a table.

Important Notice About the findById() Method

Since the recording of this workshop, the Sequelize findById() method has been deprecated and replaced by the findByPk() method.

Using the findByPk() method, the code for the routes to get the delete article form and delete an article look like this:

/* Delete article form. */
router.get('/:id/delete', function (req, res, next) {
  Article.findByPk(req.params.id).then((article) => {
    res.render('articles/delete', { article: article, title: 'Delete Article' });
  });
});

/* DELETE individual article. */
router.delete('/:id', function (req, res, next) {
  Article.findByPk(req.params.id).then((article) => {
    return article.destroy();
  }).then(() => {
    res.redirect('/articles');
  });
});

Sequelize Methods

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    We have only one good operation left. 0:00
    Delete. 0:03
    There are two actions that deal with deleting. 0:09
    A human friendly form. 0:12
    And a route that deals with the deleting of the entry. 0:19
    Let's start by using SQL Ice to find the article for the delete form. 0:26
    Then down in the delete method route, let's find the article 0:37
    Once the article is found, we can destroy it. 1:00
    The destroy method is an asynchronous call that returns a promise. 1:08
    Once the promise is fulfilled, then we want to redirect to the article's path. 1:15
    Let's restart the server and see if we can delete an article. 1:37
    We can, awesome! 1:53
    All of our code operations are done. 1:56
    So, we're done right? 1:58
    Wrong, we haven't handled any errors. 2:00
    In the next video, I'll show you how to handle validation failures and 2:03
    general errors. 2:07
    Like if a record is missing or if other unforseen errors occur. 2:09

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up