<commit_before>-- IFS-2123 - Temporarily modify test data to allow testing for backwards compatability for this feature
-- Remove the new research category question from one example competition in the web test data

SET @competition_id = (SELECT id FROM competition WHERE name="Photonics for All");
SET @question_id = (SELECT id FROM question WHERE competition_id=@competition_id AND question_setup_type="RESEARCH_CATEGORY");

DELETE from question_status WHERE question_id = @question_id;
DELETE from question WHERE id = @question_id;<commit_msg>IFS-4110: Temporary tweak to webtest data. 'Make photonics for public' an example of a competition that had application team question but not research category question.<commit_after>-- IFS-2123 - Temporarily modify test data to allow testing for backwards compatability for this feature
-- Remove the new research category question from one example competition in the web test data which _doesn't_ have the
-- new application team view either

SET @competition_id = (SELECT id FROM competition WHERE name="Photonics for All");
SET @question_id = (SELECT id FROM question WHERE competition_id=@competition_id AND question_setup_type="RESEARCH_CATEGORY");

DELETE from question_status WHERE question_id = @question_id;
DELETE from question WHERE id = @question_id;

-- Remove the new research category question from one example competition in the web test data
-- For a competition which _does_ have the new application team view deployed.
SET @competition_id = (SELECT id FROM competition WHERE name="Photonics for Public");
SET @question_id = (SELECT id FROM question WHERE competition_id=@competition_id AND question_setup_type="RESEARCH_CATEGORY");

DELETE from question_status WHERE question_id = @question_id;
DELETE from question WHERE id = @question_id;
{'fraction_non_alphanumeric': 0.05758582502768549, 'fraction_numerical': 0.006644518272425249, 'mean_word_length': 5.896946564885496, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '426325', 'n_tokens_mistral': 460, 'n_tokens_neox': 448, 'n_words': 215}