Subversion Repositories SmartDukaan

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="in.shop2020.user.persistence.MiscellaneousMapper">

<resultMap type="usernote" id="usernoteResult">
                <id property="id" column="id"/>
        </resultMap>

<insert id="insertUserNote" parameterType="usernote" useGeneratedKeys="true" keyProperty="id">
    INSERT INTO usercommunication
      (user_id, entity_id, slide, note)
    VALUES
      (#{user_id}, #{entity_id}, #{slide}, #{note})
</insert>

<update id="updateUserNote" parameterType="map">
        UPDATE usernote
        SET note=#{note},
        <where>
                user_id = #{user_id}
                AND entity_id = #{entity_id}
        </where>        
</update>

<select id="getUserNotes" parameterType="map" resultType="usernote">
        SELECT *
        FROM usernote
        <where>
                user_id = #{user_id}
                AND entity_id = #{entity_id}
        </where>
</select>

</mapper>