1
00:00:00,360 --> 00:00:07,410
In this video, we are going to perform particular CRUD operations into the A.V. table with using a

2
00:00:07,590 --> 00:00:08,760
laser light commands.

3
00:00:08,760 --> 00:00:14,010
So we will learn how to use a particle for dynamic DB from the LHC commands.

4
00:00:14,280 --> 00:00:19,710
In order to do that, please open the visual images to the code and open the lecture folder.

5
00:00:19,740 --> 00:00:23,130
You can see that we are performing particle crud operations.

6
00:00:23,130 --> 00:00:25,510
So here you can find several commands.

7
00:00:25,530 --> 00:00:31,790
We will start creating any item into order table we're using to insert into command.

8
00:00:31,800 --> 00:00:38,220
So this is the our command, which is the dynamo DB and execute statement.

9
00:00:38,220 --> 00:00:45,450
So execute statement is same for all CRUD operations when it comes to particle commands because we can

10
00:00:45,450 --> 00:00:51,960
use execute statement for insert into command, select serve from command, update command and delete

11
00:00:51,960 --> 00:00:52,500
command.

12
00:00:52,500 --> 00:00:59,060
So that's why execute statement is the same and the first command when we are using the particle click

13
00:00:59,070 --> 00:00:59,700
commands.

14
00:00:59,700 --> 00:01:07,020
And after that we can provide this statement which is the SQL Command, SQL queries that we can provide,

15
00:01:07,020 --> 00:01:09,150
insert, update and delete information.

16
00:01:09,270 --> 00:01:15,720
So let's open the our PowerShell command and I'm going to copy and paste this command.

17
00:01:16,260 --> 00:01:22,080
And this is basically perform adding any item into our order table with the partition key is two and

18
00:01:22,440 --> 00:01:23,610
is in progress.

19
00:01:23,610 --> 00:01:30,300
We have to provide this partition and sort key when it comes to creating any item into any Dynamo DB

20
00:01:30,300 --> 00:01:35,790
table, we are providing the primary key value, which is the composite primary key, which is the partition

21
00:01:35,790 --> 00:01:38,070
key ID and the key is status.

22
00:01:38,940 --> 00:01:41,280
Let me clear it and.

23
00:01:42,670 --> 00:01:44,080
It's again hit until.

24
00:01:45,170 --> 00:01:48,860
So this time we have a new item in the order table.

25
00:01:49,100 --> 00:01:54,200
In order to verify that, please run the scan command on the console.

26
00:01:54,200 --> 00:02:00,680
And you can see that we have successfully added a new item into our Dynamo DB table and after that we

27
00:02:00,680 --> 00:02:03,700
can retrieve an item we're using select start from.

28
00:02:03,710 --> 00:02:10,160
For that purpose, I'm going to retrieve an item which giving the statement is a select serve from order

29
00:02:10,160 --> 00:02:18,380
where ID equal to and status is in progress and just copy paste in this command to the PowerShell command

30
00:02:18,380 --> 00:02:19,940
line hit enter.

31
00:02:20,450 --> 00:02:27,800
So you can see that we can successfully retrieve the item what we have created in our video so we can

32
00:02:27,800 --> 00:02:28,130
see.

33
00:02:28,130 --> 00:02:35,960
Now let me pass in here and again so you can see that the ID and so this information is get from our

34
00:02:35,960 --> 00:02:43,190
command line window and after that we will update an item using this execute statement command.

35
00:02:43,190 --> 00:02:44,480
I'm going to copy and paste.

36
00:02:44,480 --> 00:02:50,810
I'm going to update the description which is the updated order for our newly added item.

37
00:02:50,810 --> 00:02:53,270
So copy and paste and hit enter.

38
00:02:53,270 --> 00:02:58,940
So this time it is updated successfully to verify that go to console and see in this location.

39
00:02:58,940 --> 00:03:03,650
Click the refresh and see that we have added the description with updated order.

40
00:03:03,650 --> 00:03:11,030
So last command is the deleting an item for that purpose and we are going to use execute statement with

41
00:03:11,030 --> 00:03:16,910
this statement of the delete from order table with specifying the partition and sort k which is the

42
00:03:16,910 --> 00:03:24,380
primary k paste into our common time window hit enter and this is successfully delete our record to

43
00:03:24,380 --> 00:03:29,060
verify that go to console and see these ID two will be disappeared.

44
00:03:29,090 --> 00:03:31,910
Yes, we have successfully delete an item.

45
00:03:31,910 --> 00:03:37,490
So as you can see that we have used the particle crud operations into dynamo db table with using the

46
00:03:37,490 --> 00:03:38,390
click commands.