codingspecialist/Springboot-TStory-Project

스프링부트 JPA 블로그 V3 - GREEN Computer

시큐리티 테스트 참고

• https://tecoble.techcourse.co.kr/post/2020-09-30-spring-security-test/

1. 의존성

• devtools
• spring web (mvc)
• mustache
• lombok
• jpa
• mariadb
• security
• validation

2. DB설정

CREATE USER 'green'@'%' IDENTIFIED BY 'green1234';
CREATE DATABASE greendb;
GRANT ALL PRIVILEGES ON greendb.* TO 'green'@'%';

3. 에디터

• https://quilljs.com/

4. 댓글

• https://livere.com/

5. 주소 요청 이런식으로 해볼까?

localhost:8080/ (메인페이지 - 글 있는 곳 아님)
localhost:8080/user/{userId}/post
localhost:8080/user/{userId}/post/{postId}
localhost:8080/user/{userId}/category/{title}

6. 모델링

Visit
id
userId
totalCount
createDate
updateDate

User
id
username
password
createDate
updateDate

Post
id
title
content
thumnail
userId
categoryId
createDate
updateDate

Like
id
postId
userId
createDate
updateDate

Category
id
title
userId
createDate
updateDate

7. 기능정리

• 단위테스트 - API 문서 자동생성
• AOP 처리
• 배포
• firebase fcm

8. 추가 보완

• 글수정 (직접)
• 회원정보 수정 (직접)

Gradle depenency update

'''txt ./gradlew --refresh-dependencie '''

페이징 참고

-- currentPage, totalPages
SELECT TRUE last FROM dual;

SELECT 
true LAST,
false FIRST,
3 size, 
0 currentPage,
(SELECT COUNT(*) FROM post WHERE userId = 1) totalCount,
(SELECT CEIL(COUNT(*)/3) FROM post WHERE userId = 1) totalPages,
p.*
FROM post p
ORDER BY p.id DESC
LIMIT 0, 3;
-- LIMIT (0*3), 3;