VersionPress\Tests\Utils\DBAsserter::assertEntitiesEqualDatabase PHP Method

    private static function assertEntitiesEqualDatabase($entityName)
    {
        $storage = self::$storageFactory->getStorage($entityName);
        $entityInfo = self::$schemaInfo->getEntityInfo($entityName);
        $allDbEntities = self::selectAll(self::$schemaInfo->getPrefixedTableName($entityName));
        $idMap = self::getVpIdMap();
        $allDbEntities = self::identifyEntities($entityName, $allDbEntities, $idMap);
        $allDbEntities = self::replaceForeignKeys($entityName, $allDbEntities, $idMap);
        $dbEntities = array_filter($allDbEntities, [$storage, 'shouldBeSaved']);
        $urlReplacer = new AbsoluteUrlReplacer(self::$testConfig->testSite->url);
        $storageEntities = array_map(function ($entity) use($urlReplacer) {
            return $urlReplacer->restore($entity);
        }, $storage->loadAll());
        $countOfentitiesInDb = count($dbEntities);
        $countOfentitiesInStorage = count($storageEntities);
        if ($countOfentitiesInDb !== $countOfentitiesInStorage) {
            if ($countOfentitiesInStorage > $countOfentitiesInDb) {
                $problematicEntities = self::findMissingEntities($entityName, $storageEntities, $dbEntities);
            } else {
                $problematicEntities = self::findExceedingEntities($entityName, $storageEntities, $dbEntities);
            }
            throw new \PHPUnit_Framework_AssertionFailedError("Different count of synchronized entities ({$entityName}): DB = {$countOfentitiesInDb}, " . "storage = {$countOfentitiesInStorage}\nProblematic entities: " . join(", ", $problematicEntities));
        }
        foreach ($dbEntities as $dbEntity) {
            $id = $dbEntity[$entityInfo->vpidColumnName];
            $storageEntity = $storageEntities[$id];
            $dbEntity = self::$shortcodesReplacer->replaceShortcodesInEntity($entityName, $dbEntity);
            foreach ($dbEntity as $column => $value) {
                if ($entityInfo->idColumnName === $column || isset($entityInfo->getIgnoredColumns()[$column])) {
                    continue;
                }
                if (!isset($storageEntity[$column])) {
                    throw new \PHPUnit_Framework_AssertionFailedError("{$entityName}[{$column}] with value = {$value}, ID = {$id} not found in storage");
                }
                if (is_string($storageEntity[$column])) {
                    $storageEntity[$column] = str_replace("\r\n", "\n", $storageEntity[$column]);
                }
                if (is_string($value)) {
                    $value = str_replace("\r\n", "\n", $value);
                }
                if ($storageEntity[$column] != $value) {
                    throw new \PHPUnit_Framework_AssertionFailedError("Different values ({$entityName}[{$column}]: {$id}): DB = {$value}, storage = {$storageEntity[$column]}");
                }
            }
        }
        $missingReferences = [];
        $exceedingReferences = [];
        foreach ($entityInfo->mnReferences as $reference => $targetEntity) {
            if ($entityInfo->isVirtualReference($reference)) {
                continue;
            }
            $referenceDetails = ReferenceUtils::getMnReferenceDetails(self::$schemaInfo, $entityName, $reference);
            $sourceColumn = $referenceDetails['source-column'];
            $targetColumn = $referenceDetails['target-column'];
            $junctionTable = $referenceDetails['junction-table'];
            $prefixedJunctionTable = self::$schemaInfo->getPrefixedTableName($junctionTable);
            $prefixedVpIdTable = self::$schemaInfo->getPrefixedTableName('vp_id');
            $sourceTable = self::$schemaInfo->getTableName($referenceDetails['source-entity']);
            $targetTable = self::$schemaInfo->getTableName($referenceDetails['target-entity']);
            $junctionTableContent = self::fetchAll("SELECT HEX(s_vp_id.vp_id), HEX(t_vp_id.vp_id) FROM {$prefixedJunctionTable} j\n                 JOIN {$prefixedVpIdTable} s_vp_id ON j.{$sourceColumn} = s_vp_id.id AND s_vp_id.`table`='{$sourceTable}'\n                 JOIN {$prefixedVpIdTable} t_vp_id ON j.{$targetColumn} = t_vp_id.id AND t_vp_id.`table` = '{$targetTable}'", MYSQLI_NUM);
            $checkedReferences = [];
            $missingReferences[$junctionTable] = [];
            foreach ($storageEntities as $storageEntity) {
                if (!isset($storageEntity["vp_{$targetEntity}"])) {
                    continue;
                }
                foreach ($storageEntity["vp_{$targetEntity}"] as $referenceVpId) {
                    if (!ArrayUtils::any($junctionTableContent, function ($junctionRow) use($storageEntity, $referenceVpId) {
                        return $junctionRow[0] === $storageEntity['vp_id'] && $junctionRow[1] === $referenceVpId;
                    })) {
                        $missingReferences[$junctionTable][] = [$sourceColumn => $storageEntity['vp_id'], $targetColumn => $referenceVpId];
                    }
                    $checkedReferences[] = [$storageEntity['vp_id'], $referenceVpId];
                }
            }
            $exceedingReferences[$junctionTable] = array_map(function ($pair) use($sourceColumn, $targetColumn) {
                return [$sourceColumn => $pair[0], $targetColumn => $pair[1]];
            }, array_filter($junctionTableContent, function ($pair) use($checkedReferences) {
                foreach ($checkedReferences as $reference) {
                    if ($reference[0] === $pair[0] && $reference[1] === $pair[1]) {
                        return false;
                    }
                }
                return true;
            }));
        }
        self::reportResultOfMnReferenceCheck($missingReferences, "Missing");
        self::reportResultOfMnReferenceCheck($exceedingReferences, "Exceeding");
    }