hyese ch

<p>해결되었습니다. snake case로 설정해서 그렇게 설정 되었다고 생각했는데 isAnswered로 되어 있었습니다. 감사합니다!</p>

Boolean 값 update 문제

<p>라우터는 post와 delete 전부 잘 실행됩니다.&nbsp;</p>
<p>패치는 update를 말하려고 했던 건데 잘못 이야기해서 혼선을 드린 것 같네요.</p>
<p>지금 하려는 것은 post 라우터 안쪽에서 answer create와 ask update를 실행하고</p>
<p>delete 라우터 안쪽에서 answer destroy와 ask update를 실행하는 것입니다.</p>

<p>answer를 작성하면 answer 디비에 잘 들어가고, 다만 patch만 되지 않아서... 혹시 실수가 있는데 제가 모르는 건지ㅠㅠ 조언 부탁드립니다...</p>

<p>프론트 saga에서 answer 게시와 삭제는 아래와 같이 작성했습니다.</p>
<div style="color: #f8f8f2; background-color: #272822; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; line-height: 18px; white-space: pre;"><br />
<div><span style="color: #88846f;">// Add Answer</span></div>
<div><span style="color: #66d9ef; font-style: italic;">function</span> <span style="color: #a6e22e;">addAnswerAPI</span>(<span style="color: #fd971f; font-style: italic;">data</span>) {</div>
<div><span style="color: #f92672;">return</span> axios.<span style="color: #a6e22e;">post</span>(<span style="color: #e6db74;">`/answers/</span><span style="color: #f92672;">${</span><span style="color: #fd971f; font-style: italic;">data</span>.askId<span style="color: #f92672;">}</span><span style="color: #e6db74;">`</span>, <span style="color: #fd971f; font-style: italic;">data</span>);</div>
<div>}</div>
<br />
<div><span style="color: #66d9ef; font-style: italic;">function</span><span style="color: #f92672;">*</span> <span style="color: #a6e22e;">addAnswer</span>(<span style="color: #fd971f; font-style: italic;">action</span>) {</div>
<div><span style="color: #f92672;">try</span> {</div>
<div><span style="color: #66d9ef; font-style: italic;">const</span> result <span style="color: #f92672;">=</span> <span style="color: #f92672;">yield</span> <span style="color: #a6e22e;">call</span>(<span style="color: #a6e22e;">addAnswerAPI</span>, <span style="color: #fd971f; font-style: italic;">action</span>.data);</div>
<div><span style="color: #f92672;">yield</span> <span style="color: #a6e22e;">put</span>({</div>
<div>type: ADD_ANSWER_SUCCESS,</div>
<div>data: result.data,</div>
<div>});</div>
<div>} <span style="color: #f92672;">catch</span> (err) {</div>
<div><span style="color: #f92672;">yield</span> <span style="color: #a6e22e;">put</span>({</div>
<div>type: ADD_ANSWER_FAILURE,</div>
<div>error: err.message,</div>
<div>});</div>
<div>}</div>
<div>}</div>
<br />
<div><span style="color: #88846f;">// REMOVE ANSWER</span></div>
<div><span style="color: #66d9ef; font-style: italic;">function</span> <span style="color: #a6e22e;">removeAnswerAPI</span>(<span style="color: #fd971f; font-style: italic;">data</span>) {</div>
<div><span style="color: #f92672;">return</span> axios.<span style="color: #a6e22e;">delete</span>(<span style="color: #e6db74;">`/answers/</span><span style="color: #f92672;">${</span><span style="color: #fd971f; font-style: italic;">data</span>.answerId<span style="color: #f92672;">}</span><span style="color: #e6db74;">/delete/</span><span style="color: #f92672;">${</span><span style="color: #fd971f; font-style: italic;">data</span>.askId<span style="color: #f92672;">}</span><span style="color: #e6db74;">`</span>);</div>
<div>}</div>
<br />
<div><span style="color: #66d9ef; font-style: italic;">function</span><span style="color: #f92672;">*</span> <span style="color: #a6e22e;">removeAnswer</span>(<span style="color: #fd971f; font-style: italic;">action</span>) {</div>
<div><span style="color: #f92672;">try</span> {</div>
<div><span style="color: #66d9ef; font-style: italic;">const</span> result <span style="color: #f92672;">=</span> <span style="color: #f92672;">yield</span> <span style="color: #a6e22e;">call</span>(<span style="color: #a6e22e;">removeAnswerAPI</span>, <span style="color: #fd971f; font-style: italic;">action</span>.data);</div>
<div><span style="color: #f92672;">yield</span> <span style="color: #a6e22e;">put</span>({</div>
<div>type: REMOVE_ANSWER_SUCCESS,</div>
<div>data: result.data,</div>
<div>});</div>
<div>} <span style="color: #f92672;">catch</span> (err) {</div>
<div><span style="color: #f92672;">yield</span> <span style="color: #a6e22e;">put</span>({</div>
<div>type: REMOVE_ANSWER_FAILURE,</div>
<div>error: err.message,</div>
<div>});</div>
<div>}</div>
<div>}</div>
</div>
<p></p>
<p>그리고 백엔드 코드에서 answer 게시(+연결된 ask의 is_answered: true)로 변경, answer 삭제(+ 연결된 ask의 is_answered:false)로 변경하는 코드는 다음과 같이 작성했습니다.</p>
<div style="color: #f8f8f2; background-color: #272822; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; line-height: 18px; white-space: pre;">
<div><span style="color: #88846f;">// 특정 질문에 대답하기 POST /answers/askId</span></div>
<div>router.<span style="color: #a6e22e;">post</span>(<span style="color: #e6db74;">"/:askId"</span>, isLoggedIn, <span style="color: #f92672;">async</span> (<span style="color: #fd971f; font-style: italic;">req</span>, <span style="color: #fd971f; font-style: italic;">res</span>, <span style="color: #a6e22e;">next</span>) <span style="color: #66d9ef; font-style: italic;">=></span> {</div>
<div><span style="color: #f92672;">try</span> {</div>
<div><span style="color: #66d9ef; font-style: italic;">const</span> ask <span style="color: #f92672;">=</span> <span style="color: #f92672;">await</span> Ask.<span style="color: #a6e22e;">findOne</span>({</div>
<div>where: { id: <span style="color: #fd971f; font-style: italic;">req</span>.params.askId },</div>
<div>});</div>
<div><span style="color: #f92672;">if</span> (<span style="color: #f92672;">!</span>ask) {</div>
<div><span style="color: #88846f;">// 해당 질문이 없으면 리다이렉트</span></div>
<div><span style="color: #f92672;">return</span> <span style="color: #fd971f; font-style: italic;">res</span>.<span style="color: #a6e22e;">status</span>(<span style="color: #ae81ff;">403</span>).<span style="color: #a6e22e;">send</span>(<span style="color: #e6db74;">"존재하지 않는 ask입니다."</span>);</div>
<div>}</div>
<div><span style="color: #88846f;">// 해당 질문이 있으면 is_answered를 true로 변경</span></div>
<div><span style="color: #f92672;">await</span> Ask.<span style="color: #a6e22e;">update</span>(</div>
<div>{</div>
<div>is_answered: <span style="color: #ae81ff;">true</span>,</div>
<div>},</div>
<div>{</div>
<div>where: { id: <span style="color: #fd971f; font-style: italic;">req</span>.params.askId },</div>
<div>}</div>
<div>);</div>
<br />
<div><span style="color: #66d9ef; font-style: italic;">const</span> answer <span style="color: #f92672;">=</span> <span style="color: #f92672;">await</span> Answer.<span style="color: #a6e22e;">create</span>({</div>
<div>content: <span style="color: #fd971f; font-style: italic;">req</span>.body.answer,</div>
<div>linked_ask_id: <span style="color: #fd971f; font-style: italic;">req</span>.params.askId,</div>
<div>target_user_id: <span style="color: #fd971f; font-style: italic;">req</span>.user.id,</div>
<div>});</div>
<br />
<div><span style="color: #88846f;">// 리다이렉트 걸어주면 좋겠다...</span></div>
<div><span style="color: #fd971f; font-style: italic;">res</span>.<span style="color: #a6e22e;">status</span>(<span style="color: #ae81ff;">201</span>).<span style="color: #a6e22e;">json</span>(answer);</div>
<div>} <span style="color: #f92672;">catch</span> (err) {</div>
<div>console.<span style="color: #a6e22e;">error</span>(err);</div>
<div><span style="color: #a6e22e;">next</span>(err);</div>
<div>}</div>
<div>});</div>
<br />
<div><span style="color: #88846f;">// 특정 답변 삭제하기</span></div>
<div>router.<span style="color: #a6e22e;">delete</span>(</div>
<div><span style="color: #e6db74;">"/:answerId/delete/:askId"</span>,</div>
<div>isLoggedIn,</div>
<div><span style="color: #f92672;">async</span> (<span style="color: #fd971f; font-style: italic;">req</span>, <span style="color: #fd971f; font-style: italic;">res</span>, <span style="color: #a6e22e;">next</span>) <span style="color: #66d9ef; font-style: italic;">=></span> {</div>
<div><span style="color: #f92672;">try</span> {</div>
<div><span style="color: #88846f;">// 해당 답변에 연결된 ask의 is_answered 컬럼값 false로 변경</span></div>
<div><span style="color: #f92672;">await</span> Ask.<span style="color: #a6e22e;">update</span>(</div>
<div>{</div>
<div>is_answered: <span style="color: #ae81ff;">false</span>,</div>
<div>},</div>
<div>{</div>
<div>where: { id: <span style="color: #fd971f; font-style: italic;">req</span>.params.askId },</div>
<div>}</div>
<div>);</div>
<br />
<div><span style="color: #88846f;">// 답변 삭제</span></div>
<div><span style="color: #f92672;">await</span> Answer.<span style="color: #a6e22e;">destroy</span>({</div>
<div>where: {</div>
<div>id: <span style="color: #fd971f; font-style: italic;">req</span>.params.answerId,</div>
<div>target_user_id: <span style="color: #fd971f; font-style: italic;">req</span>.user.id,</div>
<div>},</div>
<div>});</div>
<br />
<div><span style="color: #fd971f; font-style: italic;">res</span>.<span style="color: #a6e22e;">status</span>(<span style="color: #ae81ff;">201</span>).<span style="color: #a6e22e;">send</span>(<span style="color: #e6db74;">"답변을 삭제했습니다."</span>);</div>
<div>} <span style="color: #f92672;">catch</span> (err) {</div>
<div>console.<span style="color: #a6e22e;">error</span>(err);</div>
<div><span style="color: #a6e22e;">next</span>(err);</div>
<div>}</div>
<div>}</div>
<div>);</div>
</div>
<p></p>

