diff options
Diffstat (limited to 'tests/unit/SQLMap/TAdodbConnectionTestCase.php')
| -rw-r--r-- | tests/unit/SQLMap/TAdodbConnectionTestCase.php | 126 | 
1 files changed, 63 insertions, 63 deletions
| diff --git a/tests/unit/SQLMap/TAdodbConnectionTestCase.php b/tests/unit/SQLMap/TAdodbConnectionTestCase.php index 1ba0ec04..7d566386 100644 --- a/tests/unit/SQLMap/TAdodbConnectionTestCase.php +++ b/tests/unit/SQLMap/TAdodbConnectionTestCase.php @@ -1,64 +1,64 @@ -<?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);
 -	
 -	}
 -}
 -
 +<?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); +	 +	} +} +  ?>
\ No newline at end of file | 
