CodeIgniter4/tests/system/Commands/Database/MigrateStatusTest.php at 2a0003ded1331d5c09e806e9e39c68832be025d8 · paulbalandan/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
<?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\Commands\Database;

use CodeIgniter\CLI\CLI;
use CodeIgniter\Test\CIUnitTestCase;
use CodeIgniter\Test\DatabaseTestTrait;
use CodeIgniter\Test\StreamFilterTrait;
use Config\Database;
use PHPUnit\Framework\Attributes\Group;

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

    private string $migrationFileFrom = SUPPORTPATH . 'MigrationTestMigrations/Database/Migrations/2018-01-24-102301_Some_migration.php';
    private string $migrationFileTo   = APPPATH . 'Database/Migrations/2018-01-24-102301_Some_migration.php';

    protected function setUp(): void
    {
        parent::setUp();

        Database::connect()->table('migrations')->emptyTable();
        Database::forge()->dropTable('foo', true);

        if (! is_file($this->migrationFileFrom)) {
            $this->fail(clean_path($this->migrationFileFrom) . ' is not found.');
        }

        if (is_file($this->migrationFileTo)) {
            @unlink($this->migrationFileTo);
        }

        copy($this->migrationFileFrom, $this->migrationFileTo);

        $contents = file_get_contents($this->migrationFileTo);
        $contents = str_replace(
            'namespace Tests\Support\MigrationTestMigrations\Database\Migrations;',
            'namespace App\Database\Migrations;',
            $contents,
        );
        file_put_contents($this->migrationFileTo, $contents);

        putenv('NO_COLOR=1');
        CLI::init();
    }

    protected function tearDown(): void
    {
        parent::tearDown();

        Database::connect()->table('migrations')->emptyTable();

        if (is_file($this->migrationFileTo)) {
            @unlink($this->migrationFileTo);
        }

        putenv('NO_COLOR');
        CLI::init();
    }

    public function testMigrateAllWithWithTwoNamespaces(): void
    {
        command('migrate --all');
        $this->resetStreamFilterBuffer();

        command('migrate:status');

        $result   = str_replace(PHP_EOL, "\n", $this->getStreamFilterBuffer());
        $result   = preg_replace('/\d{4}-\d\d-\d\d \d\d:\d\d:\d\d/', 'YYYY-MM-DD HH:MM:SS', $result);
        $expected = <<<'EOL'
            +---------------+-------------------+--------------------+-------+---------------------+-------+
            | Namespace     | Version           | Filename           | Group | Migrated On         | Batch |
            +---------------+-------------------+--------------------+-------+---------------------+-------+
            | App           | 2018-01-24-102301 | Some_migration     | tests | YYYY-MM-DD HH:MM:SS | 1     |
            | Tests\Support | 20160428212500    | Create_test_tables | tests | YYYY-MM-DD HH:MM:SS | 1     |
            +---------------+-------------------+--------------------+-------+---------------------+-------+


            EOL;
        $this->assertSame($expected, $result);
    }

    public function testMigrateWithWithTwoNamespaces(): void
    {
        command('migrate -n App');
        command('migrate -n Tests\\\\Support');
        $this->resetStreamFilterBuffer();

        command('migrate:status');

        $result   = str_replace(PHP_EOL, "\n", $this->getStreamFilterBuffer());
        $result   = preg_replace('/\d{4}-\d\d-\d\d \d\d:\d\d:\d\d/', 'YYYY-MM-DD HH:MM:SS', $result);
        $expected = <<<'EOL'
            +---------------+-------------------+--------------------+-------+---------------------+-------+
            | Namespace     | Version           | Filename           | Group | Migrated On         | Batch |
            +---------------+-------------------+--------------------+-------+---------------------+-------+
            | App           | 2018-01-24-102301 | Some_migration     | tests | YYYY-MM-DD HH:MM:SS | 1     |
            | Tests\Support | 20160428212500    | Create_test_tables | tests | YYYY-MM-DD HH:MM:SS | 2     |
            +---------------+-------------------+--------------------+-------+---------------------+-------+


            EOL;
        $this->assertSame($expected, $result);
    }
}