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

Last change on this file since 19199 was 19199, checked in by dorner, 11 months ago
added setup for StarEventsFilled and CalcSource
File size: 2.7 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
58StarEventsFilled.MainTable: StarEventsFilled
59StarEventsFilled.Primaries: fNight, fRunID
60StarEventsFilled.Needs: Star
61StarEventsFilled.SpecialJoin: LEFT JOIN RunInfo USING(fRunID, fNight)
62StarEventsFilled.SpecialJoin2: LEFT JOIN RunInfo USING(fSequenceID, fNight)
63
64CalcSource.MainTable: CalcSource
65CalcSource.Primaries: fNight, fRunID
66CalcSource.Needs: StarEventsFilled
67
68#Merpp.MainTable: Merpp
69#Merpp.Primaries: fNight, fSequenceID
70#Merpp.Needs: RawFileAvailISDC Callisto Star
71#Merpp.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID)
72
73
Note: See TracBrowser for help on using the repository browser.