FilesExpand file tree

master

/

DiffSorterIndexColumnOrderTest.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

63 lines (56 loc) · 2.21 KB

master

/

DiffSorterIndexColumnOrderTest.php

Copy path

Top

File metadata and controls

• Code
• Blame

63 lines (56 loc) · 2.21 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

<?php

namespace DBDiff\Tests\Unit;

use PHPUnit\Framework\TestCase;

use DBDiff\SQLGen\DiffSorter;

use DBDiff\Diff\AlterTableAddColumn;

use DBDiff\Diff\AlterTableAddKey;

use DBDiff\Diff\AlterTableDropColumn;

use DBDiff\Diff\AlterTableDropKey;

/**

* An index is dropped before the column it is on.

*

* DROP COLUMN ... CASCADE takes the column's indexes with it, so a DROP INDEX

* sorted after it failed with `index "t_x" does not exist`: in UP when an

* indexed column was removed, and in DOWN when one was added.

*/

class DiffSorterIndexColumnOrderTest extends TestCase

{

private static function kinds(array $diffs): array

{

return array_map(fn($d) => (new \ReflectionClass($d))->getShortName(), $diffs);

}

public function testUpDropsTheIndexBeforeTheColumn(): void

{

$sorted = (new DiffSorter())->sort([

new AlterTableDropColumn('t', 'x', null),

new AlterTableDropKey('t', 't_x', null),

], 'up');

$this->assertSame(['AlterTableDropKey', 'AlterTableDropColumn'], self::kinds($sorted));

}

public function testUpAddsTheColumnBeforeTheIndex(): void

{

$sorted = (new DiffSorter())->sort([

new AlterTableAddKey('t', 't_x', null),

new AlterTableAddColumn('t', 'x', null),

], 'up');

$this->assertSame(['AlterTableAddColumn', 'AlterTableAddKey'], self::kinds($sorted));

}

// DOWN of an added indexed column: the index's DROP, then the column's.

public function testDownUndoesTheIndexBeforeTheColumn(): void

{

$sorted = (new DiffSorter())->sort([

new AlterTableAddColumn('t', 'x', null),

new AlterTableAddKey('t', 't_x', null),

], 'down');

$this->assertSame(['AlterTableAddKey', 'AlterTableAddColumn'], self::kinds($sorted));

}

// DOWN of a removed indexed column: the column back, then its index.

public function testDownRestoresTheColumnBeforeTheIndex(): void

{

$sorted = (new DiffSorter())->sort([

new AlterTableDropKey('t', 't_x', null),

new AlterTableDropColumn('t', 'x', null),

], 'down');

$this->assertSame(['AlterTableDropColumn', 'AlterTableDropKey'], self::kinds($sorted));

}

}