Changeset 245 for trunk/import

Timestamp:

01/31/13 09:36:34 (11 years ago)

Author:

astrid.emde

Message:

View upper case, Comment on View, Test steht aus

File:

• trunk/import/pg-to-oci_keytables.pl (modified) (2 diffs)

trunk/import/pg-to-oci_keytables.pl

@@ -31 +31 @@
 open I, "alkis_PostNAS_keytables.sql";
 open O, ">alkis_PostNAS_ORACLE_keytables.sql";
+#open I, "nutzungsart_definition.sql";
+#open O, ">nutzungsart_definition_ORACLE.sql";
+#open I, "nutzungsart_laden.sql";
+#open O, ">nutzungsart_laden_ORACLE.sql";
+#open I, "pp_definition.sql";
+#open O, ">pp_definition_ORACLE.sql";
+#open I, "pp_laden.sql";
+#open O, ">pp_laden_ORACLE.sql";
+#open I, "sichten.sql";
+#open O, ">sichten_ORACLE.sql";
 
 $i = 0;
@@ -107 +117 @@
         s/INSERT INTO (\S+)/INSERT INTO \U$1\E/;
 
+        # View Tabellennamen in uppercase
+        s/CREATE OR REPLACE VIEW (\S+)/CREATE OR REPLACE VIEW \U$1\E/;
+
+        # View Comment in uppercase
+        s/COMMENT ON VIEW (\S+)/COMMENT ON VIEW \U$1\E/; 
+
         next if /^COMMENT ON TABLE (geometry_columns|spatial_ref_sys)/;