Changeset 5692 for spike/wktraster/scripts/gdal2wktraster.py

Timestamp:

06/11/10 11:50:38 (2 years ago)

Author:

pracine

Message:

We are always creating only one table, even when loading many rasters and apparently even when using the -l option, so there is no reason to add two CREATE INDEX and VACUUM lines in the SQL output. Adding two CREATE INDEX was making the loading process to abort.

Files:

• spike/wktraster/scripts/gdal2wktraster.py (modified) (3 diffs)

spike/wktraster/scripts/gdal2wktraster.py

@@ -359 +359 @@
     logit("MSG: Create GiST spatial index on %s\n" % gist_table)
 
-    sql = "CREATE INDEX \"%s_%s_gist\" ON %s USING GIST (st_convexhull(%s));\n" % \
+    sql = "CREATE INDEX \"%s_%s_gist_idx\" ON %s USING GIST (st_convexhull(%s));\n" % \
           (gist_table, column, target_table, column)
     logit("SQL: %s" % sql)
@@ -979 +979 @@
     # INDEX
     if opts.index and SUMMARY is not None:
-        for s in SUMMARY:
-            sql = make_sql_create_gist(s[0], opts.column)
-            opts.output.write(sql)
+        sql = make_sql_create_gist(SUMMARY[0][0], opts.column)
+        opts.output.write(sql)
     
     # COMMIT
@@ -988 +987 @@
     # VACUUM
     if opts.vacuum and SUMMARY is not None:
-        for s in SUMMARY:
-            sql = make_sql_vacuum(s[0])
-            opts.output.write(sql)
+        sql = make_sql_vacuum(SUMMARY[0][0])
+        opts.output.write(sql)
 
     # Cleanup