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
Well done!
You have completed Using SQL and Node.js with Sequelize!
You have completed Using SQL and Node.js with Sequelize!
Preview
In this video we'll use Sequelize to add rows of date in to a table.
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
First and foremost,
0:00
we need to include the article model
in our articles JS routes writes file.
0:02
Each model that we define is
a property loaded in from the code
0:29
in the index.js file that's
in our models folder.
0:33
This will let us use the article model and
all the associated ORM methods,
0:38
like finding, updating, creating and
deleting database records.
0:42
Let's work on getting
data into a database.
1:01
Make sure your database is running.
1:05
And let's go to
the Create New Article form.
1:13
Let's review the server code for
this page.
1:17
This is an empty object.
1:28
ORMs can generate instances of
objects with empty properties
1:31
that still retain the methods and
functionality of an ORM object.
1:35
The way we generate an empty instance of
the model, you can use the Build method.
1:40
And it's not just the ORM
functionality that's included when
1:50
you build an instance, but
any functionality that you define.
1:55
For example, we'll be adding a published
out method for date formatting.
2:00
And a short description that shows
a brief excerpt of our post.
2:04
We'll be adding this functionality
to our model in the form of instance
2:08
methods later.
2:12
Next we want to work on
the creating of rows.
2:26
We're looking at the HTTP post routes, and
2:32
all this code up here is my code for
creating objects in memory.
2:35
The key part of this is the rec.body.
2:39
This is the data from the form.
2:42
This maps one to one to the properties
from the form inputs and
2:45
the properties on the article models.
2:49
These two lines add instance
methods to the article.
2:56
To display the published at time and short
descriptions on each article created.
2:59
This is a crude approach and
3:05
would refine this later when
we look at instance methods.
3:07
To create a model,
we can use the Create method.
3:10
It requires an object with properties
that map to the properties of the object.
3:22
Remember the request
body is such an object.
3:28
Then when the database is finished
saving the new article record,
3:52
the database will redirect
to the new article.
3:57
The article with the new id
that's been also incremented.
4:03
I accidentally did the plural articles,
it should be just be article.
4:07
We don't want to make a mistake there.
4:12
When we restart the server.
4:15
And type in some sample data
into the Create form and Submit.
4:20
We see that we are redirected to
the static article with the ID of one,
4:29
since we're not retrieving
it from the database yet.
4:33
Before we look at the ORM code for
finding articles,
4:37
we should look at including the instance
methods in our sequelize objects.
4:40
If we don't include them,
all of the routes that show articles or
4:45
individual entries will break since the
views require instance methods on each of
4:49
these article instances.
4:53
In the next video,
we'll see how to do this.
5:01
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