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

순서

• 멤버십 등록 >
• 회원가입 >
• 등록된 회원 한명을 찾아 셀러등록 >
• 등록된셀러 중 한명을 찾아 상품 등록 >
• 등록된 상품 하나를 찾아 주문
  (주문정보,주문상세,배송정보 같이 등록되어야함) >
• 주문된 상품중 하나 리뷰 > 그 리뷰를 베스트 리뷰로 등록

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, '다이아몬드');

2. 회원가입 테스트 메서드

• User table Inserted data 확인
  
• Point table Inserted data 확인
  

3. 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 확인
  

4. 상품 등록 테스트 메서드

• 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

5. 주문 테스트

• Order table Inserted data 확인
  • OK
• Order_detail table Inserted data 확인
  • OK
• Delivery table Inserted data 확인
  • OK

6. 리뷰 테스트

• Review table Inserted data 확인
  • OK

7. 베스트 리뷰 테스트

• Best_review Inserted data 확인
  • OK