Symfony2 Doctrine2 - 通过 doctine:mapping:import 从现有数据库生成一对多注释 [英] Symfony2 Doctrine2 - generate One-To-Many annotation from existing database by doctrine:mapping:import
问题描述
我想通过使用 Doctrine 工具进行逆向工程从现有数据库生成实体
I want to generate Entities from an Existing Database by using Doctrine tools for reverse engineering
/*
* SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `country`
-- ----------------------------
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `provider`
-- ----------------------------
DROP TABLE IF EXISTS `provider`;
CREATE TABLE `provider` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `provider_country`
-- ----------------------------
DROP TABLE IF EXISTS `provider_country`;
CREATE TABLE `provider_country` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`providerId` int(11) unsigned NOT NULL,
`countryId` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_provider_has_id0_idx` (`providerId`),
KEY `fk_user_country_idx` (`countryId`),
CONSTRAINT `fk_rss_has_id` FOREIGN KEY (`providerId`) REFERENCES `provider` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_user_country` FOREIGN KEY (`countryId`) REFERENCES `country` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=1;
*/
您可以通过执行以下两个命令让 Doctrine 导入架构并构建相关实体类.
you can ask Doctrine to import the schema and build related entity classes by executing the following two commands.
1 $ php app/console algorithm:mapping:import AcmeBlogBundle注解
2 $ php app/console algorithm:generate:entities AcmeBlogBundle
但现在该学说仅检测多方ProviderCountry"表中的多对一关系
but now the doctrine detect only ManyToOne relation in many side only "ProviderCountry" table
如果我需要添加 OneToMany 关系，我必须通过添加以下注释来手动添加注释
if i need to add the OneToMany relation i have to add the annotation by my hand by adding the follwing annotation
在Provider.php中添加
in Provider.php add
/**
* @ORMOneToMany(targetEntity="ProviderCountry", mappedBy="providerId", cascade={"persist"})
*/
private $datas;
在 ProviderCountry.php 添加
in ProviderCountry.php add
/**
* @var Provider
*
* @ORMManyToOne(targetEntity="Provider", inversedBy = "datas")
* @ORMJoinColumn(name="providerId", referencedColumnName="id")
*/
private $userid;
那么我如何通过学说命令生成一对多注释
so how can I genrate One-To-Many annotation by doctrine command
推荐答案
简单的说就是orm lib里面的变化，
Simply this is change inside doctrine orm lib,
你可以通过修改
vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/DatabaseDriver.php
vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/DatabaseDriver.php
替换以下语句
foreach ($foreignKeys as $foreignKey) {
$foreignTable = $foreignKey->getForeignTableName();
$cols = $foreignKey->getColumns();
$fkCols = $foreignKey->getForeignColumns();
$localColumn = current($cols);
$associationMapping = array();
$associationMapping['fieldName'] = $this->getFieldNameForColumn($tableName, $localColumn, true);
$associationMapping['targetEntity'] = $this->getClassNameForTable($foreignTable);
if ($primaryKeyColumns && in_array($localColumn, $primaryKeyColumns)) {
$associationMapping['id'] = true;
}
for ($i = 0; $i < count($cols); $i++) {
$associationMapping['joinColumns'][] = array(
'name' => $cols[$i],
'referencedColumnName' => $fkCols[$i],
);
}
//Here we need to check if $cols are the same as $primaryKeyColums
if (!array_diff($cols, $primaryKeyColumns)) {
$metadata->mapOneToOne($associationMapping);
} else {
$metadata->mapManyToOne($associationMapping);
}
}
改为
foreach ($foreignKeys as $foreignKey) {
$foreignTable = $foreignKey->getForeignTableName();
$cols = $foreignKey->getColumns();
$fkCols = $foreignKey->getForeignColumns();
$localColumn = current($cols);
$associationMapping = array();
$associationMapping['fieldName'] = $this->getFieldNameForColumn($tableName, $localColumn, true);
$associationMapping['targetEntity'] = $this->getClassNameForTable($foreignTable);
for ($i = 0; $i < count($cols); $i++) {
$associationMapping['joinColumns'][] = array(
'name' => $cols[$i],
'referencedColumnName' => $fkCols[$i],
);
}
$metadata->mapManyToOne($associationMapping);
}
foreach ($this->tables as $tableCandidate) {
if ($this->_sm->getDatabasePlatform()->supportsForeignKeyConstraints()) {
$foreignKeysCandidate = $tableCandidate->getForeignKeys();
} else {
$foreignKeysCandidate = array();
}
foreach ($foreignKeysCandidate as $foreignKey) {
$foreignTable = $foreignKey->getForeignTableName();
if ($foreignTable == $tableName && !isset($this->manyToManyTables[$tableCandidate->getName()])) {
$fkCols = $foreignKey->getForeignColumns();
$cols = $foreignKey->getColumns();
$localColumn = current($cols);
$associationMapping = array();
$associationMapping['fieldName'] = $this->getFieldNameForColumn($tableCandidate->getName(), $tableCandidate->getName(), true);
$associationMapping['targetEntity'] = $this->getClassNameForTable($tableCandidate->getName());
$associationMapping['mappedBy'] = $this->getFieldNameForColumn($tableCandidate->getName(), $localColumn, true);
try {
$primaryKeyColumns = $tableCandidate->getPrimaryKey()->getColumns();
if (count($primaryKeyColumns) == 1) {
$indexColumn = current($primaryKeyColumns);
$associationMapping['indexBy'] = $indexColumn;
}
} catch (SchemaException $e) {
}
$metadata->mapOneToMany($associationMapping);
}
}
}
现在，如果你运行学说:映射:导入
now if you run doctrine:mapping:import
你会发现 OneToMany 注释.
you will find OneToMany annotation.
然后运行学说:生成:实体
then run doctrine:generate:entities
你会发现两边都是单向的关系.
you will find A unidirectional relationship on both sides.
这篇关于Symfony2 Doctrine2 - 通过 doctine:mapping:import 从现有数据库生成一对多注释的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
