public function listar() { $string = ""; $string .= parent::lista(parent::$dev['indices'], "DEV INDICE"); $string .= parent::lista(parent::$homolog['indices'], "HOMOLOG INDICE"); return $string; }
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; }
$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()); $saida->gravar($tabela->alterTableDropColumnHomolog()); $saida->gravar($tabela->alterTableAddColumnHomolog()); $saida->gravar($tabela->alterTableAlterColumnHomolog()); $tabelasArray = $tabela->arrayTabelas(); echo "<pre>"; print_r($tabelasArray); // print_r($schema->arrayHomolog()); echo "</pre>"; if (isset($tabelasArray)) { foreach ($tabelasArray as $tabelaNome) { $constraint = new ConstraintBO($empresa, $tabelaNome); $saida->gravar($constraint->dropConstraintHomolog()); echo "<pre>";
} } 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()); $saida->gravar($coluna->listar());