Changes between Version 37 and Version 38 of DatabaseBasedAnalysis/Tables


Ignore:
Timestamp:
09/03/18 20:45:21 (6 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseBasedAnalysis/Tables

    v37 v38  
    9595   StatusTable
    9696}}}
     97
     98Here is a query to give a full status overview (only data runs are included)
     99
     100{{{#!Spoiler
     101{{{#!sql
     102SELECT
     103   'RunInfo' AS 'Type',
     104   COUNT(IF(fRunTypeKEY!=1, 1, NULL)) AS 'BLOCKED',
     105   0 AS 'WAITING',
     106   0 AS 'RUNNING',
     107   0 AS 'SCHEDULED',
     108   COUNT(IF(fRunTypeKEY=1, 1, NULL)) AS 'SUCCESS',
     109   0 AS 'FAILED'
     110FROM
     111   RunInfo
     112
     113UNION ALL
     114
     115SELECT
     116   'Callisto',
     117   COUNT(IF(fStartTime<'1972-01-01 00:00:00' AND fStopTime<'1972-01-01 00:00:00', 1, NULL)),
     118   COUNT(IF(    ISNULL(fStartTime) AND ISNULL(fStopTime), 1, NULL)),
     119   COUNT(IF(NOT ISNULL(fStartTime) AND ISNULL(fStopTime), 1, NULL)),
     120   COUNT(IF(fStartTime='1971-01-01 01:01:01' AND ISNULL(fStopTime), 1, NULL)),
     121   COUNT(IF(fStartTime>'1972-01-01 00:00:00' AND fStopTime>'1972-01-01 00:00:00' AND     ISNULL(fReturnCode), 1, NULL)),
     122   COUNT(IF(fStartTime>'1972-01-01 00:00:00' AND fStopTime>'1972-01-01 00:00:00' AND NOT ISNULL(fReturnCode), 1, NULL))
     123FROM
     124   CallistoStatus
     125LEFT JOIN
     126   RunInfo USING (fNight, fSequenceID)
     127WHERE
     128   fRunTypeKey=1
     129
     130UNION ALL
     131
     132SELECT
     133   'Star',
     134   COUNT(IF(fStartTime<'1972-01-01 00:00:00' AND fStopTime<'1972-01-01 00:00:00', 1, NULL)),
     135   COUNT(IF(    ISNULL(fStartTime) AND ISNULL(fStopTime), 1, NULL)),
     136   COUNT(IF(NOT ISNULL(fStartTime) AND ISNULL(fStopTime), 1, NULL)),
     137   COUNT(IF(fStartTime='1971-01-01 01:01:01' AND ISNULL(fStopTime), 1, NULL)),
     138   COUNT(IF(fStartTime>'1972-01-01 00:00:00' AND fStopTime>'1972-01-01 00:00:00' AND     ISNULL(fReturnCode), 1, NULL)),
     139   COUNT(IF(fStartTime>'1972-01-01 00:00:00' AND fStopTime>'1972-01-01 00:00:00' AND NOT ISNULL(fReturnCode), 1, NULL))
     140FROM
     141   StarStatus
     142LEFT JOIN
     143   RunInfo USING (fNight, fSequenceID)
     144WHERE
     145   fRunTypeKey=1
     146
     147UNION ALL
     148
     149SELECT
     150   'Images',
     151   COUNT(IF(fStartTime<'1972-01-01 00:00:00' AND fStopTime<'1972-01-01 00:00:00', 1, NULL)),
     152   COUNT(IF(    ISNULL(fStartTime) AND ISNULL(fStopTime), 1, NULL)),
     153   COUNT(IF(NOT ISNULL(fStartTime) AND ISNULL(fStopTime), 1, NULL)),
     154   COUNT(IF(fStartTime='1971-01-01 01:01:01' AND ISNULL(fStopTime), 1, NULL)),
     155   COUNT(IF(fStartTime>'1972-01-01 00:00:00' AND fStopTime>'1972-01-01 00:00:00' AND     ISNULL(fReturnCode), 1, NULL)),
     156   COUNT(IF(fStartTime>'1972-01-01 00:00:00' AND fStopTime>'1972-01-01 00:00:00' AND NOT ISNULL(fReturnCode), 1, NULL))
     157FROM
     158   StarEventsFilledStatus
     159LEFT JOIN
     160   RunInfo USING (fNight, fRunID)
     161WHERE
     162   fRunTypeKey=1
     163
     164UNION ALL
     165
     166SELECT
     167   'Position',
     168   COUNT(IF(fStartTime<'1972-01-01 00:00:00' AND fStopTime<'1972-01-01 00:00:00', 1, NULL)),
     169   COUNT(IF(    ISNULL(fStartTime) AND ISNULL(fStopTime), 1, NULL)),
     170   COUNT(IF(NOT ISNULL(fStartTime) AND ISNULL(fStopTime), 1, NULL)),
     171   COUNT(IF(fStartTime='1971-01-01 01:01:01' AND ISNULL(fStopTime), 1, NULL)),
     172   COUNT(IF(fStartTime>'1972-01-01 00:00:00' AND fStopTime>'1972-01-01 00:00:00' AND     ISNULL(fReturnCode), 1, NULL)),
     173   COUNT(IF(fStartTime>'1972-01-01 00:00:00' AND fStopTime>'1972-01-01 00:00:00' AND NOT ISNULL(fReturnCode), 1, NULL))
     174FROM
     175   CalcSourceStatus
     176LEFT JOIN
     177   RunInfo USING (fNight, fRunID)
     178WHERE
     179   fRunTypeKey=1
     180}}}
     181}}}