Changeset 27363

Timestamp:

Mar 19, 2010, 2:42:27 PM (16 years ago)

Author:

rhenders

Message:

Now able to create stack-stage table descriptions.

File:

• trunk/ippToPsps/scripts/pspsSchema2xml.pl (modified) (6 diffs)

trunk/ippToPsps/scripts/pspsSchema2xml.pl

@@ -29 +29 @@
 defined $type;
 
-if ($type ne "DT" && $type ne "IN" && $type ne "OB") {
+if ($type ne "DT" && $type ne "IN" && $type ne "OB" && $type ne "ST") {
 
     print "Don't understand type '$type'\n"; 
@@ -45 +45 @@
 elsif ($type eq "DT") {createDetections($schemaPath);}
 elsif ($type eq "OB") {createDiffs($schemaPath);}
+elsif ($type eq "ST") {createStacks($schemaPath);}
 
 # finish up XML
@@ -54 +55 @@
 
 
-# creates detections mappings
+# creates detections tables
 sub createInit {
     my ($schemaPath) = @_;
@@ -70 +71 @@
 }
 
-# creates init batch mappings
+# creates init batch tables
 sub createDetections {
     my ($schemaPath) = @_;
@@ -81 +82 @@
 }
 
-# creates diff batch mappings
+# creates diff batch tables
 sub createDiffs {
     my ($schemaPath) = @_;
@@ -89 +90 @@
     parseTable("$schemaPath/PanSTARRS.Tables.Slice.sql", "dbo.StackLowSigDelta");
     parseTable("$schemaPath/PanSTARRS.Tables.Slice.sql", "dbo.StackHighSigDelta");
+}
+
+# creates stack batch tables
+sub createStacks {
+    my ($schemaPath) = @_;
+
+    parseTable("$schemaPath/PanSTARRS.Tables.Slice.sql", "dbo.StackMeta");
+    parseTable("$schemaPath/PanSTARRS.Tables.Slice.sql", "dbo.StackDetection");
+    parseTable("$schemaPath/PanSTARRS.Tables.LoadMerge.sql", "dbo.SkinnyObject");
+    parseTable("$schemaPath/PanSTARRS.Tables.Slice.sql", "dbo.StackOrphan");
+    parseTable("$schemaPath/PanSTARRS.Tables.Common.sql", "dbo.ObjectCalColor");
 }