<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
    "/WEB-INF/dtd/sql-map-2.dtd">

<sqlMap namespace="Photo">
<typeAlias alias="photo" type="com.vodacar.repository.domain.AutoPhoto"/>
<resultMap id="PhotoResult" class="com.vodacar.repository.domain.AutoPhoto">
<result property="id" column="ID" nullValue="-9999999999" />
<result property="title" column="TITLE"/>
<result property="photoUrl" column="PHOTO_URL"/>
<result property="adjustedPhotoUrl" column="ADJUSTED_PHOTO_URL"/>
<result property="brandId" column="BRAND_ID" nullValue="-9999999999" />
<result property="status" column="STATUS" nullValue="-9999999999" />
<result property="createBy" column="CREATE_BY"/>
<result property="createDate" column="CREATE_DATE"/>
<result property="updateBy" column="UPDATE_BY"/>
<result property="updateDate" column="UPDATE_DATE"/>
</resultMap>
<select id="retrievePhoto" resultMap="PhotoResult" parameterClass="long">
select "ID", "BRAND_ID", "TITLE", "PHOTO_URL","ADJUSTED_PHOTO_URL","STATUS", "CREATE_BY", 
    "CREATE_DATE", "UPDATE_BY", "UPDATE_DATE"
  from "DB2ADMIN"."AUTOWIKI_PHOTO"
	WHERE "ID"=#id#
</select>

<update id="updatePhoto" parameterClass="photo">
UPDATE "DB2ADMIN"."AUTOWIKI_PHOTO" SET 
	"ID" = #id# ,
	"TITLE"=#title#, 
	"PHOTO_URL"=#photoUrl#, 
	"ADJUSTED_PHOTO_URL"=#adjustedPhotoUrl#,
	"BRAND_ID"=#brandId#, 
	"STATUS"=#status#,
	"CREATE_BY"=#createBy#, 
    "CREATE_DATE"=<isNotNull property="createDate">#createDate#</isNotNull><isNull property="createDate">NULL</isNull>, 
    "UPDATE_BY"=#updateBy#, 
    "UPDATE_DATE"=<isNotNull property="updateDate">#updateDate#</isNotNull><isNull property="updateDate">NULL</isNull>
 WHERE ID=#id#
	
</update>
<insert id="insertPhoto" parameterClass="photo">
 INSERT INTO "DB2ADMIN"."AUTOWIKI_PHOTO" 
      (	"TITLE", "PHOTO_URL", "ADJUSTED_PHOTO_URL","BRAND_ID","STATUS", "CREATE_BY", 
    "CREATE_DATE", "UPDATE_BY", "UPDATE_DATE"  )
    VALUES
      ( <isNotNull property="title">#title#</isNotNull><isNull property="title">NULL</isNull>,  
	    <isNotNull property="photoUrl">#photoUrl#</isNotNull><isNull property="photoUrl">NULL</isNull>,  
	    <isNotNull property="adjustedPhotoUrl">#adjustedPhotoUrl#</isNotNull><isNull property="adjustedPhotoUrl">NULL</isNull>, 
	   #brandId#, 
	   #status#,
	   <isNotNull property="createBy">#createBy#</isNotNull><isNull property="createBy">NULL</isNull>,  
       <isNotNull property="createDate">#createDate#</isNotNull><isNull property="createDate">NULL</isNull>,  
       <isNotNull property="updateBy">#updateBy#</isNotNull><isNull property="updateBy">NULL</isNull>,  
       <isNotNull property="updateDate">#updateDate#</isNotNull><isNull property="updateDate">NULL</isNull>)
<selectKey resultClass="java.lang.Long" keyProperty="id">values IDENTITY_VAL_LOCAL()</selectKey>
</insert>
<delete  id="deletePhoto" parameterClass="long">
DELETE FROM  "DB2ADMIN"."AUTOWIKI_PHOTO" 
WHERE "ID"= #id#
</delete>
<!-- 鏍規(guī)嵁杈撳叆鏉′歡鏌ヨ