/**
* Generates Table schema for a model class using its metadata of members, relations, mixins and indexes.
* @param string $modelClassName
* @param $messageLogger
* @return array|bool
*/
public static function resolve($modelClassName, &$messageLogger)
{
if (empty($modelClassName) || !@class_exists($modelClassName) || !$modelClassName::getCanHaveBean()) {
return false;
}
$metadata = $modelClassName::getMetadata();
$modelMetadata = array();
if (isset($metadata[$modelClassName])) {
$modelMetadata = $metadata[$modelClassName];
}
$memberColumns = array();
$relationColumns = array();
$indexes = array();
$uniqueIndexesFromValidators = array();
$parentColumnName = null;
if (isset($modelMetadata['members'])) {
if (!isset($modelMetadata['rules'])) {
$errorMessage = Zurmo::t('Core', '{{model}} must have both, members and rules, set.', array('{{model}}' => $modelClassName));
$messageLogger->addErrorMessage($errorMessage);
throw new CException($errorMessage);
}
$memberColumns = RedBeanModelMemberRulesToColumnsAdapter::resolve($modelClassName, $modelMetadata['members'], $modelMetadata['rules'], $messageLogger);
$uniqueIndexesFromValidators = RedBeanModelMemberRulesToColumnAdapter::resolveUniqueIndexesFromValidator($modelClassName);
}
if (isset($modelMetadata['relations'])) {
$relationColumns = RedBeanModelRelationsToColumnsAdapter::resolve($modelClassName, $modelMetadata['relations'], $messageLogger);
}
if (isset($modelMetadata['indexes']) || !empty($uniqueIndexesFromValidators)) {
$indexesMetadata = $uniqueIndexesFromValidators;
if (!empty($modelMetadata['indexes'])) {
if (!empty($indexesMetadata)) {
$indexesMetadata = CMap::mergeArray($indexesMetadata, $modelMetadata['indexes']);
} else {
$indexesMetadata = $modelMetadata['indexes'];
}
}
if (!empty($indexesMetadata)) {
$indexes = RedBeanModelMemberIndexesMetadataAdapter::resolve($modelClassName, $indexesMetadata, $messageLogger);
}
}
$parentColumnName = RedBeanModelChildParentRelationshipToColumnAdapter::resolve($modelClassName);
if ($parentColumnName) {
$memberColumns[] = $parentColumnName;
}
$mixinColumns = RedBeanModelMixinsToColumnsAdapter::resolve($modelClassName, $messageLogger);
$columns = CMap::mergeArray($memberColumns, $mixinColumns, $relationColumns);
$tableName = $modelClassName::getTableName();
$schemaDefinition = array($tableName => array('columns' => $columns, 'indexes' => $indexes));
return $schemaDefinition;
}
/**
* @depends testResolveWithOnlyRequiredValidatorForMember
*/
public function testResolveWithMixedRules()
{
$modelClassName = 'AuditEvent';
$expectedColumns = array(array('name' => 'type', 'type' => 'INT(11)', 'unsigned' => null, 'notNull' => 'NULL', 'collation' => null, 'default' => 'DEFAULT NULL'), array('name' => 'modelclassname', 'type' => 'VARCHAR(64)', 'unsigned' => null, 'notNull' => 'NULL', 'collation' => 'COLLATE utf8_unicode_ci', 'default' => 'DEFAULT NULL'), array('name' => 'name', 'type' => 'VARCHAR(64)', 'unsigned' => null, 'notNull' => 'NULL', 'collation' => 'COLLATE utf8_unicode_ci', 'default' => 'DEFAULT NULL'), array('name' => 'subject', 'type' => 'VARCHAR(64)', 'unsigned' => null, 'notNull' => 'NULL', 'collation' => 'COLLATE utf8_unicode_ci', 'default' => 'DEFAULT NULL'), array('name' => 'language', 'type' => 'VARCHAR(2)', 'unsigned' => null, 'notNull' => 'NULL', 'collation' => 'COLLATE utf8_unicode_ci', 'default' => 'DEFAULT NULL'), array('name' => 'htmlcontent', 'type' => 'TEXT', 'unsigned' => null, 'notNull' => 'NULL', 'collation' => 'COLLATE utf8_unicode_ci', 'default' => 'DEFAULT NULL'), array('name' => 'textcontent', 'type' => 'TEXT', 'unsigned' => null, 'notNull' => 'NULL', 'collation' => 'COLLATE utf8_unicode_ci', 'default' => 'DEFAULT NULL'));
$members = array('type', 'modelClassName', 'name', 'subject', 'language', 'htmlContent', 'textContent');
$rules = array(array('type', 'required'), array('type', 'type', 'type' => 'integer'), array('type', 'numerical'), array('modelClassName', 'required'), array('modelClassName', 'type', 'type' => 'string'), array('modelClassName', 'length', 'max' => 64), array('modelClassName', 'ModelExistsAndIsReadableValidator'), array('name', 'required'), array('name', 'type', 'type' => 'string'), array('name', 'length', 'min' => 3, 'max' => 64), array('subject', 'required'), array('subject', 'type', 'type' => 'string'), array('subject', 'length', 'min' => 3, 'max' => 64), array('language', 'type', 'type' => 'string'), array('language', 'length', 'min' => 2, 'max' => 2), array('language', 'SetToUserDefaultLanguageValidator'), array('htmlContent', 'type', 'type' => 'string'), array('textContent', 'type', 'type' => 'string'), array('htmlContent', 'AtLeastOneContentAreaRequiredValidator'), array('textContent', 'AtLeastOneContentAreaRequiredValidator'), array('htmlContent', 'EmailTemplateMergeTagsValidator'), array('textContent', 'EmailTemplateMergeTagsValidator'));
$columns = RedBeanModelMemberRulesToColumnsAdapter::resolve($modelClassName, $members, $rules, static::$messageLogger);
$this->assertNotEmpty($columns);
$this->assertCount(7, $columns);
foreach ($columns as $index => $column) {
$this->assertCount(6, $column);
$this->assertArrayHasKey('name', $column);
$this->assertArrayHasKey('type', $column);
$this->assertArrayHasKey('unsigned', $column);
$this->assertArrayHasKey('notNull', $column);
$this->assertArrayHasKey('collation', $column);
$this->assertArrayHasKey('default', $column);
$this->assertEquals($expectedColumns[$index], $column);
}
}
