[BUGFIX][Processing] Fix spatialite version comparison

qgis · Apr 20, 2017 · b35bbb6 · b35bbb6
1 parent ca40e11
commit b35bbb6
Showing 1 changed file with 3 additions and 3 deletions.
diff --git a/python/plugins/processing/algs/qgis/spatialite_utils.py b/python/plugins/processing/algs/qgis/spatialite_utils.py
@@ -26,6 +26,7 @@
 __revision__ = '$Format:%H$'
 
 from pyspatialite import dbapi2 as sqlite
+import re
 
 
 class DbError(Exception):
@@ -64,11 +65,10 @@ def init_spatialite(self):
         try:
             self._exec_sql(c, u'SELECT spatialite_version()')
             rep = c.fetchall()
-            v = [int(a) for a in rep[0][0].split('.')]
-            vv = v[0] * 100000 + v[1] * 1000 + v[2] * 10
+            v = [int(x) if x.isdigit() else x for x in re.findall("\d+|[a-zA-Z]+", rep[0][0])]
 
             # Add spatialite support
-            if vv >= 401000:
+            if v >= [4, 1, 0]:
                 # 4.1 and above
                 sql = "SELECT initspatialmetadata(1)"
             else: