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
Preview
Start a free Courses trial
to watch this video
In this video we'll take a look at the Querying API for Sequelize and I'll give you some ideas to expand the project.
Further Reading
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
We've only scratched
the surface of SQLite, but
0:00
you should be in a good place to
start using it in your projects.
0:03
Before I sign off, let me show you
the querying API in the documentation.
0:06
The findAll method and the findById
model methods can take in options.
0:11
Remember, like the findAll method where
we ordered by the createdAt column.
0:16
If you go to the querying page, there's
lots of examples of Sequelize code and
0:24
the SQL code it generates.
0:28
Here is a where clause that looks for
0:39
author IDs that equal 2.
0:48
Further down here, there's combinations
of conditions using the or
1:03
operator and operators other
than the equality operator.
1:08
You can also offset and limit,
1:20
as shown in these examples here.
1:25
And that's all we have time for.
1:33
Remember, you're not required to memorize
every ORM or library or framework.
1:35
The documentation is there to help you,
so use it.
1:40
If you want to extend this project,
why not add comments and authentication?
1:43
You don't want any old user coming
to your site and causing havoc.
1:48
Take care.
And I'll see you soon.
1:51
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