CodeIgniter4/tests/system/Database/Live/IncrementTest.php at ca4fdf7fcfbfbdf931c190a8f065ed81154b91c1 · codeigniter4/CodeIgniter4 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<?php

declare(strict_types=1);

/**
 * This file is part of CodeIgniter 4 framework.
 *
 * (c) CodeIgniter Foundation <[email protected]>
 *
 * For the full copyright and license information, please view
 * the LICENSE file that was distributed with this source code.
 */

namespace CodeIgniter\Database\Live;

use CodeIgniter\Test\CIUnitTestCase;
use CodeIgniter\Test\DatabaseTestTrait;
use PHPUnit\Framework\Attributes\Group;
use Tests\Support\Database\Seeds\CITestSeeder;

/**
 * @internal
 */
#[Group('DatabaseLive')]
final class IncrementTest extends CIUnitTestCase
{
    use DatabaseTestTrait;

    protected $refresh = true;
    protected $seed    = CITestSeeder::class;

    public function testIncrement(): void
    {
        $this->hasInDatabase('job', ['name' => 'incremental', 'description' => '6']);

        $this->db->table('job')
            ->where('name', 'incremental')
            ->increment('description');

        $this->seeInDatabase('job', ['name' => 'incremental', 'description' => '7']);
    }

    public function testIncrementWithValue(): void
    {
        $this->hasInDatabase('job', ['name' => 'incremental', 'description' => '6']);

        $this->db->table('job')
            ->where('name', 'incremental')
            ->increment('description', 2);

        $this->seeInDatabase('job', ['name' => 'incremental', 'description' => '8']);
    }

    public function testIncrementAll(): void
    {
        $this->hasInDatabase('task', ['name' => 'task1', 'description' => '6', 'priority' => '1']);

        $this->db->table('task')
            ->where('name', 'task1')
            ->incrementAll(['description' => 2, 'priority' => 3]);

        $this->seeInDatabase('task', ['name' => 'task1', 'description' => '8', 'priority' => '4']);
    }

    public function testResetStateAfterIncrement(): void
    {
        $this->hasInDatabase('job', ['name' => 'account1', 'description' => '10']);
        $this->hasInDatabase('job', ['name' => 'account2', 'description' => '10']);

        $builder = $this->db->table('job');

        $builder->where('name', 'account1')->increment('description');
        $builder->where('name', 'account2')->increment('description');

        $this->seeInDatabase('job', ['name' => 'account1', 'description' => '11']);
        $this->seeInDatabase('job', ['name' => 'account2', 'description' => '11']);
    }

    public function testDecrement(): void
    {
        $this->hasInDatabase('job', ['name' => 'incremental', 'description' => '6']);

        $this->db->table('job')
            ->where('name', 'incremental')
            ->decrement('description');

        $this->seeInDatabase('job', ['name' => 'incremental', 'description' => '5']);
    }

    public function testDecrementWithValue(): void
    {
        $this->hasInDatabase('job', ['name' => 'incremental', 'description' => '6']);

        $this->db->table('job')
            ->where('name', 'incremental')
            ->decrement('description', 2);

        $this->seeInDatabase('job', ['name' => 'incremental', 'description' => '4']);
    }

    public function testDecrementAll(): void
    {
        $this->hasInDatabase('task', ['name' => 'task2', 'description' => '6', 'priority' => '5']);

        $this->db->table('task')
            ->where('name', 'task2')
            ->decrementAll(['description' => 2, 'priority' => 3]);

        $this->seeInDatabase('task', ['name' => 'task2', 'description' => '4', 'priority' => '2']);
    }

    public function testResetStateAfterDecrement(): void
    {
        $this->hasInDatabase('job', ['name' => 'account1', 'description' => '10']);
        $this->hasInDatabase('job', ['name' => 'account2', 'description' => '10']);

        $builder = $this->db->table('job');

        $builder->where('name', 'account1')->decrement('description');
        $builder->where('name', 'account2')->decrement('description');

        $this->seeInDatabase('job', ['name' => 'account1', 'description' => '9']);
        $this->seeInDatabase('job', ['name' => 'account2', 'description' => '9']);
    }
}