Changes between Version 235 and Version 236 of DatabaseBasedAnalysis/Spectrum


Ignore:
Timestamp:
Dec 9, 2019, 6:22:14 PM (11 months ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DatabaseBasedAnalysis/Spectrum

    v235 v236  
    136136== Get Observation Time ==
    137137
     138{{{#!Spoiler
     139{{{#!sql
     140CREATE TEMPORARY TABLE ObservationTime
     141(
     142   `.theta` SMALLINT UNSIGNED NOT NULL,
     143   OnTime FLOAT NOT NULL,
     144   PRIMARY KEY (`.theta`) USING HASH
     145) ENGINE=Memory
     146AS
     147(
     148   SELECT
     149      INTERVAL(fZenithDistanceMean, %0:bins) AS `.theta`,
     150      SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn) AS OnTime
     151   FROM
     152      DataFiles
     153   LEFT JOIN
     154      factdata.RunInfo USING (FileId)
     155   GROUP BY
     156      `.theta`
     157   ORDER BY
     158      `.theta`
     159)
     160}}}
     161}}}
     162
    138163== Get Monte Carlo File List ==
    139164