Exemple #1
0
$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>";
            echo "<H1>DIFF</H1>";