Newer
Older
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
126
127
128
129
<?php
namespace Breyta\Test\Migrations;
use Breyta\Migration;
use Breyta\Migrations;
use Breyta\Test\TestCase;
use Mockery as m;
class StatusTest extends TestCase
{
/** @test */
public function queriesAllAppliedMigrations()
{
$migrations = new Migrations($this->pdo, __DIR__ . '/../Example');
$this->pdo->shouldReceive('query')->with(m::pattern('/SELECT .* FROM migrations/'))
->once()->andReturn(false);
$migrations->getStatus();
}
/** @test */
public function appliesCurrentStatusToMigrationList()
{
$migration = Migration::createInstance([
'file' => '@breyta/CreateMigrationTable.php',
'executed' => date('Y-m-dTH:i:sZ', strtotime('-1 Hour')),
'status' => 'done',
'executions' => json_encode([
[
'teaser' => 'CREATE TABLE migrations',
'action' => 'create',
'type' => 'table',
'name' => 'migrations',
'executionTime' => 0.1,
],
]),
'executionTime' => 0.1,
]);
$migrations = new Migrations($this->pdo, __DIR__ . '/../Example');
$this->pdo->shouldReceive('query')->with(m::pattern('/SELECT .* FROM migrations/'))
->once()->andReturn($statement = m::mock(\PDOStatement::class));
$statement->shouldReceive('setFetchMode')->with(\PDO::FETCH_CLASS, Migration::class)
->once()->andReturn(true);
$statement->shouldReceive('fetch')->with()
->twice()->andReturn($migration, false);
$status = $migrations->getStatus();
self::assertEquals($migration, $status->migrations['@breyta/CreateMigrationTable.php']);
}
/** @test */
public function returnsACountOfNotAppliedMigrations()
{
$migration = Migration::createInstance([
'file' => '@breyta/CreateMigrationTable.php',
'executed' => date('Y-m-dTH:i:sZ', strtotime('-1 Hour')),
'status' => 'done',
'executions' => json_encode([
[
'teaser' => 'CREATE TABLE migrations',
'action' => 'create',
'type' => 'table',
'name' => 'migrations',
'executionTime' => 0.1,
],
]),
'executionTime' => 0.1,
]);
$migrations = new Migrations($this->pdo, __DIR__ . '/../Example');
$this->pdo->shouldReceive('query')->with(m::pattern('/SELECT .* FROM migrations/'))
->once()->andReturn($statement = m::mock(\PDOStatement::class));
$statement->shouldReceive('setFetchMode')->with(\PDO::FETCH_CLASS, Migration::class)
->once()->andReturn(true);
$statement->shouldReceive('fetch')->with()
->twice()->andReturn($migration, false);
$status = $migrations->getStatus();
self::assertSame(count($status->migrations) - 1, $status->count); // the expected count is one less
}
/** @test */
public function ignoresExceptionsFromQuerying()
{
$migrations = new Migrations($this->pdo, __DIR__ . '/../Example');
$this->pdo->shouldReceive('query')->with(m::pattern('/SELECT .* FROM migrations/'))
->once()->andThrow(new \PDOException('unknown table migrations'));
$status = $migrations->getStatus();
self::assertObjectHasAttribute('migrations', $status);
self::assertObjectHasAttribute('count', $status);
}
/** @test */
public function returnsAnArrayOfMissingMigrations()
{
$migration = Migration::createInstance([
'file' => 'manually executed',
'executed' => date('Y-m-dTH:i:sZ', strtotime('-1 Hour')),
'status' => 'done',
'executions' => json_encode([]),
'executionTime' => 0.1,
]);
$migrations = new Migrations($this->pdo, __DIR__ . '/../Example');
$this->pdo->shouldReceive('query')->with(m::pattern('/SELECT .* FROM migrations/'))
->once()->andReturn($statement = m::mock(\PDOStatement::class));
$statement->shouldReceive('setFetchMode')->with(\PDO::FETCH_CLASS, Migration::class)
->once()->andReturn(true);
$statement->shouldReceive('fetch')->with()
->twice()->andReturn($migration, false);
$status = $migrations->getStatus();
self::assertObjectHasAttribute('missing', $status);
self::assertSame(1, count($status->missing));
self::assertContains($migration, $status->missing);
}
}