coolify/tests/Unit/TimescaleDbDetectionTest.php at v4.x · APISentinel/coolify · GitHub

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
<?php

use App\Models\ServiceDatabase;

use function PHPUnit\Framework\assertTrue;

test('timescaledb is detected as database with postgres environment variables', function () {
    $image = 'timescale/timescaledb';
    $serviceConfig = [
        'image' => 'timescale/timescaledb',
        'environment' => [
            'POSTGRES_DB=$POSTGRES_DB',
            'POSTGRES_USER=$SERVICE_USER_POSTGRES',
            'POSTGRES_PASSWORD=$SERVICE_PASSWORD_POSTGRES',
        ],
        'volumes' => [
            'timescaledb-data:/var/lib/postgresql/data',
        ],
    ];

    $isDatabase = isDatabaseImage($image, $serviceConfig);

    assertTrue($isDatabase, 'TimescaleDB with POSTGRES_PASSWORD should be detected as database');
});

test('timescaledb is detected as database without service config', function () {
    $image = 'timescale/timescaledb';

    $isDatabase = isDatabaseImage($image);

    assertTrue($isDatabase, 'TimescaleDB image should be in DATABASE_DOCKER_IMAGES constant');
});

test('timescaledb-ha is detected as database', function () {
    $image = 'timescale/timescaledb-ha';

    $isDatabase = isDatabaseImage($image);

    assertTrue($isDatabase, 'TimescaleDB HA image should be in DATABASE_DOCKER_IMAGES constant');
});

test('timescaledb databaseType returns postgresql', function () {
    $database = new ServiceDatabase;
    $database->setRawAttributes(['image' => 'timescale/timescaledb:latest', 'custom_type' => null]);
    $database->syncOriginal();

    $type = $database->databaseType();

    expect($type)->toBe('standalone-postgresql');
});

test('timescaledb-ha databaseType returns postgresql', function () {
    $database = new ServiceDatabase;
    $database->setRawAttributes(['image' => 'timescale/timescaledb-ha:pg17', 'custom_type' => null]);
    $database->syncOriginal();

    $type = $database->databaseType();

    expect($type)->toBe('standalone-postgresql');
});

test('timescaledb backup solution is available', function () {
    $database = new ServiceDatabase;
    $database->setRawAttributes(['image' => 'timescale/timescaledb:latest', 'custom_type' => null]);
    $database->syncOriginal();

    $isAvailable = $database->isBackupSolutionAvailable();

    assertTrue($isAvailable, 'TimescaleDB should have backup solution available');
});

test('timescaledb-ha backup solution is available', function () {
    $database = new ServiceDatabase;
    $database->setRawAttributes(['image' => 'timescale/timescaledb-ha:pg17', 'custom_type' => null]);
    $database->syncOriginal();

    $isAvailable = $database->isBackupSolutionAvailable();

    assertTrue($isAvailable, 'TimescaleDB HA should have backup solution available');
});