Hey there, welcome back friends in our last video we were successful in communicating with the database and getting the list of all the posts which were available in the database right. Now moving forward we will refix all the methods which we have commented out. So, let us uncomment these methods, first of all and there are like couple of issues First of all, in place of creating a new instance of service layer, we will make use of this private entity. Let me also mark this as private. All right, so, it would be like service dot get post. Let me fix these issues real quick.

All right, so, this looks good to me. All right. So, now we are making use of this auto wired instance Using this instance, we are calling in various methods inside of a service layer, which is cool. Now again, let us navigate to our service layer and we will get rid of our comments. All right, so now let us fix the methods one by one. So first of all, in our method and get posts to be would like to get a specific post, right, so in order to do that, we will get rid of this particular entire body.

And let me expand this real quick. And now friends. Getting a specific post from the database is extremely simple when it comes to repository convention, it would be like repo dot find by ID, and we will simply pass on ID. All right, so this is cool, nicer stuff. And let me return the value which this method will return. Now here's the catch.

If I return information Which is returned by this method then there will be an issue and if I hover upon this issue then it will say change the method return type to optional post. Now, why there is this issue, this method find by ID will always return an optional object. Now, what is optional object optional object is object which cannot be null you can research more about optional object on internet. Now, in order to convert an optional object to a post object there is a method with us which is gate and this will return what this will return the object of entity type of our entity class as post let me show you our entity class is post So, now, by taking help of this get method we will get object of post type and our work is done. So, we can easily make out that how easy easy it is to communicate with the database by taking help of Spring Boot.

Now, let us move forward and let us try to implement the business logic of the next method. And the method as add post. Let me get rid of all of these spaces real quick. And now we will add some more spaces down this add POST method. Alright, so, adding the information in the database is amazingly simple when it comes to a Spring Boot repository methodology again, we will type and repoed taught. And if I show you there are a couple of options and one of the options is a safe so, we will simply make use of this safe method and we will pass on this particular object and our work is done.

So, this is so damn simple. Now, let us move in and check in the implementation of update POST method. So, again, let me get rid of these extra spaces. Let me add in a couple of spaces in order to reduce confusion and now we are implementing the update POST method again we will get rid of the body which is that already alright. So, as of now, the method body is quite complicated, but now moving forward, things will change quite a bit. So, in here, in order to update information, the way is very simple it would be like report dot and is there a method by the name of update or something like that, and that is not a single method by the name of update or similar to that, but the reason why there is a new method because there is no requirement.

Our save method can also update the information if the object contains the ID information. So, in here it will simply post the information and if I show you the entity class entity class already have the ID information Right. So the Save method how it handles the situation as if there is a database row with same ID, the Save method will update the information. And if the ID is not present, the Save method will add a new record in the database. And our work could be done. As a result in here, you don't need the ID parameter again, so we will get rid of it.

And we will also update the controller a little. So in here, there would be a method which is updating the post here is the method, right? So we don't want the ID and we don't need to send the ID again and the issue is fixed. All right. Now finally, the last method which we need to fix is delete record method or delete POST method right. So again, we will get rid of the entire method body and again, implementing the Delete functionality is so damn simple.

It would be like Report dot delete. And we will use this particular Option Delete by ID and we will simply pass on the ID and our work is done. So implementing the CRUD operations using the crud repository methods is extremely simple. So this is amazing how easily we are able to implement all the crud related operations. Now, let us check whether our application is working properly or not. All right, so, first of all, let us stop our application and we will navigate to our application right click the blog dot java file and run this as a Spring Boot application.

This will take couple of seconds. Here we go our application is up and running. And Darryl, let us open up postman and now first of all let us quickly check the values from the database here are the existing values and now let us Posting of value. All right, so here is a sample payload. And we are making use of this history feature of the extension. And we'll give the ID as maybe 11 is good enough title as test title, and the body has test body.

Here we go. Everything else is good enough header is also set. Let me send in the request. All right. Now, let me again, check whether we were successful in adding the record. Yes, we were successful in adding the record.

Let me update the information. So in here, let me put the information for ID two, maybe. And now we will give some additional values in here. All right. And let me send in the request. All right.

So this is cool. Let me know Check a voter ID with two is updated or not amazing. So the information got updated. Cool. And now finally let us try to delete the information which is there with ID three. So in here let us delete the information with ID three, let me send in the request.

Let me now check the record. All right, so there is no record with ID three. Amazing and if I show you our workbench, again, the values are updated in here. So the database operations are getting performed perfectly. So this is amazing how easily we are able to perform the operations using our micro service. Amazing.

So this is cool and nicer stuff. Alright, so that's it for today. I hope you guys enjoyed this video. Thanks for watching. Have a nice day and take care