Changes between Version 235 and Version 236 of DatabaseBasedAnalysis/Spectrum

Timestamp:

12/09/19 18:22:14 (5 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis/Spectrum

@@ -136 +136 @@
 == Get Observation Time ==
 
+{{{#!Spoiler
+{{{#!sql
+CREATE TEMPORARY TABLE ObservationTime
+(
+   `.theta` SMALLINT UNSIGNED NOT NULL,
+   OnTime FLOAT NOT NULL,
+   PRIMARY KEY (`.theta`) USING HASH
+) ENGINE=Memory
+AS
+(
+   SELECT
+      INTERVAL(fZenithDistanceMean, %0:bins) AS `.theta`,
+      SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn) AS OnTime
+   FROM
+      DataFiles
+   LEFT JOIN
+      factdata.RunInfo USING (FileId)
+   GROUP BY
+      `.theta`
+   ORDER BY
+      `.theta`
+)
+}}}
+}}}
+
 == Get Monte Carlo File List ==