/*
 * Generated by haxORMap
 */

import data.model.Error;

class Orderlines<E> extends data.model.Haxormanager<Orderline, E>
{
	public static var instance : Dynamic;
	private function init() { TABLE = "orderline"; if(instance == null) instance = this; }
	private static var _cache = new Hash<Orderline>();
	
	public function _new(?resultObj : Dynamic, ?pre : String) : Orderline {
		if(pre == null) pre = '';
		var o = Type.createEmptyInstance(Orderline);
		Reflect.setField(o, "order", Orders.instance._object(resultObj, pre+'_o_'));
		return o;
	}
	
	public function _object(resultObj : Dynamic, ?pre : String) : Orderline
	{
		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.id = Reflect.field(resultObj, pre+"id");
		o.number = Reflect.field(resultObj, pre+"number");
		o.product = Reflect.field(resultObj, pre+"product");
		return o;
	}
	
	private function _cacheKey(obj : Dynamic, pre : String) : String {
		var k = new StringBuf();
		k.add('#'); k.add(Reflect.field(pre+"id", 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 : Orderline) : Void {
		request(engine().insert(cnx,obj,null));
	}
	public function delete(obj : Orderline) : Void {
		request(engine().delete(cnx,obj,null));
	}
	public function update(obj : Orderline) : Void {
		request(engine().update(cnx,obj,null));
	}
	public function save(obj : Orderline) : Void {
		request(engine().save(cnx,obj,null));
	}
	
	// -- Return single object -- //
	public function get(id:Int, orderId:Int, orderClientId:Int) : Orderline {
		return _object( request(engine().get(cnx,{id:id, order:{id:orderId, client:{id:orderClientId}}},null)).next() );
	}
	public function row(id:Int, orderId:Int, orderClientId:Int) : Orderline {
		return _object( request(engine().row(cnx,{id:id, order:{id:orderId, client:{id:orderClientId}}},null)).next() );
	}
	
	// -- Return List of objects -- //
	public function select(id:Int, orderId:Int, orderClientId:Int, ?where : String) : List<Orderline> {
		return objectList( request(engine().select(cnx,{id:id, order:{id:orderId, client:{id:orderClientId}}},where)) );
	}
	public function search(id:Int, orderId:Int, orderClientId:Int, ?where : String) : List<Orderline> {
		return objectList( request(engine().search(cnx,{id:id, order:{id:orderId, client:{id:orderClientId}}},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 `orderline` VALUES (');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(',');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(',');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.order.client.id);
			s.add(',');
			s.add(if(v.number == null) "NULL" else v.number);
			s.add(',');
			s.add(if(v.product == null) "NULL" else cnx.quote(v.product));
			s.add(')');
			return s;
		},
		
		delete : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('DELETE `orderline` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE `id`=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND `orderid`=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND `clientid`=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 `orderline` SET id=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(', orderid=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(', clientid=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.order.client.id);
			s.add(', number=');
			s.add(if(v.number == null) "NULL" else v.number);
			s.add(', product=');
			s.add(if(v.product == null) "NULL" else cnx.quote(v.product));
			s.add(' ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE `id`=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND `orderid`=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND `clientid`=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 `orderline` SET number=');
			s.add(if(v.number == null) "NULL" else v.number);
			s.add(', product=');
			s.add(if(v.product == null) "NULL" else cnx.quote(v.product));
			s.add(' ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE `id`=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND `orderid`=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND `clientid`=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 `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` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.id != null){
			s.add('`or`.`id`=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND');
		}
			s.add(' ');
		if(v.order.id != null){
			s.add('`o`.`orderid`=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND');
		}
			s.add(' ');
		if(v.order.client.id != null){
			s.add('`c`.`clientid`=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 `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` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.id != null){
			s.add('`or`.`id` LIKE "%');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add('%" AND');
		}
			s.add(' ');
		if(v.order.id != null){
			s.add('`o`.`orderid` LIKE "%');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add('%" AND');
		}
			s.add(' ');
		if(v.order.client.id != null){
			s.add('`c`.`clientid` LIKE "%');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 `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` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE `or`.`id`=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND `o`.`orderid`=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND `o`.`clientid`=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 `orderline` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE `id`=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND `orderid`=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND `clientid`=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 "orderline" VALUES (');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(',');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(',');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.order.client.id);
			s.add(',');
			s.add(if(v.number == null) "NULL" else v.number);
			s.add(',');
			s.add(if(v.product == null) "NULL" else cnx.quote(v.product));
			s.add(')');
			return s;
		},
		
		delete : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('DELETE "orderline" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE "id"=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND "orderid"=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND "clientid"=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 "orderline" SET id=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(', orderid=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(', clientid=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.order.client.id);
			s.add(', number=');
			s.add(if(v.number == null) "NULL" else v.number);
			s.add(', product=');
			s.add(if(v.product == null) "NULL" else cnx.quote(v.product));
			s.add(' ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE "id"=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND "orderid"=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND "clientid"=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 "orderline" SET number=');
			s.add(if(v.number == null) "NULL" else v.number);
			s.add(', product=');
			s.add(if(v.product == null) "NULL" else cnx.quote(v.product));
			s.add(' ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE "id"=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND "orderid"=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND "clientid"=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 "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" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.id != null){
			s.add('"or"."id"=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND');
		}
			s.add(' ');
		if(v.order.id != null){
			s.add('"o"."orderid"=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND');
		}
			s.add(' ');
		if(v.order.client.id != null){
			s.add('"c"."clientid"=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 "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" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.id != null){
			s.add('"or"."id" LIKE "%');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add('%" AND');
		}
			s.add(' ');
		if(v.order.id != null){
			s.add('"o"."orderid" LIKE "%');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add('%" AND');
		}
			s.add(' ');
		if(v.order.client.id != null){
			s.add('"c"."clientid" LIKE "%');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 "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" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE "or"."id"=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND "o"."orderid"=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND "o"."clientid"=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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 "orderline" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE "id"=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(' AND "orderid"=');
			s.add(if(v.order.id == null) throw NullValue(v.order, "id", "order.id") else v.order.id);
			s.add(' AND "clientid"=');
			s.add(if(v.order.client.id == null) throw NullValue(v.order.client, "id", "order.client.id") else v.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;
		},
		
	}
}