Update Question Ranks - UQ-eLIPSE/shifoo-docs GitHub Wiki

set @CONTEXTID = "CSSE1001";
set @FIRST = "intro";
set @SECOND = "input";
-- Get the correct questions to change based on the course context_id
SELECT * FROM shifoo.course c 
JOIN shifoo.module m on c.id = m.id
JOIN shifoo.question q on q.module_id
WHERE c.context_id = @CONTEXTID AND (q.name = @FIRST OR q.name = @SECOND);
-- Swap the two question ranks
UPDATE shifoo.question q SET q.question_rank = 0 WHERE q.id = 265;
UPDATE shifoo.question q SET q.question_rank = 1 WHERE q.id = 264;