<?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="Service">
<typeAlias alias="service" type="com.vodacar.repository.domain.Service" />

<resultMap id="ServiceResult" class="com.vodacar.repository.domain.Service">
	<result property="id" column="ID" />
		<result property="name" column="NAME" nullValue="" />
		<result property="introduced" column="INTRODUCED" nullValue="" />
		<result property="servicesIntroduced" column="SERVICESINTRODUCED" />
		<result property="creator" column="CREATOR" nullValue="" />
		<result property="makeId" column="MAKEID" nullValue="0" />
		<result property="area" column="AREA" nullValue="0" />
		<result property="classId" column="CLASSID" nullValue="0" />
		<result property="released" column="RELEASED"  nullValue="0" />
		<result property="pass" column="PASS" nullValue="4" />
		
	</resultMap>
<select id="retrieveService" resultMap="ServiceResult" parameterClass="long">
	select "ID", "NAME", "INTRODUCED", "SERVICESINTRODUCED", "CREATOR", "MAKEID", 
    "AREA", "CLASSID", "RELEASED", "PASS"
  from "DB2ADMIN"."AUTOWIKI_SERVICE" where "ID"=#id#
		</select>
		<select id="queryService" resultMap="ServiceResult">
	select "ID", "NAME", "INTRODUCED", "SERVICESINTRODUCED", "CREATOR", "MAKEID", 
    "AREA", "CLASSID", "RELEASED", "PASS"
  from "DB2ADMIN"."AUTOWIKI_SERVICE" 
  	<dynamic prepend=" where ">
  	<isNotNull prepend=" and " property="name">"NAME" = #name#</isNotNull>
			<isNotNull prepend=" and " property="introduced">"INTRODUCED" = #introduced#</isNotNull>
			<isNotNull prepend=" and " property="classId">"CLASSID" = #classId#</isNotNull>
			<isGreaterThan prepend=" and " property="area" compareValue="0">"AREA" = #area#</isGreaterThan>
			<isNotNull prepend=" and " property="makeId">"MAKEID" = #makeId#</isNotNull>
			<isNotNull prepend=" and " property="pass">"PASS" = #pass#</isNotNull>
			<isNotNull prepend=" and " property="creator">"CREATOR" = #creator#</isNotNull>
			
  	</dynamic>
		</select>
		
		<insert id="insertService" parameterClass="service">
		INSERT INTO "DB2ADMIN"."AUTOWIKI_SERVICE" 
		(  "NAME", "INTRODUCED", "SERVICESINTRODUCED", "CREATOR", "MAKEID", 
    "AREA", "CLASSID", "RELEASED", "PASS") VALUES 
    ( #name#, #introduced#, #servicesIntroduced#, #creator#, #makeId#,
		#area#, #classId#, #released#,#pass#)
	</insert>
	<select id="queryCountService" resultClass="int">
		select count(*) as count from "DB2ADMIN"."AUTOWIKI_SERVICE"
		<dynamic prepend=" where ">
			<isNotNull prepend=" and " property="introduced">"INTRODUCED" = #introduced#</isNotNull>
			<isNotNull prepend=" and " property="classId">"CLASSID" = #classId#</isNotNull>
			<isGreaterThan prepend=" and " property="area" compareValue="0">"AREA" = #area#</isGreaterThan>
			<isNotNull prepend=" and " property="makeId">"MAKEID" = #makeId#</isNotNull>
			<isNotNull prepend=" and " property="pass">"PASS" = #pass#</isNotNull>
		
		</dynamic>
		</select>
		<update id="updateService" parameterClass="service">
		UPDATE "DB2ADMIN"."AUTOWIKI_SERVICE" SET

		<isNotEmpty property="name">"NAME" = #name#, </isNotEmpty>
			<isNotEmpty property="introduced">"INTRODUCED" = #introduced#, </isNotEmpty>
		<isNotEmpty property="servicesIntroduced">"SERVICESINTRODUCED" = #servicesIntroduced#, </isNotEmpty>
		
		<isGreaterThan property="makeId" compareValue="0">"MAKEID" = #makeId#, </isGreaterThan>
		<isGreaterThan property="area" compareValue="0">"AREA" = #area#,  </isGreaterThan>
		<isNotEmpty property="creator">"CREATOR" = #creator#, </isNotEmpty>
		<isNotEmpty property="released">"RELEASED" =#released#, </isNotEmpty>
		<isGreaterThan property="classId" compareValue="0">"CLASSID" = #classId#,  </isGreaterThan>
		<isGreaterThan property="pass" compareValue="0">"PASS" = #pass# , </isGreaterThan>
		"ID" = #id#
		WHERE ID=#id#
	</update>
</sqlMap>