Tests\StatementTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	46
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	testUpdate()	0	9	1
A	testCreate()	0	9	1
A	testAll()	0	4	1
A	testSelect()	0	8	1
A	testDelete()	0	4	1

<?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';
        $this->assertEquals($expected, $this->statement);
    }

    public function testDelete()
    {
        $this->delete('users');
        $this->assertEquals('DELETE FROM `users`', $this->statement);
    }
}