nus-mtp/cs-modify

View on GitHub
utils/moduleMountedPopulator.sql

Summary

Maintainability
Test Coverage
INSERT INTO moduleMounted VALUES('BT5110', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CG1001', 'AY 16/17 Sem 1', 150);
INSERT INTO moduleMounted VALUES('CG2271', 'AY 16/17 Sem 2', 80);
INSERT INTO moduleMounted VALUES('CG3002', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CG3002', 'AY 16/17 Sem 2', 70);
INSERT INTO moduleMounted VALUES('CP2201', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CP3106', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CP3108A', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CP3108B', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CP3109', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CP3200', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CP3201', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CP3208', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CP3209', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CP3880', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CP4101', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CP6010', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CS1010', 'AY 16/17 Sem 1', 240);
INSERT INTO moduleMounted VALUES('CS1010', 'AY 16/17 Sem 2', 40);
INSERT INTO moduleMounted VALUES('CS1010E', 'AY 16/17 Sem 1', 900);
INSERT INTO moduleMounted VALUES('CS1010E', 'AY 16/17 Sem 2', 450);
INSERT INTO moduleMounted VALUES('CS1010J', 'AY 16/17 Sem 1', 120);
INSERT INTO moduleMounted VALUES('CS1010S', 'AY 16/17 Sem 1', 240);
INSERT INTO moduleMounted VALUES('CS1010S', 'AY 16/17 Sem 2', 200);
INSERT INTO moduleMounted VALUES('CS1010X', 'AY 16/17 Sem 2', 100);
INSERT INTO moduleMounted VALUES('CS1020', 'AY 16/17 Sem 1', 210);
INSERT INTO moduleMounted VALUES('CS1020', 'AY 16/17 Sem 2', 400);
INSERT INTO moduleMounted VALUES('CS1020E', 'AY 16/17 Sem 1', 220);
INSERT INTO moduleMounted VALUES('CS1020E', 'AY 16/17 Sem 2', 110);
INSERT INTO moduleMounted VALUES('CS1101S', 'AY 16/17 Sem 1', 120);
INSERT INTO moduleMounted VALUES('CS1231', 'AY 16/17 Sem 1', 500);
INSERT INTO moduleMounted VALUES('CS2010', 'AY 16/17 Sem 1', 170);
INSERT INTO moduleMounted VALUES('CS2010', 'AY 16/17 Sem 2', 120);
INSERT INTO moduleMounted VALUES('CS2020', 'AY 16/17 Sem 2', 100);
INSERT INTO moduleMounted VALUES('CS2100', 'AY 16/17 Sem 1', 180);
INSERT INTO moduleMounted VALUES('CS2100', 'AY 16/17 Sem 2', 300);
INSERT INTO moduleMounted VALUES('CS2101', 'AY 16/17 Sem 1', 190);
INSERT INTO moduleMounted VALUES('CS2101', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS2102', 'AY 16/17 Sem 1', 250);
INSERT INTO moduleMounted VALUES('CS2102', 'AY 16/17 Sem 2', 250);
INSERT INTO moduleMounted VALUES('CS2103', 'AY 16/17 Sem 1', 150);
INSERT INTO moduleMounted VALUES('CS2103', 'AY 16/17 Sem 2', 180);
INSERT INTO moduleMounted VALUES('CS2103T', 'AY 16/17 Sem 1', 190);
INSERT INTO moduleMounted VALUES('CS2103T', 'AY 16/17 Sem 2', 160);
INSERT INTO moduleMounted VALUES('CS2104', 'AY 16/17 Sem 1', 120);
INSERT INTO moduleMounted VALUES('CS2105', 'AY 16/17 Sem 1', 250);
INSERT INTO moduleMounted VALUES('CS2105', 'AY 16/17 Sem 2', 250);
INSERT INTO moduleMounted VALUES('CS2106', 'AY 16/17 Sem 1', 250);
INSERT INTO moduleMounted VALUES('CS2106', 'AY 16/17 Sem 2', 180);
INSERT INTO moduleMounted VALUES('CS2107', 'AY 16/17 Sem 1', 150);
INSERT INTO moduleMounted VALUES('CS2107', 'AY 16/17 Sem 2', 200);
INSERT INTO moduleMounted VALUES('CS2108', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS2220', 'AY 16/17 Sem 1', 30);
INSERT INTO moduleMounted VALUES('CS2309', 'AY 16/17 Sem 1', 20);
INSERT INTO moduleMounted VALUES('CS3103', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS3201', 'AY 16/17 Sem 1', 120);
INSERT INTO moduleMounted VALUES('CS3201', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3202', 'AY 16/17 Sem 1', 120);
INSERT INTO moduleMounted VALUES('CS3202', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3205', 'AY 16/17 Sem 1', 40);
INSERT INTO moduleMounted VALUES('CS3210', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS3211', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3216', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CS3217', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3218', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3219', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS3219', 'AY 16/17 Sem 2', 80);
INSERT INTO moduleMounted VALUES('CS3223', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3225', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3226', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3230', 'AY 16/17 Sem 1', 120);
INSERT INTO moduleMounted VALUES('CS3230', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3233', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3234', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3235', 'AY 16/17 Sem 1', 100);
INSERT INTO moduleMounted VALUES('CS3235', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3236', 'AY 16/17 Sem 2', 60);
INSERT INTO moduleMounted VALUES('CS3240', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3241', 'AY 16/17 Sem 1', 140);
INSERT INTO moduleMounted VALUES('CS3241', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3242', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3243', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3244', 'AY 16/17 Sem 1', 120);
INSERT INTO moduleMounted VALUES('CS3245', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3247', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3249', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3281', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3282', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3283', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS3284', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CS3284', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4212', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CS4215', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4218', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4220', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4221', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4222', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4223', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CS4224', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS4225', 'AY 16/17 Sem 2', 80);
INSERT INTO moduleMounted VALUES('CS4226', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CS4231', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4232', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CS4234', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS4236', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS4238', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4239', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CS4242', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4243', 'AY 16/17 Sem 1', 120);
INSERT INTO moduleMounted VALUES('CS4244', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4246', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS4247', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4248', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS4249', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS4345', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CS4347', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS4350', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CS5218', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS5219', 'AY 16/17 Sem 2', 50);
INSERT INTO moduleMounted VALUES('CS5223', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS5224', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS5228', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS5229', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS5231', 'AY 16/17 Sem 1', 90);
INSERT INTO moduleMounted VALUES('CS5232', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS5233', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS5234', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CS5236', 'AY 16/17 Sem 1', 50);
INSERT INTO moduleMounted VALUES('CS5238', 'AY 16/17 Sem 1', 50);
INSERT INTO moduleMounted VALUES('CS5239', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CS5240', 'AY 16/17 Sem 1', 80);
INSERT INTO moduleMounted VALUES('CS5250', 'AY 16/17 Sem 2', 80);
INSERT INTO moduleMounted VALUES('CS5321', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS5330', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS5331', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS5339', 'AY 16/17 Sem 2', 100);
INSERT INTO moduleMounted VALUES('CS5340', 'AY 16/17 Sem 1', 60);
INSERT INTO moduleMounted VALUES('CS5344', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS5345', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS6101', 'AY 16/17 Sem 1', 0);
INSERT INTO moduleMounted VALUES('CS6101', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS6203', 'AY 16/17 Sem 1', 30);
INSERT INTO moduleMounted VALUES('CS6208', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS6210', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS6220', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS6231', 'AY 16/17 Sem 1', 40);
INSERT INTO moduleMounted VALUES('CS6234', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS6240', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('CS6280', 'AY 16/17 Sem 1', NULL);
INSERT INTO moduleMounted VALUES('CS6880', 'AY 16/17 Sem 1', 30);
INSERT INTO moduleMounted VALUES('FMC1206', 'AY 16/17 Sem 1', 15);
INSERT INTO moduleMounted VALUES('GET1031', 'AY 16/17 Sem 2', NULL);
INSERT INTO moduleMounted VALUES('IT1005', 'AY 16/17 Sem 1', 350);
INSERT INTO moduleMounted VALUES('XFC4101', 'AY 16/17 Sem 1', NULL);