<?xml version="1.0" encoding="UTF-8"?>
<haxormap>
	<model class="OrderlineDelivery" manager="OrderlineDeliveries" alias="d" prefix="my">
		<primary>
			<address datatype="AString(255)" property="address" notNull="true"/>
			<lineid datatype="AInt(2097152,SIGNED,Int)" property="orderline" notNull="true"/>
			<orderid datatype="AInt(2097152,SIGNED,Int)" property="orderline" notNull="true"/>
			<clientid datatype="AInt(2097152,SIGNED,Int)" property="orderline" notNull="true"/>
		</primary>
		<fields>
			<amount datatype="AInt(8192,SIGNED,Int)" property="amount" notNull="true"/>
		</fields>
	</model>

	<exec methodName="insert"><![CDATA[
		INSERT `orderdelivery`
		VALUES (::address::,::orderline.id::,::orderline.order.id::,::orderline.order.client.id::,::amount::)
	]]></exec>

	<exec methodName="delete"><![CDATA[
		DELETE `orderdelivery`
		 WHERE `address`=::address:: AND `lineid`=::orderline.id:: AND `orderid`=::orderline.order.id:: AND `clientid`=::orderline.order.client.id::
	]]></exec>

	<exec methodName="update"><![CDATA[
		UPDATE `orderdelivery`
		   SET address=::address::, lineid=::orderline.id::, orderid=::orderline.order.id::, clientid=::orderline.order.client.id::, amount=::amount::
		 WHERE `address`=::address:: AND `lineid`=::orderline.id:: AND `orderid`=::orderline.order.id:: AND `clientid`=::orderline.order.client.id::
	]]></exec>

	<exec methodName="save"><![CDATA[
		UPDATE `orderdelivery`
		   SET amount=::amount::
		 WHERE `address`=::address:: AND `lineid`=::orderline.id:: AND `orderid`=::orderline.order.id:: AND `clientid`=::orderline.order.client.id::
	]]></exec>

	<set methodName="select"><![CDATA[
		SELECT `d`.`address`, `d`.`lineid` AS `_or_id`, `d`.`orderid` AS `_or__o_id`, `d`.`clientid` AS `_or__o__c_id`, `d`.`amount`, `or`.`number` AS `_or_number`, `or`.`product` AS `_or_product`
		  FROM `orderdelivery` AS `d`
		  LEFT JOIN `orderline` AS `or` ON `d`.`lineid`=`or`.`id` AND `d`.`orderid`=`or`.`orderid` AND `d`.`clientid`=`or`.`clientid`
		 WHERE $$o(`d`.`address`=::address:: AND) $$o(`or`.`lineid`=::orderline.id:: AND) $$o(`o`.`orderid`=::orderline.order.id:: AND) $$o(`c`.`clientid`=::orderline.order.client.id::)
	]]></set>

	<set methodName="search"><![CDATA[
		SELECT `d`.`address`, `d`.`lineid` AS `_or_id`, `d`.`orderid` AS `_or__o_id`, `d`.`clientid` AS `_or__o__c_id`, `d`.`amount`, `or`.`number` AS `_or_number`, `or`.`product` AS `_or_product`
		  FROM `orderdelivery` AS `d`
		  LEFT JOIN `orderline` AS `or` ON `d`.`lineid`=`or`.`id` AND `d`.`orderid`=`or`.`orderid` AND `d`.`clientid`=`or`.`clientid`
		 WHERE $$o(`d`.`address` LIKE "%::address::%" AND) $$o(`or`.`lineid` LIKE "%::orderline.id::%" AND) $$o(`o`.`orderid` LIKE "%::orderline.order.id::%" AND) $$o(`c`.`clientid` LIKE "%::orderline.order.client.id::%")
	]]></set>

	<row methodName="get"><![CDATA[
		SELECT `d`.`address`, `d`.`lineid` AS `_or_id`, `d`.`orderid` AS `_or__o_id`, `d`.`clientid` AS `_or__o__c_id`, `d`.`amount`, `or`.`number` AS `_or_number`, `or`.`product` AS `_or_product`
		  FROM `orderdelivery` AS `d`
		  LEFT JOIN `orderline` AS `or` ON `d`.`lineid`=`or`.`id` AND `d`.`orderid`=`or`.`orderid` AND `d`.`clientid`=`or`.`clientid`
		 WHERE `d`.`address`=::address:: AND `or`.`lineid`=::orderline.id:: AND `or`.`orderid`=::orderline.order.id:: AND `or`.`clientid`=::orderline.order.client.id::
		 LIMIT 1
	]]></row>

	<row methodName="row"><![CDATA[
		SELECT *
		  FROM `orderdelivery`
		 WHERE `address`=::address:: AND `lineid`=::orderline.id:: AND `orderid`=::orderline.order.id:: AND `clientid`=::orderline.order.client.id::
		 LIMIT 1
	]]></row>



	<!-- ------------ REMOVED QUERIES ------------ -->
</haxormap>