Demo Portal Administration

Deploying Course to Demo Portal

Vault request

Demo Portal group

Rename "demo" courses "[DEMO]"

UPDATE courses

set name = REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(name, ')', ''), '(', '') , 'demo', 'DEMO'), 'Demo', 'DEMO'), 'DEMO', '[DEMO]')

WHERE name LIKE '%DEMO%'

AND name NOT LIKE '%[DEMO]%'

AND is_active = 1;

UPDATE courses

set name= REPLACE(name, '-[DEMO]',' [DEMO]')

WHERE name LIKE '%[DEMO]%'

AND is_active = 1 ;

NEW topic cleanup

/* Remove old new ones */

DELETE FROM course_topic_assn

WHERE topic_id = 49;

/* Add newest ones */

INSERT IGNORE INTO course_topic_assn

SELECT c.id AS course_id, 49 AS topic_id

FROM enrollments AS e

LEFT JOIN curriculums AS cu

ON cu.id = e.curriculum_id

LEFT JOIN structures AS s

ON s.id = cu.structure_id

LEFT JOIN courses AS c

ON c.id = s.course_id

GROUP BY e.curriculum_id

HAVING MIN(enrolled_at) > '2018-07-19'; /* Make this your target date */

DEMO courses not with Singles groups

SELECT *

FROM curriculums

WHERE id NOT IN

(

SELECT curriculum_id

FROM fm_autoenroll_assn AS aa

LEFT JOIN groups AS g

ON g.id = aa.group_id

WHERE g.parent_id = 52 /* Singles parent */

)

AND is_visible = 1

AND name LIKE '%[DEMO]%';

Add DEMO courses to All Courses (990+)

INSERT INTO fm_autoenroll_assn

SELECT 18 AS group_id, id AS curriculum_id

FROM curriculums

WHERE id NOT IN

(

SELECT curriculum_id

FROM fm_autoenroll_assn AS aa

WHERE group_id = 18

)

AND is_visible = 1

AND name LIKE '%[DEMO]%';