/**
* Adds externalSystemId column to specific table if it does not exist
* @param $tableName
* @param $maxLength
* @param $columnName
*/
public static function addExternalIdColumnIfMissing($tableName, $maxLength = 255, $columnName = null)
{
if (!isset($columnName)) {
$columnName = static::EXTERNAL_SYSTEM_ID_COLUMN_NAME;
}
// check if external_system_id exists in fields
$columnExists = ZurmoRedBean::$writer->doesColumnExist($tableName, $columnName);
if (!$columnExists) {
// if not, update model and add an external_system_id field
$type = 'string';
$length = null;
RedBeanModelMemberRulesToColumnAdapter::resolveStringTypeAndLengthByMaxLength($type, $length, $maxLength);
$columns = array();
$columns[] = RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($columnName, $type, $length);
$schema = CreateOrUpdateExistingTableFromSchemaDefinitionArrayUtil::getTableSchema($tableName, $columns);
CreateOrUpdateExistingTableFromSchemaDefinitionArrayUtil::generateOrUpdateTableBySchemaDefinition($schema, new MessageLogger());
}
}
protected static function getReservedColumnMetadata()
{
$columns = array();
$reservedColumnsTypes = array('status' => 'integer', 'serializedMessages' => 'string', 'analysisStatus' => 'integer', 'serializedAnalysisMessages' => 'string');
foreach ($reservedColumnsTypes as $columnName => $type) {
$length = null;
$unsigned = null;
if ($type === 'string') {
// populate the proper type given it would be 1024 char string depending on db type.
RedBeanModelMemberRulesToColumnAdapter::resolveStringTypeAndLengthByMaxLength($type, $length, 1024);
} else {
// forcing integers to be unsigned
$unsigned = DatabaseCompatibilityUtil::resolveUnsignedByHintType($type, false);
}
// last argument is false because we do not want these column names to be resolved to lower characters
$columns[] = RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($columnName, $type, $length, $unsigned, null, null, null, false);
}
return $columns;
}
