public function alterSchema() { $empresa = $this->estrutura[EstruturaQuery::COMPANY]; $schemas = $this->intersect_homolog_devQuery(); $string = ""; if (!empty($schemas)) { foreach ($schemas as $schema) { $string .= "\n\n\n\n------------------------------ ALTER SCHEMA ------------------------------"; $string .= $this->setSchema($schema); $sequence = new SequenceBO($empresa, $schema); $string .= $sequence->dropSequence(); $sequenceParameter = $sequence->diff_dev_homologQuery(); $string .= $sequence->createSequence(); $tabela = new TabelaBO($empresa, $schema, $sequenceParameter, $this->estrutura); $string .= $tabela->dropTable(); $string .= $tabela->createTable(); $string .= $tabela->alterTable(); $funcao = new FuncaoBO($empresa, $schema); $string .= $funcao->dropFuncao(); $string .= $funcao->createFuncao(); } } return $string; }
$connection = $argv[2]; } } elseif (isset($_GET['empresa'])) { $dbCompany = $_GET['empresa']; if (isset($_GET['connection'])) { $connection = $_GET['connection']; } $cmd = false; } else { $dbCompany = "test"; $cmd = false; } $saida = new Saida($dbCompany, $cmd, $connection); $schema = new SchemaBO(); $sequence = new SequenceBO(); $funcao = new FuncaoBO(); $tabela = new TabelaBO(); $trigger = new TriggerBO(); $indice = new IndiceBO(); $coluna = new ColunaBO(); $constraint = new ConstraintBO(); /* AssemblerBO::devTree(); AssemblerBO::homologTree(); $saida->gravar($schema->listar()); $saida->gravar($sequence->listar()); $saida->gravar($funcao->listar()); $saida->gravar($tabela->listar()); $saida->gravar($trigger->listar()); $saida->gravar($indice->listar());