FilesExpand file tree

master

/

PostgresConnectionConfigTest.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

109 lines (95 loc) · 4.11 KB

master

/

PostgresConnectionConfigTest.php

Copy path

Top

File metadata and controls

• Code
• Blame

109 lines (95 loc) · 4.11 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

<?php

namespace Tests\Unit;

use DBDiff\DB\Adapters\PostgresAdapter;

use PHPUnit\Framework\TestCase;

/**

* The PDO options the Postgres adapter connects with.

*

* Issue #220: with PDO's defaults every catalog query costs three round trips —

* PREPARE, EXECUTE, DEALLOCATE — and a diff makes dozens of them, so over a

* link with any latency that is most of the wall clock. Disabling *named*

* prepares makes each query a single round trip.

*

* The output of a diff is unchanged by this, which is the whole point and also

* why nothing else in the suite would notice it being reverted: the schema

* fixtures pass either way. These tests exist so the choice cannot be undone

* silently, and so the *particular* choice is pinned — `ATTR_EMULATE_PREPARES`

* would also remove the round trips, but by interpolating parameters

* client-side, and the data diff sends values through these connections.

*/

class PostgresConnectionConfigTest extends TestCase

{

/** The attribute under either spelling; both carry the same value. */

private function disablePrepares(): int

{

return defined('Pdo\Pgsql::ATTR_DISABLE_PREPARES')

? constant('Pdo\Pgsql::ATTR_DISABLE_PREPARES')

: \PDO::PGSQL_ATTR_DISABLE_PREPARES;

}

private function config(array $server = [], string $db = 'somedb'): array

{

return (new PostgresAdapter())->buildConnectionConfig($server, $db);

}

public function testNamedPreparesAreDisabled(): void

{

$config = $this->config();

$this->assertArrayHasKey('options', $config, 'no PDO options were set at all');

$this->assertArrayHasKey(

$this->disablePrepares(),

$config['options'],

'named prepares are not disabled, so every query costs three round trips (#220)'

);

$this->assertTrue($config['options'][$this->disablePrepares()]);

}

public function testParametersAreStillBoundServerSide(): void

{

$config = $this->config();

// ATTR_EMULATE_PREPARES would also avoid the round trips, by building

// the statement client-side. The data diff sends values through these

// connections, so binding must stay server-side.

$this->assertArrayNotHasKey(

\PDO::ATTR_EMULATE_PREPARES,

$config['options'],

'parameters would be interpolated client-side'

);

}

public function testTheAttributeResolvesOnThisPhpVersion(): void

{

// PHP 8.4 moved the PDO_PGSQL constants onto a Pdo\Pgsql class and

// deprecated the PDO::PGSQL_* spellings. Whichever this runtime has,

// the adapter must produce a usable integer attribute rather than null.

$config = $this->config();

$keys = array_keys($config['options']);

$this->assertCount(1, $keys);

$this->assertIsInt($keys[0]);

$this->assertSame($this->disablePrepares(), $keys[0]);

}

public function testTheRestOfTheConnectionIsUnchanged(): void

{

// The options were added to an existing config; nothing else about how

// the adapter connects should have moved.

$config = $this->config([

'host' => 'db.example.invalid',

'port' => '6543',

'user' => 'someone',

'password' => 'secret',

'sslmode' => 'require',

], 'thedb');

$this->assertSame('pgsql', $config['driver']);

$this->assertSame('db.example.invalid', $config['host']);

$this->assertSame('6543', $config['port']);

$this->assertSame('thedb', $config['database']);

$this->assertSame('someone', $config['username']);

$this->assertSame('secret', $config['password']);

$this->assertSame('public', $config['schema']);

$this->assertSame('require', $config['sslmode']);

}

public function testDefaultsSurvive(): void

{

$config = $this->config();

$this->assertSame('localhost', $config['host']);

$this->assertSame('5432', $config['port']);

$this->assertSame('prefer', $config['sslmode']);

$this->assertSame('public', $config['schema']);

}

}