script-cr-unique-test

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

#1 - desativo todos as variacoes de unique-tests atuais;
UPDATE rollout.UniqueTest SET Active = 0 WHERE Active = 1;
#2 - desativo todos os student-unique-tests já selecionados;
UPDATE rollout.StudentUniqueTest SET Active = 0 WHERE Active = 1;
#3 - crio o out-of-test novo de CR variation;
INSERT INTO rollout.UniqueTest
(Id, Name, VariationPercentage, Active)
VALUES
(25, 'CR Limit Variation - Out of Test (D)', 70, 1);
#4 - pego todos os usuários já cadastrados e jogo nessa variacao nova;
INSERT INTO rollout.StudentUniqueTest
(StudentId, UniqueTestId, Active, SelectionDate)
(
SELECT s.Id as StudentId, 25 as UniqueTestId, 1 as Active, CURRENT_TIMESTAMP as SelectionDate
FROM dbo.Student s
);
#5 - crio as variacoes que vão valer;
INSERT INTO rollout.UniqueTest
(Id, Name, VariationPercentage, Active)
VALUES
(22, 'CR Limit Variation - 1 Material (A)', 10, 1);
INSERT INTO rollout.UniqueTest
(Id, Name, VariationPercentage, Active)
VALUES
(23, 'CR Limit Variation - 2 Materials (B)', 10, 1);
INSERT INTO rollout.UniqueTest
(Id, Name, VariationPercentage, Active)
VALUES
(24, 'CR Limit Variation - 3 Materials (C)', 10, 1);