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