composer require --dev phpunit/phpunit

<?php

// tests/DatabaseSchemaTest.php
// CLI: vendor/bin/phpunit --filter DatabaseSchemaTest

namespace App\Tests;

use Doctrine\DBAL\Connection;
use Doctrine\DBAL\DriverManager;
use PHPUnit\Framework\TestCase;

class DatabaseSchemaTest extends TestCase
{
    private $localDb1Connection;
    private $remoteDb1Connection;
    private $localDb2Connection;
    private $remoteDb2Connection;

    protected function setUp(): void
    {
        $this->localDb1Connection = DriverManager::getConnection(['url' => 'mysql://user:pass@localhost/local_db1']);
        $this->remoteDb1Connection = DriverManager::getConnection(['url' => 'mysql://user:pass@remote_host/remote_db1']);
        $this->localDb2Connection = DriverManager::getConnection(['url' => 'mysql://user:pass@localhost/local_db2']);
        $this->remoteDb2Connection = DriverManager::getConnection(['url' => 'mysql://user:pass@remote_host/remote_db2']);
    }

    public function testCompareDatabaseSchemas(): void
    {
        $errors = [];

        $this->compareSchemas($this->localDb1Connection, $this->remoteDb1Connection, 'Local DB1', 'Remote DB1', $errors);
        $this->compareSchemas($this->localDb2Connection, $this->remoteDb2Connection, 'Local DB2', 'Remote DB2', $errors);

        if (!empty($errors)) {
            $this->fail("Schema comparison errors:\n" . implode("\n", $errors));
        }

        $this->assertEmpty($errors, "Schema comparison passed without errors.");
    }

    private function compareSchemas($localConnection, $remoteConnection, string $localDbName, string $remoteDbName, array &$errors): void
    {
        $localSchemaManager = $localConnection->createSchemaManager();
        $remoteSchemaManager = $remoteConnection->createSchemaManager();

        $localTables = $localSchemaManager->listTableNames();
        $remoteTables = $remoteSchemaManager->listTableNames();

        foreach ($localTables as $localTableName) {
            if (str_ends_with($localTableName, '_pv')) {
                continue; // Ignoriere Tabellen, die auf '_pv' enden
            }

            if (!in_array($localTableName, $remoteTables)) {
                $errors[] = "Table '$localTableName' exists in $localDbName but not in $remoteDbName.";
                continue;
            }

            $localTable = $localSchemaManager->introspectTable($localTableName);
            $remoteTable = $remoteSchemaManager->introspectTable($localTableName);

            $localColumns = $localTable->getColumns();
            $remoteColumns = $remoteTable->getColumns();

            foreach ($localColumns as $localColumn) {
                $columnName = $localColumn->getName();
                if (!isset($remoteColumns[$columnName])) {
                    $errors[] = "Column '$columnName' in table '$localTableName' exists in $localDbName but not in $remoteDbName.";
                    continue;
                }

                $localType = get_class($localColumn->getType());
                $remoteType = get_class($remoteColumns[$columnName]->getType());

                if ($localType !== $remoteType) {
                    $errors[] = "Column type mismatch for '$columnName' in table '$localTableName' between $localDbName and $remoteDbName. Expected type: $localType, but got: $remoteType.";
                }
            }

            foreach ($remoteColumns as $remoteColumn) {
                $columnName = $remoteColumn->getName();
                if (!isset($localColumns[$columnName])) {
                    $errors[] = "Column '$columnName' in table '$localTableName' exists in $remoteDbName but not in $localDbName.";
                }
            }
        }

        foreach ($remoteTables as $remoteTableName) {
            if (!in_array($remoteTableName, $localTables)) {
                $errors[] = "Table '$remoteTableName' exists in $remoteDbName but not in $localDbName.";
            }
        }
    }
}

<?xml version="1.0" encoding="UTF-8"?>
<phpunit bootstrap="vendor/autoload.php">
    <testsuites>
        <testsuite name="Application Test Suite">
            <directory>./tests</directory>
        </testsuite>
    </testsuites>
</phpunit>

<?php

use Symfony\Component\Dotenv\Dotenv;

require dirname(__DIR__).'/vendor/autoload.php'; // Autoloader für Composer-Pakete

if (file_exists(dirname(__DIR__).'/config/bootstrap.php')) {
    require dirname(__DIR__).'/config/bootstrap.php';
} elseif (method_exists(Dotenv::class, 'bootEnv')) {
    (new Dotenv())->bootEnv(dirname(__DIR__).'/.env');
}

vendor/bin/phpunit tests/DatabaseSchemaTest.php

touch .git/hooks/pre-push
chmod +x .git/hooks/pre-push

#!/bin/sh

# Führe PHPUnit Tests aus
./vendor/bin/phpunit --filter DatabaseSchemaTest

# Überprüfe den Exit-Code von PHPUnit
if [ $? -ne 0 ]; then
    echo "DatabaseSchemaTest failed. Push aborted."
    exit 1
fi