tests: add a string column with digits validation (#43546)

tests/conftest.py

@@ -103,6 +103,8 @@ formdef.fields = [
     fields.StringField(id='5', label='5th field', type='string', anonymise=False, varname='stringCaseSensitive-é'),
     fields.BoolField(id='6', label='6th field duplicate', type='bool', varname='duplicate'),
     fields.StringField(id='7', label='7th field duplicate', type='string', anonymise=False, varname='duplicate'),
+    fields.StringField(id='8', label='8th field integer', type='string', anonymise=False, varname='integer',
+        validation={'type': 'digits'}),
 ]
 formdef.store()
 
@@ -134,6 +136,7 @@ for i in range(50):
         formdata.data['4_display'] = "open'three"
 
     formdata.data['3'] = bool(i % 2)
+    formdata.data['8'] = str(i % 10)
     if i%3 == 0:
         formdata.jump_status('new')
     else:

tests/olap.model

@@ -287,6 +287,13 @@
                "name": "stringCaseSensitive-é",
                "type": "string",
                "value": "\"field_stringCaseSensitive-é\""
+            },
+            {
+               "filter": true,
+               "label": "8th field integer",
+               "name": "integer",
+               "type": "string",
+               "value": "\"field_integer\""
             }
          ],
          "fact_table" : "\"formdata_demande\"",

tests/test_wcs.py

@@ -85,6 +85,7 @@ def test_wcs_fixture(wcs, postgres_db, tmpdir, olap_cmd, caplog):
         ('formdata_demande', 'field_bool'),
         ('formdata_demande', 'field_itemOpen'),
         ('formdata_demande', 'field_stringCaseSensitive-\xe9'),
+        ('formdata_demande', 'field_integer'),
         ('formdata_demande', 'function__receiver'),
         ('formdata_demande_field_item', 'id'),
         ('formdata_demande_field_item', 'label'),