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>