Changeset 14939 for main/waeup.kofa/trunk/src/waeup/kofa/utils/helpers.py

Timestamp:

18 Jan 2018, 07:34:42 (7 years ago)

Author:

Henrik Bettermann

Message:

Do not allow uploading data with trailing whitespaces.

File:

• main/waeup.kofa/trunk/src/waeup/kofa/utils/helpers.py (modified) (3 diffs)

main/waeup.kofa/trunk/src/waeup/kofa/utils/helpers.py

@@ -756 +756 @@
 
 def check_csv_charset(iterable):
-    """Check contents of `iterable` regarding valid CSV encoding.
+    """Check contents of `iterable` regarding valid CSV encoding and
+    trailing whitespaces in data.
 
     `iterable` is expected to be an iterable on _rows_ (not
@@ -764 +765 @@
 
     Returns line num of first illegal char or ``None``. Line nums
-    start counting with 1 (not zero).
+    start counting with 1 (not zero). Returns -1 if data contain
+    trailing whitespaces.
     """
     linenum = 1
@@ -771 +773 @@
         for row in reader:
             linenum += 1
+            for value in row.values():
+                if value.endswith(' '):
+                    return -1
     except UnicodeDecodeError:
         return linenum