-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathcleaning.sql
More file actions
28 lines (16 loc) · 10.2 KB
/
cleaning.sql
File metadata and controls
28 lines (16 loc) · 10.2 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
-- LOC=0
DELETE FROM event WHERE id IN (SELECT substr(filename, instr(filename, "-")+2,
length(filename) - instr(filename, "-") - 6 ) FROM loc WHERE loc=0);
DELETE FROM issue WHERE filename IN (SELECT filename FROM loc WHERE loc=0);
DELETE FROM snapshot WHERE name IN (SELECT filename FROM loc WHERE loc=0);
DELETE FROM loc WHERE loc=0;
-- LOC=NULL
DELETE FROM issue WHERE filename NOT IN (SELECT filename FROM loc);
DELETE FROM snapshot WHERE name NOT IN (SELECT filename FROM loc);
-- Events without snapshots
DELETE from event where id NOT IN (select event_id from snapshot);
DELETE FROM loc WHERE filename NOT IN (SELECT name FROM snapshot);
-- Files that give CPD errors
DELETE FROM issue WHERE filename IN ("f8713411-e333353536.java","f8713411-e333355386.java","f8713411-e333356153.java","f9591098-e333875327.java","f9591110-e333875327.java","f9591113-e333875327.java","f9591114-e333875327.java","f9591120-e333875327.java","f9611697-e334670901.java","f9567587-e336259645.java","f9636921-e335697714.java","f9640831-e335846071.java","f9643390-e335947282.java","f9661896-e336733311.java","f9673073-e337200049.java","f9673073-e337200129.java","f9673073-e337200170.java","f9673073-e337200566.java","f9673073-e337203591.java","f9673073-e337203938.java","f9673073-e337211802.java","f9673073-e337211957.java","f9673073-e337222780.java","f9675460-e337304130.java","f9675460-e337304152.java","f9675460-e337304446.java","f9675460-e337305121.java","f9675460-e337305596.java","f9675460-e337305606.java","f9675460-e337330578.java","f9675460-e337338226.java","f9675460-e337338313.java","f9676662-e337338834.java","f9676662-e337339010.java","f9676742-e337342426.java","f9676742-e337348098.java","f9676742-e337366139.java","f9676742-e337366159.java","f9676742-e337366169.java","f9676742-e337366177.java","f9676742-e337366187.java","f9676742-e337366195.java","f9676742-e337367953.java","f9676742-e337368117.java","f9676742-e337371533.java","f9677302-e337374181.java","f9677302-e337374833.java","f9677302-e337375738.java","f9677302-e337375744.java","f9677302-e337376066.java","f9591098-e338740848.java","f9591098-e338792086.java","f9591110-e338740848.java","f9591110-e338792086.java","f9591113-e338740848.java","f9591113-e338792086.java","f9591114-e338740848.java","f9591114-e338791502.java","f9591114-e338791627.java","f9591120-e338740848.java","f9591120-e338791346.java","f9686357-e337785987.java","f9686650-e337798558.java","f13688428-e501682779.java","f13688428-e501684173.java","f13701009-e502093675.java","f13701009-e502094755.java","f13701009-e502098537.java","f13701009-e502469065.java","f13701009-e502469268.java","f13701009-e502512014.java","f13701009-e502514836.java","f13701009-e502515136.java","f13701009-e502519533.java","f13701009-e502522270.java","f13701009-e502528078.java","f13701009-e502530044.java","f13701009-e502539967.java","f13701009-e502542738.java","f13701009-e502544765.java","f13701009-e502547111.java","f13701009-e502562633.java","f13701009-e502564933.java","f13701009-e502566923.java","f13701009-e502568584.java","f13701009-e502569924.java","f13701009-e502571227.java","f13701009-e502573448.java","f13701009-e502631197.java","f13701009-e502647916.java","f13701009-e502651064.java","f13701009-e502652998.java","f13701009-e502657017.java","f13701009-e502658467.java","f13701009-e502659564.java","f13701009-e502661035.java","f13701009-e502662673.java","f13701009-e502664179.java","f13701009-e502667064.java","f13701009-e502667958.java","f13701009-e502668531.java","f13701009-e502669524.java","f13701009-e502670906.java","f13701009-e502682280.java","f13718455-e502696041.java","f13732057-e503274030.java","f13240091-e504494976.java","f13863715-e508234284.java","f10096522-e610227036.java","f16723836-e612040367.java","f16723836-e612040881.java","f16723836-e612041053.java","f16779712-e611874001.java","f16779712-e611874056.java","f16268705-e614221986.java","f16818466-e615079906.java","f17008057-e620058928.java");
DELETE FROM snapshot WHERE name IN ("f8713411-e333353536.java","f8713411-e333355386.java","f8713411-e333356153.java","f9591098-e333875327.java","f9591110-e333875327.java","f9591113-e333875327.java","f9591114-e333875327.java","f9591120-e333875327.java","f9611697-e334670901.java","f9567587-e336259645.java","f9636921-e335697714.java","f9640831-e335846071.java","f9643390-e335947282.java","f9661896-e336733311.java","f9673073-e337200049.java","f9673073-e337200129.java","f9673073-e337200170.java","f9673073-e337200566.java","f9673073-e337203591.java","f9673073-e337203938.java","f9673073-e337211802.java","f9673073-e337211957.java","f9673073-e337222780.java","f9675460-e337304130.java","f9675460-e337304152.java","f9675460-e337304446.java","f9675460-e337305121.java","f9675460-e337305596.java","f9675460-e337305606.java","f9675460-e337330578.java","f9675460-e337338226.java","f9675460-e337338313.java","f9676662-e337338834.java","f9676662-e337339010.java","f9676742-e337342426.java","f9676742-e337348098.java","f9676742-e337366139.java","f9676742-e337366159.java","f9676742-e337366169.java","f9676742-e337366177.java","f9676742-e337366187.java","f9676742-e337366195.java","f9676742-e337367953.java","f9676742-e337368117.java","f9676742-e337371533.java","f9677302-e337374181.java","f9677302-e337374833.java","f9677302-e337375738.java","f9677302-e337375744.java","f9677302-e337376066.java","f9591098-e338740848.java","f9591098-e338792086.java","f9591110-e338740848.java","f9591110-e338792086.java","f9591113-e338740848.java","f9591113-e338792086.java","f9591114-e338740848.java","f9591114-e338791502.java","f9591114-e338791627.java","f9591120-e338740848.java","f9591120-e338791346.java","f9686357-e337785987.java","f9686650-e337798558.java","f13688428-e501682779.java","f13688428-e501684173.java","f13701009-e502093675.java","f13701009-e502094755.java","f13701009-e502098537.java","f13701009-e502469065.java","f13701009-e502469268.java","f13701009-e502512014.java","f13701009-e502514836.java","f13701009-e502515136.java","f13701009-e502519533.java","f13701009-e502522270.java","f13701009-e502528078.java","f13701009-e502530044.java","f13701009-e502539967.java","f13701009-e502542738.java","f13701009-e502544765.java","f13701009-e502547111.java","f13701009-e502562633.java","f13701009-e502564933.java","f13701009-e502566923.java","f13701009-e502568584.java","f13701009-e502569924.java","f13701009-e502571227.java","f13701009-e502573448.java","f13701009-e502631197.java","f13701009-e502647916.java","f13701009-e502651064.java","f13701009-e502652998.java","f13701009-e502657017.java","f13701009-e502658467.java","f13701009-e502659564.java","f13701009-e502661035.java","f13701009-e502662673.java","f13701009-e502664179.java","f13701009-e502667064.java","f13701009-e502667958.java","f13701009-e502668531.java","f13701009-e502669524.java","f13701009-e502670906.java","f13701009-e502682280.java","f13718455-e502696041.java","f13732057-e503274030.java","f13240091-e504494976.java","f13863715-e508234284.java","f10096522-e610227036.java","f16723836-e612040367.java","f16723836-e612040881.java","f16723836-e612041053.java","f16779712-e611874001.java","f16779712-e611874056.java","f16268705-e614221986.java","f16818466-e615079906.java","f17008057-e620058928.java");
DELETE FROM loc WHERE filename IN ("f8713411-e333353536.java","f8713411-e333355386.java","f8713411-e333356153.java","f9591098-e333875327.java","f9591110-e333875327.java","f9591113-e333875327.java","f9591114-e333875327.java","f9591120-e333875327.java","f9611697-e334670901.java","f9567587-e336259645.java","f9636921-e335697714.java","f9640831-e335846071.java","f9643390-e335947282.java","f9661896-e336733311.java","f9673073-e337200049.java","f9673073-e337200129.java","f9673073-e337200170.java","f9673073-e337200566.java","f9673073-e337203591.java","f9673073-e337203938.java","f9673073-e337211802.java","f9673073-e337211957.java","f9673073-e337222780.java","f9675460-e337304130.java","f9675460-e337304152.java","f9675460-e337304446.java","f9675460-e337305121.java","f9675460-e337305596.java","f9675460-e337305606.java","f9675460-e337330578.java","f9675460-e337338226.java","f9675460-e337338313.java","f9676662-e337338834.java","f9676662-e337339010.java","f9676742-e337342426.java","f9676742-e337348098.java","f9676742-e337366139.java","f9676742-e337366159.java","f9676742-e337366169.java","f9676742-e337366177.java","f9676742-e337366187.java","f9676742-e337366195.java","f9676742-e337367953.java","f9676742-e337368117.java","f9676742-e337371533.java","f9677302-e337374181.java","f9677302-e337374833.java","f9677302-e337375738.java","f9677302-e337375744.java","f9677302-e337376066.java","f9591098-e338740848.java","f9591098-e338792086.java","f9591110-e338740848.java","f9591110-e338792086.java","f9591113-e338740848.java","f9591113-e338792086.java","f9591114-e338740848.java","f9591114-e338791502.java","f9591114-e338791627.java","f9591120-e338740848.java","f9591120-e338791346.java","f9686357-e337785987.java","f9686650-e337798558.java","f13688428-e501682779.java","f13688428-e501684173.java","f13701009-e502093675.java","f13701009-e502094755.java","f13701009-e502098537.java","f13701009-e502469065.java","f13701009-e502469268.java","f13701009-e502512014.java","f13701009-e502514836.java","f13701009-e502515136.java","f13701009-e502519533.java","f13701009-e502522270.java","f13701009-e502528078.java","f13701009-e502530044.java","f13701009-e502539967.java","f13701009-e502542738.java","f13701009-e502544765.java","f13701009-e502547111.java","f13701009-e502562633.java","f13701009-e502564933.java","f13701009-e502566923.java","f13701009-e502568584.java","f13701009-e502569924.java","f13701009-e502571227.java","f13701009-e502573448.java","f13701009-e502631197.java","f13701009-e502647916.java","f13701009-e502651064.java","f13701009-e502652998.java","f13701009-e502657017.java","f13701009-e502658467.java","f13701009-e502659564.java","f13701009-e502661035.java","f13701009-e502662673.java","f13701009-e502664179.java","f13701009-e502667064.java","f13701009-e502667958.java","f13701009-e502668531.java","f13701009-e502669524.java","f13701009-e502670906.java","f13701009-e502682280.java","f13718455-e502696041.java","f13732057-e503274030.java","f13240091-e504494976.java","f13863715-e508234284.java","f10096522-e610227036.java","f16723836-e612040367.java","f16723836-e612040881.java","f16723836-e612041053.java","f16779712-e611874001.java","f16779712-e611874056.java","f16268705-e614221986.java","f16818466-e615079906.java","f17008057-e620058928.java");