Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
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
- Reduce Error Handling Code When Using Async/Await
- VSCode extension to explore and query SQLite databases
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 upRelated 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 upYou need to sign up for Treehouse in order to set up Workspace
Sign up