public function cargaSeqGerenciamento()
{
$sequences = $this->intersect_homolog_devQuery();
if (isset($sequences)) {
foreach ($sequences as $sequence) {
GerenciadorSequence::adicionaCriados($sequence);
}
}
}
public function retorna($valor, $fase, $condicao, $estrutura)
{
$schema = $estrutura[EstruturaQuery::SCHEMA];
$tabela = $estrutura[EstruturaQuery::TABELA];
$coluna = $estrutura[EstruturaQuery::COLUNA];
$sequences = $estrutura[EstruturaQuery::SEQUENCE];
GerenciadorSequence::sobreCarregaCriados($sequences);
$sequences = GerenciadorSequence::getCriados();
$string = "";
if (isset($valor)) {
if (substr($valor, 0, strlen("nextval('")) == "nextval('" && $fase != FaseQuery::CREATE) {
$fimSequence = strpos($valor, "':") - strlen("nextval('");
$sequence = substr($valor, strlen("nextval('"), $fimSequence);
if ($schema == "public") {
$sequence = "public." . $sequence;
}
if (isset($sequences)) {
if (!in_array($sequence, $sequences)) {
GerenciadorSequence::adicionaCriados($sequence);
$createSequence = "\n\n-------------------- CREATE DA SEQUENCE --------------------";
$createSequence .= "\nCREATE SEQUENCE {$sequence};";
GerenciadorSequence::adicionaQueryCriado($createSequence);
$setSequence = "\n\n-------------------- SET DA SEQUENCE --------------------";
$setSequence .= "\nSELECT setval('{$sequence}', MAX({$coluna})) FROM {$tabela};";
GerenciadorSequence::adicionaQuerySetado($setSequence);
} else {
$setSequence = "\n\n-------------------- SET DA SEQUENCE --------------------";
$setSequence .= "\nSELECT setval('{$sequence}', MAX({$coluna})) FROM {$tabela};";
GerenciadorSequence::adicionaQuerySetado($setSequence);
}
}
}
switch ($fase) {
case FaseQuery::CREATE:
$string = " DEFAULT {$valor} ";
break;
case FaseQuery::ADD:
$string = "\n\tDEFAULT {$valor} ";
break;
case FaseQuery::ALTER:
$string = "\nALTER TABLE {$tabela} ALTER COLUMN {$coluna} DROP DEFAULT;";
$string .= "\nALTER TABLE {$tabela} ALTER COLUMN {$coluna} SET DEFAULT {$valor};";
break;
default:
break;
}
return $string;
}
}
