src/Propel/Generator/Model/Diff/ColumnComparator.php
<?php
/**
* MIT License. This file is part of the Propel package.
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
namespace Propel\Generator\Model\Diff;
use Propel\Generator\Model\Column;
/**
* Service class for comparing Column objects.
* Heavily inspired by Doctrine2's Migrations
* (see http://github.com/doctrine/dbal/tree/master/lib/Doctrine/DBAL/Schema/)
*/
class ColumnComparator
{
/**
* Compute and return the difference between two column objects
*
* @param \Propel\Generator\Model\Column $fromColumn
* @param \Propel\Generator\Model\Column $toColumn
*
* @return \Propel\Generator\Model\Diff\ColumnDiff|false return false if the two columns are similar
*/
public static function computeDiff(Column $fromColumn, Column $toColumn)
{
$changedProperties = self::compareColumns($fromColumn, $toColumn);
if ($changedProperties) {
if ($fromColumn->hasPlatform() || $toColumn->hasPlatform()) {
$platform = $fromColumn->hasPlatform() ? $fromColumn->getPlatform() : $toColumn->getPlatform();
if ($platform->getColumnDDL($fromColumn) == $platform->getColumnDDl($toColumn)) {
return false;
}
}
$columnDiff = new ColumnDiff($fromColumn, $toColumn);
$columnDiff->setChangedProperties($changedProperties);
return $columnDiff;
}
return false;
}
/**
* @param \Propel\Generator\Model\Column $fromColumn
* @param \Propel\Generator\Model\Column $toColumn
*
* @return array
*/
public static function compareColumns(Column $fromColumn, Column $toColumn): array
{
$changedProperties = [];
// compare column types
$fromDomain = $fromColumn->getDomain();
$toDomain = $toColumn->getDomain();
if ($fromDomain->getScale() !== $toDomain->getScale()) {
$changedProperties['scale'] = [$fromDomain->getScale(), $toDomain->getScale()];
}
if ($fromDomain->getSize() !== $toDomain->getSize()) {
$changedProperties['size'] = [$fromDomain->getSize(), $toDomain->getSize()];
}
$fromSqlType = $fromDomain->getSqlType() === null ?: strtoupper($fromDomain->getSqlType());
$toSqlType = $toDomain->getSqlType() === null ?: strtoupper($toDomain->getSqlType());
if ($fromSqlType !== $toSqlType) {
$changedProperties['sqlType'] = [$fromDomain->getSqlType(), $toDomain->getSqlType()];
if ($fromDomain->getType() !== $toDomain->getType()) {
$changedProperties['type'] = [$fromDomain->getType(), $toDomain->getType()];
}
}
if ($fromColumn->isNotNull() !== $toColumn->isNotNull()) {
$changedProperties['notNull'] = [$fromColumn->isNotNull(), $toColumn->isNotNull()];
}
// compare column default value
$fromDefaultValue = $fromColumn->getDefaultValue();
$toDefaultValue = $toColumn->getDefaultValue();
if ($fromDefaultValue && !$toDefaultValue) {
$changedProperties['defaultValueType'] = [$fromDefaultValue->getType(), null];
$changedProperties['defaultValueValue'] = [$fromDefaultValue->getValue(), null];
} elseif (!$fromDefaultValue && $toDefaultValue) {
$changedProperties['defaultValueType'] = [null, $toDefaultValue->getType()];
$changedProperties['defaultValueValue'] = [null, $toDefaultValue->getValue()];
} elseif ($fromDefaultValue) {
if (!$fromDefaultValue->equals($toDefaultValue)) {
if ($fromDefaultValue->getType() !== $toDefaultValue->getType()) {
$changedProperties['defaultValueType'] = [$fromDefaultValue->getType(), $toDefaultValue->getType()];
}
if ($fromDefaultValue->getValue() !== $toDefaultValue->getValue()) {
$changedProperties['defaultValueValue'] = [$fromDefaultValue->getValue(), $toDefaultValue->getValue()];
}
}
}
if ($fromColumn->isAutoIncrement() !== $toColumn->isAutoIncrement()) {
$changedProperties['autoIncrement'] = [$fromColumn->isAutoIncrement(), $toColumn->isAutoIncrement()];
}
return $changedProperties;
}
}