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.AffiliateMapper">

<resultMap type="masteraffiliate" id="masteraffiliateResult">

		<id property="id" column="id"/>

</resultMap>

<resultMap type="affiliate" id="affiliateResult">

		<id property="id" column="id"/>

</resultMap>

<select id="getAffiliateById" parameterType="long" resultType="affiliate">

    SELECT *

    FROM affiliate

    <where>

        id = #{id}

	</where>

</select>

<select id="getAffiliateByName" parameterType="String" resultType="affiliate">

    SELECT *

    FROM affiliate

    <where>

        name = #{name}

	</where>

</select>

<select id="getAffiliatesByMasterAffiliate" parameterType="String" resultType="affiliate">

    SELECT *

    FROM affiliate

    <where>

        master_affiliate_id = #{masterAffiliateId}

	</where>

</select>

<select id="getMasterAffiliateById" parameterType="long" resultType="masteraffiliate">

    SELECT *

    FROM masteraffiliate

    <where>

        id = #{id}

	</where>

</select>

<select id="getMasterAffiliateByName" parameterType="String" resultType="masteraffiliate">

    SELECT *

    FROM masteraffiliate

    <where>

        name = #{name}

	</where>

</select>

<select id="getAllMasterAffiliates" resultType="masteraffiliate">

    SELECT *

    FROM masteraffiliate

</select>

<insert id="createMasterAffiliate" parameterType="masteraffiliate" useGeneratedKeys="true" keyProperty="id">

   INSERT INTO masteraffiliate

      (name, added_on)

    VALUES

      (#{name}, #{added_on})

</insert>

<insert id="createAffiliate" parameterType="affiliate" useGeneratedKeys="true" keyProperty="id">

   INSERT INTO affiliate

      (master_affiliate_id, name, url, added_on)

    VALUES

      (#{master_affiliate_id}, #{name}, #{url}, #{added_on})

</insert>

</mapper>