Code: Select all
<?php
require_once LIBRARY .
'packages/database/connection.php';
class DatabaseConnectionTestCase extends UnitTestCase
{
private $connection;
public function __construct()
{
$this->connection = new DatabaseConnection;
}
public function testFailedConnectionReturnFalse()
{
$status = $this->connection->connect(
'localhost', 'erik', 'invalid password');
$this->assertIdentical($status, false);
}
public function testSuccessfulConnectionReturnTrue()
{
$status = $this->connection->connect(
'localhost', 'erik', 'valid password');
$this->assertIdentical($status, true);
}
public function testInvalidDatabaseReturnFalse()
{
$status = $this->connection->select('invalid');
$this->assertIdentical($status, false);
}
public function testValidDatabaseReturnTrue()
{
$status = $this->connection->select('testing');
$this->assertIdentical($status, true);
}
public function testCloseConnection()
{
$this->connection->disconnect();
$this->assertNull($this->connection->getResource());
}
}
?>Code: Select all
<?php
class DatabaseConnection
{
private $resource;
public function connect($host, $username, $password)
{
return ( ($this->resource =@ mysql_connect($host, $username, $password)) !== false );
}
public function select($database)
{
return ( @ mysql_select_db($database, $this->resource) !== false );
}
public function disconnect()
{
@ mysql_close($this->resource); $this->resource = null;
}
public function getResource() { return $this->resource; }
}
?>