Changeset 21007

Timestamp:

Dec 15, 2008, 4:09:59 PM (17 years ago)

Author:

bills

Message:

need to set diffSkyfile.skkcell_id when converting to new schema

File:

• trunk/tools/collapse_diffinputs.pl (modified) (4 diffs)

trunk/tools/collapse_diffinputs.pl

@@ -34 +34 @@
     stack1,
     warp2,
-    stack2
+    stack2,
+    skycell_id
     FROM
         (select
             diff_id,
             warp1 as warp1,
-            stack2 as stack1
+            stack2 as stack1,
+            skycell_id as skycell_id
         from diffInputSkyfile
         WHERE template = 0
@@ -47 +49 @@
             diff_id,
             warp1 as warp2,
-            stack2 as stack2
+            stack2 as stack2,
+            skycell_id as stack_skycell
         from diffInputSkyfile
         WHERE template = 1
@@ -68 +71 @@
     my $stack1 = $ref->{stack1};
     my $stack2 = $ref->{stack2};
+    my $skycell_id = $ref->{skycell_id};
 
     # reorganizing columns puts warp1 and stack 1 correctly for template.
@@ -87 +91 @@
         die "unexpected input set for $diff_id";
     }
+
+    # set skycell_id in any existing diffSkyfile
+    $dbh->do("UPDATE diffSkyfile set skycell_id = ? where diff_id = ?", undef, $skycell_id, $diff_id);
 
     #