FilesExpand file tree

master

/

InsertDeleteDataSQLTest.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

121 lines (99 loc) · 3.99 KB

master

/

InsertDeleteDataSQLTest.php

Copy path

Top

File metadata and controls

• Code
• Blame

121 lines (99 loc) · 3.99 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

<?php

namespace DBDiff\Tests\Unit;

use PHPUnit\Framework\TestCase;

use DBDiff\SQLGen\DiffToSQL\InsertDataSQL;

use DBDiff\SQLGen\DiffToSQL\DeleteDataSQL;

use DBDiff\SQLGen\Dialect\MySQLDialect;

use Diff\DiffOp\DiffOpAdd;

use Diff\DiffOp\DiffOpRemove;

class InsertDeleteDataSQLTest extends TestCase

{

// ── InsertDataSQL ─────────────────────────────────────────────────────

public function testInsertGetUpIncludesColumnNames(): void

{

$row = ['id' => '1', 'name' => 'Alice', 'email' => 'alice@example.com'];

$obj = (object) [

'table' => 'users',

'diff' => [

'keys' => ['id' => '1'],

'diff' => new DiffOpAdd($row),

],

];

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

$result = $sql->getUp();

$this->assertStringContainsString('(`id`,`name`,`email`)', $result);

$this->assertStringContainsString("VALUES('1','Alice','alice@example.com')", $result);

}

public function testInsertGetUpHandlesNullValues(): void

{

$row = ['id' => '1', 'name' => null, 'email' => 'test@test.com'];

$obj = (object) [

'table' => 'users',

'diff' => [

'keys' => ['id' => '1'],

'diff' => new DiffOpAdd($row),

],

];

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

$result = $sql->getUp();

$this->assertStringContainsString('(`id`,`name`,`email`)', $result);

$this->assertStringContainsString("VALUES('1',NULL,'test@test.com')", $result);

}

public function testInsertGetDownGeneratesDelete(): void

{

$obj = (object) [

'table' => 'users',

'diff' => [

'keys' => ['id' => '1'],

'diff' => new DiffOpAdd(['id' => '1', 'name' => 'Alice']),

],

];

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

$result = $sql->getDown();

$this->assertSame("DELETE FROM `users` WHERE `id` = '1';", $result);

}

// ── DeleteDataSQL ─────────────────────────────────────────────────────

public function testDeleteGetDownIncludesColumnNames(): void

{

$row = ['id' => '2', 'name' => 'Bob', 'email' => 'bob@example.com'];

$obj = (object) [

'table' => 'users',

'diff' => [

'keys' => ['id' => '2'],

'diff' => new DiffOpRemove($row),

],

];

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

$result = $sql->getDown();

$this->assertStringContainsString('(`id`,`name`,`email`)', $result);

$this->assertStringContainsString("VALUES('2','Bob','bob@example.com')", $result);

}

public function testDeleteGetDownHandlesNullValues(): void

{

$row = ['id' => '2', 'name' => null, 'email' => 'test@test.com'];

$obj = (object) [

'table' => 'users',

'diff' => [

'keys' => ['id' => '2'],

'diff' => new DiffOpRemove($row),

],

];

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

$result = $sql->getDown();

$this->assertStringContainsString('(`id`,`name`,`email`)', $result);

$this->assertStringContainsString("VALUES('2',NULL,'test@test.com')", $result);

}

public function testDeleteGetUpGeneratesDelete(): void

{

$obj = (object) [

'table' => 'users',

'diff' => [

'keys' => ['id' => '2'],

'diff' => new DiffOpRemove(['id' => '2', 'name' => 'Bob']),

],

];

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

$result = $sql->getUp();

$this->assertSame("DELETE FROM `users` WHERE `id` = '2';", $result);

}

}