FilesExpand file tree

master

/

AlterTablePropertiesSQLTest.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

151 lines (127 loc) · 5.39 KB

master

/

AlterTablePropertiesSQLTest.php

Copy path

Top

File metadata and controls

• Code
• Blame

151 lines (127 loc) · 5.39 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

139

140

141

142

143

144

145

146

147

148

149

150

151

<?php

namespace Tests\Unit;

use DBDiff\Diff\AlterTableOptions;

use DBDiff\Diff\AlterTablePersistence;

use DBDiff\SQLGen\Dialect\PostgresDialect;

use DBDiff\SQLGen\DiffToSQL\AlterTableOptionsSQL;

use DBDiff\SQLGen\DiffToSQL\AlterTablePersistenceSQL;

use PHPUnit\Framework\TestCase;

/**

* Durability and storage parameters on an existing table (issue #229).

*

* Both were read for rendering a *new* table and never compared for one that

* exists on both sides, so switching a table between LOGGED and UNLOGGED, or

* changing its fillfactor, was reported as "Databases are identical". UNLOGGED

* is not decoration: an unlogged table is not crash-safe and is emptied on

* recovery.

*/

class AlterTablePropertiesSQLTest extends TestCase

{

private function persistence(bool $source, bool $target): AlterTablePersistenceSQL

{

return new AlterTablePersistenceSQL(

new AlterTablePersistence('t_unlogged', $source, $target),

new PostgresDialect()

);

}

private function options(?string $source, ?string $target): AlterTableOptionsSQL

{

return new AlterTableOptionsSQL(

new AlterTableOptions('t_fill', $source, $target),

new PostgresDialect()

);

}

// ── LOGGED / UNLOGGED ────────────────────────────────────────────────────

public function testAnUnloggedTargetIsSetLogged(): void

{

// Source logged, target unlogged: the UP makes the target durable.

$this->assertSame(

'ALTER TABLE "t_unlogged" SET LOGGED;',

$this->persistence(false, true)->getUp()

);

}

public function testTheReverseIsSetUnlogged(): void

{

$this->assertSame(

'ALTER TABLE "t_unlogged" SET UNLOGGED;',

$this->persistence(true, false)->getUp()

);

}

public function testTheDownRestoresTheTargetsOwnPersistence(): void

{

$this->assertSame(

'ALTER TABLE "t_unlogged" SET UNLOGGED;',

$this->persistence(false, true)->getDown()

);

}

// ── Storage parameters ───────────────────────────────────────────────────

public function testAnOptionOnlyTheTargetHasIsReset(): void

{

// `RESET` returns it to the default; there is no way to replace the

// whole list in one statement.

$this->assertSame(

'ALTER TABLE "t_fill" RESET (fillfactor);',

$this->options(null, 'fillfactor = 70')->getUp()

);

}

public function testAnOptionOnlyTheSourceHasIsSet(): void

{

$this->assertSame(

'ALTER TABLE "t_fill" SET (fillfactor = 70);',

$this->options('fillfactor = 70', null)->getUp()

);

}

public function testAChangedValueIsSetToTheSources(): void

{

$this->assertSame(

'ALTER TABLE "t_fill" SET (fillfactor = 90);',

$this->options('fillfactor = 90', 'fillfactor = 70')->getUp()

);

}

public function testSettingAndResettingCanBothHappen(): void

{

$sql = $this->options('fillfactor = 90', 'autovacuum_enabled = false')->getUp();

$this->assertStringContainsString('SET (fillfactor = 90);', $sql);

$this->assertStringContainsString('RESET (autovacuum_enabled);', $sql);

}

public function testSeveralOptionsAreSetTogether(): void

{

$sql = $this->options('fillfactor = 90, autovacuum_enabled = false', null)->getUp();

$this->assertStringContainsString('fillfactor = 90', $sql);

$this->assertStringContainsString('autovacuum_enabled = false', $sql);

$this->assertSame(1, substr_count($sql, 'SET ('));

}

public function testAnOptionPresentAndEqualOnBothSidesIsLeftAlone(): void

{

$sql = $this->options('fillfactor = 70, autovacuum_enabled = false', 'fillfactor = 70')->getUp();

$this->assertStringContainsString('autovacuum_enabled = false', $sql);

$this->assertStringNotContainsString('fillfactor', $sql);

}

public function testTheDownDirectionIsTheMirrorImage(): void

{

$alter = $this->options(null, 'fillfactor = 70');

$this->assertSame('ALTER TABLE "t_fill" RESET (fillfactor);', $alter->getUp());

$this->assertSame('ALTER TABLE "t_fill" SET (fillfactor = 70);', $alter->getDown());

}

// ── Parsing ──────────────────────────────────────────────────────────────

public function testOptionsAreParsedIntoPairs(): void

{

$this->assertSame(

['fillfactor' => '70', 'autovacuum_enabled' => 'false'],

AlterTableOptionsSQL::parse('fillfactor = 70, autovacuum_enabled = false')

);

}

public function testNoOptionsParsesToNothing(): void

{

$this->assertSame([], AlterTableOptionsSQL::parse(null));

$this->assertSame([], AlterTableOptionsSQL::parse(''));

$this->assertSame([], AlterTableOptionsSQL::parse(' '));

}

public function testAValueContainingAnEqualsSignSurvives(): void

{

$this->assertSame(

['check_option' => 'a=b'],

AlterTableOptionsSQL::parse('check_option = a=b')

);

}

}