After this switch, property terms will be written to both old store (wb_terms table) and the new one (wbt_text, wbt_type, wbt_text_in_lang, wbt_term_in_lang and wbt_property_terms).
Order of SWAT patches:
- Introduce config variables for new terms store in mediawiki-config (nothing to test apart from wikidata is loading) - https://gerrit.wikimedia.org/r/c/operations/mediawiki-config/+/517819
- Switch property terms migration to WRITE_BOTH on test wikidata (test on test wikidata, see next section) https://gerrit.wikimedia.org/r/c/operations/mediawiki-config/+/517820
- Switch property terms migration to WRITE_BOTH on wikidata production (test on production wikidata, see next section) - https://gerrit.wikimedia.org/r/c/operations/mediawiki-config/+/517674
How to test changes in SWAT
- You need access to test and production (at least to run maintenance/sql.php to execute some sql)
- Add/Update a property labels/descriptions/aliases in different languages of a property (use sandbox property on production https://www.wikidata.org/wiki/Property:P2368)
- Check new terms store tables for the data. Here's a helper sql query to run to get all terms of that property from new store tables:
SELECT wbxl_language as term_language, wby_name as term_type, wbx_text as term_text FROM wbt_property_terms INNER JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id INNER JOIN wbt_type ON wbtl_type_id = wby_id INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id INNER JOIN wbt_text ON wbxl_text_id = wbx_id WHERE wbpt_property_id = 123 -- put here the numeric property id (without the P prefix) ;