Now we continue with Part 13.
\nWe are still working with the GET requests<\/p>\n
<\/p>\n
Part 13\u00a0\u2013 Get List of Users by Location<\/strong><\/p>\n Now we would try to get the list of users in a location. So we would write a method in the LocationController that takes the location_id and returns the users in that location.<\/p>\n This method is written as follows in the LocationController.<\/p>\n Step 1:<\/strong> Copy the code below and paste inside the LocationController<\/p>\n Listing 1: GetUsersByLocation() method<\/p>\n In Listing 1, we first get the Optional<Location> object using findById. Then if the location exists, then we get the actual Location object. Finally we get the list of users in that location using the getUser() member function of the the Location class.<\/p>\n Also observe, the url pattern “\/location\/{id}\/users”<\/p>\n Step 2:<\/strong> Relaunch the application and try to access \/location\/1\/users. List of users is returned for that location.<\/p>\n <\/p>\n Part 14 – Get List of Posts by User<\/strong><\/p>\n We would do the same thing with the List of Posts. This is similar to what we did in part 14. I would recommend you try to do this yourself, before you use the code below<\/p>\n Step 1:<\/strong> Paste the code below in the UserController file<\/p>\n <\/p>\n <\/p>\n Step 2:<\/strong> Relaunch and test the application<\/p>\n <\/p>\n Part 15 \u2013 List of Users By Location from UserController by Extending JPARepository<\/strong><\/p>\n Now you can skip this part if you want. It’s just a different way of achieving the same thing.<\/p>\n Here, we would receive the Location_id as a PathVariable and use it to filter the list of users. We’ll achieve this by extending the UserRepository.<\/p>\n Step 1:<\/strong> Write the code below in the UserRepository.<\/p>\n <\/p>\n Step 2:<\/strong> Write the following method in the UserService<\/p>\n <\/p>\n Step 3:<\/strong> Write the following method in the UserController<\/p>\n <\/p>\n Notice that the url pattern is “\/users\/location\/{id}\/users”<\/p>\n Step 4<\/strong>: Launch the application and test it by accessing http:\/\/localhost\/users\/location\/1\/users<\/p>\n <\/p>\n Part 16 – Get List of Posts by User from PostController\u00a0 by Extending JPARepository<\/strong><\/p>\n Now you can skip this part if you want. It’s just a different way of achieving the same thing.<\/p>\n We’ll do something similar to what we did in Part 15, but this time with the Post.<\/p>\n Step 1:<\/strong> Copy and paste the code below in the PostRepository<\/p>\n <\/p>\n Step 2:<\/strong> Paste the code below in the PostService<\/p>\n <\/p>\n <\/p>\n Step 3:<\/strong> Paste the code below in the PostController<\/p>\n <\/p>\n Step 4:<\/strong> Relaunch and test the application<\/p>\n If you have gotten to this point, then, thumbs up to you! Just keep moving!<\/p>\n","protected":false},"excerpt":{"rendered":" Now we continue with Part 13. We are still working with the GET requests Part 1 to 7 – Setting Up Part 8 to 12 … <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[414],"tags":[],"class_list":["post-1944","post","type-post","status-publish","format-standard","hentry","category-programming"],"_links":{"self":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1944","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/comments?post=1944"}],"version-history":[{"count":1,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1944\/revisions"}],"predecessor-version":[{"id":2112,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1944\/revisions\/2112"}],"wp:attachment":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media?parent=1944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/categories?post=1944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/tags?post=1944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}@GetMapping<\/span>(<\/span>\"\/location\/{id}\/users\"<\/span>)<\/span>\npublic<\/span> List<<\/span>User><\/span> GetUsersByLocation<\/span>(<\/span>@PathVariable<\/span> Integer id)<\/span> {<\/span>\n Optional<<\/span>Location><\/span> location =<\/span> locationService.<\/span>findById<\/span>(<\/span>id);<\/span>\t\t\n if<\/span>(<\/span>location.<\/span>isPresent<\/span>())<\/span> {<\/span>\n\treturn<\/span> location.<\/span>get<\/span>().<\/span>getUsers<\/span>();<\/span>\n }<\/span>\t\t\n return<\/span> null<\/span>;<\/span>\n}<\/span>\n<\/pre>\n@GetMapping<\/span>(<\/span>\"\/user\/{id}\/posts\"<\/span>)<\/span>\npublic<\/span> List<<\/span>Post><\/span> getPostsByUser<\/span>(<\/span>@PathVariable<\/span> Integer id)<\/span> {<\/span>\n Optional<<\/span>User><\/span> user =<\/span> userService.<\/span>findById<\/span>(<\/span>id);<\/span>\n if<\/span>(<\/span>user.<\/span>isPresent<\/span>())<\/span> {<\/span>\n\treturn<\/span> user.<\/span>get<\/span>().<\/span>getPosts<\/span>();<\/span>\n }<\/span>\n return<\/span> null<\/span>;<\/span>\n}<\/span>\n<\/pre>\nList<<\/span>User><\/span> findByLocationId<\/span>(<\/span>Integer id);<\/span>\n<\/pre>\npublic<\/span> List<<\/span>User><\/span> getUsersByLocation<\/span>(<\/span>Integer id)<\/span> {<\/span>\n return<\/span> userRepository.<\/span>findByLocationId<\/span>(<\/span>id);<\/span>\n}<\/span>\n<\/pre>\n@GetMapping<\/span>(<\/span>\"\/users\/location\/{id}\/users\"<\/span>)<\/span>\npublic<\/span> List<<\/span>User><\/span> getUsersByLocation<\/span>(<\/span>@PathVariable<\/span> Integer id)<\/span> {<\/span>\n return<\/span> userService.<\/span>getUsersByLocation<\/span>(<\/span>id);<\/span>\n}<\/span>\n<\/pre>\nList<<\/span>Post><\/span> findByUserId<\/span>(<\/span>Integer id);<\/span>\n<\/pre>\npublic<\/span> List<<\/span>Post><\/span> findByLocationId<\/span>(<\/span>Integer id)<\/span> {<\/span>\n return<\/span> postRepository.<\/span>findByUserId<\/span>(<\/span>id);<\/span>\n}<\/span>\n<\/pre>\n@GetMapping<\/span>(<\/span>\"\/posts\/user\/{id}\/posts\"<\/span>)<\/span>\npublic<\/span> List<<\/span>Post><\/span> getPostsByUser<\/span>(<\/span>@PathVariable<\/span> Integer id)<\/span> {<\/span>\n return<\/span> postService.<\/span>findByLocationId<\/span>(<\/span>id);<\/span>\n}<\/span>\n<\/pre>\n