User Details
User Details
- User Since
- Aug 2 2023, 3:42 PM (149 w, 6 d)
- Availability
- Available
- LDAP User
- Unknown
- MediaWiki User
- Ricki Jay (WMDE) [ Global Accounts ]
Yesterday
Yesterday
Thu, Jun 11
Thu, Jun 11
RickiJay-WMDE moved T424681: [Scraper] Add full-text search to frontend from Review to Done on the Wikibase Suite Team (Sprint 19 (Jun 09 - Jun 23)) board.
Tue, Jun 9
Tue, Jun 9
RickiJay-WMDE moved T424681: [Scraper] Add full-text search to frontend from Doing to Review on the Wikibase Suite Team (Sprint 19 (Jun 09 - Jun 23)) board.
Mon, Jun 8
Mon, Jun 8
RickiJay-WMDE added a comment to T426942: [Scraper] Update Database Checks: Quantity Observations.
SELECT COUNT(*), COUNT(DISTINCT wikibase_id), wb_type FROM wikibase_quantity_observation JOIN wikibase ON wikibase_quantity_observation.wikibase_id = wikibase.id WHERE total_items = 0 OR total_properties = 0 OR total_triples = 0 GROUP BY wb_type;
Fri, Jun 5
Fri, Jun 5
RickiJay-WMDE added a comment to T426940: [Scraper] Update Database Checks: Populated Wikibase Software.
Attempted to follow software fetcher logic; kept getting 403 responses. Added log warning for responses other than 200. Folo recommended.
RickiJay-WMDE moved T426944: [Scraper] Update Database Checks: Wikibase Name from Review to Done on the Wikibase Suite Team (Sprint 18 (May 26 - June 9)) board.
RickiJay-WMDE moved T426172: [Scraper] Add Statistics from Review to Done on the Wikibase Suite Team (Sprint 18 (May 26 - June 9)) board.
RickiJay-WMDE changed the status of T426940: [Scraper] Update Database Checks: Populated Wikibase Software, a subtask of T411797: [Scraper] Assess Database Check Findings, from Open to In Progress.
RickiJay-WMDE changed the status of T426940: [Scraper] Update Database Checks: Populated Wikibase Software from Open to In Progress.
Thu, Jun 4
Thu, Jun 4
RickiJay-WMDE changed the status of T426937: [Scraper] Update Database Checks: Nonzero Wikibase Log Observation Month, a subtask of T411797: [Scraper] Assess Database Check Findings, from Open to In Progress.
RickiJay-WMDE changed the status of T426937: [Scraper] Update Database Checks: Nonzero Wikibase Log Observation Month from Open to In Progress.
RickiJay-WMDE changed the status of T426944: [Scraper] Update Database Checks: Wikibase Name, a subtask of T411797: [Scraper] Assess Database Check Findings, from Open to In Progress.
RickiJay-WMDE changed the status of T426944: [Scraper] Update Database Checks: Wikibase Name from Open to In Progress.
Mon, Jun 1
Mon, Jun 1
RickiJay-WMDE changed the status of T425613: [Scraper] Update .env.template from Open to In Progress.
RickiJay-WMDE changed the status of T425613: [Scraper] Update .env.template, a subtask of T414610: [Scraper] Release first Wikibase discovery prototype - 09.06.2026, from Open to In Progress.
Tue, May 26
Tue, May 26
RickiJay-WMDE moved T427268: [Scraper] Missing Action API when Empty from Ready for Sprint to Ready for Refinement on the Wikibase Suite Team board.
RickiJay-WMDE moved T424681: [Scraper] Add full-text search to frontend from Backlog to Doing on the Wikibase Suite Team (Sprint 18 (May 26 - June 9)) board.
RickiJay-WMDE moved T424681: [Scraper] Add full-text search to frontend from Ready for Sprint to Sprint 18 (May 26 - June 9) on the Wikibase Suite Team board.
Fri, May 22
Fri, May 22
RickiJay-WMDE changed the status of T424681: [Scraper] Add full-text search to frontend, a subtask of T424657: [Scraper] UI Overhaul, from Open to In Progress.
RickiJay-WMDE changed the status of T424681: [Scraper] Add full-text search to frontend from Open to In Progress.
Thu, May 21
Thu, May 21
RickiJay-WMDE moved T425933: [Scraper] Feedback Button from Doing to Review on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE moved T411797: [Scraper] Assess Database Check Findings from Review to Done on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE renamed T425613: [Scraper] Update .env.template from [Scraper] Add env-example to [Scraper] Update .env.template.
RickiJay-WMDE moved T425932: [Scraper] Total Widgets from Review to Done on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE moved T411797: [Scraper] Assess Database Check Findings from Backlog to Review on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE placed T426940: [Scraper] Update Database Checks: Populated Wikibase Software up for grabs.
RickiJay-WMDE placed T426942: [Scraper] Update Database Checks: Quantity Observations up for grabs.
RickiJay-WMDE added a comment to T411797: [Scraper] Assess Database Check Findings.
wikibase_expectation_suite.json
- wikibase_name: whitespace: 100% -> 97%
- Could not find any such records
- Reset expectation to 100%
- wb_type: expect_column_distinct_values_to_be_in_set: add TEST
- VALID
RickiJay-WMDE added a comment to T411797: [Scraper] Assess Database Check Findings.
wikibase_log_observation_month_type_expectation_suite.json
- log_type: expect_column_distinct_values_to_be_in_set: add PAGE_TRANSLATE_REVIEW, UNCLASSIFIED, USER_UNBLOCK
- VALID
RickiJay-WMDE added a comment to T411797: [Scraper] Assess Database Check Findings.
wikibase_url_expectation_suite.json
- url: whitespace: removed
- Replaced by below: VALID
RickiJay-WMDE renamed T426940: [Scraper] Update Database Checks: Populated Wikibase Software from [Scraper] Update Database Checks: Nonzero Wikibase Log Observation Month to [Scraper] Update Database Checks: Populated Wikibase Software.
RickiJay-WMDE added a comment to T411797: [Scraper] Assess Database Check Findings.
valid_wikibase_quantity_observation_expectation_suite.json
- total_items: min_value: 1 -> 0
- Valid - though, check if instances are actual Wikibases
- total_properties: min_value: 1 -> 0
- Valid - though, check if instances are actual Wikibases
- total_triples: min_value: 1 -> 0
- Valid - though, check if instances are actual Wikibases
RickiJay-WMDE added a comment to T411797: [Scraper] Assess Database Check Findings.
valid_wikibase_external_identifier_observation_expectation_suite.json
- total_external_identifier_properties: min_value: 1 -> 0
- Valid
- total_external_identifier_statements: min_value: 1 -> 0
- Valid
- total_url_properties: min_value: 1 -> 0
- Valid
- total_url_statements: min_value: 1 -> 0
- Valid
RickiJay-WMDE added a comment to T411797: [Scraper] Assess Database Check Findings.
populated_wikibase_software_expectation_suite.json
- description: expect_column_values_to_not_be_null: 70% -> 55%
- Per spot-checking, several instances have url but no other data, and webpages do have no text. However, some have latest_version data but not descriptions, and websites do appear to have description text. Suggest: periodic re-fetch expectations that have no descriptions but have other data, investigate fetcher for proper description parsing
- latest_version: expect_column_values_to_not_be_null: 60% -> 49%
- Per spot-checking: several instances legit do not have this datum. Remove expectation
- quarterly_download_count: expect_column_values_to_not_be_null: 25% -> 0.1%
- Per spot-checking: several instances legit do not have this datum. Remove expectation
- public_wiki_count: expect_column_values_to_not_be_null: 25% -> 0.1%
- Per spot-checking: several instances legit do not have this datum. Remove expectation
- mw_bundled: expect_column_values_to_not_be_null: 75% -> 57%
- Found 1 record where not archived and mw_bundled null
- archived: expect_column_values_to_not_be_null: 75% -> 57%
- Per spot-checking: several instances have entirely blank pages
- Suggest: move all criteria except archived to another validation definition that also filters on not archived
RickiJay-WMDE changed the status of T411797: [Scraper] Assess Database Check Findings from Open to In Progress.
nonzero_wikibase_log_observation_month_expectation_suite.json
- user_count_no_bot: expect_column_values_to_not_be_null: 100% -> 98%
- Constructor should never result in null value
- 1 record fits the bill - anything is false, and it appears to have crashed on the previous active_user_count step
- Suggest: further filter data query to anything is true, reset expection to 100%
RickiJay-WMDE changed the status of T411797: [Scraper] Assess Database Check Findings, a subtask of T414610: [Scraper] Release first Wikibase discovery prototype - 09.06.2026, from Open to In Progress.
Tue, May 19
Tue, May 19
RickiJay-WMDE moved T425933: [Scraper] Feedback Button from Backlog to Doing on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE moved T425933: [Scraper] Feedback Button from Ready for Sprint to Sprint 17 (May 12 - 26) on the Wikibase Suite Team board.
RickiJay-WMDE changed the status of T425933: [Scraper] Feedback Button, a subtask of T424657: [Scraper] UI Overhaul, from Open to In Progress.
RickiJay-WMDE reopened T425931: [Scraper] Style Cleanup, a subtask of T424657: [Scraper] UI Overhaul, as In Progress.
RickiJay-WMDE reopened T425931: [Scraper] Style Cleanup as "In Progress".
RickiJay-WMDE closed T425931: [Scraper] Style Cleanup, a subtask of T424657: [Scraper] UI Overhaul, as Resolved.
RickiJay-WMDE moved T425931: [Scraper] Style Cleanup from Review to Done on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE moved T426172: [Scraper] Add Statistics from Doing to Review on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE moved T426172: [Scraper] Add Statistics from Backlog to Doing on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE changed the status of T426172: [Scraper] Add Statistics, a subtask of T424657: [Scraper] UI Overhaul, from Open to In Progress.
RickiJay-WMDE added a comment to T426172: [Scraper] Add Statistics.
@Leif_WMDE I'm assuming the EI statistic called for is the total EI statements? We also have total EI properties, total URL statements, and total URL properties.
RickiJay-WMDE added a comment to T426172: [Scraper] Add Statistics.
Per discussion with Leif, omit Entity Schemas
Mon, May 18
Mon, May 18
RickiJay-WMDE moved T425932: [Scraper] Total Widgets from Done to Review on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE moved T425932: [Scraper] Total Widgets from Doing to Done on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE moved T425932: [Scraper] Total Widgets from Backlog to Doing on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE changed the status of T425932: [Scraper] Total Widgets, a subtask of T424657: [Scraper] UI Overhaul, from Open to In Progress.
May 15 2026
May 15 2026
RickiJay-WMDE moved T425931: [Scraper] Style Cleanup from Doing to Review on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
RickiJay-WMDE moved T425931: [Scraper] Style Cleanup from Backlog to Doing on the Wikibase Suite Team (Sprint 17 (May 12 - 26)) board.
May 13 2026
May 13 2026
May 12 2026
May 12 2026
RickiJay-WMDE moved T409419: [Scraper] Intended for reuse - new flag from Review to Done on the Wikibase Suite Team (Sprint 16 (Apr 28 - May 12)) board.
May 11 2026
May 11 2026
RickiJay-WMDE moved T425933: [Scraper] Feedback Button from Sprint 16 (Apr 28 - May 12) to Ready for Sprint on the Wikibase Suite Team board.
RickiJay-WMDE moved T425932: [Scraper] Total Widgets from Sprint 16 (Apr 28 - May 12) to Ready for Sprint on the Wikibase Suite Team board.
RickiJay-WMDE moved T424657: [Scraper] UI Overhaul from Sprint 16 (Apr 28 - May 12) to Ready for Sprint on the Wikibase Suite Team board.
RickiJay-WMDE moved T425931: [Scraper] Style Cleanup from Backlog to Doing on the Wikibase Suite Team (Sprint 16 (Apr 28 - May 12)) board.
RickiJay-WMDE moved T424657: [Scraper] UI Overhaul from Doing to Backlog on the Wikibase Suite Team (Sprint 16 (Apr 28 - May 12)) board.
RickiJay-WMDE changed the status of T425931: [Scraper] Style Cleanup, a subtask of T424657: [Scraper] UI Overhaul, from Open to In Progress.
RickiJay-WMDE changed the status of T424657: [Scraper] UI Overhaul, a subtask of T414610: [Scraper] Release first Wikibase discovery prototype - 09.06.2026, from In Progress to Open.
RickiJay-WMDE placed T425932: [Scraper] Total Widgets up for grabs.
RickiJay-WMDE added a subtask for T424657: [Scraper] UI Overhaul: T424681: [Scraper] Add full-text search to frontend.
