Subversion Repositories bacoAlunos

ESTG NOVEMBRO DE 2017

correr o ant -> generateUpdateHibernateUpdateSql

SELECT * FROM baco4.repositoryfileversion where mirrorFileVersionId is not null;

Para todos os encontrados colocar manualmente o valor do mirror no novo campo
seguir os comandos

mirroredFileVersion

apagar o campo mirrorFileVersionId

update repositoryfileversion set mirroredFileVersion = mirrorFileVersionId;

ALTER TABLE repositoryfileversion DROP COLUMN mirrorFileVersionId;



Atualizacao do relatorio de avaliacao das unidades curriculares

update courseunitevaluation set numAlunosInscritos = 0 where numAlunosInscritos is null;
update courseunitevaluation set numAlunosSemElementosAvaliacao = 0 where numAlunosSemElementosAvaliacao is null;
update courseunitevaluation set numAlunosAprovFrequencia = 0 where numAlunosAprovFrequencia is null;
update courseunitevaluation set numAlunosAprovNormal = 0 where numAlunosAprovNormal is null;
update courseunitevaluation set numAlunosAprovRecurso = 0 where numAlunosAprovRecurso is null;
update courseunitevaluation set numAlunosAprovTotal = 0 where numAlunosAprovTotal is null;
update courseunitevaluation set numAlunosAprov1013 = 0 where numAlunosAprov1013 is null;
update courseunitevaluation set numAlunosAprov1416 = 0 where numAlunosAprov1416 is null;
update courseunitevaluation set numAlunosAprov1720 = 0 where numAlunosAprov1720 is null;
update courseunitevaluation set numAlunosAprovados = 0 where numAlunosAprovados is null;
update courseunitevaluation set numAlunosReprovados = 0 where numAlunosReprovados is null;
update courseunitevaluation set numAlunosAprov1013Percent = 0 where numAlunosAprov1013Percent is null;
update courseunitevaluation set numAlunosAprov1416Percent = 0 where numAlunosAprov1416Percent is null;
update courseunitevaluation set numAlunosAprov1720Percent = 0 where numAlunosAprov1720Percent is null;



update courseunitevaluation set numAlunosAprov1013Percent = numAlunosAprov1013;
update courseunitevaluation set numAlunosAprov1416Percent = numAlunosAprov1416;
update courseunitevaluation set numAlunosAprov1720Percent = numAlunosAprov1720;

ALTER TABLE courseunitevaluation DROP COLUMN numAlunosAprovados;


update courseunitevaluation set numAlunosAprov1013 = numAlunosAprov1013Percent * numAlunosAprovTotal / 100 where id > 683;
update courseunitevaluation set numAlunosAprov1416 = numAlunosAprov1416Percent * numAlunosAprovTotal / 100 where id > 683;
update courseunitevaluation set numAlunosAprov1720 = numAlunosAprov1720Percent * numAlunosAprovTotal / 100 where id > 683;