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); $string .= $tabela->createTable(); } } return $string; }
} if (isset($argv[1])) { $empresa = $argv[1]; $cmd = true; } elseif (isset($_GET['empresa'])) { $empesa = $_GET['empresa']; $cmd = false; } else { $empresa = "teste"; $cmd = false; } $saida = new Saida($empresa, $cmd); $saida->open(); $schema = new SchemaBO($empresa); $schemasArray = $schema->arrayHomolog(); $sequence = new SequenceBO($empresa); $saida->gravarDataBase(); $saida->gravar($schema->listarDev()); $saida->gravar($schema->listarHomolog()); $saida->gravar($schema->dropSchemaHomolog()); $saida->gravar($schema->createSchemaHomolog()); echo "<pre>"; // print_r($schema->dropSchemaHomolog()); // print_r($schema->arrayHomolog()); echo "</pre>"; $saida->gravar($sequence->dropSequenceHomolog()); foreach ($schemasArray as $schemaNome) { $saida->gravar($schema->setSchema($schemaNome)); $tabela = new TabelaBO($empresa, $schemaNome); $saida->gravar($tabela->dropTableHomolog()); $saida->gravar($tabela->createTableHomolog());
if (isset($argv[2])) { $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());