Wallogit.com
2017 © Pedro Peláez
Base class for testing database
Base class for testing database with PDO. Tested only against MySql., (*1)
Work in progress, (*2)
Code information:, (*3)
, (*4)
Package information:, (*5)
, (*6)
In your bootstrap file set up the connection, (*7)
// tests/bootstrap.php // [...] \Koine\PHPUnit\DbTestCase::setConnection($pdoConnection);
namespace MyAppTest;
use Koine\PHPUnit\DbTestCase;
use MyApp\BlogService;
/**
* @author Marcelo Jacobus <marcelo.jacobus@gmail.com>
*/
class DbTestCaseTest extends DbTestCase
{
public function setUp()
{
parent::setUp(); // enclose everything in a transaction
}
public function tearDown()
{
parent::tearDown(); // rollback the transaction
}
/**
* @test
*/
public function canCreatePost()
{
$service = new BlogService($this->getConnection());
$service->create(array(
'title' => 'some title',
'body' => 'some body',
));
$this->assertTableCount(1, 'blog_post');
}
/**
* @test
*/
public function canFindByCategory()
{
$helper = $this->createTableHelper('blog_post');
$helper->insert(array(
'title' => 'foo',
'body' => 'bar',
'categoryId' => 1,
));
$helper->insert(array(
'title' => 'foo',
'body' => 'bar',
'categoryId' => 2,
));
$service = new BlogService($this->getConnection());
$records = $service->findByCategoryId(1);
$this->assertEquals(1, count($records));
}
}
Table helper is a very simple ORM for creating records for test, updating and querying a single table., (*8)
Setting up, (*9)
$tableName = 'blog_post'; $tableHelper = new \Koine\DbTestCase\TableHelper\TableHelper( $pdo, $tableName, 'id' );
Finding records by conditions, (*10)
$posts = $tableHelper->findAllBy(array( 'categoryId' => $categoryId, ));
Finding record by id, (*11)
$post = $tableHelper->find(10);
Crating records, (*12)
$tableHelper->insert(array( 'title' => 'First blog', 'body' => 'Post body', ));
Updating, (*13)
$tableHelper->update(10, array( 'title' => 'new title', ));
Deleting, (*14)
$tableHelper->delete(10);
Counting, (*15)
$tableHelper->getNumberOfRows();
Append the lib to your requirements key in your composer.json., (*16)
{
// composer.json
// [..]
require: {
// append this line to your requirements
"koine/db-test-case": "*"
}
}
Here is the issue tracker., (*17)
Please refer to the contribuiting guide., (*18)
MIT, (*19)
Base class for testing database
MIT
Base class for testing database
MIT
Base class for testing database
MIT