<p>Executing (default): SELECT `id`, `email`, `username`, `password`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `users` AS `User` WHERE `User`.`id` = 1;</p>
<p>Executing (default): SELECT `id`, `nickname`, `content`, `is_answered` AS `isAnswered`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt`, `target_user_id` FROM `asks` AS `Ask` WHERE `Ask`.`id` = '10';</p>
<p>Executing (default): INSERT INTO `answers` (`id`,`content`,`created_at`,`updated_at`,`target_user_id`,`linked_ask_id`) VALUES (DEFAULT,?,?,?,?,?);</p>
<p></p>
<p>위의 쿼리는 is_answered 기본값을 true로 변경하려고 할 때 뜨는 쿼리입니다.</p>
<p></p>

<p>백엔드 콘솔에는</p>
<p>`is_answered` TINYINT(1) DEFAULT false</p>
<p>이렇게 뜹니다.</p>
<p></p>
<p>전체는</p>
<p>Executing (default): CREATE TABLE IF NOT EXISTS `asks` (`id` INTEGER NOT NULL auto_increment , `nickname` VARCHAR(30), `content` VARCHAR(1500) NOT NULL, `is_answered` TINYINT(1) DEFAULT false, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NOT NULL, `target_user_id` INTEGER, PRIMARY KEY (`id`), FOREIGN KEY (`target_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci;</p>
<p>Executing (default): SHOW INDEX FROM `asks` FROM `asker`</p>
<p></p>
<p>이렇게 뜨고요!&nbsp;<span style="background-color: #272822; color: #f8f8f2; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; white-space: pre;"> </span><span style="background-color: #272822; color: #f8f8f2; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; white-space: pre;">underscored</span><span style="background-color: #272822; color: #f8f8f2; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; white-space: pre;">: </span><span style="background-color: #272822; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; white-space: pre; color: #ae81ff;">true</span><span style="background-color: #272822; color: #f8f8f2; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; white-space: pre;">,</span></p>
<div style="color: #f8f8f2; background-color: #272822; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; line-height: 18px; white-space: pre;">
<div></div>
</div>
<p>스네이크 케이스로 설정을 변경했습니다.</p>
<p>그래서 문제가 없다고 생각했는데, 값이 변경이 되지 않네요..ㅜㅜ</p>
<p></p>
<p></p>

