/*
 * Generated by haxORMap
 */

import data.model.Error;

class OrderlineDeliveries<E> extends data.model.Haxormanager<OrderlineDelivery, E>
{
	public static var instance : Dynamic;
	private function init() { TABLE = "orderdelivery"; if(instance == null) instance = this; }
	private static var _cache = new Hash<OrderlineDelivery>();
	
	public function _new(?resultObj : Dynamic, ?pre : String) : OrderlineDelivery {
		if(pre == null) pre = '';
		var o = Type.createEmptyInstance(OrderlineDelivery);
		Reflect.setField(o, "orderline", Orderlines.instance._object(resultObj, pre+'_or_'));
		return o;
	}
	
	public function _object(resultObj : Dynamic, ?pre : String) : OrderlineDelivery
	{
		if(resultObj == null) throw '_object() called on empty Resultset'; //return null();
		if(pre == null) pre = '';
		var key = _cacheKey(resultObj, pre);
		var o : Dynamic = if(_cache.exists(key)) _cache.get(key); else _new(resultObj, pre);
		
		o.address = Reflect.field(resultObj, pre+"address");
		o.amount = Reflect.field(resultObj, pre+"amount");
		return o;
	}
	
	private function _cacheKey(obj : Dynamic, pre : String) : String {
		var k = new StringBuf();
		k.add('#'); k.add(Reflect.field(pre+"address", obj));
		k.add('#'); k.add(Reflect.field(pre+"lineid", obj));
		k.add('#'); k.add(Reflect.field(pre+"orderid", obj));
		k.add('#'); k.add(Reflect.field(pre+"clientid", obj));
		return k.toString();
	}
	
	// -- No return values -- //
	public function insert(obj : OrderlineDelivery) : Void {
		request(engine().insert(cnx,obj,null));
	}
	public function delete(obj : OrderlineDelivery) : Void {
		request(engine().delete(cnx,obj,null));
	}
	public function update(obj : OrderlineDelivery) : Void {
		request(engine().update(cnx,obj,null));
	}
	public function save(obj : OrderlineDelivery) : Void {
		request(engine().save(cnx,obj,null));
	}
	
	// -- Return single object -- //
	public function get(address:String, orderlineId:Int, orderlineOrderId:Int, orderlineOrderClientId:Int) : OrderlineDelivery {
		return _object( request(engine().get(cnx,{address:address, orderline:{id:orderlineId, order:{id:orderlineOrderId, client:{id:orderlineOrderClientId}}}},null)).next() );
	}
	public function row(address:String, orderlineId:Int, orderlineOrderId:Int, orderlineOrderClientId:Int) : OrderlineDelivery {
		return _object( request(engine().row(cnx,{address:address, orderline:{id:orderlineId, order:{id:orderlineOrderId, client:{id:orderlineOrderClientId}}}},null)).next() );
	}
	
	// -- Return List of objects -- //
	public function select(address:String, orderlineId:Int, orderlineOrderId:Int, orderlineOrderClientId:Int, ?where : String) : List<OrderlineDelivery> {
		return objectList( request(engine().select(cnx,{address:address, orderline:{id:orderlineId, order:{id:orderlineOrderId, client:{id:orderlineOrderClientId}}}},where)) );
	}
	public function search(address:String, orderlineId:Int, orderlineOrderId:Int, orderlineOrderClientId:Int, ?where : String) : List<OrderlineDelivery> {
		return objectList( request(engine().search(cnx,{address:address, orderline:{id:orderlineId, order:{id:orderlineOrderId, client:{id:orderlineOrderClientId}}}},where)) );
	}
	
	// --- DBMS abstraction --- //
	
	private function MySQLEngine(){ queryEngine = MySQLQueries; }
	private function SQLiteEngine(){ queryEngine = SQLiteQueries; }

	
	private static var MySQLQueries = {
		
		insert : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('INSERT `orderdelivery` VALUES (');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(',');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(',');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(',');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			s.add(',');
			s.add(if(v.amount == null) throw NullValue(v, "amount", "amount") else v.amount);
			s.add(')');
			return s;
		},
		
		delete : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('DELETE `orderdelivery` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE `address`=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND `lineid`=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND `orderid`=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND `clientid`=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); 
			return s;
		},
		
