Changeset 18713 for trunk/FACT++/scripts

Timestamp:

01/06/17 11:56:10 (8 years ago)

Author:

tbretz

Message:

The conversion key to name is now done directly with the query by joining the tables (the results are not that big anyways), added a sanity check for the new suspend/resume feature

File:

• trunk/FACT++/scripts/getSchedule.js (modified) (5 diffs)

trunk/FACT++/scripts/getSchedule.js

@@ -3 +3 @@
 function getSchedule()
 {
-    // List of all available measurement types (see also Observation_class.js)
-    var measurementType = [ "STARTUP", "IDLE", "DRSCALIB", "SINGLEPE", "DATA", "RATESCAN", "SHUTDOWN", "OVTEST", "RATESCAN2", "SLEEP", "CUSTOM" ];
-
     // Get current time
     var start = new Date();//new Date("2013-04-07 19:00:00 UTC");
@@ -19 +16 @@
     var db = new Database($['schedule-database']);
 
-    // get all sources from database
-    var sources = db.query("SELECT * from Source");
-
     // Get the current schedule
-    var rows = db.query("SELECT * FROM Schedule WHERE fStart>'"+start.toISOString()+"' ORDER BY fStart, fMeasurementID");
+    var rows = db.query("SELECT * FROM Schedule "+
+                        "LEFT JOIN MeasurementType USING (fMeasurementTypeKey) "+
+                        "LEFT JOIN Source USING (fSourceKey) "+
+                        "WHERE fStart>'"+start.toISOString()+"' "+
+                        "ORDER BY fStart, fMeasurementID");
 
     // Close db connection
@@ -36 +34 @@
     for (var i=0; i<rows.length; i++)
     {
+        var id  = rows[i]['fScheduleID'];
         var sub = rows[i]['fMeasurementID'];
         if (sub==0)
@@ -42 +41 @@
         var m = { }
 
-        var task = rows[i]['fMeasurementTypeKey'];
-        m.task = measurementType[task];
+        m.task = rows[i]['fMeasurementTypeName'];
+        if (!m.task)
+            throw new Error("No valid measurement type for id=("+id+":"+sub+")");
 
-        var src = rows[i]['fSourceKey'];
-        if (src)
-        {
-            // Convert SourceKey to SourceName
-            var arr = sources.filter(function(e) { return e['fSourceKEY']==src; });
-            if (arr.length==0)
-                throw new Error("SourceKey "+src+" unknown.");
+        // For simplicity, measurements suspend and resume must be unique in an observation
+        if ((m.task=="suspend" || m.task=="resume") && sub>0)
+            throw new Error("Measurement "+m.task+" not the only one in the observation (id="+id+")");
 
-            m.source = arr[0]['fSourceName'];
-        }
+        m.source = rows[i]['fSourceName'];
 
         var data = rows[i]['fData'];
@@ -67 +62 @@
             schedule[entry] = { };
 
-        schedule[entry].id   = rows[i]['fScheduleID'];
+        schedule[entry].id   = id;
         schedule[entry].date = new Date(rows[i]['fStart']+" UTC");