Como preparar a base de dados para realizar testes 'HTM/PHP'

Contents - Index

Como preparar a base de dados para realizar testes 'HTM/PHP'

A preparação da base de dados para realização de teste 'HTM/PHP' requer:

Actualização dos campos 'dti' e 'dtf' da tabela 'util', para todos os utilizadores que poderão responder aos testes, o que pode ser feito pela execução de um 'query' idêntico ao seguinte:

# Base de Dados : `ec2`

# --------------------------------------------------------

# Actualização de 'dti' da tabela `util` para todos os utilizadores dos cursos indicados

UPDATE `util` SET dti = "20050918" WHERE `curso`= "ECO";

UPDATE `util` SET dti = "20050918" WHERE `curso`= "FIN";

UPDATE `util` SET dti = "20050918" WHERE `curso`= "GEI";

UPDATE `util` SET dti = "20050918" WHERE `curso`= "IGE";

UPDATE `util` SET dti = "20050918" WHERE `curso`= "OGE1S";

UPDATE `util` SET dti = "20050918" WHERE `curso`= "OGE2S";

# --------------------------------------------------------

# Actualização de 'dtf' da tabela `util` para todos os utilizadores dos cursos indicados

UPDATE `util` SET dtf = "20051218" WHERE `curso`= "ECO";

UPDATE `util` SET dtf = "20051218" WHERE `curso`= "FIN";

UPDATE `util` SET dtf = "20051218" WHERE `curso`= "GEI";

UPDATE `util` SET dtf = "20051218" WHERE `curso`= "IGE";

UPDATE `util` SET dtf = "20051218" WHERE `curso`= "OGE1S";

UPDATE `util` SET dtf = "20051218" WHERE `curso`= "OGE2S";

Execução de 'qpreptestes.sql', que actualiza o número de testes em alternativa, e as tabelas das respectivas questões ('tes'), respostas ('sol') e penalizações por resposta errada ('tpe'). O 'query' 'qpreptestes.sql' é do tipo:

UPDATE `nrtes` SET nrt = "4";

DELETE FROM `sol` WHERE `teste`!= "ex1";

DELETE FROM `tes` WHERE `teste`!= "ex1";

DELETE FROM `tpe` WHERE `teste`!= "ex1";

INSERT INTO `tes` ( `teste` , `datahora` , `p1` , `p2` , `p3` , `p4` , `p5` , `p6` , `p7` , `p8` , `p9` , `p10` , `p11` , `p12` , `p13` , `p14` , `p15` , `p16` , `p17` , `p18` , `p19` , `p20` )

VALUES ('1', '2005-12-19' ,'d3' , 'ia0a' , 'a5' , 'ia0b' , 'a4' , 'a8' , 'ie0a' , 'a7' , 'b2' , 'b4' , 'id0a' , 'ie0b' , 'b6' , 'ic0a' , 'vb6' , 'e23' , 'e10' , 'c11' , 'c22' , 'gc5a' ),

('2', '2005-12-19' ,'d16' , 'ia0a' , 'a6' , 'if1a' , 'a4' , 'a8' , 'ie0a' , 'a7' , 'b2' , 'b4' , 'id0a' , 'ie0e' , 'c22' , 'ic0a' , 'vb6' , 'e23' , 'c7' , 'c11' , 'c23' , 'gc5a' ),

('3', '2005-12-19' ,'a1' , 'ia0a' , 'a5' , 'ia0b' , 'a4' , 'a8' , 'ie0a' , 'a7' , 'b2' , 'b4' , 'id0a' , 'ie0d' , 'c22' , 'ic0a' , 'b7' , 'c1' , 'e10' , 'c11' , 'c23' , 'gc5a' ),

('4', '2005-12-19' ,'d16' , 'ia0a' , 'a5' , 'ia0b' , 'a4' , 'a8' , 'ie0a' , 'a7' , 'b2' , 'b4' , 'id0a' , 'ie0b' , 'b6' , 'ic0a' , 'b7' , 'c1' , 'e13' , 'c11' , 'c23' , 'gc5a' );

INSERT INTO `sol` ( `teste` , `datahora` , `rp1` , `rp2` , `rp3` , `rp4` , `rp5` , `rp6` , `rp7` , `rp8` , `rp9` , `rp10` , `rp11` , `rp12` , `rp13` , `rp14` , `rp15` , `rp16` , `rp17` , `rp18` , `rp19` , `rp20` )

VALUES ('1', '2005-12-19' ,'3' , '0.05' , '2' , '0.0804' , '3' , '4' , '2000' , '2' , '2' , '2' , '-20' , '22.87' , '1' , '-16' , '2' , '1' , '1' , '2' , '2' , '2' ),

('2', '2005-12-19' ,'2' , '0.05' , '2' , '0.0394' , '3' , '4' , '2000' , '2' , '2' , '2' , '-20' , '0' , '2' , '-16' , '2' , '1' , '1' , '2' , '2' , '2' ),

('3', '2005-12-19' ,'1' , '0.05' , '2' , '0.0804' , '3' , '4' , '2000' , '2' , '2' , '2' , '-20' , '100' , '2' , '-16' , '3' , '3' , '1' , '2' , '2' , '2' ),

('4', '2005-12-19' ,'2' , '0.05' , '2' , '0.0804' , '3' , '4' , '2000' , '2' , '2' , '2' , '-20' , '22.87' , '1' , '-16' , '3' , '3' , '2' , '2' , '2' , '2' );

INSERT INTO `tpe` ( `teste` , `datahora` , `pp1` , `pp2` , `pp3` , `pp4` , `pp5` , `pp6` , `pp7` , `pp8` , `pp9` , `pp10` , `pp11` , `pp12` , `pp13` , `pp14` , `pp15` , `pp16` , `pp17` , `pp18` , `pp19` , `pp20` )

VALUES ('1', '2005-12-19' ,'0.25' , '0' , '0.25' , '0' , '0.33' , '0.25' , '0' , '0.25' , '0.25' , '0.25' , '0' , '0' , '0.25' , '0' , '0.5' , '0.25' , '0.25' , '0.25' , '0.25' , '0.5' ),

('2', '2005-12-19' ,'0.25' , '0' , '0.25' , '0' , '0.33' , '0.25' , '0' , '0.25' , '0.25' , '0.25' , '0' , '0' , '0.25' , '0' , '0.5' , '0.25' , '0.25' , '0.25' , '0.25' , '0.5' ),

('3', '2005-12-19' ,'0.33' , '0' , '0.25' , '0' , '0.33' , '0.25' , '0' , '0.25' , '0.25' , '0.25' , '0' , '0' , '0.25' , '0' , '0.25' , '0.25' , '0.25' , '0.25' , '0.25' , '0.5' ),

('4', '2005-12-19' ,'0.25' , '0' , '0.25' , '0' , '0.33' , '0.25' , '0' , '0.25' , '0.25' , '0.25' , '0' , '0' , '0.25' , '0' , '0.25' , '0.25' , '0.25' , '0.25' , '0.25' , '0.5' );