tests: add check for user_label migration (#34179)

tests/test_sql.py

@@ -1831,3 +1831,24 @@ def test_migration_30_anonymize_evo_who():
     assert cur.fetchone() == (1,)
     conn.commit()
     cur.close()
+
+@postgresql
+def test_migration_31_user_label():
+    conn, cur = sql.get_connection_and_cursor()
+    cur.execute('UPDATE wcs_meta SET value = 30 WHERE key = %s', ('sql_level',))
+    cur.execute('DROP VIEW wcs_all_forms CASCADE')
+
+    cur.execute('DROP VIEW wcs_view_1_tests')
+    cur.execute('ALTER TABLE formdata_1_tests DROP COLUMN user_label')
+    sql.drop_views(formdef, conn, cur)
+    assert not column_exists_in_table(cur, 'formdata_1_tests', 'user_label')
+
+    sql.migrate()
+
+    assert column_exists_in_table(cur, 'formdata_1_tests', 'user_label')
+    assert column_exists_in_table(cur, 'wcs_view_1_tests', 'user_label')
+    assert column_exists_in_table(cur, 'wcs_all_forms', 'user_label')
+    assert migration_level(cur) >= 31
+
+    conn.commit()
+    cur.close()