Changeset 29078

Timestamp:

Aug 30, 2010, 9:06:56 AM (16 years ago)

Author:

rhenders

Message:

New veriosn (12) including a new table for nightlyscience status and a method to update that table

File:

• trunk/tools/czartool/CzarDb.pm (modified) (3 diffs)

trunk/tools/czartool/CzarDb.pm

@@ -119 +119 @@
 
     $query->execute;
+}
+
+###########################################################################
+#
+# Updates nightlyscience table
+#
+###########################################################################
+sub updateNightlyScience {
+    my ($self, $status) = @_;
+
+    my $query = $self->{_db}->prepare(<<SQL);
+    DELETE FROM nightlyscience;
+SQL
+
+    $query->execute;
+
+    $query = $self->{_db}->prepare(<<SQL);
+    INSERT INTO nightlyscience
+        (status)
+        VALUES
+        ('$status');
+SQL
+
+       $query->execute;
 }
 
@@ -630 +654 @@
         elsif ($currentRevision == 9) {$self->createRevision_10();}
         elsif ($currentRevision == 10) {$self->createRevision_11();}
+        elsif ($currentRevision == 11) {$self->createRevision_12();}
         else {last;}
     }
@@ -985 +1010 @@
 }
 
-
+#######################################################################################
+# 
+# Create revision 12 of the database 
+#
+#######################################################################################
+sub createRevision_12 {
+    my ($self) = @_;
+
+    print "* Creating revision 12 of '$self->{_dbName}'\n";
+
+    # same shape as other stage tables to enable easy update
+    my $query = $self->{_db}->prepare(<<SQL);
+    CREATE TABLE nightlyscience (
+            timestamp TIMESTAMP DEFAULT NOW(),
+            status VARCHAR(128) DEFAULT "NONE"); 
+SQL
+
+    $query->execute;
+
+    $self->setRevision(12);
+}
 
 1;