WebSVN - bacoAlunos - Diff - Rev 1834 and 1841 - /branches/v3/impl/src/updates/version/updateRepositorioDigital


ESTG NOVEMBRO DE 2017
 
correr o ant -> generateUpdateHibernateSql
 
SELECT * FROM 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
 
 
 
 
 
Atualizacao do relatorio de avaliacao das unidades curriculares
 
SELECT * FROM repositoryfileversion where mirrorFileVersionId is not null;
 
 
update repositoryfileversion set mirroredFileVersion = mirrorFileVersionId;
 
SELECT * FROM repositoryfileversion where mirroredFileVersion is not null;
 
ALTER TABLE repositoryfileversion DROP COLUMN mirrorFileVersionId;
 
 
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;
 
 
ALTER TABLE courseunitevaluation CHANGE COLUMN numAlunosInscritos numAlunosInscritos INT(10) NULL DEFAULT 0 ;

Subversion Repositories bacoAlunos

(root)/branches/v3/impl/src/updates/version/updateRepositorioDigital @ 1831 - Rev 1834 → 1841

Rev 1834		Rev 1841
1	ESTG NOVEMBRO DE 2017	1	ESTG NOVEMBRO DE 2017
2		2
3	correr o ant -> generateUpdateHibernateSql	3	correr o ant -> generateUpdateHibernateSql
4		4
5	SELECT * FROM repositoryfileversion where mirrorFileVersionId is not null;	5	SELECT * FROM repositoryfileversion where mirrorFileVersionId is not null;
6		6
7	Para todos os encontrados colocar manualmente o valor do mirror no novo campo	7	Para todos os encontrados colocar manualmente o valor do mirror no novo campo
8	seguir os comandos	8	seguir os comandos
9		9
10	mirroredFileVersion	10	mirroredFileVersion
11		11
12	apagar o campo mirrorFileVersionId	12	apagar o campo mirrorFileVersionId
13		13
14		14
15		15
16		16
17		17
18	Atualizacao do relatorio de avaliacao das unidades curriculares	18	Atualizacao do relatorio de avaliacao das unidades curriculares
19		19
20	SELECT * FROM repositoryfileversion where mirrorFileVersionId is not null;	20	SELECT * FROM repositoryfileversion where mirrorFileVersionId is not null;
21		21
22		22
23	update repositoryfileversion set mirroredFileVersion = mirrorFileVersionId;	23	update repositoryfileversion set mirroredFileVersion = mirrorFileVersionId;
24		24
25	SELECT * FROM repositoryfileversion where mirroredFileVersion is not null;	25	SELECT * FROM repositoryfileversion where mirroredFileVersion is not null;
26		26
27	ALTER TABLE repositoryfileversion DROP COLUMN mirrorFileVersionId;	27	ALTER TABLE repositoryfileversion DROP COLUMN mirrorFileVersionId;
28		28
29		29
30	update courseunitevaluation set numAlunosInscritos = 0 where numAlunosInscritos is null;	30	update courseunitevaluation set numAlunosInscritos = 0 where numAlunosInscritos is null;
31	update courseunitevaluation set numAlunosSemElementosAvaliacao = 0 where numAlunosSemElementosAvaliacao is null;	31	update courseunitevaluation set numAlunosSemElementosAvaliacao = 0 where numAlunosSemElementosAvaliacao is null;
32	update courseunitevaluation set numAlunosAprovFrequencia = 0 where numAlunosAprovFrequencia is null;	32	update courseunitevaluation set numAlunosAprovFrequencia = 0 where numAlunosAprovFrequencia is null;
33	update courseunitevaluation set numAlunosAprovNormal = 0 where numAlunosAprovNormal is null;	33	update courseunitevaluation set numAlunosAprovNormal = 0 where numAlunosAprovNormal is null;
34	update courseunitevaluation set numAlunosAprovRecurso = 0 where numAlunosAprovRecurso is null;	34	update courseunitevaluation set numAlunosAprovRecurso = 0 where numAlunosAprovRecurso is null;
35	update courseunitevaluation set numAlunosAprovTotal = 0 where numAlunosAprovTotal is null;	35	update courseunitevaluation set numAlunosAprovTotal = 0 where numAlunosAprovTotal is null;
36	update courseunitevaluation set numAlunosAprov1013 = 0 where numAlunosAprov1013 is null;	36	update courseunitevaluation set numAlunosAprov1013 = 0 where numAlunosAprov1013 is null;
37	update courseunitevaluation set numAlunosAprov1416 = 0 where numAlunosAprov1416 is null;	37	update courseunitevaluation set numAlunosAprov1416 = 0 where numAlunosAprov1416 is null;
38	update courseunitevaluation set numAlunosAprov1720 = 0 where numAlunosAprov1720 is null;	38	update courseunitevaluation set numAlunosAprov1720 = 0 where numAlunosAprov1720 is null;
39	update courseunitevaluation set numAlunosAprovados = 0 where numAlunosAprovados is null;	39	update courseunitevaluation set numAlunosAprovados = 0 where numAlunosAprovados is null;
40	update courseunitevaluation set numAlunosReprovados = 0 where numAlunosReprovados is null;	40	update courseunitevaluation set numAlunosReprovados = 0 where numAlunosReprovados is null;
41	update courseunitevaluation set numAlunosAprov1013Percent = 0 where numAlunosAprov1013Percent is null;	41	update courseunitevaluation set numAlunosAprov1013Percent = 0 where numAlunosAprov1013Percent is null;
42	update courseunitevaluation set numAlunosAprov1416Percent = 0 where numAlunosAprov1416Percent is null;	42	update courseunitevaluation set numAlunosAprov1416Percent = 0 where numAlunosAprov1416Percent is null;
43	update courseunitevaluation set numAlunosAprov1720Percent = 0 where numAlunosAprov1720Percent is null;	43	update courseunitevaluation set numAlunosAprov1720Percent = 0 where numAlunosAprov1720Percent is null;
44		44
45		45
46		46
47	update courseunitevaluation set numAlunosAprov1013Percent = numAlunosAprov1013;	47	update courseunitevaluation set numAlunosAprov1013Percent = numAlunosAprov1013;
48	update courseunitevaluation set numAlunosAprov1416Percent = numAlunosAprov1416;	48	update courseunitevaluation set numAlunosAprov1416Percent = numAlunosAprov1416;
49	update courseunitevaluation set numAlunosAprov1720Percent = numAlunosAprov1720;	49	update courseunitevaluation set numAlunosAprov1720Percent = numAlunosAprov1720;
50		50
51	ALTER TABLE courseunitevaluation DROP COLUMN numAlunosAprovados;	51	ALTER TABLE courseunitevaluation DROP COLUMN numAlunosAprovados;
52		52
53		53
54	update courseunitevaluation set numAlunosAprov1013 = numAlunosAprov1013Percent * numAlunosAprovTotal / 100 where id > 683;	54	update courseunitevaluation set numAlunosAprov1013 = numAlunosAprov1013Percent * numAlunosAprovTotal / 100 where id > 683;
55	update courseunitevaluation set numAlunosAprov1416 = numAlunosAprov1416Percent * numAlunosAprovTotal / 100 where id > 683;	55	update courseunitevaluation set numAlunosAprov1416 = numAlunosAprov1416Percent * numAlunosAprovTotal / 100 where id > 683;
56	update courseunitevaluation set numAlunosAprov1720 = numAlunosAprov1720Percent * numAlunosAprovTotal / 100 where id > 683;	56	update courseunitevaluation set numAlunosAprov1720 = numAlunosAprov1720Percent * numAlunosAprovTotal / 100 where id > 683;
-		57
-		58
-		59	ALTER TABLE courseunitevaluation CHANGE COLUMN numAlunosInscritos numAlunosInscritos INT(10) NULL DEFAULT 0 ;