Advanced REST Client GUI<\/figcaption><\/figure>\n <\/p>\n
Part 18: Add New Location<\/strong><\/p>\nTo Insert a new Location we need to make a POST request.<\/p>\n
Step 1<\/strong>: Write the AddLocation method in the LocationService. Copy and paste in the LocationService<\/p>\npublic<\/span> void<\/span> AddLocation<\/span>(<\/span>Location location)<\/span> {<\/span>\n locationRepository.<\/span>save<\/span>(<\/span>location);<\/span>\n}<\/span>\n<\/pre>\n <\/p>\n
Step 2<\/strong>: Write the AddLocation method in the LocationController. The method is given below. Copy and paste in the LocationController<\/p>\n <\/p>\n
@PostMapping<\/span>(<\/span>\"\/locations\/addNew\"<\/span>)<\/span>\npublic<\/span> void<\/span> AddLocation<\/span>(<\/span>@RequestBody<\/span> Location location)<\/span> {<\/span>\n locationService.<\/span>AddLocation<\/span>(<\/span>location);<\/span>\n}<\/span>\n<\/pre>\n <\/p>\n
<\/p>\n
Step 3:<\/strong> Relaunch the application.<\/p>\nStep 4:<\/strong> Make a POST request to the\u00a0http:\/\/localhost:8080\/locations\/addNew url using Advanced Rest Client. The body of the request is as shown below:<\/p>\n{\n \"id\"<\/span>: 5<\/span>,\n \"name\"<\/span>: \"KanysTown\"<\/span>\n}\n<\/pre>\n <\/p>\n
Step 5:<\/strong> Now access the http:\/\/localhost\/locations url to ensure the location is inserted. Then add a couple more locations.<\/p>\n <\/p>\n
Part 19 – Inserting a New User<\/strong><\/p>\nWe would also do the same as we did with adding new Location, but with a little variation. We’ll make some modifications to the User entity and to our data.sql file.<\/p>\n
Step 1:<\/strong> Launch the application and access the H2 Console to check\u00a0 what columns are there in the User table. Notice that there is a column in the User table called location_Id.<\/p>\nStep 2:<\/strong> Open the data.sql file. In the code to insert location, change the location_id to locationid (remove the underscore)<\/p>\nStep 3:<\/strong> Open the User model class. Add a new field named locationid.<\/p>\nStep 4:<\/strong> Add the getters and setters for the new locationid field<\/p>\nStep 5:<\/strong> In the @JoinColumn annotation, change the attribute location_id to locationid.<\/p>\nStep 6:<\/strong> Add new attributes to the @JoinColumn: insertable= false, updatable= false<\/p>\nAt the end all the changes you have made is given below:<\/p>\n
...\n...\n@ManyToOne<\/span>\n@JoinColumn<\/span>(<\/span>name=<\/span>\"locationid\"<\/span>,<\/span> insertable =<\/span> false<\/span>,<\/span> updatable=<\/span>false<\/span>)<\/span>\nprivate<\/span> Location location;<\/span>\n\nprivate<\/span> Integer locationid;<\/span>\n\npublic<\/span> Integer getLocationid<\/span>()<\/span> {<\/span>\n return<\/span> locationid;<\/span>\n}<\/span>\n\npublic<\/span> void<\/span> setLocationid<\/span>(<\/span>Integer locationid)<\/span> {<\/span>\n this<\/span>.<\/span>locationid<\/span> =<\/span> locationid;<\/span>\n}\n<\/span>...\n...<\/pre>\n <\/p>\n
Step 7:<\/strong> Open the UserService and add the following code to insert new User<\/p>\npublic<\/span> void<\/span> UpdateUser<\/span>(<\/span>User user)<\/span> {<\/span>\n\tuserRepository.<\/span>save<\/span>(<\/span>user);<\/span>\n}<\/span>\n<\/pre>\n <\/p>\n
Step 8:<\/strong> Open the UserController and add the following code<\/p>\n@PostMapping<\/span>(<\/span>\"\/users\/addNew\"<\/span>)<\/span>\npublic<\/span> void<\/span> AddUser<\/span>(<\/span>@RequestBody<\/span> User user)<\/span> {<\/span>\n userService.<\/span>AddUser<\/span>(<\/span>user);<\/span>\n}<\/span>\n<\/pre>\n <\/p>\n
Step 10:<\/strong> Launch the application and an try to insert a new user using Advanced REST Client. If it works, thumbs up to you! Otherwise, let me know.<\/p>\n <\/p>\n
Part 20 – Inserting a New Post<\/strong><\/p>\nTry to make the changes similar to the ones we made to insert a User. Try it and see if you get it, before following the procedure. The procedures are below:<\/p>\n
Step 1:<\/strong> Open the data.sql file. Change the post_id to postid for the insert into POST queries.<\/p>\nStep 2<\/strong>: In the Post model, add a new field named postid.<\/p>\nStep 3:<\/strong> Add the getters and setters for the new postid field<\/p>\nStep 4:<\/strong> In the @JoinColumn annotation, change the post_id to postid.<\/p>\nStep 5:<\/strong> Add updatable and insertable attribute and set them to false<\/p>\nAt the end, the changes to the\u00a0 Post model would be as follows:<\/p>\n
<\/p>\n
<\/p>\n
@ManyToOne<\/span>\n@JoinColumn<\/span>(<\/span>name=<\/span>\"userid\"<\/span>,<\/span> insertable=<\/span>false<\/span>,<\/span> updatable=<\/span>false<\/span>)<\/span>\nprivate<\/span> User user;<\/span>\n\nprivate<\/span> Integer userid;<\/span>\t\n\npublic<\/span> Integer getUserid<\/span>()<\/span> {<\/span>\n return<\/span> userid;<\/span>\n}<\/span>\n\npublic<\/span> void<\/span> setUserid<\/span>(<\/span>Integer userid)<\/span> {<\/span>\n this<\/span>.<\/span>userid<\/span> =<\/span> userid;<\/span>\n}<\/span>\n<\/pre>\n <\/p>\n
Step 6:<\/strong> Launch the application and make a request using the Advanced REST Client. The Json file is as shown below<\/p>\n{\n\"id\"<\/span>: 4<\/span>,\n\"postDate\"<\/span>: \"2019-09-02T17:42:03.878\"<\/span>,\n\"userid\"<\/span>: 2<\/span>,\n\"details\"<\/span>: \"Kindson The Genius\"<\/span>\n}\n<\/pre>\n <\/p>\n
Check the H2 Console to ensure that the data inserted correctly.<\/p>\n
At this point, you have completed this Part. Thumbs up to you! You are a genius!<\/p>\n
Let’s now see how to perform updates on the entities.<\/p>\n","protected":false},"excerpt":{"rendered":"
Good to know you’ve completed Parts 1 to 16! Thumbs up to you! Otherwise, you can see the links below and follow. Now we’ll continue … <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[414],"tags":[],"class_list":["post-1945","post","type-post","status-publish","format-standard","hentry","category-programming"],"acf":[],"_links":{"self":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1945","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=1945"}],"version-history":[{"count":1,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1945\/revisions"}],"predecessor-version":[{"id":2113,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/1945\/revisions\/2113"}],"wp:attachment":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media?parent=1945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/categories?post=1945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/tags?post=1945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Advanced](\"https:\/\/www.kindsonthegenius.com\/wp-content\/uploads\/2020\/09\/Advanced-REST-Client.jpg\")
<\/a>