提问者:小点点

MySQL错误时迁移数据库模式,原则与Symfony


我正在使用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');
}
}

模式包含更多的类,客户端和业务实体包含更多的属性,但为了简单起见,我只发布了生成错误的属性。我将感谢任何人的帮助,因为这是我第一次使用这些技术,我有点迷路了。


共1个答案

匿名用户

在开发阶段,我经常必须“清除”以前的迁移,然后重新开始。如果您的数据库正在生产中,您不应该这样做!要重新开始,您可以删除数据库,重新创建它,删除以前的迁移,然后重新运行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