1
00:00:00,210 --> 00:00:03,220
We've only scratched
the surface of SQLite, but

2
00:00:03,220 --> 00:00:06,842
you should be in a good place to
start using it in your projects.

3
00:00:06,842 --> 00:00:11,460
Before I sign off, let me show you
the querying API in the documentation.

4
00:00:11,460 --> 00:00:16,210
The findAll method and the findById
model methods can take in options.

5
00:00:16,210 --> 00:00:20,280
Remember, like the findAll method where
we ordered by the createdAt column.

6
00:00:24,205 --> 00:00:28,902
If you go to the querying page, there's
lots of examples of Sequelize code and

7
00:00:28,902 --> 00:00:30,550
the SQL code it generates.

8
00:00:39,380 --> 00:00:48,029
Here is a where clause that looks for

9
00:00:48,029 --> 00:00:54,380
author IDs that equal 2.

10
00:01:03,925 --> 00:01:08,073
Further down here, there's combinations
of conditions using the or

11
00:01:08,073 --> 00:01:11,600
operator and operators other
than the equality operator.

12
00:01:20,295 --> 00:01:25,971
You can also offset and limit,

13
00:01:25,971 --> 00:01:32,090
as shown in these examples here.

14
00:01:33,700 --> 00:01:35,830
And that's all we have time for.

15
00:01:35,830 --> 00:01:40,460
Remember, you're not required to memorize
every ORM or library or framework.

16
00:01:40,460 --> 00:01:43,900
The documentation is there to help you,
so use it.

17
00:01:43,900 --> 00:01:48,130
If you want to extend this project,
why not add comments and authentication?

18
00:01:48,130 --> 00:01:51,780
You don't want any old user coming
to your site and causing havoc.

19
00:01:51,780 --> 00:01:53,020
Take care.
And I'll see you soon.