Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[REFACTOR] 열거 항목 분리 #72

Closed
3 tasks done
chhs2131 opened this issue Dec 16, 2022 · 1 comment · Fixed by #73
Closed
3 tasks done

[REFACTOR] 열거 항목 분리 #72

chhs2131 opened this issue Dec 16, 2022 · 1 comment · Fixed by #73
Labels
refactor 로직 수정을 통한 개선 진행 (입출력에 변화 X)

Comments

@chhs2131
Copy link
Owner

chhs2131 commented Dec 16, 2022 •
edited
Loading

목적

기존 String으로 처리되던 상수값들에 대하여, 연관성있는 항목들은 Enum 형태로 묶어 가독성 증대 및 오류 방지, 로직 분리 등이 목적


상세내용

  • 대상
    • stockKinds : 공모주, 실권주,스펙주 ...
    • stockExchange : 코스피, 코스닥, 코넥스, 기타
    • ipoSequence : 개선필요. 관련 로직을 클래스 자체에서 검증할 것

참고사항
@chhs2131 chhs2131 added the refactor 로직 수정을 통한 개선 진행 (입출력에 변화 X) label Dec 16, 2022
chhs2131 added a commit that referenced this issue Dec 16, 2022
@chhs2131
feat(StockExchange,StockKinds): #72 - 시장 및 주식형태에 대한 Enum 뼈대 추가
9c03f24
chhs2131 added a commit that referenced this issue Dec 16, 2022
@chhs2131
feat(StockExchange): #72 - 시장 형태에 대해 내부적으로 Enum으로 관리하도록 수정
07638fa
chhs2131 added a commit that referenced this issue Dec 16, 2022
@chhs2131
feat(StockKinds): #72 - 종목 종류(공모주,실권주,,,)에 따른 Enum을 내부적으로 적용
c76a759
chhs2131 added a commit that referenced this issue Dec 16, 2022
@chhs2131
refactor(IpoSequence): #72 - 공모 진행 단계에 대한 검증을 IpoSequence Enum에서 진행하도…
e44ff8e 
…록 수정
@chhs2131
Copy link
Owner Author

lazy loading
https://jinseongsoft.tistory.com/248