<p></p>
<p><img src="https://cdn.inflearn.com/public/comments/684a4d2b-d59c-4670-869d-243401bee4a7/스크린샷 2021-02-21 오후 8.48.20.png" title="스크린샷 2021-02-21 오후 8.48.20.png" width="1130" height="948" alt="" /></p>
<p></p>
<p>말씀해주신대로 설정했더니 값이 들어갔습니다!</p>
<p>이후에... 이제 게시물이 제대로 올라가면 is_answered 값을 true로 변경하려고 하는데</p>
<p>1.</p>
<p>위의 사진처럼 delete 라우트에서 delete와 patch 작업을 동시에 해주어도 되나요?&nbsp;</p>
<p></p>
<p>2.</p>
<p>그리고&nbsp;</p>
<p>위와 같은 방식으로 update를 했더니 default 값으로 설정되었던 0의 값이 1로 변경되지 않는 문제가 생겼습니다. ㅠㅠ</p>
<p>두 가지 질문 드립니다.&nbsp;</p>

BOOLEAN

Class 방식으로 바꾸고 난 이후

<p>오늘 계속 수정해보았는데... 아무리 해도 외래키가 생성되지 않아서 질문을 드립니다ㅠㅠ&nbsp;<br /><br /><a href="https://github.com/Askers/asker-back/tree/dev/models" target="_blank" rel="noopener noreferrer">https://github.com/Askers/asker-back/tree/dev/models</a><br /><br /><br /></p>
<p>user, ask, answer 세 가지 모델에 대한 관계를 정의해두었는데 혹시 확인 부탁드려도 될까요? 도저히 원인을 모르겠습니다 ㅠㅠ 한 부분 뿐만 아니라 전체 관계가 정의되지 않는 상태입니다... ㅜ</p>

hyese ch

Posts