Skip to content

Instantly share code, notes, and snippets.

@Pchelolo

Pchelolo/gist:97124bc952c34e913f10b74331578e96

Created September 19, 2019 19:13
Show Gist options
  • Save Pchelolo/97124bc952c34e913f10b74331578e96 to your computer and use it in GitHub Desktop.
Save Pchelolo/97124bc952c34e913f10b74331578e96 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
/srv/mediawiki/php/extensions/WikimediaMaintenance/purgeStaleMemcachedText.php: $latestReplicatedTextId = $db->selectField( [ 'recentchanges', 'revision' ], 'rev_text_id',
/srv/mediawiki/php/extensions/WikimediaMaintenance/bug-53687/fixOrphans.php: 'ar_text_id' => 'rev_text_id',
/srv/mediawiki/php/extensions/WikimediaMaintenance/bug-53687/fixOrphans.php: 'ar_text_id' => $revRow->rev_text_id,
/srv/mediawiki/php/extensions/WikimediaMaintenance/bug-53687/find-orphans.sql:select up_page,up_timestamp,log_namespace,log_title,rev_id,ar_rev_id is not null as ar_rev_match,rev_text_id=ar_text_id as ar_text_match from revision left join archive on ar_rev_id=rev_id ,updates left join logging on up_timestamp=log_timestamp where log_action='delete' and rev_page=up_page and up_action='delete';
/srv/mediawiki/php/extensions/Translate/translationaids/TranslationAidDataProvider.php: 'text' => [ 'INNER JOIN', [ 'rev_text_id=old_id' ] ]
/srv/mediawiki/php/extensions/Translate/tag/PageTranslationHooks.php: $field = 'rev_text_id';
/srv/mediawiki/php/extensions/Translate/TranslateUtils.php: 'text' => [ 'JOIN', 'rev_text_id=old_id' ],
/srv/mediawiki/php/extensions/Translate/scripts/fuzzy.php: 'rev_text_id=old_id',
/srv/mediawiki/php/extensions/Translate/scripts/fuzzy.php: 'text' => [ 'JOIN', 'rev_text_id=old_id' ],
/srv/mediawiki/php/extensions/Translate/scripts/populateFuzzy.php: 'old_id = rev_text_id',
/srv/mediawiki/php/extensions/Translate/utils/MessageWebImporter.php: 'rev_text_id=old_id',
/srv/mediawiki/php/extensions/Translate/MessageCollection.php: 'text' => [ 'JOIN', 'old_id = rev_text_id' ],
/srv/mediawiki/php/extensions/Flow/maintenance/repair_missing_revision_content.php: " JOIN text ON revision.rev_text_id = old_id " .
/srv/mediawiki/php/extensions/Flow/maintenance/repair_missing_revision_content.php: " AND revision.rev_text_id <> parent.rev_text_id " .
/srv/mediawiki/php/extensions/EntitySchema/tests/phpunit/integration/MediaWiki/Specials/NewEntitySchemaTest.php: 'rev_text_id=old_id',
@Pchelolo
Copy link
Author

ppchelko@mwmaint1002:~$ grep ar_text_id -r /srv/mediawiki/php/extensions/
/srv/mediawiki/php/extensions/WikimediaMaintenance/bug-53687/fixOrphans.php: 'ar_text_id' => 'rev_text_id',
/srv/mediawiki/php/extensions/WikimediaMaintenance/bug-53687/fixOrphans.php: 'ar_text_id' => $revRow->rev_text_id,
/srv/mediawiki/php/extensions/WikimediaMaintenance/bug-53687/find-orphans.sql:select up_page,up_timestamp,log_namespace,log_title,rev_id,ar_rev_id is not null as ar_rev_match,rev_text_id=ar_text_id as ar_text_match from revision left join archive on ar_rev_id=rev_id ,updates left join logging on up_timestamp=log_timestamp where log_action='delete' and rev_page=up_page and up_action='delete';

@Pchelolo
Copy link
Author

grep text_id -r /srv/mediawiki/php/extensions/
/srv/mediawiki/php/extensions/Wikibase/repo/sql/AddNormalizedTermsTablesDDL.sql: wbxl_text_id INT unsigned NOT NULL
/srv/mediawiki/php/extensions/Wikibase/repo/sql/AddNormalizedTermsTablesDDL.sql:CREATE UNIQUE INDEX /i/wbt_text_in_lang_text_id_text_id ON /_/wbt_text_in_lang (wbxl_text_id, wbxl_language);
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsAcquirerTest.php: [ 'wbxl_text_id' => $sameTextId, 'wbxl_language' => 'en' ]
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsAcquirerTest.php: 'wbt_text_in_lang', [ 'wbxl_id', 'wbxl_text_id', 'wbxl_language' ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsAcquirerTest.php: 'wbxl_text_id' => $record->wbxl_text_id,
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsAcquirerTest.php: [ 'wbxl_language' => $lang, 'wbxl_text_id' => $textId ]
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsResolverTest.php: [ 'wbxl_language' => 'ru', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsCleanerTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsCleanerTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsCleanerTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsCleanerTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsCleanerTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsCleanerTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsCleanerTest.php: [ 'wbxl_language' => 'fr', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsCleanerTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsCleanerTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsCleanerTest.php: [ 'wbxl_language' => 'en', 'wbxl_text_id' => $text1Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/tests/phpunit/Store/Sql/Terms/DatabaseTermIdsCleanerTest.php: [ 'wbxl_language' => 'de', 'wbxl_text_id' => $text2Id ] );
/srv/mediawiki/php/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermIdsAcquirer.php: $textInLangRecords[] = [ 'wbxl_text_id' => $textId, 'wbxl_language' => $lang ];
/srv/mediawiki/php/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermIdsAcquirer.php: $textInLangIds[$acquiredId['wbxl_language']][$acquiredId['wbxl_text_id']]
/srv/mediawiki/php/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermIdsCleaner.php: 'wbxl_text_id',
/srv/mediawiki/php/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermIdsCleaner.php: 'wbxl_text_id',
/srv/mediawiki/php/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermIdsCleaner.php: [ 'wbxl_text_id' => $potentiallyUnusedTextIds ],
/srv/mediawiki/php/extensions/Wikibase/lib/includes/Store/Sql/Terms/DatabaseTermIdsResolver.php: 'wbxl_text_id=wbx_id',
/srv/mediawiki/php/extensions/WikimediaMaintenance/purgeStaleMemcachedText.php: $latestReplicatedTextId = $db->selectField( [ 'recentchanges', 'revision' ], 'rev_text_id',
/srv/mediawiki/php/extensions/WikimediaMaintenance/bug-53687/fixOrphans.php: 'ar_text_id' => 'rev_text_id',
/srv/mediawiki/php/extensions/WikimediaMaintenance/bug-53687/fixOrphans.php: 'ar_text_id' => $revRow->rev_text_id,
/srv/mediawiki/php/extensions/WikimediaMaintenance/bug-53687/find-orphans.sql:select up_page,up_timestamp,log_namespace,log_title,rev_id,ar_rev_id is not null as ar_rev_match,rev_text_id=ar_text_id as ar_text_match from revision left join archive on ar_rev_id=rev_id ,updates left join logging on up_timestamp=log_timestamp where log_action='delete' and rev_page=up_page and up_action='delete';
/srv/mediawiki/php/extensions/Translate/translationaids/TranslationAidDataProvider.php: 'text' => [ 'INNER JOIN', [ 'rev_text_id=old_id' ] ]
/srv/mediawiki/php/extensions/Translate/tag/PageTranslationHooks.php: $field = 'rev_text_id';
/srv/mediawiki/php/extensions/Translate/TranslateUtils.php: 'text' => [ 'JOIN', 'rev_text_id=old_id' ],
/srv/mediawiki/php/extensions/Translate/scripts/fuzzy.php: 'rev_text_id=old_id',
/srv/mediawiki/php/extensions/Translate/scripts/fuzzy.php: 'text' => [ 'JOIN', 'rev_text_id=old_id' ],
/srv/mediawiki/php/extensions/Translate/scripts/populateFuzzy.php: 'old_id = rev_text_id',
/srv/mediawiki/php/extensions/Translate/utils/MessageWebImporter.php: 'rev_text_id=old_id',
/srv/mediawiki/php/extensions/Translate/MessageCollection.php: 'text' => [ 'JOIN', 'old_id = rev_text_id' ],
/srv/mediawiki/php/extensions/AbuseFilter/includes/AbuseFilter.php: $text_id = substr( $stored_dump, strlen( 'stored-text:' ) );
/srv/mediawiki/php/extensions/AbuseFilter/includes/AbuseFilter.php: [ 'old_id' => $text_id ],
/srv/mediawiki/php/extensions/Flow/maintenance/repair_missing_revision_content.php: " JOIN text ON revision.rev_text_id = old_id " .
/srv/mediawiki/php/extensions/Flow/maintenance/repair_missing_revision_content.php: " AND revision.rev_text_id <> parent.rev_text_id " .
/srv/mediawiki/php/extensions/EntitySchema/tests/phpunit/integration/MediaWiki/Specials/NewEntitySchemaTest.php: 'rev_text_id=old_id',

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment