[Spring Kotlin API] 게시판 API 만들기

                                    id, 작성자, 작성일, 수정일, 조회수, 좋아요 수, 부모 id, tpye -> parentId로 대체

                                    CREATE TABLE boards(
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    writer BIGINT NOT NULL,  -- 외래 키로 사용할 것
    text_content TEXT NOT NULL,
    file_url TEXT,
    first_writing_time DATETIME NOT NULL,
    last_modified_time DATETIME NOT NULL,
    like_count BIGINT NOT NULL,
    reading_count BIGINT NOT NULL,
    parent_id BIGINT
);

                                    CREATE INDEX writer
ON x.boards
(writer);

CREATE INDEX parent_id
ON x.boards
(parent_id);

                                    package com.example.frontServer.entity

import com.example.frontServer.enum.BoardType
import jakarta.persistence.*
import org.springframework.data.annotation.CreatedBy
import org.springframework.data.annotation.CreatedDate
import org.springframework.data.annotation.LastModifiedDate
import org.springframework.data.jpa.domain.support.AuditingEntityListener
import java.time.LocalDateTime

@Entity
@Table(name = "boards")
@EntityListeners(AuditingEntityListener::class)
data class Board (
    @Id @GeneratedValue(strategy = GenerationType.IDENTITY)
    var id: Long? = null,

    val writer : Long,

    @Column(name = "text_content")
    var textContent: String,

    @Column(name="file_url")
    var fileUri: String? = null, //

    @CreatedDate
    @Column(name = "first_writing_time")
    var firstWritingDate: LocalDateTime? = null,

    @LastModifiedDate
    @Column(name = "last_modified_time")
    var lastModifiedDate: LocalDateTime? = null,

    @Column(name = "like_count")
    var likeCount: Long = 0,

    @Column(name = "reading_count")
    var readingCount : Long,

    @Column(name = "parent_id")
    var parentId: Long? = null,

)

                                    package com.example.frontServer.dto

import jakarta.validation.constraints.NotEmpty
import org.springframework.web.multipart.MultipartFile

data class SaveBoardRequest(
    @field:NotEmpty
    val textContent: String,

    val file: MultipartFile?,

    @field:NotEmpty
    val parentId: Long,
)

                                    POST: 게시글 작성 기능

                                    GET: 특정 유저의 게시글 받아오기, 특정 게시글 id의 reply목록을 받아오기

                                    DELETE : 특정 게시글 삭제하기

                                    import com.example.frontServer.dto.*
import com.example.frontServer.security.AuthUserDetails
import com.example.frontServer.service.BoardService
import jakarta.validation.Valid
import org.springframework.http.ResponseEntity
import org.springframework.security.core.annotation.AuthenticationPrincipal
import org.springframework.web.bind.annotation.*

@RestController
class BoardController(
    private val boardService: BoardService
) {
    @PostMapping("/board")
    fun save(
        @Valid @RequestBody saveBoardRequest: SaveBoardRequest
        @AuthenticationPricipal user: AutheUserDetails
    ) : ResponseEntity<SomeToClientDto>{
        // save 로직 구현
    }

    @GetMapping("/boards")
    fun findBoards(): ResponseEntity<List<SometoClientDto>> {
        // 전체 게시글 조회 로직 구현
    }

    @GetMapping("/board")
    fun findBoardById(
        @RequestParam id: Long
    ) : ResponseEntity<SomeToClientDto> {
        // id로 Board 조회 로직
    }

    @DeleteMapping("/board")
    fun delete(
        @RequestParam id: Long
    ): ResponseEntity<SomeToClientDto> {
        // delte 로직
    }
}

                                    @Service
class BoardService(
    val boardRepository: BoardRepository
) {
    fun save(request: SaveBoardRequest, userId:Long): Boolean {
        // userId get from Aturhentication
        boardRepository.save(
            Board(
                writer = userId,
                writer = userId,
                textContent = request.textContent,
                imgUri = imgUrl,
                readingCount = 0,
                likeCount = 0,
            )
        )
    }

    fun findAll(): List<SomeToCtrDto> {
        // logic
    }

    fun findById(id: Long): SomeToCtrDto {
        // logic
    }

    fun deleteById(id: Long): Boolean {
        // write logic
    }
}

                                    package com.example.frontServer.repository

import com.example.frontServer.entity.Board
import org.springframework.data.jpa.repository.JpaRepository
import org.springframework.stereotype.Repository

@Repository
interface BoardRepository: JpaRepository<Board, Long>, BoardQueryDslRepository {
}