run(); } } /** * Declared columns the database lacks, by unprefixed table name. Extra live columns are fine. * * @return array */ public function missingColumns(): array { $missing = []; foreach (self::MIGRATIONS as $migration) { /** @var Migration $instance */ $instance = new $migration(); $columns = $instance->liveColumns(); if ($columns === []) { // The table is absent or unreadable. $missing[$instance->tableName()] = $instance->columnNames(); continue; } $absent = array_values(array_diff($instance->columnNames(), $columns)); if ($absent !== []) { $missing[$instance->tableName()] = $absent; } } return $missing; } /** Whether one table has every declared column; cheaper than isCurrent() for a one-table reader. */ public function tableIsCurrent(string $table): bool { foreach (self::MIGRATIONS as $migration) { /** @var Migration $instance */ $instance = new $migration(); if ($instance->tableName() !== $table) { continue; } $columns = $instance->liveColumns(); return $columns !== [] && array_diff($instance->columnNames(), $columns) === []; } return false; } public function isCurrent(): bool { return $this->missingColumns() === []; } /** * Declared UNIQUE keys the database lacks. dbDelta adds keys in a separate ALTER a duplicate can * refuse, so isCurrent() alone would pass a schema whose write path is unsafe. * * @return array */ public function missingUniqueKeys(): array { $missing = []; foreach (self::MIGRATIONS as $migration) { /** @var Migration $instance */ $instance = new $migration(); foreach ($instance->uniqueKeyNames() as $key) { if (! $instance->hasIndex($key)) { $missing[$instance->tableName()][] = $key; } } } return $missing; } }