Changeset 27526 for branches/eam_branches/20100225/ippToPsps/scripts/pspsSchema2xml.pl

Timestamp:

Mar 30, 2010, 9:40:04 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/eam_branches/20100225

Files:

• . (modified) (1 prop)
• ippToPsps/scripts/pspsSchema2xml.pl (modified) (3 diffs)

branches/eam_branches/20100225/ippToPsps/scripts/pspsSchema2xml.pl

@@ -89 +89 @@
 
             while (<FILE>) {
-                if ($_ =~ m/.*CREATE TABLE.*$tableName/) {
+                if ($_ =~ m/.*CREATE TABLE\s+dbo\.$tableName\s*\(/i) {
 
                     close (FILE);
@@ -209 +209 @@
         }
 
-        if($reading && $_ =~ m/^\)/) {$reading = 0;}
+        if($reading && $_ =~ m/^\s*\)\s*/) {$reading = 0;}
 
         if(!$reading) {next;}
@@ -218 +218 @@
         if (!$line) {next;}
         if (length($line) < 5) {next;}
-        if ($line =~ m/^--/) {next;}
+        if ($line =~ m/^\s*--/) {next;}
         if ($line =~ m/\/\*/) {next;}
         if ($line =~ m/\*\//) {next;}