for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace Tests;
use PHPUnit\Framework\TestCase;
class StatementTest extends TestCase
{
use \Bonfim\Component\Database\Statement;
public function testCreate()
$this->create('users', [
'name' => 'Edson Onildo',
'login' => 'edsononildo',
'password' => 1234
]);
$expected = 'INSERT INTO `users` (`name`, `login`, `password`) VALUES (:name, :login, :password)';
$this->assertEquals($expected, $this->statement);
}
public function testAll()
$this->all('users');
$this->assertEquals('SELECT * FROM `users`', $this->statement);
public function testSelect()
$this->select('users', [
'name',
'login',
'password'
$this->assertEquals('SELECT `name`, `login`, `password` FROM `users`', $this->statement);
public function testUpdate()
$this->update('users', [
'name' => 'Bonfim',
'login' => 'admin',
'password' => 4321
$expected = 'UPDATE `users` SET `name` = :name, `login` = :login, `password` = :password';
public function testDelete()
$this->delete('users');
$this->assertEquals('DELETE FROM `users`', $this->statement);