/*
 * Generated by haxORMap
 */

import data.model.Error;

class Clients<E> extends data.model.Haxormanager<Client, E>
{
	public static var instance : Dynamic;
	private function init() { TABLE = "client"; if(instance == null) instance = this; }
	private static var _cache = new Hash<Client>();
	
	public function _new(?resultObj : Dynamic, ?pre : String) : Client {
		if(pre == null) pre = '';
		var o = Type.createEmptyInstance(Client);
		return o;
	}
	
	public function _object(resultObj : Dynamic, ?pre : String) : Client
	{
		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.address = Reflect.field(resultObj, pre+"address");
		o.name = Reflect.field(resultObj, pre+"name");
		return o;
	}
	
	private function _cacheKey(obj : Dynamic, pre : String) : String {
		var k = new StringBuf();
		k.add('#'); k.add(Reflect.field(pre+"id", obj));
		return k.toString();
	}
	
	// -- No return values -- //
	public function insert(obj : Client) : Void {
		request(engine().insert(cnx,obj,null));
	}
	public function delete(obj : Client) : Void {
		request(engine().delete(cnx,obj,null));
	}
	public function update(obj : Client) : Void {
		request(engine().update(cnx,obj,null));
	}
	public function save(obj : Client) : Void {
		request(engine().save(cnx,obj,null));
	}
	
	// -- Return single object -- //
	public function get(id:Int) : Client {
		return _object( request(engine().get(cnx,{id:id},null)).next() );
	}
	public function row(id:Int) : Client {
		return _object( request(engine().row(cnx,{id:id},null)).next() );
	}
	
	// -- Return List of objects -- //
	public function select(id:Int, ?where : String) : List<Client> {
		return objectList( request(engine().select(cnx,{id:id},where)) );
	}
	public function search(id:Int, ?where : String) : List<Client> {
		return objectList( request(engine().search(cnx,{id:id},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 `client` VALUES (');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(',');
			s.add(if(v.address == null) "NULL" else cnx.quote(v.address));
			s.add(',');
			s.add(if(v.name == null) "NULL" else cnx.quote(v.name));
			s.add(')');
			return s;
		},
		
		delete : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('DELETE `client` ');
			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);
			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 `client` SET id=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(', address=');
			s.add(if(v.address == null) "NULL" else cnx.quote(v.address));
			s.add(', name=');
			s.add(if(v.name == null) "NULL" else cnx.quote(v.name));
			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);
			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 `client` SET address=');
			s.add(if(v.address == null) "NULL" else cnx.quote(v.address));
			s.add(', name=');
			s.add(if(v.name == null) "NULL" else cnx.quote(v.name));
			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);
			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 `c`.`id`, `c`.`address`, `c`.`name` FROM `client` AS `c` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.id != null){
			s.add('`c`.`id`=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.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 `c`.`id`, `c`.`address`, `c`.`name` FROM `client` AS `c` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.id != null){
			s.add('`c`.`id` LIKE "%');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.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 `c`.`id`, `c`.`address`, `c`.`name` FROM `client` AS `c` ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE `c`.`id`=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.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 `client` ');
			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);
			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 "client" VALUES (');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(',');
			s.add(if(v.address == null) "NULL" else cnx.quote(v.address));
			s.add(',');
			s.add(if(v.name == null) "NULL" else cnx.quote(v.name));
			s.add(')');
			return s;
		},
		
		delete : function (cnx, v : Dynamic, where : String) : StringBuf
		{
			var s = new StringBuf();
			s.add('DELETE "client" ');
			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);
			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 "client" SET id=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.id);
			s.add(', address=');
			s.add(if(v.address == null) "NULL" else cnx.quote(v.address));
			s.add(', name=');
			s.add(if(v.name == null) "NULL" else cnx.quote(v.name));
			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);
			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 "client" SET address=');
			s.add(if(v.address == null) "NULL" else cnx.quote(v.address));
			s.add(', name=');
			s.add(if(v.name == null) "NULL" else cnx.quote(v.name));
			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);
			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 "c"."id", "c"."address", "c"."name" FROM "client" AS "c" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.id != null){
			s.add('"c"."id"=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.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 "c"."id", "c"."address", "c"."name" FROM "client" AS "c" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE ');
		if(v.id != null){
			s.add('"c"."id" LIKE "%');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.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 "c"."id", "c"."address", "c"."name" FROM "client" AS "c" ');
			var q=s.toString(); s=new StringBuf(); s.add('WHERE "c"."id"=');
			s.add(if(v.id == null) throw NullValue(v, "id", "id") else v.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 "client" ');
			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);
			var w=s.toString(); s=new StringBuf(); s.add(q); if(w.length > 10) s.add(w); s.add(' LIMIT 1');
			return s;
		},
		
	}
}