/**
* @param LoggerInterface $logger
* @param bool $dryRun
*/
protected function runActivityLists(LoggerInterface $logger, $dryRun = false)
{
// @todo: this workaround should be removed in BAP-9156
$this->configManager->clear();
$targetEntities = $this->provider->getTargetEntityClasses(false);
$toSchema = clone $this->schema;
$hasSchemaChanges = false;
foreach ($targetEntities as $targetEntity) {
$associationName = ExtendHelper::buildAssociationName($targetEntity, ActivityListEntityConfigDumperExtension::ASSOCIATION_KIND);
$relationTableName = $this->nameGenerator->generateManyToManyJoinTableName(ActivityListEntityConfigDumperExtension::ENTITY_CLASS, $associationName, $targetEntity);
if (!$toSchema->hasTable($relationTableName)) {
$hasSchemaChanges = true;
$this->activityListExtension->addActivityListAssociation($toSchema, $this->metadataHelper->getTableNameByEntityClass($targetEntity));
}
}
if ($hasSchemaChanges) {
$comparator = new Comparator();
$platform = $this->connection->getDatabasePlatform();
$schemaDiff = $comparator->compare($this->schema, $toSchema);
$queries = $schemaDiff->toSql($platform);
foreach ($queries as $query) {
$this->logQuery($logger, $query);
if (!$dryRun) {
$this->connection->executeQuery($query);
}
}
}
}
public function testGetTableNameByEntityClass()
{
$metadata = $this->getMockBuilder('Doctrine\\ORM\\Mapping\\ClassMetadata')->disableOriginalConstructor()->getMock();
$metadata->expects($this->once())->method('getTableName')->will($this->returnValue('acme_test'));
$metadata->expects($this->once())->method('getName')->will($this->returnValue('Oro\\Bundle\\EntityBundle\\Tests\\Unit\\ORM\\Fixtures\\TestEntity'));
$metadataFactory = $this->getMockBuilder('Doctrine\\ORM\\Mapping\\ClassMetadataFactory')->disableOriginalConstructor()->getMock();
$metadataFactory->expects($this->once())->method('getAllMetadata')->will($this->returnValue([$metadata]));
$em = $this->getMockBuilder('Doctrine\\ORM\\EntityManager')->disableOriginalConstructor()->getMock();
$em->expects($this->once())->method('getMetadataFactory')->will($this->returnValue($metadataFactory));
$this->doctrine->expects($this->once())->method('getManagers')->will($this->returnValue(array('default' => $em)));
$this->doctrine->expects($this->once())->method('getManager')->with($this->equalTo('default'))->will($this->returnValue($em));
$this->assertEquals('acme_test', $this->helper->getTableNameByEntityClass('Oro\\Bundle\\EntityBundle\\Tests\\Unit\\ORM\\Fixtures\\TestEntity'));
}
/**
* @param LoggerInterface $logger
* @param bool $dryRun
*/
protected function addActivityContactColumns(LoggerInterface $logger, $dryRun = false)
{
$hasSchemaChanges = false;
$toSchema = clone $this->schema;
$contactingActivityClasses = $this->activityContactProvider->getSupportedActivityClasses();
$entities = $this->getConfigurableEntitiesData($logger);
foreach ($entities as $entityClassName => $config) {
if (isset($config['extend']['is_extend'], $config['activity']['activities']) && $config['extend']['is_extend'] == true && $config['activity']['activities'] && array_intersect($contactingActivityClasses, $config['activity']['activities'])) {
if (isset($config['extend']['schema']['doctrine'][$entityClassName]['table'])) {
$tableName = $config['extend']['schema']['doctrine'][$entityClassName]['table'];
} else {
$tableName = $this->metadataHelper->getTableNameByEntityClass($entityClassName);
}
// Process only existing tables
if (!$toSchema->hasTable($tableName)) {
continue;
}
$table = $toSchema->getTable($tableName);
$tableColumns = $table->getColumns();
/**
* Check if entity already has all needed columns.
* If at least one is not present we should check and add it.
*/
if (false === (bool) array_diff(array_keys(ActivityScope::$fieldsConfiguration), array_intersect(array_keys($tableColumns), array_keys(ActivityScope::$fieldsConfiguration)))) {
continue;
}
foreach (ActivityScope::$fieldsConfiguration as $fieldName => $fieldConfig) {
if (!$table->hasColumn($fieldName)) {
$hasSchemaChanges = true;
$table->addColumn($fieldName, $fieldConfig['type'], ['notnull' => false, OroOptions::KEY => array_merge([ExtendOptionsManager::MODE_OPTION => $fieldConfig['mode']], $fieldConfig['options'])]);
}
}
}
}
if ($hasSchemaChanges) {
// Run schema related SQLs manually because this query run when diff is already calculated by schema tool
$comparator = new Comparator();
$platform = $this->connection->getDatabasePlatform();
$schemaDiff = $comparator->compare($this->schema, $toSchema);
foreach ($schemaDiff->toSql($platform) as $query) {
$this->logQuery($logger, $query);
if (!$dryRun) {
$this->connection->query($query);
}
}
}
}
/**
* @param $config
* @param $entityClassName
*
* @return string
*/
protected function getTableName($config, $entityClassName)
{
if (isset($config['extend']['schema']['doctrine'][$entityClassName]['table'])) {
$tableName = $config['extend']['schema']['doctrine'][$entityClassName]['table'];
} else {
$tableName = $this->metadataHelper->getTableNameByEntityClass($entityClassName);
}
return $tableName;
}
protected function renameOneToManyExtendField(Schema $schema, QueryBag $queries, Table $table, $associationName, $targetEntityClassName, EntityMetadataHelper $entityMetadataHelper)
{
$entityClassName = $entityMetadataHelper->getEntityClassByTableName($table->getName());
$targetTableName = $entityMetadataHelper->getTableNameByEntityClass($targetEntityClassName);
if ($schema->hasTable($targetTableName)) {
$targetTable = $schema->getTable($targetTableName);
$oldTargetColumnName = sprintf('field_%s_%s_id', strtolower(ExtendHelper::getShortClassName($entityClassName)), $associationName);
if ($targetTable->hasColumn($oldTargetColumnName)) {
$newTargetColumnName = $this->nameGenerator->generateOneToManyRelationColumnName($entityClassName, $associationName);
$oldIndexName = $this->nameGenerator->generateIndexName($targetTableName, [$oldTargetColumnName], false, true);
if ($targetTable->hasIndex($oldIndexName)) {
$targetTable->dropIndex($oldIndexName);
}
$oldForeignKeyName = $this->nameGenerator->generateForeignKeyConstraintName($targetTableName, [$oldTargetColumnName], true);
if ($targetTable->hasForeignKey($oldForeignKeyName)) {
$targetTable->removeForeignKey($oldForeignKeyName);
}
$this->renameExtension->renameColumn($schema, $queries, $targetTable, $oldTargetColumnName, $newTargetColumnName);
$this->renameExtension->addIndex($schema, $queries, $targetTable->getName(), [$newTargetColumnName]);
$this->renameExtension->addForeignKeyConstraint($schema, $queries, $targetTable->getName(), $table->getName(), [$newTargetColumnName], $table->getPrimaryKeyColumns(), ['onDelete' => 'SET NULL']);
}
}
}
/**
* Gets a table name by entity full class name
*
* @param string $className
*
* @return string|null
*/
public function getTableNameByEntityClass($className)
{
return $this->entityMetadataHelper->getTableNameByEntityClass($className);
}
