/** * 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; }