Page MenuHomePhabricator

Add script to insert or update the status of translatable pages in translatable_bundles table
Closed, ResolvedPublic4 Estimated Story Points

Description

Once we have the table (T317601), we need to populate the data in the table with content from all the translatable pages. The script should do the following:

  1. Fetch all translatable pages
  2. Determine the status of the translatable page based on the values in the revtag table
  3. Insert or update existing record in the table created in T317601

Note that we do not do any processing for message bundles right now.

Other TODO:

  • Reduce the output from the script.
  • Ensure that this script runs on update.php.

Event Timeline

Change 835611 had a related patch set uploaded (by Abijeet Patro; author: Abijeet Patro):

[mediawiki/core@master] Introduce LanguageVariantConverter

https://gerrit.wikimedia.org/r/835611

Change 836131 had a related patch set uploaded (by Abijeet Patro; author: Abijeet Patro):

[mediawiki/extensions/Translate@master] Add script to sync translatable bundle status from the rev_tag table

https://gerrit.wikimedia.org/r/836131

Change 836131 merged by jenkins-bot:

[mediawiki/extensions/Translate@master] Add script to sync translatable bundle status from the rev_tag table

https://gerrit.wikimedia.org/r/836131

This was deployed and tested on translatewiki.net. No issues were noticed. The script populated the translatable bundle status table with correct information

Change 841388 had a related patch set uploaded (by Abijeet Patro; author: Abijeet Patro):

[mediawiki/extensions/Translate@master] Schedule syncing of translatable bundle status in update.php

https://gerrit.wikimedia.org/r/841388

Change 841388 merged by jenkins-bot:

[mediawiki/extensions/Translate@master] Schedule syncing of translatable bundle status in update.php

https://gerrit.wikimedia.org/r/841388

We deployed and tested this on translatewiki.net on Nov, 2nd 2022. This script ran via maintenance/update.php. No unsynced changes were found on the server.