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

Using Sequelize ORM With Express

Well done!

You have completed Using Sequelize ORM With Express !

Sign up for Treehouse Back to Library

Create Entries

5:27 with Guil Hernandez

You've configured Sequelize, initialized a connection to the SQLite database, and synced the Article model with the database. In this video, you will work on the routes for data creation.

The request's body property returns an object containing the key/value pairs of data submitted in the request body. The following app.use() methods, written in app.js, provide access to the request body.

// view engine setup
...
app.use(express.json());
app.use(express.urlencoded({ extended: false }));

Resources

Sequelize has recently updated the structure of their docs. If you're following along with the video, you can access the old layout via the link below! Don't worry, the instructions are all the same!

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

    You've configured sequelize, initialized a connection to the SQLite database, and 0:00
    synced the article model with the database. 0:04
    In this video, we'll work on the routes for data creation. 0:07
    We'll start by including the article model at the top of the articles.js routes file. 0:10
    Require the index file of the models folder with const 0:15
    Article = require, passing it the path to the folder. 0:21
    We can access each model that we define via a property that gets imported from 0:28
    the code in the models index.js file. 0:33
    We want to import the article model, so we'll access it with .Article. 0:35
    Now we're able to use the article model and all the associated ORM methods you've 0:42
    worked with before, like find all, create, update, destroy, and so on. 0:47
    The articles.js file contains several routes to handle HTTP requests, 0:52
    like POST and GET. 0:57
    The handler functions execute when a route matches the path defined. 0:59
    Since sequelize is promise-based, 1:03
    most of the handlers are going to perform asynchronous actions to 1:05
    make calls to the database and execute all the CRUD operations. 1:08
    We're going to use the async/await syntax for 1:11
    all asynchronous calls made with sequelize. 1:14
    And we want to use a try/catch statement in each handler 1:17
    to run the code that needs to be executed and catch any exceptions that are thrown. 1:20
    So because of the necessity of the try/catch block for 1:25
    error handling, our code can get quite verbose and unwieldy. 1:28
    So I'm abstracting away the try/catch block here in the asyncHandler function, 1:32
    which acts as a middleware that wraps each of our wrap handlers in a try/catch block. 1:37
    That way we won't have to explicitly write try/catch over and 1:42
    over again when making our sequelize calls. 1:45
    The catch statement will send a 500 error or internal server error to the user 1:48
    if an exception is thrown in the try block, or in any of the handler functions. 1:53
    You can learn more about the asyncHandler function in the teacher's notes with 1:59
    this video. 2:03
    All right, we're ready to work on getting data into the database. 2:04
    You create a new article by clicking the Create Article button on the main page. 2:07
    You can see the server side code for 2:11
    this page in articles.js under Create a new article form. 2:13
    When the path is articles/new, the app renders the new view where the article or 2:18
    locals object is an empty object. 2:24
    The post route under POST create article is the route responsible for creating and 2:26
    posting a new article. 2:31
    Currently it just redirects to the main articles page. 2:33
    So we'll begin here by working on the creation of rows. 2:36
    You've learned that the sequelize create method builds a new model instance, 2:39
    which represents a database row and 2:44
    automatically stores its data in the database. 2:47
    Create is an asynchronous call that returns a promise. 2:49
    And inside an async function, you use the await keyword to wait for a promise. 2:52
    So inside this handler function, initialize a constant 2:57
    variable named article to await Article.create. 3:02
    Create requires an object with properties that map to the model attributes, 3:10
    or the ones defined here in Article.init, for example. 3:16
    The request body property returns an object containing the key value 3:21
    pairs of data submitted in the request body, in other words, the form data. 3:27
    For example, I'll comment out the article variable. 3:30
    And if I log req.body to the console, 3:34
    notice that it's an object which maps to the properties of the form inputs and 3:39
    the properties associated with the article model, title, author, and body. 3:44
    So we'll pass create the request body with req.body. 3:48
    When the database builds and saves the new article record, 3:56
    the app should redirect to the newly created article. 3:59
    Sequelize generates an auto-incrementing ID for each model instance or 4:03
    entry created. 4:08
    So in the res.redirect method, I'll add the article id to 4:09
    the URL path by concatenating article.id to the articles path. 4:14
    Over in the browser, I'll click Create Article, 4:21
    then type some sample data in the Create New Article form. 4:25
    When I click Submit, I'm redirected to the URL path articles/1. 4:38
    The article data does not render to the view since we're not yet 4:44
    retrieving the data from the database. 4:47
    We'll do that in the next video. 4:49
    But I'll quickly check if the new entry was added to the articles table, 4:51
    using the DB Browser for SQLite app, which you may have used in a previous course. 4:55
    I'll open the development.db file in the app. 5:00
    And clicking Browse Data shows the new article entry with an id of 1. 5:04
    We see the title, author, and body data, 5:10
    as well as the timestamps generated by sequelize, it worked! 5:14
    In the next video, we'll start reading from the database. 5:18
    That way we'll be able to view all the articles on the main page and 5:21
    individually by their ID. 5:25

    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