2022-12-16 22:36:49.999 DEBUG 42679   [nio-8080-exec-4] o.s.security.web.FilterChainProxy        : [Line:208]Securing GET /api/v1/ipo/179
2022-12-16 22:36:50.02 DEBUG 42679   [nio-8080-exec-4] s.s.w.c.SecurityContextPersistenceFilter : [Line:102]Set SecurityContextHolder to empty SecurityContext
2022-12-16 22:36:50.03 DEBUG 42679   [nio-8080-exec-4] c.d.d.g.filter.JwtAuthenticationFilter   : [Line:33 ]authHeader : null
2022-12-16 22:36:50.03 DEBUG 42679   [nio-8080-exec-4] c.d.d.g.filter.JwtAuthenticationFilter   : [Line:34 ]JWT : null
2022-12-16 22:36:50.04 DEBUG 42679   [nio-8080-exec-4] c.d.d.g.filter.JwtAuthenticationFilter   : [Line:48 ]유효한 JWT 토큰이 없습니다. URI: /api/v1/ipo/179
2022-12-16 22:36:50.14 DEBUG 42679   [nio-8080-exec-4] o.s.s.w.a.i.FilterSecurityInterceptor    : [Line:210]Authorized filter invocation [GET /api/v1/ipo/179] with attributes [permitAll]
2022-12-16 22:36:50.14 DEBUG 42679   [nio-8080-exec-4] o.s.security.web.FilterChainProxy        : [Line:323]Secured GET /api/v1/ipo/179
2022-12-16 22:36:50.15 DEBUG 42679   [nio-8080-exec-4] o.s.web.servlet.DispatcherServlet        : [Line:119]GET "/api/v1/ipo/179", parameters={}
2022-12-16 22:36:50.17 DEBUG 42679   [nio-8080-exec-4] s.w.s.m.m.a.RequestMappingHandlerMapping : [Line:522]Mapped to com.dbsgapi.dbsgapi.api.ipo.controller.IpoApiController#getIpo(long)
2022-12-16 22:36:50.18  INFO 42679   [nio-8080-exec-4] c.d.d.g.interceptor.LoggerInterceptor    : [Line:17 ]======================== START ========================
2022-12-16 22:36:50.18  INFO 42679   [nio-8080-exec-4] c.d.d.g.interceptor.LoggerInterceptor    : [Line:18 ] Class       	:  class org.springframework.web.method.HandlerMethod
2022-12-16 22:36:50.18  INFO 42679   [nio-8080-exec-4] c.d.d.g.interceptor.LoggerInterceptor    : [Line:19 ] Request URI 	:  /api/v1/ipo/179
2022-12-16 22:36:50.18  INFO 42679   [nio-8080-exec-4] c.d.d.g.interceptor.LoggerInterceptor    : [Line:20 ] Servlet URI 	:  /api/v1/ipo/179
2022-12-16 22:36:50.20 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:29 ]Start => Controller : com.dbsgapi.dbsgapi.api.ipo.controller.IpoApiController.getIpo()
2022-12-16 22:36:50.20 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:29 ]Start => Service : com.dbsgapi.dbsgapi.api.ipo.service.IpoServiceImpl.selectIpo()
2022-12-16 22:36:50.20 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:29 ]Start => Mapper : com.dbsgapi.dbsgapi.api.ipo.mapper.IpoMapper.selectIpo()
2022-12-16 22:36:50.21 DEBUG 42679   [nio-8080-exec-4] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]Creating a new SqlSession
2022-12-16 22:36:50.22 DEBUG 42679   [nio-8080-exec-4] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@516834f0] was not registered for synchronization because synchronization is not active
2022-12-16 22:36:50.22 DEBUG 42679   [nio-8080-exec-4] o.s.jdbc.datasource.DataSourceUtils      : [Line:116]Fetching JDBC Connection from DataSource
2022-12-16 22:36:50.207 DEBUG 42679   [nio-8080-exec-4] o.m.s.t.SpringManagedTransaction         : [Line:49 ]JDBC Connection [HikariProxyConnection@1605353645 wrapping com.mysql.cj.jdbc.ConnectionImpl@7408e74f] will not be managed by Spring
2022-12-16 22:36:50.214 DEBUG 42679   [nio-8080-exec-4] c.d.d.a.ipo.mapper.IpoMapper.selectIpo   : [Line:137]==>  Preparing: SELECT ipo_index, stock_name, stock_exchange, IF(INSTR(stock_name,'스팩')=0 AND INSTR(stock_name, '기업인수목적')=0, stock_kinds, '스팩주') AS stock_kinds, stock_code, dart_code, ipo.sector AS sector_code, sector_code.sector_desc AS sector, profits, sales, DATE_FORMAT(ex_start_date, '%Y-%m-%d') ex_start_date, DATE_FORMAT(ex_end_date, '%Y-%m-%d') ex_end_date, DATE_FORMAT(ipo_forecast_start, '%Y-%m-%d') ipo_forecast_start, DATE_FORMAT(ipo_forecast_end, '%Y-%m-%d') ipo_forecast_end, DATE_FORMAT(ipo_start_date, '%Y-%m-%d') ipo_start_date, DATE_FORMAT(ipo_end_date, '%Y-%m-%d') ipo_end_date, DATE_FORMAT(ipo_refund_date, '%Y-%m-%d') ipo_refund_date, DATE_FORMAT(ipo_debut_date, '%Y-%m-%d') ipo_debut_date, ipo_cancel_bool, DATE_FORMAT(ipo_cancel_date, '%Y-%m-%d') ipo_cancel_date, ipo_cancel_reason, purpose_of_funds, lock_up_percent, ipo_institutional_acceptance_rate, ipo_price, ipo_price_low, ipo_price_high, ipo_min_deposit, put_back_option_who, put_back_option_price, put_back_option_deadline, tag, DATE_FORMAT(regist_date, '%Y-%m-%d') regist_date, DATE_FORMAT(update_date, '%Y-%m-%d') update_date, DATE_FORMAT(terminate_date, '%Y-%m-%d') terminate_date FROM ipo LEFT OUTER JOIN sector_code ON ipo.sector = sector_code.sector_code WHERE ipo_index = ?
2022-12-16 22:36:50.221 DEBUG 42679   [nio-8080-exec-4] c.d.d.a.ipo.mapper.IpoMapper.selectIpo   : [Line:137]==> Parameters: 179(Long)
bbbbbbbbbbb스팩주
비교한다:공모주 vs 스팩주
비교한다:실권주 vs 스팩주
비교한다:스팩주 vs 스팩주
aaaaaaaaaaaaaa스팩주
2022-12-16 22:36:50.425 DEBUG 42679   [nio-8080-exec-4] c.d.d.a.ipo.mapper.IpoMapper.selectIpo   : [Line:137]<==      Total: 1
2022-12-16 22:36:50.426 DEBUG 42679   [nio-8080-exec-4] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@516834f0]
2022-12-16 22:36:50.426 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:33 ]End => Mapper : com.dbsgapi.dbsgapi.api.ipo.mapper.IpoMapper.selectIpo()
2022-12-16 22:36:50.426 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:33 ]End => Service : com.dbsgapi.dbsgapi.api.ipo.service.IpoServiceImpl.selectIpo()
2022-12-16 22:36:50.427 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:29 ]Start => Service : com.dbsgapi.dbsgapi.api.ipo.service.IpoServiceImpl.selectIpoComment()
2022-12-16 22:36:50.427 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:29 ]Start => Mapper : com.dbsgapi.dbsgapi.api.ipo.mapper.IpoMapper.selectIpoComment()
2022-12-16 22:36:50.427 DEBUG 42679   [nio-8080-exec-4] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]Creating a new SqlSession
2022-12-16 22:36:50.427 DEBUG 42679   [nio-8080-exec-4] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1e92ca96] was not registered for synchronization because synchronization is not active
2022-12-16 22:36:50.428 DEBUG 42679   [nio-8080-exec-4] o.s.jdbc.datasource.DataSourceUtils      : [Line:116]Fetching JDBC Connection from DataSource
2022-12-16 22:36:50.428 DEBUG 42679   [nio-8080-exec-4] o.m.s.t.SpringManagedTransaction         : [Line:49 ]JDBC Connection [HikariProxyConnection@239968768 wrapping com.mysql.cj.jdbc.ConnectionImpl@7408e74f] will not be managed by Spring
2022-12-16 22:36:50.428 DEBUG 42679   [nio-8080-exec-4] c.d.d.a.i.m.IpoMapper.selectIpoComment   : [Line:137]==>  Preparing: SELECT comment_index, ipo_index, comment, writer, DATE_FORMAT(regist_date, '%Y-%m-%d') regist_date, log_type, change_log_json FROM ipo_comment WHERE ipo_index = ? and enabled not like 'N' ORDER BY regist_date DESC LIMIT 100;
2022-12-16 22:36:50.429 DEBUG 42679   [nio-8080-exec-4] c.d.d.a.i.m.IpoMapper.selectIpoComment   : [Line:137]==> Parameters: 179(Long)
2022-12-16 22:36:50.637 DEBUG 42679   [nio-8080-exec-4] c.d.d.a.i.m.IpoMapper.selectIpoComment   : [Line:137]<==      Total: 5
2022-12-16 22:36:50.637 DEBUG 42679   [nio-8080-exec-4] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1e92ca96]
2022-12-16 22:36:50.638 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:33 ]End => Mapper : com.dbsgapi.dbsgapi.api.ipo.mapper.IpoMapper.selectIpoComment()
2022-12-16 22:36:50.638 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:33 ]End => Service : com.dbsgapi.dbsgapi.api.ipo.service.IpoServiceImpl.selectIpoComment()
2022-12-16 22:36:50.641 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:29 ]Start => Service : com.dbsgapi.dbsgapi.api.ipo.service.IpoServiceImpl.selectIpoUnderwriter()
2022-12-16 22:36:50.641 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:29 ]Start => Mapper : com.dbsgapi.dbsgapi.api.ipo.mapper.IpoMapper.selectIpoUnderwriter()
2022-12-16 22:36:50.641 DEBUG 42679   [nio-8080-exec-4] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]Creating a new SqlSession
2022-12-16 22:36:50.642 DEBUG 42679   [nio-8080-exec-4] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7ebd35d9] was not registered for synchronization because synchronization is not active
2022-12-16 22:36:50.642 DEBUG 42679   [nio-8080-exec-4] o.s.jdbc.datasource.DataSourceUtils      : [Line:116]Fetching JDBC Connection from DataSource
2022-12-16 22:36:50.642 DEBUG 42679   [nio-8080-exec-4] o.m.s.t.SpringManagedTransaction         : [Line:49 ]JDBC Connection [HikariProxyConnection@486786476 wrapping com.mysql.cj.jdbc.ConnectionImpl@7408e74f] will not be managed by Spring
2022-12-16 22:36:50.643 DEBUG 42679   [nio-8080-exec-4] c.d.d.a.i.m.I.selectIpoUnderwriter       : [Line:137]==>  Preparing: SELECT DISTINCT ipo_underwriter.ipo_index, IFNULL(uc2.underwriter_name, ipo_underwriter.under_name) AS under_name, ipo_underwriter.ind_total_max, ipo_underwriter.ind_total_min, ipo_underwriter.ind_total_max, ipo_underwriter.ind_total_min, ipo_underwriter.sub_min_quan, ipo_underwriter.sub_deposit_percent, DATE_FORMAT(ipo_underwriter.update_date, '%Y-%m-%d') update_date FROM underwriter_code AS uc1 JOIN underwriter_code AS uc2 ON uc1.parents_code = uc2.underwriter_code RIGHT OUTER JOIN ipo_underwriter ON ipo_underwriter.under_name LIKE CONCAT('%', uc1.underwriter_name, '%') WHERE ipo_underwriter.ipo_index = ?;
2022-12-16 22:36:50.643 DEBUG 42679   [nio-8080-exec-4] c.d.d.a.i.m.I.selectIpoUnderwriter       : [Line:137]==> Parameters: 179(Long)
2022-12-16 22:36:50.827 DEBUG 42679   [nio-8080-exec-4] c.d.d.a.i.m.I.selectIpoUnderwriter       : [Line:137]<==      Total: 1
2022-12-16 22:36:50.831 DEBUG 42679   [nio-8080-exec-4] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7ebd35d9]
2022-12-16 22:36:50.832 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:33 ]End => Mapper : com.dbsgapi.dbsgapi.api.ipo.mapper.IpoMapper.selectIpoUnderwriter()
2022-12-16 22:36:50.833 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:33 ]End => Service : com.dbsgapi.dbsgapi.api.ipo.service.IpoServiceImpl.selectIpoUnderwriter()
2022-12-16 22:36:50.834 DEBUG 42679   [nio-8080-exec-4] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:33 ]End => Controller : com.dbsgapi.dbsgapi.api.ipo.controller.IpoApiController.getIpo()
2022-12-16 22:36:50.845 DEBUG 42679   [nio-8080-exec-4] o.s.w.s.m.m.a.HttpEntityMethodProcessor  : [Line:268]Using 'application/json', given [*/*] and supported [application/json, application/*+json, application/json, application/*+json]
2022-12-16 22:36:50.852 DEBUG 42679   [nio-8080-exec-4] o.s.w.s.m.m.a.HttpEntityMethodProcessor  : [Line:119]Writing [com.dbsgapi.dbsgapi.global.response.CustomResponse@6d77cc4f]
bbbbbbbbbbbbbbbbbb스팩주
2022-12-16 22:36:50.857 DEBUG 42679   [nio-8080-exec-4] .m.m.a.ExceptionHandlerExceptionResolver : [Line:416]Using @ExceptionHandler com.dbsgapi.dbsgapi.global.response.handler.RestControllerExceptionHandler#handleException(Exception, WebRequest)
2022-12-16 22:36:50.858 DEBUG 42679   [nio-8080-exec-4] o.s.w.s.m.m.a.HttpEntityMethodProcessor  : [Line:268]Using 'application/octet-stream', given [*/*] and supported [*/*]
2022-12-16 22:36:50.859 DEBUG 42679   [nio-8080-exec-4] .m.m.a.ExceptionHandlerExceptionResolver : [Line:146]Resolved [org.springframework.http.converter.HttpMessageNotWritableException: Could not write JSON: (was java.lang.NullPointerException); nested exception is com.fasterxml.jackson.databind.JsonMappingException: (was java.lang.NullPointerException) (through reference chain: com.dbsgapi.dbsgapi.global.response.CustomResponse["body"]->com.dbsgapi.dbsgapi.api.ipo.dto.IpoDetailDto["comment"]->java.util.ArrayList[0]->com.dbsgapi.dbsgapi.api.ipo.dto.IpoCommentDto["stockKinds"])]
2022-12-16 22:36:50.860 DEBUG 42679   [nio-8080-exec-4] o.s.web.servlet.DispatcherServlet        : [Line:1131]Completed 500 INTERNAL_SERVER_ERROR
2022-12-16 22:36:50.860 DEBUG 42679   [nio-8080-exec-4] s.s.w.c.SecurityContextPersistenceFilter : [Line:118]Cleared SecurityContextHolder to complete request
2022-12-16 22:37:02.285 DEBUG 42679   [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : [Line:421]HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0)
2022-12-16 22:37:02.286 DEBUG 42679   [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : [Line:518]HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2022-12-16 22:37:32.290 DEBUG 42679   [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : [Line:421]HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0)
2022-12-16 22:37:32.293 DEBUG 42679   [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : [Line:518]HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2022-12-16 22:37:47.579 DEBUG 42679   [nio-8080-exec-5] o.s.security.web.FilterChainProxy        : [Line:208]Securing GET /api/v1/ipo/179/basic
2022-12-16 22:37:47.581 DEBUG 42679   [nio-8080-exec-5] s.s.w.c.SecurityContextPersistenceFilter : [Line:102]Set SecurityContextHolder to empty SecurityContext
2022-12-16 22:37:47.583 DEBUG 42679   [nio-8080-exec-5] c.d.d.g.filter.JwtAuthenticationFilter   : [Line:33 ]authHeader : null
2022-12-16 22:37:47.583 DEBUG 42679   [nio-8080-exec-5] c.d.d.g.filter.JwtAuthenticationFilter   : [Line:34 ]JWT : null
2022-12-16 22:37:47.584 DEBUG 42679   [nio-8080-exec-5] c.d.d.g.filter.JwtAuthenticationFilter   : [Line:48 ]유효한 JWT 토큰이 없습니다. URI: /api/v1/ipo/179/basic
2022-12-16 22:37:47.589 DEBUG 42679   [nio-8080-exec-5] o.s.s.w.a.i.FilterSecurityInterceptor    : [Line:210]Authorized filter invocation [GET /api/v1/ipo/179/basic] with attributes [permitAll]
2022-12-16 22:37:47.590 DEBUG 42679   [nio-8080-exec-5] o.s.security.web.FilterChainProxy        : [Line:323]Secured GET /api/v1/ipo/179/basic
2022-12-16 22:37:47.591 DEBUG 42679   [nio-8080-exec-5] o.s.web.servlet.DispatcherServlet        : [Line:119]GET "/api/v1/ipo/179/basic", parameters={}
2022-12-16 22:37:47.595 DEBUG 42679   [nio-8080-exec-5] s.w.s.m.m.a.RequestMappingHandlerMapping : [Line:522]Mapped to com.dbsgapi.dbsgapi.api.ipo.controller.IpoApiController#getIpoDetail(long)
2022-12-16 22:37:47.597  INFO 42679   [nio-8080-exec-5] c.d.d.g.interceptor.LoggerInterceptor    : [Line:17 ]======================== START ========================
2022-12-16 22:37:47.598  INFO 42679   [nio-8080-exec-5] c.d.d.g.interceptor.LoggerInterceptor    : [Line:18 ] Class       	:  class org.springframework.web.method.HandlerMethod
2022-12-16 22:37:47.598  INFO 42679   [nio-8080-exec-5] c.d.d.g.interceptor.LoggerInterceptor    : [Line:19 ] Request URI 	:  /api/v1/ipo/179/basic
2022-12-16 22:37:47.598  INFO 42679   [nio-8080-exec-5] c.d.d.g.interceptor.LoggerInterceptor    : [Line:20 ] Servlet URI 	:  /api/v1/ipo/179/basic
2022-12-16 22:37:47.604 DEBUG 42679   [nio-8080-exec-5] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:29 ]Start => Controller : com.dbsgapi.dbsgapi.api.ipo.controller.IpoApiController.getIpoDetail()
2022-12-16 22:37:47.605 DEBUG 42679   [nio-8080-exec-5] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:29 ]Start => Service : com.dbsgapi.dbsgapi.api.ipo.service.IpoServiceImpl.selectIpo()
2022-12-16 22:37:47.605 DEBUG 42679   [nio-8080-exec-5] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:29 ]Start => Mapper : com.dbsgapi.dbsgapi.api.ipo.mapper.IpoMapper.selectIpo()
2022-12-16 22:37:47.606 DEBUG 42679   [nio-8080-exec-5] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]Creating a new SqlSession
2022-12-16 22:37:47.606 DEBUG 42679   [nio-8080-exec-5] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5275215] was not registered for synchronization because synchronization is not active
2022-12-16 22:37:47.606 DEBUG 42679   [nio-8080-exec-5] o.s.jdbc.datasource.DataSourceUtils      : [Line:116]Fetching JDBC Connection from DataSource
2022-12-16 22:37:47.786 DEBUG 42679   [nio-8080-exec-5] o.m.s.t.SpringManagedTransaction         : [Line:49 ]JDBC Connection [HikariProxyConnection@199277761 wrapping com.mysql.cj.jdbc.ConnectionImpl@7408e74f] will not be managed by Spring
2022-12-16 22:37:47.788 DEBUG 42679   [nio-8080-exec-5] c.d.d.a.ipo.mapper.IpoMapper.selectIpo   : [Line:137]==>  Preparing: SELECT ipo_index, stock_name, stock_exchange, IF(INSTR(stock_name,'스팩')=0 AND INSTR(stock_name, '기업인수목적')=0, stock_kinds, '스팩주') AS stock_kinds, stock_code, dart_code, ipo.sector AS sector_code, sector_code.sector_desc AS sector, profits, sales, DATE_FORMAT(ex_start_date, '%Y-%m-%d') ex_start_date, DATE_FORMAT(ex_end_date, '%Y-%m-%d') ex_end_date, DATE_FORMAT(ipo_forecast_start, '%Y-%m-%d') ipo_forecast_start, DATE_FORMAT(ipo_forecast_end, '%Y-%m-%d') ipo_forecast_end, DATE_FORMAT(ipo_start_date, '%Y-%m-%d') ipo_start_date, DATE_FORMAT(ipo_end_date, '%Y-%m-%d') ipo_end_date, DATE_FORMAT(ipo_refund_date, '%Y-%m-%d') ipo_refund_date, DATE_FORMAT(ipo_debut_date, '%Y-%m-%d') ipo_debut_date, ipo_cancel_bool, DATE_FORMAT(ipo_cancel_date, '%Y-%m-%d') ipo_cancel_date, ipo_cancel_reason, purpose_of_funds, lock_up_percent, ipo_institutional_acceptance_rate, ipo_price, ipo_price_low, ipo_price_high, ipo_min_deposit, put_back_option_who, put_back_option_price, put_back_option_deadline, tag, DATE_FORMAT(regist_date, '%Y-%m-%d') regist_date, DATE_FORMAT(update_date, '%Y-%m-%d') update_date, DATE_FORMAT(terminate_date, '%Y-%m-%d') terminate_date FROM ipo LEFT OUTER JOIN sector_code ON ipo.sector = sector_code.sector_code WHERE ipo_index = ?
2022-12-16 22:37:47.791 DEBUG 42679   [nio-8080-exec-5] c.d.d.a.ipo.mapper.IpoMapper.selectIpo   : [Line:137]==> Parameters: 179(Long)
bbbbbbbbbbb스팩주
비교한다:공모주 vs 스팩주
비교한다:실권주 vs 스팩주
비교한다:스팩주 vs 스팩주
aaaaaaaaaaaaaa스팩주
2022-12-16 22:37:48.00 DEBUG 42679   [nio-8080-exec-5] c.d.d.a.ipo.mapper.IpoMapper.selectIpo   : [Line:137]<==      Total: 1
2022-12-16 22:37:48.04 DEBUG 42679   [nio-8080-exec-5] org.mybatis.spring.SqlSessionUtils       : [Line:49 ]Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5275215]
2022-12-16 22:37:48.05 DEBUG 42679   [nio-8080-exec-5] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:33 ]End => Mapper : com.dbsgapi.dbsgapi.api.ipo.mapper.IpoMapper.selectIpo()
2022-12-16 22:37:48.05 DEBUG 42679   [nio-8080-exec-5] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:33 ]End => Service : com.dbsgapi.dbsgapi.api.ipo.service.IpoServiceImpl.selectIpo()
2022-12-16 22:37:48.05 DEBUG 42679   [nio-8080-exec-5] c.d.dbsgapi.global.aop.LoggerAspect      : [Line:33 ]End => Controller : com.dbsgapi.dbsgapi.api.ipo.controller.IpoApiController.getIpoDetail()
2022-12-16 22:37:48.15 DEBUG 42679   [nio-8080-exec-5] o.s.w.s.m.m.a.HttpEntityMethodProcessor  : [Line:268]Using 'application/json', given [*/*] and supported [application/json, application/*+json, application/json, application/*+json]
2022-12-16 22:37:48.16 DEBUG 42679   [nio-8080-exec-5] o.s.w.s.m.m.a.HttpEntityMethodProcessor  : [Line:119]Writing [com.dbsgapi.dbsgapi.global.response.CustomResponse@4addb6fa]
bbbbbbbbbbbbbbbbbb스팩주
2022-12-16 22:37:48.20  INFO 42679   [nio-8080-exec-5] c.d.d.g.interceptor.LoggerInterceptor    : [Line:28 ]======================== END ========================
2022-12-16 22:37:48.21 DEBUG 42679   [nio-8080-exec-5] o.s.web.servlet.DispatcherServlet        : [Line:1131]Completed 200 OK
2022-12-16 22:37:48.21 DEBUG 42679   [nio-8080-exec-5] s.s.w.c.SecurityContextPersistenceFilter : [Line:118]Cleared SecurityContextHolder to complete request
2022-12-16 22:38:02.297 DEBUG 42679   [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : [Line:421]HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0)
2022-12-16 22:38:02.299 DEBUG 42679   [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : [Line:518]HikariPool-1 - Fill pool skipped, pool is at sufficient level.

@chhs2131 chhs2131 mentioned this issue Dec 17, 2022
Merged
chhs2131 added a commit that referenced this issue Dec 17, 2022
@chhs2131
Merge pull request #73 from chhs2131/refactor/#72
3755ca3 
Refactor/#72 - Enum 적용 (stockKinds, stockExchange)
@chhs2131 chhs2131 mentioned this issue Dec 28, 2022
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
refactor 로직 수정을 통한 개선 진행 (입출력에 변화 X)
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Refactor/#72 - Enum 적용 (stockKinds, stockExchange) chhs2131/dbsgAPI
1 participant
@chhs2131