better quotes in processing/ogr import to postgis tools

Giovanni Manghi · Giovanni Manghi · commit dfc5670c5f00 · 2015-03-01T11:34:20.000Z
diff --git a/python/plugins/processing/algs/gdal/ogr2ogrtabletopostgislist.py b/python/plugins/processing/algs/gdal/ogr2ogrtabletopostgislist.py
@@ -88,7 +88,7 @@ def defineCharacteristics(self):
             self.tr('Primary key (existing field, used if the above option is left empty)'),
             self.INPUT_LAYER, optional=True))
         self.addParameter(ParameterString(self.WHERE,
-            self.tr('Select features using a SQL "WHERE" statement (Ex: column="value")'),
+            self.tr('Select features using a SQL "WHERE" statement (Ex: column=\'value\')'),
             '', optional=True))
         self.addParameter(ParameterString(self.GT,
             self.tr('Group N features per transaction (Default: 20000)'),
@@ -128,7 +128,7 @@ def processAlgorithm(self, progress):
         pkstring = "-lco FID="+pk
         primary_key = self.getParameterValue(self.PRIMARY_KEY)
         where = unicode(self.getParameterValue(self.WHERE))
-        wherestring = "-where '"+where+"'"
+        wherestring = '-where "'+where+'"'
         gt = unicode(self.getParameterValue(self.GT))
         overwrite = self.getParameterValue(self.OVERWRITE)
         append = self.getParameterValue(self.APPEND)
diff --git a/python/plugins/processing/algs/gdal/ogr2ogrtopostgis.py b/python/plugins/processing/algs/gdal/ogr2ogrtopostgis.py
@@ -122,7 +122,7 @@ def defineCharacteristics(self):
             self.tr('Clip the input layer using the above (rectangle) extent'),
             False))
         self.addParameter(ParameterString(self.WHERE,
-            self.tr('Select features using a SQL "WHERE" statement (Ex: column="value")'),
+            self.tr('Select features using a SQL "WHERE" statement (Ex: column=\'value\')'),
             '', optional=True))
         self.addParameter(ParameterString(self.GT,
             self.tr('Group N features per transaction (Default: 20000)'),
@@ -175,7 +175,7 @@ def processAlgorithm(self, progress):
         ogrspat = self.ogrConnectionString(spat)
         clip = self.getParameterValue(self.CLIP)
         where = unicode(self.getParameterValue(self.WHERE))
-        wherestring = "-where '"+where+"'"
+        wherestring = '-where "'+where+'"'
         gt = unicode(self.getParameterValue(self.GT))
         overwrite = self.getParameterValue(self.OVERWRITE)
         append = self.getParameterValue(self.APPEND)
diff --git a/python/plugins/processing/algs/gdal/ogr2ogrtopostgislist.py b/python/plugins/processing/algs/gdal/ogr2ogrtopostgislist.py
@@ -124,7 +124,7 @@ def defineCharacteristics(self):
             self.tr('Clip the input layer using the above (rectangle) extent'),
             False))
         self.addParameter(ParameterString(self.WHERE,
-            self.tr('Select features using a SQL "WHERE" statement (Ex: column="value")'),
+            self.tr('Select features using a SQL "WHERE" statement (Ex: column=\'value\')'),
             '', optional=True))
         self.addParameter(ParameterString(self.GT,
             self.tr('Group N features per transaction (Default: 20000)'),
@@ -181,7 +181,7 @@ def processAlgorithm(self, progress):
         ogrspat = self.ogrConnectionString(spat)
         clip = self.getParameterValue(self.CLIP)
         where = unicode(self.getParameterValue(self.WHERE))
-        wherestring = "-where '"+where+"'"
+        wherestring = '-where "'+where+'"'
         gt = unicode(self.getParameterValue(self.GT))
         overwrite = self.getParameterValue(self.OVERWRITE)
         append = self.getParameterValue(self.APPEND)
