Completed
Push — master ( 79a5bc...8feb3f )
by Edson
01:27
created

StatementTest::testDelete()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 4
Code Lines 2

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 0
CRAP Score 2

Importance

Changes 0
Metric Value
cc 1
eloc 2
nc 1
nop 0
dl 0
loc 4
ccs 0
cts 4
cp 0
crap 2
rs 10
c 0
b 0
f 0
1
<?php
2
3
namespace Tests;
4
5
use PHPUnit\Framework\TestCase;
6
7
class StatementTest extends TestCase
8
{
9
    use \Bonfim\Component\Database\Statement;
10
11
    public function testCreate()
12
    {
13
        $this->create('users', [
14
            'name'     => 'Edson Onildo',
15
            'login'    => 'edsononildo',
16
            'password' => 1234
17
        ]);
18
        $expected = 'INSERT INTO `users` (`name`, `login`, `password`) VALUES (:name, :login, :password)';
19
        $this->assertEquals($expected, $this->statement);
20
    }
21
22
    public function testAll()
23
    {
24
        $this->all('users');
25
        $this->assertEquals('SELECT * FROM `users`', $this->statement);
26
    }
27
28
    public function testSelect()
29
    {
30
        $this->select('users', [
31
            'name',
32
            'login',
33
            'password'
34
        ]);
35
        $this->assertEquals('SELECT `name`, `login`, `password` FROM `users`', $this->statement);
36
    }
37
38
    public function testUpdate()
39
    {
40
        $this->update('users', [
41
            'name'     => 'Bonfim',
42
            'login'    => 'admin',
43
            'password' => 4321
44
        ]);
45
        $expected = 'UPDATE `users` SET `name` = :name, `login` = :login, `password` = :password';
46
        $this->assertEquals($expected, $this->statement);
47
    }
48
49
    public function testDelete()
50
    {
51
        $this->delete('users');
52
        $this->assertEquals('DELETE FROM `users`', $this->statement);
53
    }
54
}
55