LabDevKitModules/laboratory/resources/schemas/dbscripts/postgresql/laboratory-12.273-12.274.sql at 489d8e3cc6e88afa97eae194d27fc81ae8c31cb2 · LabKey/LabDevKitModules · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
DELETE FROM laboratory.samplecategory WHERE category = 'Empty Well';
DELETE FROM laboratory.samplecategory WHERE category = 'Blank';
DELETE FROM laboratory.samplecategory WHERE category = 'Sample';
DELETE FROM laboratory.samplecategory WHERE category = 'Standard';
DELETE FROM laboratory.samplecategory WHERE category = 'NTC';
DELETE FROM laboratory.samplecategory WHERE category = 'CTL';
DELETE FROM laboratory.samplecategory WHERE category = 'STD';
DELETE FROM laboratory.samplecategory WHERE category = 'Pos Control';
DELETE FROM laboratory.samplecategory WHERE category = 'Neg Control';
DELETE FROM laboratory.samplecategory WHERE category = 'Control';

-- @SkipOnEmptySchemasBegin
INSERT INTO laboratory.samplecategory (category) VALUES ('Pos Control');
INSERT INTO laboratory.samplecategory (category) VALUES ('Neg Control');
INSERT INTO laboratory.samplecategory (category) VALUES ('Control');
INSERT INTO laboratory.samplecategory (category) VALUES ('Blank');
INSERT INTO laboratory.samplecategory (category) VALUES ('Standard');
-- @SkipOnEmptySchemasEnd

ALTER TABLE laboratory.samplecategory ADD control boolean;
UPDATE laboratory.samplecategory SET control = true;
UPDATE laboratory.samplecategory SET control = false where category = 'Unknown';