Next Steps1:53 with Andrew Chalkley
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.
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 up