TIL 18. [Mission 5] CRUD with Prisma

smยท2022๋…„ 6์›” 15์ผ
0

๐Ÿ“๐Ÿ“Œ๐Ÿ“’

๐Ÿ“CRUD

๐Ÿ“’ READ

๐Ÿ“Œ ํฌ์ŠคํŒ… ๋ฆฌ์ŠคํŠธ

API ํ˜ธ์ถœ url : /postings
HTTP method : /GET
ํฌ์ŠคํŒ… ๋ฆฌ์ŠคํŠธ๋ฅผ READ

๐Ÿ“’ CREATE

๐Ÿ“Œ ํฌ์ŠคํŒ… ์ž‘์„ฑํ•˜๊ธฐ

API ํ˜ธ์ถœ url : /postings
HTTP method : /POST
Request body์— ๋‹ด์„ ์ •๋ณด : user_id, contents
HTTP response status code : 201
HTTP response body : { Message : "CREATED" }
Express ์„œ๋ฒ„์—์„œ client๋กœ ๋ถ€ํ„ฐ ์ „์†ก๋œ request body์—์„œ user_id, contents ๊ฐ’์„ ๊บผ๋‚ด์™€ INSERT๋ฅผ ์ด์šฉํ•˜์—ฌ ํฌ์ŠคํŒ…์„ ์ž‘์„ฑํ•˜์—ฌ ์ฃผ์—ˆ๋‹ค.

๐Ÿ“’ UPDATE

๐Ÿ“Œ ํฌ์ŠคํŒ… ์ˆ˜์ •ํ•˜๊ธฐ

API ํ˜ธ์ถœ url : /postings/:id
HTTP method : /PUT
Request body์— ๋‹ด์„ ์ •๋ณด : contents
HTTP response status code : 200
HTTP response body : { Message : "UPDATED" }
Express ์„œ๋ฒ„์—์„œ client๋กœ ๋ถ€ํ„ฐ ์ „์†ก๋œ request url parameter๋กœ ๋ถ€ํ„ฐ id๊ฐ’์„ ๊บผ๋‚ด์™€ ํ•ด๋‹น id์˜ ํฌ์ŠคํŒ…์˜ contents๋ฅผ UPDATE๋ฅผ ์ด์šฉํ•˜์—ฌ ํฌ์ŠคํŒ…์„ ์ˆ˜์ •ํ•˜์—ฌ ์ฃผ์—ˆ๋‹ค.

๐Ÿ“’ DELETE

๐Ÿ“Œ ํฌ์ŠคํŒ… ์‚ญ์ œํ•˜๊ธฐ

API ํ˜ธ์ถœ url : /postings/:id
HTTP method : /DELETE
HTTP response status code : 204
Express ์„œ๋ฒ„์—์„œ client๋กœ ๋ถ€ํ„ฐ ์ „์†ก๋œ request url parameter๋กœ ๋ถ€ํ„ฐ id๊ฐ’์„ ๊บผ๋‚ด์™€ ํ•ด๋‹น id์˜ ํฌ์ŠคํŒ…์„ DELETE๋ฅผ ์ด์šฉํ•˜์—ฌ ํฌ์ŠคํŒ…์„ ์‚ญ์ œํ•˜์—ฌ ์ฃผ์—ˆ๋‹ค.

profile
Today I Learned

2๊ฐœ์˜ ๋Œ“๊ธ€

comment-user-thumbnail
2022๋…„ 7์›” 14์ผ

TIL 18. [Mission 5] CRUD with Prisma๋Š” ์ € ๊ฐ™์€ ์ดˆ๋ณด ํ”„๋กœ๊ทธ๋ž˜๋จธ๋“ค์—๊ฒŒ ๊ท€์ค‘ํ•œ ๊ตํ›ˆ ์ค‘ ํ•˜๋‚˜์ž…๋‹ˆ๋‹ค.

๋‹ต๊ธ€ ๋‹ฌ๊ธฐ
comment-user-thumbnail
2022๋…„ 7์›” 14์ผ

Express Server๊ฐ€ ํด๋ผ์ด์–ธํŠธ์—์„œ ๋ณด๋‚ธ ์š”์ฒญ url ๋งค๊ฐœ๋ณ€์ˆ˜์—์„œ id ๊ฐ’์„ ๊ฒ€์ƒ‰ํ–ˆ์ง€๋งŒ DELETE๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ id ๊ฒŒ์‹œ๋ฅผ ์ œ๊ฑฐํ•œ ์ ์ด ์—†์Šต๋‹ˆ๋‹ค.

๋‹ต๊ธ€ ๋‹ฌ๊ธฐ