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());
