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>