Version20140528154337.php
1.39 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
<?php
namespace Cacic\CommonBundle\Migrations;
use Symfony\Component\DependencyInjection\ContainerAwareInterface;
use Symfony\Component\DependencyInjection\ContainerInterface;
use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;
/**
* Auto-generated Migration: Please modify to your needs!
*/
class Version20140528154337 extends AbstractMigration implements ContainerAwareInterface
{
private $container;
public function setContainer(ContainerInterface $container = null)
{
$this->container = $container;
}
public function up(Schema $schema)
{
// this up() migration is auto-generated, please modify it to your needs
$em = $this->container->get('doctrine.orm.entity_manager');
$logger = $this->container->get('logger');
$modulos = $em->getRepository('CacicCommonBundle:Acao')->findBy( array('csOpcional' => 'N') );
foreach ($modulos as $elm) {
// PEga todos os módulos que são opcionais e remove da tabela acao_rede
$acoes = $em->getRepository('CacicCommonBundle:AcaoRede')->findBy( array('acao' => $elm->getIdAcao() ) );
foreach ($acoes as $acao) {
$em->remove($acao);
}
}
$em->flush();
}
public function down(Schema $schema)
{
// this down() migration is auto-generated, please modify it to your needs
}
}