Forem: Rakesh Sagar

[TIL] A better response to post request (Spring Boot)

Rakesh Sagar — Mon, 07 Nov 2022 04:55:23 +0000

When writing an api that saves the data it would be nice if there was a way to see the the data stored. So usually the id is returned in the response of the api.
Spring Boot provides a better way to handle this, By providing the created method in response entity which accepts a url as an argument and returns 201 as he response status.

ResponseEntity.created(
  URI.create("http://domainname/getEndpoint/"+entity.getId())
).build();

This would apply a response header called Location with the above mentioned url.

However, we want to make the domain name dynamic as the api can be deployed in multiple environments.
A quick google search led me to this Stack Overflow Answer

Sep 29 '09 Comments: 1 Answers: 7

119

I'd like to create URLs based on the URL used by the client for the active request. Is there anything smarter than taking the current HttpServletRequest object and it's getParameter...() methods to rebuilt the complete URL including (and only) it's GET parameters.

Clarification: If possible I want to resign from…

Open Full Question

Here is the code snippet for that

URI uri = ServletUriComponentsBuilder
             .fromCurrentContextPath()
         .path("/get/{id}")
             .build(String.valueOf(entity.getId()));

return ResponseEntity.created(uri).build();

and the final response

Conclusion (da ta daaa) So after almost a year I posted here again. Any form of constructive critisism is always welcome with open arms. So.. see you around I guess ${insert akward goodbye}.

[TIL] More Mysql Stuff

Rakesh Sagar — Fri, 10 Sep 2021 18:29:30 +0000

1) You can get the create statement that was used to create a
table with the query

    SHOW CREATE TABLE table_name;

2) JSON type in mysql an can be created by the query

CREATE TABLE table_name(col_name JSON);

(obligatory crud tutorial coming soon)

3) MySQL has ENUM datatype which can be used to store flag values.

CREATE TABLE table_name(status_flag ENUM('success' 'failed'));

This is better than storing string values as enums are indexed by the database.

4) using markdown text editor of this site.(It's pretty cool actually).

Conclusion (da ta daaa) this flimsy article was written so that i don't break the habit of writing flimsy articles. Any form of constructive criticism is always welcome with open arms. So.. see you around i guess ${insert awkward goodbye}.

[TIL] Mysql Stuff

Rakesh Sagar — Thu, 09 Sep 2021 19:44:23 +0000

1) mysql has a json type and the subjectively less interesting spatial types (more r&d coming soon).

2) mysql has a decimal type where you can specify exact number of digits. egs:- some_col DECIMAL(5,2); where 5 is the scale ie number of digits and 2 is the precision ie the number of digits after the decimal.

3) the int column can be declared in these ways
...int, ...
...int(10), ...
...int(10) unsigned, ...
...int(10) unsigned zerofill, ...

4) the '8' int(8) refers to the number of padding to the left of the number not the size/length of the number, and it becomes obvious when zerofill is added.Here is a screen shot i took just for you

5) Timestamp converts data into utc and back where as date time stores data as is.
Here's a link to a post by someone who takes the chore of writing articles much more seriously.

Conclusion (da ta daaa) this is first of (hopefully) many articles (atleast one per week). Any form of constructive critisism is always welcome with open arms. So.. see you around i guess ${insert akward goodbye}.