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.AddressMapper">
<resultMap type="address" id="addressResult">
                <id property="id" column="id"/>
        </resultMap>

<insert id="addAddressForUser" parameterType="address" useGeneratedKeys="true" keyProperty="id">
    INSERT INTO address
      (line_1, line_2, landmark, city, country, enabled, state, pin, type, added_on, name, phone,user_id)
    VALUES
      (#{line_1}, #{line_2}, #{landmark}, #{city}, #{country}, #{enabled}, #{state}, #{pin},
       #{type}, #{added_on}, #{name}, #{phone}, #{user_id})
  </insert>
        
<select id="getAddress" parameterType="long" resultType="address">
    SELECT *
    FROM address
    <where>
        id = #{addressId}
        </where>
</select>

<update id="disableAddress" parameterType="long">
        UPDATE address
        SET enabled = 0
        <where>
                id = #{addressId}
        </where>
</update>

<select id="getPincodeForAddress" parameterType="long" resultType="String">
    SELECT pin
    FROM address
    <where>
        id = #{id}
        </where>
</select>

<select id="getAllAddressesForUser" parameterType="long" resultType="address">
    SELECT *
    FROM address
    <where>
        user_id = #{userId}
        AND enabled = 1
        </where>
</select>

</mapper>