		update : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('UPDATE `orderdelivery` SET address=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(', lineid=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(', orderid=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(', clientid=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			s.add(', amount=');
			s.add(if(v.amount == null) throw NullValue(v, "amount", "amount") else v.amount);
			s.add(' ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE `address`=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND `lineid`=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND `orderid`=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND `clientid`=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); 
			return s;
		},
		
		save : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('UPDATE `orderdelivery` SET amount=');
			s.add(if(v.amount == null) throw NullValue(v, "amount", "amount") else v.amount);
			s.add(' ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE `address`=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND `lineid`=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND `orderid`=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND `clientid`=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); 
			return s;
		},
		
		select : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('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` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.address != null){
			s.add('`d`.`address`=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND');
		}
			s.add(' ');
		if(v.orderline.id != null){
			s.add('`or`.`lineid`=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND');
		}
			s.add(' ');
		if(v.orderline.order.id != null){
			s.add('`o`.`orderid`=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND');
		}
			s.add(' ');
		if(v.orderline.order.client.id != null){
			s.add('`c`.`clientid`=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			
		}
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); 
			return s;
		},
		
		search : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('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` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.address != null){
			s.add('`d`.`address` LIKE "%');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add('%" AND');
		}
			s.add(' ');
		if(v.orderline.id != null){
			s.add('`or`.`lineid` LIKE "%');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add('%" AND');
		}
			s.add(' ');
		if(v.orderline.order.id != null){
			s.add('`o`.`orderid` LIKE "%');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add('%" AND');
		}
			s.add(' ');
		if(v.orderline.order.client.id != null){
			s.add('`c`.`clientid` LIKE "%');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			s.add('%"');
		}
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); 
			return s;
		},
		
		get : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('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` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE `d`.`address`=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND `or`.`lineid`=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND `or`.`orderid`=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND `or`.`clientid`=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); s.add(' LIMIT 1');
			return s;
		},
		
		row : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('SELECT * FROM `orderdelivery` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE `address`=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND `lineid`=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND `orderid`=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND `clientid`=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); s.add(' LIMIT 1');
			return s;
		},
		
	}
	private static var SQLiteQueries = {
		
		insert : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('INSERT "orderdelivery" VALUES (');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(',');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(',');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(',');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			s.add(',');
			s.add(if(v.amount == null) throw NullValue(v, "amount", "amount") else v.amount);
			s.add(')');
			return s;
		},
		
		delete : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('DELETE "orderdelivery" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE "address"=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND "lineid"=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND "orderid"=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND "clientid"=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); 
			return s;
		},
		
		update : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('UPDATE "orderdelivery" SET address=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(', lineid=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(', orderid=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(', clientid=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			s.add(', amount=');
			s.add(if(v.amount == null) throw NullValue(v, "amount", "amount") else v.amount);
			s.add(' ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE "address"=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND "lineid"=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND "orderid"=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND "clientid"=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); 
			return s;
		},
		
		save : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('UPDATE "orderdelivery" SET amount=');
			s.add(if(v.amount == null) throw NullValue(v, "amount", "amount") else v.amount);
			s.add(' ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE "address"=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND "lineid"=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND "orderid"=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND "clientid"=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); 
			return s;
		},
		
		select : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('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" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.address != null){
			s.add('"d"."address"=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND');
		}
			s.add(' ');
		if(v.orderline.id != null){
			s.add('"or"."lineid"=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND');
		}
			s.add(' ');
		if(v.orderline.order.id != null){
			s.add('"o"."orderid"=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND');
		}
			s.add(' ');
		if(v.orderline.order.client.id != null){
			s.add('"c"."clientid"=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			
		}
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); 
			return s;
		},
		
		search : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('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" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.address != null){
			s.add('"d"."address" LIKE "%');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add('%" AND');
		}
			s.add(' ');
		if(v.orderline.id != null){
			s.add('"or"."lineid" LIKE "%');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add('%" AND');
		}
			s.add(' ');
		if(v.orderline.order.id != null){
			s.add('"o"."orderid" LIKE "%');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add('%" AND');
		}
			s.add(' ');
		if(v.orderline.order.client.id != null){
			s.add('"c"."clientid" LIKE "%');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			s.add('%"');
		}
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); 
			return s;
		},
		
		get : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('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" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE "d"."address"=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND "or"."lineid"=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND "or"."orderid"=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND "or"."clientid"=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); s.add(' LIMIT 1');
			return s;
		},
		
		row : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('SELECT * FROM "orderdelivery" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE "address"=');
			s.add(if(v.address == null) throw NullValue(v, "address", "address") else cnx.quote(v.address));
			s.add(' AND "lineid"=');
			s.add(if(v.orderline.id == null) throw NullValue(v.orderline, "id", "orderline.id") else v.orderline.id);
			s.add(' AND "orderid"=');
			s.add(if(v.orderline.order.id == null) throw NullValue(v.orderline.order, "id", "orderline.order.id") else v.orderline.order.id);
			s.add(' AND "clientid"=');
			s.add(if(v.orderline.order.client.id == null) throw NullValue(v.orderline.order.client, "id", "orderline.order.client.id") else v.orderline.order.client.id);
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); s.add(' LIMIT 1');
			return s;
		},
		
	}
}