[Project] User-Seller-Product 연관관계 JUnit Test 전략

sung eon·2023년 2월 18일
0

순서

  • 멤버십 등록 >
  • 회원가입 >
  • 등록된 회원 한명을 찾아 셀러등록 >
  • 등록된셀러 중 한명을 찾아 상품 등록 >
  • 등록된 상품 하나를 찾아 주문
    (주문정보,주문상세,배송정보 같이 등록되어야함) >
  • 주문된 상품중 하나 리뷰 > 그 리뷰를 베스트 리뷰로 등록
  1. Membership dummy date Insert
INSERT INTO membership(membership_num, membership_level)
VALUES(1, '브론즈');
INSERT INTO membership(membership_num, membership_level)
VALUES(2, '실버');
INSERT INTO membership(membership_num, membership_level)
VALUES(3, '골드');
INSERT INTO membership(membership_num, membership_level)
VALUES(4, '다이아몬드');
  1. 회원가입 테스트 메서드
  • User table Inserted data 확인
  • Point table Inserted data 확인
  1. Seller 등록 테스트 메서드
  • User table에 null값 안들어갔는지 확인
Hibernate: 
    select
        user0_.id as id1_11_0_,
        user0_.addr as addr2_11_0_,
        user0_.created_date as created_date3_11_0_,
        user0_.email as email4_11_0_,
        user0_.membership_num as membership_num10_11_0_,
        user0_.name as name5_11_0_,
        user0_.pwd as pwd6_11_0_,
        user0_.role as role7_11_0_,
        user0_.signout_date as signout_date8_11_0_,
        user0_.tel as tel9_11_0_,
        membership1_.membership_num as membership_num1_4_1_,
        membership1_.membership_level as membership_level2_4_1_,
        point2_.user_id as user_id1_7_2_,
        point2_.total_point as total_point2_7_2_,
        seller3_.seller_id as seller_id1_10_3_,
        seller3_.addr as addr2_10_3_,
        seller3_.company_name as company_name3_10_3_,
        seller3_.company_num as company_num4_10_3_,
        seller3_.follow_cnt as follow_cnt5_10_3_,
        seller3_.internet_num as internet_num6_10_3_,
        seller3_.manager as manager7_10_3_,
        seller3_.status as status8_10_3_ 
    from
        users user0_ 
    left outer join
        membership membership1_ 
            on user0_.membership_num=membership1_.membership_num 
    left outer join
        point point2_ 
            on user0_.id=point2_.user_id 
    left outer join
        seller_info seller3_ 
            on user0_.id=seller3_.seller_id 
    where
        user0_.id=?

  • null값 안들어가는거 확인
  • Seller table Inserted data 확인
  1. 상품 등록 테스트 메서드
  • Product table Inserted data 확인
select
        product0_.num as num1_8_0_,
        product0_.category as category2_8_0_,
        product0_.detail as detail3_8_0_,
        product0_.fee as fee4_8_0_,
        product0_.name as name5_8_0_,
        product0_.origin_price as origin_price6_8_0_,
        product0_.percentage as percentage7_8_0_,
        product0_.review_cnt as review_cnt8_8_0_,
        product0_.seller_id as seller_id12_8_0_,
        product0_.stars as stars9_8_0_,
        product0_.status as status10_8_0_,
        product0_.week as week11_8_0_ 
    from
        product product0_ 
    where
        product0_.num=?

  • 연관관계 table null 값 체크
    • OK
  1. 주문 테스트
  • Order table Inserted data 확인
    • OK
  • Order_detail table Inserted data 확인
    • OK
  • Delivery table Inserted data 확인
    • OK
  1. 리뷰 테스트
  • Review table Inserted data 확인
    • OK
  1. 베스트 리뷰 테스트
  • Best_review Inserted data 확인
    • OK
profile
코베베

0개의 댓글