FilesExpand file tree

master

/

UpdateDataSQLTest.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

138 lines (107 loc) · 4.94 KB

master

/

UpdateDataSQLTest.php

Copy path

Top

File metadata and controls

• Code
• Blame

138 lines (107 loc) · 4.94 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

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

130

131

132

133

134

135

136

137

138

<?php

namespace DBDiff\Tests\Unit;

use PHPUnit\Framework\TestCase;

use DBDiff\SQLGen\DiffToSQL\UpdateDataSQL;

use DBDiff\SQLGen\Dialect\MySQLDialect;

use Diff\DiffOp\DiffOpAdd;

use Diff\DiffOp\DiffOpRemove;

use Diff\DiffOp\DiffOpChange;

class UpdateDataSQLTest extends TestCase

{

private function makeObj(string $table, array $diffMap, array $keys): object

{

return (object) [

'table' => $table,

'diff' => ['diff' => $diffMap, 'keys' => $keys],

];

}

// ── getUp ─────────────────────────────────────────────────────────────

public function testGetUpWithDiffOpChange(): void

{

$obj = $this->makeObj('users', [

'name' => new DiffOpChange('old_name', 'new_name'),

], ['id' => '1']);

$sql = new UpdateDataSQL($obj, new MySQLDialect());

$result = $sql->getUp();

$this->assertSame("UPDATE `users` SET `name` = 'new_name' WHERE `id` = '1';", $result);

}

public function testGetUpWithDiffOpChangeNullNewValue(): void

{

$obj = $this->makeObj('users', [

'email' => new DiffOpChange('old@test.com', null),

], ['id' => '2']);

$sql = new UpdateDataSQL($obj, new MySQLDialect());

$result = $sql->getUp();

$this->assertSame("UPDATE `users` SET `email` = NULL WHERE `id` = '2';", $result);

}

public function testGetUpLeavesOutAColumnOnlyTheTargetHas(): void

{

// A column only the target's rows have is one only its table has, and

// the UP drops it before the rows are updated: naming it failed with

// "unknown column". With nothing else to set, there is no UPDATE.

$obj = $this->makeObj('users', [

'old_col' => new DiffOpRemove('removed_value'),

], ['id' => '3']);

$sql = new UpdateDataSQL($obj, new MySQLDialect());

$this->assertSame('', $sql->getUp());

}

public function testGetUpWithDiffOpAddDoesNotCrash(): void

{

$obj = $this->makeObj('users', [

'new_col' => new DiffOpAdd('added_value'),

], ['id' => '4']);

$sql = new UpdateDataSQL($obj, new MySQLDialect());

$result = $sql->getUp();

$this->assertSame("UPDATE `users` SET `new_col` = 'added_value' WHERE `id` = '4';", $result);

}

// ── getDown ───────────────────────────────────────────────────────────

public function testGetDownWithDiffOpChange(): void

{

$obj = $this->makeObj('users', [

'name' => new DiffOpChange('old_name', 'new_name'),

], ['id' => '1']);

$sql = new UpdateDataSQL($obj, new MySQLDialect());

$result = $sql->getDown();

$this->assertSame("UPDATE `users` SET `name` = 'old_name' WHERE `id` = '1';", $result);

}

public function testGetDownWithDiffOpChangeNullOldValue(): void

{

$obj = $this->makeObj('users', [

'email' => new DiffOpChange(null, 'new@test.com'),

], ['id' => '2']);

$sql = new UpdateDataSQL($obj, new MySQLDialect());

$result = $sql->getDown();

$this->assertSame("UPDATE `users` SET `email` = NULL WHERE `id` = '2';", $result);

}

public function testGetDownLeavesOutAColumnOnlyTheSourceHas(): void

{

// The DOWN drops a column only the source has before the rows are put

// back, so it is not named (DiffOpAdd has no old value to set either).

$obj = $this->makeObj('users', [

'new_col' => new DiffOpAdd('added_value'),

], ['id' => '3']);

$sql = new UpdateDataSQL($obj, new MySQLDialect());

$this->assertSame('', $sql->getDown());

}

public function testGetDownWithDiffOpRemoveDoesNotCrash(): void

{

$obj = $this->makeObj('users', [

'old_col' => new DiffOpRemove('removed_value'),

], ['id' => '4']);

$sql = new UpdateDataSQL($obj, new MySQLDialect());

$result = $sql->getDown();

$this->assertSame("UPDATE `users` SET `old_col` = 'removed_value' WHERE `id` = '4';", $result);

}

// ── Mixed DiffOp types in a single UPDATE ─────────────────────────────

public function testMixedDiffOpTypes(): void

{

$obj = $this->makeObj('users', [

'name' => new DiffOpChange('old', 'new'),

'bio' => new DiffOpAdd('new_bio'),

'phone' => new DiffOpRemove('old_phone'),

], ['id' => '5']);

$sql = new UpdateDataSQL($obj, new MySQLDialect());

$this->assertSame("UPDATE `users` SET `name` = 'new', `bio` = 'new_bio' WHERE `id` = '5';", $sql->getUp());

$this->assertSame("UPDATE `users` SET `name` = 'old', `phone` = 'old_phone' WHERE `id` = '5';", $sql->getDown());

}

}