我正在使用Symfony框架和MySQL做一个web应用程序。我用条令来做ORM来映射数据库。我创建了模式,并执行了原则:migrations:diff来验证查询,并检查我的关系是否按顺序排列,它们看起来是否正确。但是,当我想将新模式迁移到MySQL时,会出现以下错误:描述错误的命令行的图片
这是商务舱
/**
* @ORM\Column(type="string")
*/
private $name;
/**
* @ORM\Column(type="string")
*/
private $stage_Of_Development;
//Relations
/**
* @ORM\ManyToOne(targetEntity="Client")
* @ORM\JoinColumn(name="client_email", referencedColumnName="clientEmail")
*/
private $client;
//Getters and Setters
/**
* @return mixed
*/
public function getClient()
{
return $this->client;
}
/**
* @param mixed $client
*/
public function setClient(Client $client)
{
$this->client = $client;
}
}
以下是客户端类:
<?php
/**
* @ORM\Entity
* @ORM\Table(name="client")
*/
class Client
{
/**
* @ORM\Id
* @ORM\Column(type="string", unique=true)
*/
private $clientEmail;
/**
* @return mixed
*/
public function getClientEmail()
{
return $this->clientEmail;
}
/**
* @param mixed $clientEmail
*/
public function setClientEmail($clientEmail)
{
$this->clientEmail = $clientEmail;
}
}
以下是迁移:
命名空间应用程序\迁移;
class Version20170325232622 extends AbstractMigration
{
/**
* @param Schema $schema
*/
public function up(Schema $schema)
{
// this up() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
$this->addSql('ALTER TABLE business ADD client_email VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE business ADD CONSTRAINT FK_8D36E3844FFE0C3 FOREIGN KEY (client_email) REFERENCES client (clientEmail)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_8D36E38A89DB457 ON business (business_id)');
$this->addSql('CREATE INDEX IDX_8D36E3844FFE0C3 ON business (client_email)');
}
/**
* @param Schema $schema
*/
public function down(Schema $schema)
{
// this down() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
$this->addSql('ALTER TABLE business DROP FOREIGN KEY FK_8D36E3844FFE0C3');
$this->addSql('DROP INDEX UNIQ_8D36E38A89DB457 ON business');
$this->addSql('DROP INDEX IDX_8D36E3844FFE0C3 ON business');
$this->addSql('ALTER TABLE business DROP client_email');
}
}
模式包含更多的类,客户端和业务实体包含更多的属性,但为了简单起见,我只发布了生成错误的属性。我将感谢任何人的帮助,因为这是我第一次使用这些技术,我有点迷路了。
在开发阶段,我经常必须“清除”以前的迁移,然后重新开始。如果您的数据库正在生产中,您不应该这样做!要重新开始,您可以删除数据库,重新创建它,删除以前的迁移,然后重新运行diff并迁移。在Symfony3中,我这样做:
// WARNING: This will delete your database!!!
>
> bin/console doctrine:database:drop --force
> bin/console doctrine:database:create
> rm -f app/DoctrineMigrations/*
>
> bin/console doctrine:migrations:diff
> bin/console doctrine:migrations:migrate