장바구니 기능 (merge 사용) / 좋아요 기능 (exists 사용)

<insert id="insertCart" parameterType="map">
MERGE INTO CART
USING DUAL
ON (P_IDX = #{pIdx} AND USER_IDX=#{userIdx})
WHEN MATCHED THEN UPDATE SET QUANT = QUANT + 1
WHEN NOT MATCHED THEN INSERT (CART_IDX, USER_IDX, P_IDX, QUANT)
VALUES (CART_SEQ.NEXTVAL, #{userIdx}, #{pIdx}, 1)
</insert>

 

 

<insert id="likeInsert">
INSERT INTO LIKEHATE
SELECT LIKEHATE_SEQ.NEXTVAL
, 0
, #{reviewIdx}
, 0
FROM dual
WHERE NOT EXISTS (SELECT 1
FROM LIKEHATE
WHERE REVIEW_IDX = #{reviewIdx})
</insert>