source: trunk/DataCheck/Setup/steps_fact_isdc.rc@ 19036

Last change on this file since 19036 was 18766, checked in by Daniela Dorner, 8 years ago
bugfix in join for StarStatus; cleanup
File size: 2.3 KB
Line 
1# Definition of Steps and Dependencies for Jobs running at ISDC
2
3RawFileRsyncedISDC.MainTable: RawFileRsyncedISDC
4RawFileRsyncedISDC.Primaries: fNight, fRunID
5RawFileRsyncedISDC.Needs:
6RawFileRsyncedISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fRunID)
7RawFileRsyncedISDC.SortDirection: ASC
8
9RawFileAvailWue.MainTable: RawFileAvailWue
10RawFileAvailWue.Primaries: fNight, fRunID
11RawFileAvailWue.Needs: RawFileRsyncedISDC
12RawFileAvailWue.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fRunID)
13RawFileAvailWue.SortDirection: ASC
14
15#RawFileAvailPhido.MainTable: RawFileAvailPhido
16#RawFileAvailPhido.Primaries: fNight, fRunID
17#RawFileAvailPhido.Needs: RawFileRsyncedISDC
18#RawFileAvailPhido.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fRunID)
19#RawFileAvailPhido.SortDirection: ASC
20
21# independent as filled by CheckRawFileAvail.sh
22RawFileAvailISDC.MainTable: RawFileAvailISDC
23RawFileAvailISDC.Primaries: fNight, fRunID
24RawFileAvailISDC.Needs: RawFileRsyncedISDC
25RawFileAvailISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fRunID)
26
27AuxFilesAvailISDC.MainTable: AuxFilesAvailISDC
28AuxFilesAvailISDC.Primaries: fNight
29#AuxFilesAvailISDC.Needs:
30AuxFilesAvailISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight)
31
32DriveFileAvailISDC.MainTable: DriveFileAvailISDC
33DriveFileAvailISDC.Primaries: fNight
34#DriveFileAvailISDC.Needs:
35DriveFileAvailISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight)
36
37RatesFileAvailISDC.MainTable: RatesFileAvailISDC
38RatesFileAvailISDC.Primaries: fNight
39#RatesFileAvailISDC.Needs:
40RatesFileAvailISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight)
41
42SequenceFileAvailISDC.MainTable: SequenceFileAvailISDC
43SequenceFileAvailISDC.Primaries: fNight, fSequenceID
44#SequenceFileAvailISDC.Needs:
45SequenceFileAvailISDC.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID)
46
47Callisto.MainTable: Callisto
48Callisto.Primaries: fNight, fSequenceID
49Callisto.Needs: SequenceFileAvailISDC
50Callisto.SpecialJoin: LEFT JOIN SequenceInfo USING(fNight, fSequenceID)
51Callisto.SpecialWhere: AND fNumRuns=fNumRawfilesAvailISDC
52
53Star.MainTable: Star
54Star.Primaries: fNight, fSequenceID
55Star.Needs: Callisto DriveFileAvailISDC RatesFileAvailISDC SequenceFileAvailISDC
56Star.SpecialJoin: LEFT JOIN SequenceInfo USING(fNight, fSequenceID)
57
58#Merpp.MainTable: Merpp
59#Merpp.Primaries: fNight, fSequenceID
60#Merpp.Needs: RawFileAvailISDC Callisto Star
61#Merpp.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID)
62
63
Note: See TracBrowser for help on using the repository browser.