<?php

require_once(dirname(__FILE__).'/common.php');
Prado::using('System.Data.SqlMap.TSqlMapManager');

/**
 * @package System.Data.SqlMap
 */
class BaseCase extends PHPUnit_Framework_TestCase
{
	protected $sqlmap;
	protected $connection;
	private $mapper;
	private $config;
	protected $ScriptDirectory;

	public function testCase1()
	{
		$this->assertTrue(true);
	}

	public function testCase2()
	{
		$this->assertTrue(true);
	}

	public function __construct()
	{
		parent::__construct();
		$this->config = BaseTestConfig::createConfigInstance();
		$this->ScriptDirectory = $this->config->getScriptDir();
	}

	public function hasSupportFor($feature)
	{
		return $this->config->hasFeature($feature);
	}

	public function __destruct()
	{
		if(!is_null($this->mapper))
			$this->mapper->cacheConfiguration();
	}

	function getConnection()
	{
		if(is_null($this->connection))
			$this->connection = $this->config->getConnection();
		$this->connection->setActive(true);
		return $this->connection;
	}

	/**
	 * Initialize an sqlMap
	 */
	protected function initSqlMap()
	{
		$manager = new TSqlMapManager($this->config->getConnection());
		$manager->configureXml($this->config->getSqlMapConfigFile());
		$this->sqlmap = $manager->getSqlMapGateway();
		$manager->TypeHandlers->registerTypeHandler(new TDateTimeHandler);
	}

	/**
	 * Run a sql batch for the datasource.
	 */
	protected function initScript($script)
	{
		$runner = $this->config->getScriptRunner();
		$runner->runScript($this->getConnection(), $this->ScriptDirectory.$script);
	}

	/**
	 * Create a new account with id = 6
	 */
	protected function NewAccount6()
	{
		$account = new Account();
		$account->setID(6);
		$account->setFirstName('Calamity');
		$account->setLastName('Jane');
		$account->setEmailAddress('no_email@provided.com');
		return $account;
	}

	/**
	 * Verify that the input account is equal to the account(id=1).
	 */
	protected function assertAccount1(Account $account)
	{
		$this->assertSame($account->getID(), 1);
		$this->assertSame($account->getFirstName(), 'Joe');
		$this->assertSame($account->getEmailAddress(), 'Joe.Dalton@somewhere.com');
	}

	/**
	 * Verify that the input account is equal to the account(id=6).
	 */
	protected function assertAccount6(Account $account)
	{
		$this->assertSame($account->getID(), 6);
		$this->assertSame($account->getFirstName(), 'Calamity');
		$this->assertSame($account->getLastName(), 'Jane');
		$this->assertNull($account->getEmailAddress());
	}

	/**
	 * Verify that the input order is equal to the order(id=1).
	 */
	protected function assertOrder1(Order $order)
	{
		$date = @mktime(8,15,0,2,15,2003);

		$this->assertSame((int)$order->getID(), 1);
		if($order->getDate() instanceof TDateTime)
			$this->assertSame($order->getDate()->getTimestamp(), $date);
		else
			$this->fail();
		$this->assertSame($order->getCardType(), 'VISA');
		$this->assertSame($order->getCardNumber(), '999999999999');
		$this->assertSame($order->getCardExpiry(), '05/03');
		$this->assertSame($order->getStreet(), '11 This Street');
		$this->assertSame($order->getProvince(), 'BC');
		$this->assertSame($order->getPostalCode(), 'C4B 4F4');
	}

	function assertAccount1AsHashArray($account)
	{
		$this->assertSame(1, (int)$account["Id"]);
		$this->assertSame("Joe", $account["FirstName"]);
		$this->assertSame("Dalton", $account["LastName"]);
		$this->assertSame("Joe.Dalton@somewhere.com", $account["EmailAddress"]);
	}

	function AssertOrder1AsHashArray($order)
	{
		$date = @mktime(8,15,0,2,15,2003);

		$this->assertSame(1, $order["Id"]);
		if($order['Date'] instanceof TDateTime)
			$this->assertSame($date, $order["Date"]->getTimestamp());
		else
			$this->fail();
		$this->assertSame("VISA", $order["CardType"]);
		$this->assertSame("999999999999", $order["CardNumber"]);
		$this->assertSame("05/03", $order["CardExpiry"]);
		$this->assertSame("11 This Street", $order["Street"]);
		$this->assertSame("Victoria", $order["City"]);
		$this->assertSame("BC", $order["Province"]);
		$this->assertSame("C4B 4F4", $order["PostalCode"]);
	}

}

class HundredsBool extends TSqlMapTypeHandler
{
	public function getResult($string)
	{
		$value = intval($string);
		if($value == 100)
			return true;
		if($value == 200)
			return false;
		//throw new Exception('unexpected value '.$value);
	}

	public function getParameter($parameter)
	{
		if($parameter)
			return 100;
		else
			return 200;
	}

	public function createNewInstance($data=null)
	{
		throw new TDataMapperException('can not create');
	}
}

class OuiNonBool extends TSqlMapTypeHandler
{
	const YES = "Oui";
	const NO = "Non";

	public function getResult($string)
	{
		if($string === self::YES)
			return true;
		if($string === self::NO)
			return false;
		//throw new Exception('unexpected value '.$string);
	}

	public function getParameter($parameter)
	{
		if($parameter)
			return self::YES;
		else
			return self::NO;
	}

	public function createNewInstance($data=null)
	{
		throw new TDataMapperException('can not create');
	}
}

class TDateTimeHandler extends TSqlMapTypeHandler
{
	public function getType()
	{
		return 'date';
	}

	public function getResult($string)
	{
		$time = new TDateTime($string);
		return $time;
	}

	public function getParameter($parameter)
	{
		if($parameter instanceof TDateTime)
			return $parameter->getTimestamp();
		else
			return $parameter;
	}

	public function createNewInstance($data=null)
	{
		return new TDateTime;
	}
}

class TDateTime
{
	private $_datetime;

	public function __construct($datetime=null)
	{
		if(!is_null($datetime))
			$this->setDatetime($datetime);
	}

	public function getTimestamp()
	{
		return strtotime($this->getDatetime());
	}

	public function getDateTime()
	{
		return $this->_datetime;
	}

	public function setDateTime($value)
	{
		$this->_datetime = $value;
	}
}