/**
* 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());
}
}
/**
* Provided modelClassName and rules for a member we resolve a column in table.
* @param string $modelClassName
* @param array $rules
* @param $messageLogger
* @return array|bool
*/
public static function resolve($modelClassName, array $rules, &$messageLogger)
{
if (empty($rules)) {
return false;
}
$member = $rules[0][0];
assert('strpos($member, " ") === false');
$name = RedBeanModelMemberToColumnUtil::resolve($member);
$type = null;
$length = null;
$notNull = null;
$default = null;
static::resolveColumnTypeAndLengthFromRules($modelClassName, $member, $rules, $type, $length, $notNull, $default, $messageLogger);
if (!isset($type)) {
return false;
}
return RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($name, $type, $length, null, $notNull, $default, null);
}
protected static function resolvePolymorphicTypeColumnByLinkName($linkName)
{
$linkName .= '_type';
return RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($linkName);
}
protected function createImportTempTable($columnCount, $tableName)
{
$importColumns = array();
for ($i = 0; $i < $columnCount; $i++) {
$columnName = 'column_' . $i;
$importColumns[] = RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($columnName, 'string', 50);
}
ImportDatabaseUtil::createTableByTableNameAndImportColumns($tableName, $importColumns);
}
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;
}
/**
* @depends testResolveForeignKeyColumnMetadataWithRelatedModelClassName
*/
public function testResolveColumnMetadataByHintTypeWithStringWithoutId()
{
$unresolvedName = 'memberNameGoesHere';
$columnDefinition = RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($unresolvedName);
$this->assertNotEmpty($columnDefinition);
$this->assertCount(6, $columnDefinition);
$this->assertArrayHasKey('name', $columnDefinition);
$this->assertEquals('membernamegoeshere', $columnDefinition['name']);
$this->assertArrayHasKey('type', $columnDefinition);
$this->assertEquals('VARCHAR(255)', $columnDefinition['type']);
$this->assertArrayHasKey('unsigned', $columnDefinition);
$this->assertNull($columnDefinition['unsigned']);
$this->assertArrayHasKey('notNull', $columnDefinition);
$this->assertEquals('NULL', $columnDefinition['notNull']);
// Not Coding Standard
$this->assertArrayHasKey('collation', $columnDefinition);
$this->assertEquals('COLLATE utf8_unicode_ci', $columnDefinition['collation']);
$this->assertArrayHasKey('default', $columnDefinition);
$this->assertEquals('DEFAULT NULL', $columnDefinition['default']);
// Not Coding Standard
$this->assertArrayNotHasKey('length', $columnDefinition);
}
