/**
* Prepare list of columns to be updated
*
* @param Db_Object $object
* @return array (
* 'name'=>'somename',
* 'action'=>[drop/add/change],
* )
*/
public function prepareColumnUpdates()
{
$config = $this->_objectConfig->__toArray();
$updates = array();
if (!$this->tableExists()) {
$fields = array();
} else {
$fields = $this->_getExistingColumns();
}
/*
* Remove deprecated fields
*/
foreach ($fields as $k => $v) {
if (!array_key_exists($k, $config['fields'])) {
$updates[] = array('name' => $k, 'action' => 'drop', 'type' => 'field');
}
}
foreach ($config['fields'] as $name => $v) {
/*
* Add new field
*/
if (!array_key_exists($name, $fields)) {
$updates[] = array('name' => $name, 'action' => 'add');
continue;
}
$dataType = strtolower($fields[$name]['DATA_TYPE']);
/*
* Field type compare flag
*/
$typeCmp = false;
/*
* Field length compare flag
*/
$lenCmp = false;
/*
* IsNull compare flag
*/
$nullcmp = false;
/*
* Default value compare flag
*/
$defaultCmp = false;
/*
* Unsigned compare flag
*/
$unsignedCmp = false;
/**
* AUTO_INCREMENT compare flag
*
* @var bool
*/
$incrementCmp = false;
if ($v['db_type'] === 'boolean' && $dataType === 'tinyint') {
/*
* skip check for booleans
*/
} else {
if (strtolower($v['db_type']) !== $dataType) {
$typeCmp = true;
}
if (in_array($v['db_type'], self::$floatTypes, true)) {
if ($v['db_scale'] != $fields[$name]['SCALE'] || $v['db_precision'] != $fields[$name]['PRECISION']) {
$lenCmp = true;
}
} elseif (in_array($v['db_type'], self::$numTypes, true) && isset(Db_Object_Property::$numberLength[$v['db_type']])) {
$lenCmp = (string) Db_Object_Property::$numberLength[$v['db_type']] != (string) $fields[$name]['LENGTH'];
} else {
if (isset($v['db_len'])) {
$lenCmp = (string) $v['db_len'] != (string) $fields[$name]['LENGTH'];
}
}
/*
Auto set default '' for NOT NULL string properties
if(in_array($v['db_type'] , self::$charTypes , true) && (! isset($v['db_isNull']) || ! $v['db_isNull']) && (! isset($v['db_default']) || $v['db_default'] === false))
{
$v['db_default'] = '';
}
*/
if (in_array($v['db_type'], self::$textTypes, true)) {
if (isset($v['required']) && $v['required']) {
$v['db_isNull'] = false;
} else {
$v['db_isNull'] = true;
}
}
$nullcmp = (bool) $v['db_isNull'] !== (bool) $fields[$name]['NULLABLE'];
if ((!isset($v['db_unsigned']) || !$v['db_unsigned']) && $fields[$name]['UNSIGNED']) {
$unsignedCmp = true;
}
if (isset($v['db_unsigned']) && $v['db_unsigned'] && !$fields[$name]['UNSIGNED']) {
$unsignedCmp = true;
}
}
if (!(bool) $v['db_isNull'] && !in_array($v['db_type'], self::$dateTypes, true) && !in_array($v['db_type'], self::$textTypes, true)) {
if ((!isset($v['db_default']) || $v['db_default'] === false) && !is_null($fields[$name]['DEFAULT'])) {
$defaultCmp = true;
}
if (isset($v['db_default'])) {
if (is_null($fields[$name]['DEFAULT']) && $v['db_default'] !== false || !is_null($fields[$name]['DEFAULT']) && $v['db_default'] === false) {
$defaultCmp = true;
} else {
$defaultCmp = (string) $v['db_default'] != (string) $fields[$name]['DEFAULT'];
}
}
}
if ($fields[$name]['IDENTITY'] && $name != $this->_objectConfig->getPrimaryKey()) {
$incrementCmp = true;
}
if ($name == $this->_objectConfig->getPrimaryKey() && !$fields[$name]['IDENTITY']) {
$incrementCmp = true;
}
/*
* If not passed at least one comparison then rebuild the the field
*/
if ($typeCmp || $lenCmp || $nullcmp || $defaultCmp || $unsignedCmp || $incrementCmp) {
/*
* echo $this->_objectName.'<br>'; var_dump($v);
* var_dump($fields[$name]); echo 'type - ' . intval($typeCmp)."<br>";
* echo 'len - ' . intval($lenCmp)."<br>"; echo 'null - ' .
* intval($nullcmp)."<br>"; echo 'default - ' .
* intval($defaultCmp)."<br>"; echo 'unsigned - ' .
* intval($unsignedCmp)."<br>"; echo 'increment - ' .
* intval($incrementCmp)."<br>";
*/
$updates[] = array('name' => $name, 'action' => 'change');
}
}
return $updates;
}
