Changeset 29686 for trunk/tools/czartool/Gpc1Db.pm

Timestamp:

Nov 5, 2010, 3:54:50 PM (16 years ago)

Author:

rhenders

Message:

major changes to support generaionof IPP metrics

File:

• trunk/tools/czartool/Gpc1Db.pm (modified) (2 diffs)

trunk/tools/czartool/Gpc1Db.pm

@@ -56 +56 @@
 
     return "ERROR";
+}
+
+###########################################################################
+#
+# Returns the number of science exposures taken 'last night' for a given day
+# 
+# Notes:
+#
+# - 03:00 HST = 17:00 last night UTC
+# - 17:00 HST = 07:00 this morning UTC
+# - 'OBJECT' = science exposures
+#
+###########################################################################
+sub countScienceExposuresFromLastNight {
+    my ($self, $day) = @_;
+
+    my $begin = "$day 03"; 
+    my $end = "$day 17"; 
+
+    my $query = $self->{_db}->prepare(<<SQL);
+    SELECT COUNT(*)
+        FROM summitExp 
+        WHERE dateobs > '$begin' 
+        AND dateobs < '$end' AND
+        exp_type = 'OBJECT';
+SQL
+
+    $query->execute;
+return scalar $query->fetchrow_array();
 }
 
@@ -158 +187 @@
     }
 
-
     $query->execute;
     return scalar $query->fetchrow_array();