Bummer! This is just a preview. You need to be signed in with a Pro account to view the entire video.

Preview

Start a free Basic trial
to watch this video

Sign up for Treehouse

Retrieving Entries from a Table

4:07 with Andrew Chalkley

In this video we'll retrieve single and multiple rows of data from tables.

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 route to get an individual article looks like this:

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

Sequelize Methods

  • 0:00

    Now let's start reading from the database.

  • 0:03

    First we'll find individual posts.

  • 0:16

    Down here we have the get route found individual article.

  • 0:20

    I've created a simple synchronous function called find that gets the ID

  • 0:25

    from the route, and searches from the static articles.

  • 0:29

    We can use SQLizer's find by ID method to find an article by the ID.

  • 1:03

    Now we can get rid of the static articles at the top here and define function too.

  • 1:16

    Next, let's work on getting all the articles back.

  • 1:20

    In the get route for all of the articles we can use SQLizer's find all method.

  • 1:57

    This will retrieve all of the articles, instead of a single article.

  • 2:05

    Let's restart the server.

  • 2:08

    This should now retrieve and show all of the blog posts.

  • 2:14

    Let's create another blog post.

  • 2:20

    My second Blog Post.

  • 2:28

    Authored by me.

  • 2:31

    And we can have any old text in this body here.

  • 2:41

    It shows correctly.

  • 2:43

    And when we go back to the article list page, we have a problem.

  • 2:47

    The latest article appears last.

  • 2:51

    We need to order the results.

  • 2:58

    The findAll method can take an options object.

  • 3:04

    Within that you can add any number of criteria to filter the results including

  • 3:09

    order by to order a result set you use the order key

  • 3:17

    with an array of a race.

  • 3:21

    Each array includes the column you'd want to order by.

  • 3:32

    And in which order, ascending or descending.

  • 3:39

    It's an array of a race because you can order by multiple columns.

  • 3:44

    In this case, it's only one, and it's in descending order.

  • 3:52

    Let's reboot the server now, and go back to the list page.

  • 4:00

    And now the articles are in the desired order.

  • 4:04

    Next, let's work on updating models.

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

Sign up