Compare commits
26 Commits
feature/31
...
feature/38
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
7b5135c109 | ||
|
|
2c93cc3dd2 | ||
|
|
be217c6b01 | ||
|
|
dbf8b046b0 | ||
|
|
6f183e38ec | ||
|
|
2c8b4c9a09 | ||
|
|
c0fcefa8c0 | ||
|
|
6036bd63ad | ||
|
|
cb5179abd7 | ||
|
|
9e376bfefb | ||
|
|
f4b11c755c | ||
|
|
af1a95b1c7 | ||
|
|
8cc64c879f | ||
|
|
e08c02a99a | ||
|
|
13566e1f86 | ||
|
|
e9115e5322 | ||
|
|
0210499e66 | ||
|
|
42c8b3df14 | ||
|
|
54c4481031 | ||
|
|
2d142eb829 | ||
|
|
09b6beee53 | ||
|
|
a39084a11a | ||
|
|
1beaaad422 | ||
|
|
826cfb0eaa | ||
|
|
37169355da | ||
|
|
3e7b928d8f |
@@ -1,24 +1,26 @@
|
||||
pipeline {
|
||||
agent any
|
||||
tools {
|
||||
jdk("openjdk-17")
|
||||
}
|
||||
|
||||
stages {
|
||||
stage('Init') {
|
||||
steps {
|
||||
sh 'printenv'
|
||||
script {
|
||||
sh 'whoami'
|
||||
sh 'printenv'
|
||||
|
||||
migration_script = './script/db_migration.sh'
|
||||
FLYWAY_CONFIG = '/home/ec2-user/flyway/flyway.conf'
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
stage('DB Migrate') {
|
||||
steps {
|
||||
sh """
|
||||
chmod 755 ${migration_script}
|
||||
/bin/bash ${migration_script}
|
||||
"""
|
||||
flywayrunner installationName: 'flywaytool-jenkins',
|
||||
flywayCommand: 'info migrate validate',
|
||||
commandLineArgs: "-configFiles=${FLYWAY_CONFIG}",
|
||||
credentialsId: 'ecb29499-7272-4e8b-b3ab-a7a3ab7eafab',
|
||||
url: '',
|
||||
locations: "filesystem:${WORKSPACE}/db/migration"
|
||||
}
|
||||
}
|
||||
|
||||
|
||||
47
README.md
47
README.md
@@ -5,11 +5,19 @@
|
||||
|
||||
<br>
|
||||
|
||||
## Specification
|
||||
- java 17
|
||||
- kotlin 1.6.21
|
||||
- Spring Boot 2.7.0
|
||||
- MySQL 8.0.21
|
||||
## :pushpin: Specification
|
||||
- Lang
|
||||
- java 17
|
||||
- kotlin 1.6.21
|
||||
- Framework
|
||||
- Spring Boot 2.7.0
|
||||
- DB
|
||||
- MySQL 8.0.21
|
||||
- Flyway(migration)
|
||||
- CI/CD
|
||||
- Jenkins
|
||||
- Cloud Server
|
||||
- AWS Lightsail(Amazon Linux2)
|
||||
|
||||
<br>
|
||||
|
||||
@@ -25,7 +33,7 @@
|
||||
|
||||
<br>
|
||||
|
||||
## :pushpin: Run Application
|
||||
## :pushpin: Setting
|
||||
|
||||
### 💽 로컬 DB 구성 (docker)
|
||||
- local에 DB(MySQL)용 docker container run
|
||||
@@ -34,31 +42,8 @@
|
||||
$ docker run --name mysql-server -e MYSQL_ROOT_PASSWORD=beaniejoy -d -p 3306:3306 mysql:8.0.21
|
||||
```
|
||||
|
||||
### 💽 DB Migration (flyway)
|
||||
[flyway doc](https://documentation.red-gate.com/fd/flyway-documentation-138346877.html)
|
||||
- **Info**
|
||||
Prints the details and status information about all the migrations
|
||||
```bash
|
||||
$ ./gradlew :db:flywayInfo
|
||||
```
|
||||
- **Validate**
|
||||
Validates the applied migrations against the available ones
|
||||
DB에 적용된 migration과 local에 적용된 migration 정보 일치 여부 체크
|
||||
```bash
|
||||
$ ./gradlew :db:flywayValidate
|
||||
```
|
||||
- **Migrate**
|
||||
Migrates the schema to the latest version
|
||||
migration 설정 내용들 반영
|
||||
```bash
|
||||
$ ./gradlew :db:flywayMigrate
|
||||
```
|
||||
- **Clean**
|
||||
Drops all objects (tables, views, procedures, triggers, …) in the configured schemas
|
||||
(prodution 단계에서는 절대 사용 X)
|
||||
```bash
|
||||
$ ./gradlew :db:flywayClean -i
|
||||
```
|
||||
### 💽 DB Migration (with flyway)
|
||||
- [DB migration directory README](https://github.com/beaniejoy/dongne-cafe-api/blob/main/db/README.md)
|
||||
|
||||
### 💽 docker compose 실행(수정 작업 진행중)
|
||||
- docker compose를 이용한 nginx, DB(MySQL), application 한꺼번에 실행하는 경우
|
||||
|
||||
@@ -15,8 +15,4 @@ object Plugins {
|
||||
const val PLUGIN_SPRING = "plugin.spring"
|
||||
const val PLUGIN_JPA = "plugin.jpa"
|
||||
}
|
||||
|
||||
object FlywayDB {
|
||||
const val FLYWAY = "org.flywaydb.flyway"
|
||||
}
|
||||
}
|
||||
@@ -15,8 +15,4 @@ object Version {
|
||||
const val KOTLIN_LOGGING = "3.0.4"
|
||||
const val JWT = "0.11.5"
|
||||
}
|
||||
|
||||
object FlywayDB {
|
||||
const val FLYWAY_CORE = "9.8.1"
|
||||
}
|
||||
}
|
||||
42
db/README.md
Normal file
42
db/README.md
Normal file
@@ -0,0 +1,42 @@
|
||||
# DB Migration
|
||||
|
||||
- flyway version: `9.15.4`
|
||||
- [flyway doc](https://documentation.red-gate.com/fd/flyway-documentation-138346877.html)
|
||||
|
||||
## :pushpin: Installation
|
||||
|
||||
```shell
|
||||
$ brew install flyway
|
||||
```
|
||||
- macOS 전용
|
||||
|
||||
<br>
|
||||
|
||||
## :pushpin: Flyway Command
|
||||
|
||||
- **Clean**
|
||||
Drops all objects (tables, views, procedures, triggers, …) in the configured schemas
|
||||
(prodution 단계에서는 절대 사용 X)
|
||||
```bash
|
||||
$ flyway clean -configFiles=db/flyway.conf
|
||||
```
|
||||
|
||||
- **Info**
|
||||
Prints the details and status information about all the migrations
|
||||
```bash
|
||||
$ flyway info -configFiles=db/flyway.conf
|
||||
```
|
||||
|
||||
- **Migrate**
|
||||
Migrates the schema to the latest version
|
||||
migration 설정 내용들 반영
|
||||
```bash
|
||||
$ flyway migrate -configFiles=db/flyway.conf
|
||||
```
|
||||
|
||||
- **Validate**
|
||||
Validates the applied migrations against the available ones
|
||||
DB에 적용된 migration과 local에 적용된 migration 정보 일치 여부 체크
|
||||
```bash
|
||||
$ flyway validate -configFiles=db/flyway.conf
|
||||
```
|
||||
@@ -1,26 +0,0 @@
|
||||
buildscript {
|
||||
repositories {
|
||||
mavenCentral()
|
||||
}
|
||||
dependencies {
|
||||
classpath("org.flywaydb:flyway-mysql:${Version.FlywayDB.FLYWAY_CORE}")
|
||||
}
|
||||
}
|
||||
|
||||
plugins {
|
||||
id(Plugins.FlywayDB.FLYWAY).version(Version.FlywayDB.FLYWAY_CORE)
|
||||
}
|
||||
|
||||
dependencies {
|
||||
implementation("org.flywaydb:flyway-core:${Version.FlywayDB.FLYWAY_CORE}") // flyway
|
||||
}
|
||||
|
||||
flyway {
|
||||
baselineDescription = "Start Flyway Migration!"
|
||||
baselineOnMigrate = true
|
||||
baselineVersion = "000"
|
||||
locations = arrayOf("filesystem:./migration", "filesystem:./seed")
|
||||
configFiles = arrayOf("conf/flyway.conf")
|
||||
cleanDisabled = false // activate flywayClean
|
||||
ignoreMigrationPatterns = arrayOf("*:pending") // ignore validating pending(대기) state
|
||||
}
|
||||
@@ -1,4 +0,0 @@
|
||||
flyway.url=jdbc:mysql://localhost:3306/dongne?autoreconnect=true&characterEncoding=utf8&serverTimezone=Asia/Seoul
|
||||
flyway.user=root
|
||||
flyway.password=beaniejoy
|
||||
flyway.driver=com.mysql.cj.jdbc.Driver
|
||||
10
db/flyway.conf
Normal file
10
db/flyway.conf
Normal file
@@ -0,0 +1,10 @@
|
||||
flyway.url=jdbc:mysql://localhost:3306/dongne?autoreconnect=true&characterEncoding=utf8&serverTimezone=Asia/Seoul
|
||||
flyway.user=root
|
||||
flyway.password=beaniejoy
|
||||
flyway.driver=com.mysql.cj.jdbc.Driver
|
||||
flyway.locations=filesystem:db/migration,db/seed
|
||||
|
||||
flyway.baselineOnMigrate=true
|
||||
flyway.baselineVersion=000
|
||||
# flyway.ignoreMigrationPatterns=*:pending
|
||||
flyway.cleanDisabled=false
|
||||
@@ -6,8 +6,8 @@ CREATE TABLE `cafe` (
|
||||
`total_rate` float NOT NULL COMMENT '카페 종합 평가 점수',
|
||||
`description` varchar(255) COMMENT '카페 상세설명',
|
||||
`created_at` datetime NOT NULL COMMENT '카페 등록날짜',
|
||||
`created_by` varchar(20) NOT NULL COMMENT '카페 등록자',
|
||||
`created_by` varchar(320) NOT NULL COMMENT '카페 등록자',
|
||||
`updated_at` datetime NULL COMMENT '카페 변경날짜',
|
||||
`updated_by` varchar(20) NULL COMMENT '카페 변경자',
|
||||
`updated_by` varchar(320) NULL COMMENT '카페 변경자',
|
||||
PRIMARY KEY (`id`)
|
||||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||||
@@ -3,9 +3,9 @@ CREATE TABLE `cafe_menu` (
|
||||
`name` varchar(50) NOT NULL COMMENT '카페 메뉴명',
|
||||
`price` decimal(10, 2) NOT NULL COMMENT '메뉴 가격',
|
||||
`created_at` datetime NOT NULL COMMENT '메뉴 등록날짜',
|
||||
`created_by` varchar(20) NOT NULL COMMENT '메뉴 등록자',
|
||||
`created_by` varchar(320) NOT NULL COMMENT '메뉴 등록자',
|
||||
`updated_at` datetime COMMENT '메뉴 변경날짜',
|
||||
`updated_by` varchar(20) NULL COMMENT '메뉴 변경자',
|
||||
`updated_by` varchar(320) NULL COMMENT '메뉴 변경자',
|
||||
`cafe_id` bigint unsigned NOT NULL COMMENT '연관된 카페 ID',
|
||||
PRIMARY KEY (`id`),
|
||||
KEY `cafe_id` (`cafe_id`),
|
||||
|
||||
@@ -2,9 +2,9 @@ CREATE TABLE `cafe_image` (
|
||||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '카페 이미지 ID',
|
||||
`img_url` varchar(255) NOT NULL COMMENT '이미지 경로',
|
||||
`created_at` datetime NOT NULL COMMENT '이미지 등록날짜',
|
||||
`created_by` varchar(20) NOT NULL COMMENT '이미지 등록자',
|
||||
`created_by` varchar(320) NOT NULL COMMENT '이미지 등록자',
|
||||
`updated_at` datetime COMMENT '이미지 변경날짜',
|
||||
`updated_by` varchar(20) NULL COMMENT '이미지 변경자',
|
||||
`updated_by` varchar(320) NULL COMMENT '이미지 변경자',
|
||||
`cafe_id` bigint unsigned NOT NULL COMMENT '연관된 카페 ID',
|
||||
PRIMARY KEY (`id`),
|
||||
KEY `cafe_id` (`cafe_id`),
|
||||
|
||||
@@ -2,9 +2,9 @@ CREATE TABLE `menu_option`(
|
||||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '옵션 ID',
|
||||
`title` varchar(50) NOT NULL COMMENT '메뉴 옵션 이름',
|
||||
`created_at` datetime NOT NULL COMMENT '옵션 등록날짜',
|
||||
`created_by` varchar(20) NOT NULL COMMENT '옵션 등록자',
|
||||
`created_by` varchar(320) NOT NULL COMMENT '옵션 등록자',
|
||||
`updated_at` datetime COMMENT '옵션 변경날짜',
|
||||
`updated_by` varchar(20) NULL COMMENT '옵션 변경자',
|
||||
`updated_by` varchar(320) NULL COMMENT '옵션 변경자',
|
||||
`menu_id` bigint unsigned NOT NULL COMMENT '연관된 카페 메뉴 ID',
|
||||
PRIMARY KEY (`id`),
|
||||
KEY `menu_id` (`menu_id`),
|
||||
|
||||
@@ -3,9 +3,9 @@ CREATE TABLE `option_detail` (
|
||||
`name` varchar(50) NOT NULL COMMENT '옵션 상세명',
|
||||
`extra_price` decimal(10, 2) NOT NULL COMMENT '옵션 추가 요금',
|
||||
`created_at` datetime NOT NULL COMMENT '옵션 상세 등록날짜',
|
||||
`created_by` varchar(20) NOT NULL COMMENT '옵션 상세 등록자',
|
||||
`created_by` varchar(320) NOT NULL COMMENT '옵션 상세 등록자',
|
||||
`updated_at` datetime COMMENT '옵션 상세 변경날짜',
|
||||
`updated_by` varchar(20) NULL COMMENT '옵션 상세 변경자',
|
||||
`updated_by` varchar(320) NULL COMMENT '옵션 상세 변경자',
|
||||
`option_id` bigint unsigned NOT NULL COMMENT '연관된 옵션 ID',
|
||||
PRIMARY KEY (`id`),
|
||||
KEY `option_id` (`option_id`),
|
||||
|
||||
@@ -7,8 +7,8 @@ CREATE TABLE `member` (
|
||||
`role_type` varchar(20) COMMENT '회원 권한',
|
||||
`activated` tinyint NOT NULL COMMENT '계정 활성화 여부',
|
||||
`created_at` datetime NOT NULL COMMENT '회원 등록날짜',
|
||||
`created_by` varchar(20) NOT NULL COMMENT '회원 등록자',
|
||||
`created_by` varchar(320) NOT NULL COMMENT '회원 등록자',
|
||||
`updated_at` datetime NULL COMMENT '회원 변경날짜',
|
||||
`updated_by` varchar(20) NULL COMMENT '회원 변경자',
|
||||
`updated_by` varchar(320) NULL COMMENT '회원 변경자',
|
||||
PRIMARY KEY (`member_id`)
|
||||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||||
@@ -1,8 +0,0 @@
|
||||
package io.beaniejoy.dongnecafe.common.config
|
||||
|
||||
import org.springframework.context.annotation.Configuration
|
||||
import org.springframework.data.jpa.repository.config.EnableJpaAuditing
|
||||
|
||||
@Configuration
|
||||
@EnableJpaAuditing
|
||||
class AuditingConfig
|
||||
@@ -1,12 +0,0 @@
|
||||
package io.beaniejoy.dongnecafe.common.entity
|
||||
|
||||
import org.springframework.data.domain.AuditorAware
|
||||
import org.springframework.stereotype.Component
|
||||
import java.util.*
|
||||
|
||||
@Component
|
||||
class BaseEntityAuditorAware: AuditorAware<String> {
|
||||
override fun getCurrentAuditor(): Optional<String> {
|
||||
return Optional.of("system")
|
||||
}
|
||||
}
|
||||
@@ -5,7 +5,7 @@ spring:
|
||||
driver-class-name: com.mysql.cj.jdbc.Driver
|
||||
jpa:
|
||||
hibernate:
|
||||
ddl-auto: none # use [service-api] flyway migration
|
||||
ddl-auto: none # use flyway migration
|
||||
properties:
|
||||
hibernate:
|
||||
dialect: org.hibernate.dialect.MySQL5InnoDBDialect
|
||||
|
||||
@@ -0,0 +1,25 @@
|
||||
package io.beaniejoy.dongnecafe.common.config
|
||||
|
||||
import io.beaniejoy.dongnecafe.security.getAuthPrincipal
|
||||
import mu.KLogging
|
||||
import org.springframework.context.annotation.Bean
|
||||
import org.springframework.context.annotation.Configuration
|
||||
import org.springframework.data.domain.AuditorAware
|
||||
import org.springframework.data.jpa.repository.config.EnableJpaAuditing
|
||||
import org.springframework.security.core.context.SecurityContextHolder
|
||||
import java.util.*
|
||||
|
||||
@Configuration
|
||||
@EnableJpaAuditing
|
||||
class AuditingConfig {
|
||||
companion object: KLogging() {
|
||||
const val SYSTEM = "system"
|
||||
}
|
||||
|
||||
@Bean
|
||||
fun auditorProvider(): AuditorAware<String> {
|
||||
return AuditorAware<String> {
|
||||
Optional.of(SecurityContextHolder.getContext().authentication?.getAuthPrincipal() ?: SYSTEM)
|
||||
}
|
||||
}
|
||||
}
|
||||
@@ -0,0 +1,21 @@
|
||||
package io.beaniejoy.dongnecafe.common.entity
|
||||
|
||||
import org.springframework.data.annotation.CreatedBy
|
||||
import org.springframework.data.annotation.LastModifiedBy
|
||||
import org.springframework.data.jpa.domain.support.AuditingEntityListener
|
||||
import javax.persistence.Column
|
||||
import javax.persistence.EntityListeners
|
||||
import javax.persistence.MappedSuperclass
|
||||
|
||||
@MappedSuperclass
|
||||
@EntityListeners(AuditingEntityListener::class)
|
||||
abstract class BaseEntity protected constructor() : BaseTimeEntity() {
|
||||
@CreatedBy
|
||||
@Column(updatable = false)
|
||||
lateinit var createdBy: String
|
||||
protected set
|
||||
|
||||
@LastModifiedBy
|
||||
lateinit var updatedBy: String
|
||||
protected set
|
||||
}
|
||||
@@ -1,11 +1,10 @@
|
||||
package io.beaniejoy.dongnecafe.common
|
||||
package io.beaniejoy.dongnecafe.common.entity
|
||||
|
||||
import org.springframework.data.annotation.CreatedBy
|
||||
import org.springframework.data.annotation.CreatedDate
|
||||
import org.springframework.data.annotation.LastModifiedBy
|
||||
import org.springframework.data.annotation.LastModifiedDate
|
||||
import org.springframework.data.jpa.domain.support.AuditingEntityListener
|
||||
import java.time.LocalDateTime
|
||||
import javax.persistence.Column
|
||||
import javax.persistence.EntityListeners
|
||||
import javax.persistence.MappedSuperclass
|
||||
|
||||
@@ -13,18 +12,11 @@ import javax.persistence.MappedSuperclass
|
||||
@EntityListeners(AuditingEntityListener::class)
|
||||
abstract class BaseTimeEntity protected constructor() {
|
||||
@CreatedDate
|
||||
var createdAt: LocalDateTime = LocalDateTime.now()
|
||||
protected set
|
||||
|
||||
@CreatedBy
|
||||
var createdBy: String = ""
|
||||
@Column(updatable = false)
|
||||
lateinit var createdAt: LocalDateTime
|
||||
protected set
|
||||
|
||||
@LastModifiedDate
|
||||
var updatedAt: LocalDateTime? = null
|
||||
protected set
|
||||
|
||||
@LastModifiedBy
|
||||
var updatedBy: String? = null
|
||||
lateinit var updatedAt: LocalDateTime
|
||||
protected set
|
||||
}
|
||||
@@ -1,6 +1,6 @@
|
||||
package io.beaniejoy.dongnecafe.domain.cafe.entity
|
||||
|
||||
import io.beaniejoy.dongnecafe.common.BaseTimeEntity
|
||||
import io.beaniejoy.dongnecafe.common.entity.BaseEntity
|
||||
import io.beaniejoy.dongnecafe.domain.cafe.model.request.CafeMenuRegisterRequest
|
||||
import javax.persistence.*
|
||||
|
||||
@@ -11,7 +11,7 @@ class Cafe protected constructor(
|
||||
address: String,
|
||||
phoneNumber: String,
|
||||
description: String,
|
||||
) : BaseTimeEntity() {
|
||||
) : BaseEntity() {
|
||||
@Id
|
||||
@GeneratedValue(strategy = GenerationType.IDENTITY)
|
||||
@Column(name = "cafe_id", nullable = false)
|
||||
|
||||
@@ -1,11 +1,11 @@
|
||||
package io.beaniejoy.dongnecafe.domain.cafe.entity
|
||||
|
||||
import io.beaniejoy.dongnecafe.common.BaseTimeEntity
|
||||
import io.beaniejoy.dongnecafe.common.entity.BaseEntity
|
||||
import javax.persistence.*
|
||||
|
||||
@Entity
|
||||
@Table(name = "cafe_image")
|
||||
class CafeImage(
|
||||
class CafeImage protected constructor(
|
||||
@Id
|
||||
@GeneratedValue(strategy = GenerationType.IDENTITY)
|
||||
@Column(name = "cafe_image_id", nullable = false)
|
||||
@@ -17,4 +17,4 @@ class CafeImage(
|
||||
@ManyToOne
|
||||
@JoinColumn(name = "cafe_id", nullable = false)
|
||||
val cafe: Cafe
|
||||
) : BaseTimeEntity()
|
||||
) : BaseEntity()
|
||||
@@ -1,6 +1,6 @@
|
||||
package io.beaniejoy.dongnecafe.domain.cafe.entity
|
||||
|
||||
import io.beaniejoy.dongnecafe.common.BaseTimeEntity
|
||||
import io.beaniejoy.dongnecafe.common.entity.BaseEntity
|
||||
import io.beaniejoy.dongnecafe.domain.cafe.model.request.MenuOptionRegisterRequest
|
||||
import java.math.BigDecimal
|
||||
import javax.persistence.*
|
||||
@@ -10,7 +10,7 @@ import javax.persistence.*
|
||||
class CafeMenu protected constructor(
|
||||
name: String,
|
||||
price: BigDecimal,
|
||||
) : BaseTimeEntity() {
|
||||
) : BaseEntity() {
|
||||
@Id
|
||||
@GeneratedValue(strategy = GenerationType.IDENTITY)
|
||||
@Column(name = "cafe_menu_id", nullable = false)
|
||||
@@ -33,7 +33,11 @@ class CafeMenu protected constructor(
|
||||
val menuOptionList: MutableList<MenuOption> = arrayListOf()
|
||||
|
||||
companion object {
|
||||
fun createCafeMenu(name: String, price: BigDecimal, menuOptionRequestList: List<MenuOptionRegisterRequest>): CafeMenu {
|
||||
fun createCafeMenu(
|
||||
name: String,
|
||||
price: BigDecimal,
|
||||
menuOptionRequestList: List<MenuOptionRegisterRequest>
|
||||
): CafeMenu {
|
||||
val menuOptionEntityList = menuOptionRequestList.map { menuOptionRequestDto ->
|
||||
MenuOption.createMenuOption(
|
||||
title = menuOptionRequestDto.title,
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
package io.beaniejoy.dongnecafe.domain.cafe.entity
|
||||
|
||||
import io.beaniejoy.dongnecafe.common.BaseTimeEntity
|
||||
import io.beaniejoy.dongnecafe.common.entity.BaseEntity
|
||||
import io.beaniejoy.dongnecafe.domain.cafe.model.request.OptionDetailRegisterRequest
|
||||
import javax.persistence.*
|
||||
|
||||
@@ -8,7 +8,7 @@ import javax.persistence.*
|
||||
@Table(name = "menu_option")
|
||||
class MenuOption protected constructor(
|
||||
title: String
|
||||
) : BaseTimeEntity() {
|
||||
) : BaseEntity() {
|
||||
@Id
|
||||
@GeneratedValue(strategy = GenerationType.IDENTITY)
|
||||
@Column(name = "menu_option_id", nullable = false)
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
package io.beaniejoy.dongnecafe.domain.cafe.entity
|
||||
|
||||
import io.beaniejoy.dongnecafe.common.BaseTimeEntity
|
||||
import io.beaniejoy.dongnecafe.common.entity.BaseEntity
|
||||
import java.math.BigDecimal
|
||||
import javax.persistence.*
|
||||
|
||||
@@ -9,7 +9,7 @@ import javax.persistence.*
|
||||
class OptionDetail protected constructor(
|
||||
name: String,
|
||||
extraPrice: BigDecimal
|
||||
) : BaseTimeEntity() {
|
||||
) : BaseEntity() {
|
||||
@Id
|
||||
@GeneratedValue(strategy = GenerationType.IDENTITY)
|
||||
@Column(name = "option_detail_id", nullable = false)
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
package io.beaniejoy.dongnecafe.domain.member.entity
|
||||
|
||||
import io.beaniejoy.dongnecafe.common.BaseTimeEntity
|
||||
import io.beaniejoy.dongnecafe.common.entity.BaseEntity
|
||||
import io.beaniejoy.dongnecafe.domain.member.constant.RoleType
|
||||
import javax.persistence.*
|
||||
|
||||
@@ -11,7 +11,7 @@ class Member(
|
||||
password: String,
|
||||
address: String,
|
||||
phoneNumber: String
|
||||
): BaseTimeEntity() {
|
||||
) : BaseEntity() {
|
||||
@Id
|
||||
@GeneratedValue(strategy = GenerationType.IDENTITY)
|
||||
@Column(name = "member_id", nullable = false)
|
||||
|
||||
@@ -0,0 +1,15 @@
|
||||
package io.beaniejoy.dongnecafe.security
|
||||
|
||||
import io.beaniejoy.dongnecafe.security.constant.SecurityConstant.ANONYMOUS_USER
|
||||
import io.beaniejoy.dongnecafe.security.constant.SecurityConstant.ROLE_ANONYMOUS
|
||||
import org.springframework.security.core.Authentication
|
||||
|
||||
fun Authentication.getAuthPrincipal() : String? {
|
||||
if (this.isAnonymous()) return null
|
||||
|
||||
return this.principal.toString()
|
||||
}
|
||||
|
||||
fun Authentication.isAnonymous(): Boolean {
|
||||
return this.principal == ANONYMOUS_USER || this.authorities.any { it.authority == ROLE_ANONYMOUS }
|
||||
}
|
||||
@@ -3,4 +3,7 @@ package io.beaniejoy.dongnecafe.security.constant
|
||||
object SecurityConstant {
|
||||
const val BEARER = "Bearer"
|
||||
const val WHITESPACE = " "
|
||||
|
||||
const val ANONYMOUS_USER = "anonymousUser"
|
||||
const val ROLE_ANONYMOUS = "ROLE_ANONYMOUS"
|
||||
}
|
||||
@@ -1,8 +0,0 @@
|
||||
package io.beaniejoy.dongnecafe.common.config
|
||||
|
||||
import org.springframework.context.annotation.Configuration
|
||||
import org.springframework.data.jpa.repository.config.EnableJpaAuditing
|
||||
|
||||
@Configuration
|
||||
@EnableJpaAuditing
|
||||
class AuditingConfig
|
||||
@@ -21,10 +21,10 @@ class SecurityConfig {
|
||||
@Bean
|
||||
fun filterChain(http: HttpSecurity): SecurityFilterChain {
|
||||
return http
|
||||
// only api 방식 인증 & 인가 적용 위해 csrf & formLogin 비활성화
|
||||
.csrf().disable()
|
||||
.formLogin().disable()
|
||||
|
||||
// FIXME 임시 permitAll 설정
|
||||
.authorizeRequests()
|
||||
.anyRequest().authenticated()
|
||||
|
||||
@@ -43,6 +43,7 @@ class SecurityConfig {
|
||||
.jwtTokenUtils(jwtTokenUtils)
|
||||
}
|
||||
|
||||
// Security Filter 미적용 자원 설정
|
||||
@Bean
|
||||
fun webSecurityCustomizer(): WebSecurityCustomizer {
|
||||
return WebSecurityCustomizer { web ->
|
||||
|
||||
@@ -1,13 +0,0 @@
|
||||
package io.beaniejoy.dongnecafe.common.entity
|
||||
|
||||
import org.springframework.data.domain.AuditorAware
|
||||
import org.springframework.stereotype.Component
|
||||
import java.util.*
|
||||
|
||||
@Component
|
||||
class BaseEntityAuditorAware: AuditorAware<String> {
|
||||
override fun getCurrentAuditor(): Optional<String> {
|
||||
// TODO 추후 사용자 로그인 기능 추가되면 실제 등록한 사용자를 DB에 저장하는 방향으로 수정
|
||||
return Optional.of("system")
|
||||
}
|
||||
}
|
||||
@@ -24,9 +24,11 @@ class JwtAuthenticationFilter(
|
||||
val httpRequest = request as HttpServletRequest
|
||||
log.info { "[JwtAuthenticationFilter][${request.dispatcherType}] uri: ${request.requestURI}" }
|
||||
|
||||
// 인증 헤더에 토큰값 없는 경우 pass
|
||||
getAccessToken(httpRequest)?.let {
|
||||
jwtTokenUtils.getAuthentication(it)
|
||||
}?.also {
|
||||
// 유효한 인증 토큰 존재하는 경우 SecurityContext 토큰값 저장
|
||||
SecurityContextHolder.getContext().authentication = it
|
||||
log.info { "Valid Access Token [${it.name}]" }
|
||||
}
|
||||
@@ -34,6 +36,10 @@ class JwtAuthenticationFilter(
|
||||
chain.doFilter(request, response)
|
||||
}
|
||||
|
||||
/**
|
||||
* 인증 토큰 획득
|
||||
* Authorization : Bearer [AUTH_TOKEN]
|
||||
*/
|
||||
private fun getAccessToken(request: HttpServletRequest): String? {
|
||||
val bearer = request.getHeader(HttpHeaders.AUTHORIZATION)
|
||||
?: return null
|
||||
|
||||
@@ -1,7 +1,6 @@
|
||||
package io.beaniejoy.dongnecafe.domain.cafe.repository
|
||||
|
||||
import io.beaniejoy.dongnecafe.common.config.AuditingConfig
|
||||
import io.beaniejoy.dongnecafe.common.entity.BaseEntityAuditorAware
|
||||
import io.beaniejoy.dongnecafe.domain.cafe.entity.Cafe
|
||||
import io.beaniejoy.dongnecafe.domain.cafe.utils.CafeTestUtils
|
||||
import mu.KLogging
|
||||
@@ -17,7 +16,6 @@ import org.springframework.data.repository.findByIdOrNull
|
||||
@DataJpaTest(
|
||||
includeFilters = [
|
||||
ComponentScan.Filter(type = FilterType.ASSIGNABLE_TYPE, classes = [AuditingConfig::class]),
|
||||
ComponentScan.Filter(type = FilterType.ASSIGNABLE_TYPE, classes = [BaseEntityAuditorAware::class])
|
||||
]
|
||||
)
|
||||
internal class CafeRepositoryTest {
|
||||
|
||||
@@ -1,7 +0,0 @@
|
||||
#!/bin/bash
|
||||
|
||||
cd ..
|
||||
|
||||
./gradlew :db:flywayInfo
|
||||
|
||||
./gradlew :db:flywayValidate
|
||||
@@ -2,4 +2,3 @@ rootProject.name = "dongne-cafe-api"
|
||||
include("dongne-common")
|
||||
include("dongne-service-api")
|
||||
include("dongne-account-api")
|
||||
include("db")
|
||||
|
||||
Reference in New Issue
Block a user