<?php

require_once dirname(__FILE__).'/../phpunit2.php';

require_once(dirname(__FILE__).'/common.php');

/**
 * @package System.DataAccess
 */
class TAdodbConnectionTestCase extends PHPUnit2_Framework_TestCase
{
	protected $db_file;

	function setup()
	{
		$file = dirname(__FILE__).'/resources/data.db';
		$this->db_file = dirname(__FILE__).'/resources/test.db';
		copy($file,$this->db_file);
		$provider = new TAdodb();
	}

	function getDsn()
	{
		return 'sqlite://'.urlencode(realpath($this->db_file));
	}

	function testProviderCreation()
	{
		$provider = new TAdodb();
		$connection = $provider->getConnection();
		$this->assertTrue($connection instanceof TAdodbConnection);
		try
		{
			$connection->open();
			$this->fail();
		}
		catch (TDbConnectionException $e)
		{
			$this->pass();
		}
	}


	function testAdodbSqliteConnection()
	{
		$connection = new TAdodbConnection($this->getDsn());
		$this->assertTrue($connection->open());
	
		$statement = "insert into person(per_id, per_first_name,
			per_last_name, per_birth_date, per_weight_kg, per_height_m)
			values(?, ?, ?, ?, ?, ?)";
		$sql = $connection->prepare($statement);
		$connection->execute($sql, 
					array(2,'mini','me','2000-01-01', 50.5, 145.5));

		$statement = "select * from person";
		$results = $connection->execute($statement);
		$this->assertEquals($results->RecordCount(), 2);
	
	}
}

?>