New database tables for focus areas
Closed, ResolvedPublic3 Estimated Story Points
Actions

Assigned To

Authored By

	Cparle
	Mar 7 2025, 11:57 AM

Description

What + Why

Focus area data data needs to be stored in database tables.

Details

This ticket is to update and create the DB tables themselves

community_requests_focus_areas:
- crfa_page (int) FK to page.page_id for the base untranslated page
- crfa_status (int) ID of a status as stored in the code (i.e. not a FK)
- crfa_vote_count (int)
community_requests_focus_area_translations:
- crfat_id (int) PK
- crfat_fa_id (int) FK to community_requests_focus_areas.crfa_id
- crfat_lang (text) The lang code of the text in this row
- crfat_is_base_lang (bool) Whether this lang is the original untranslated one
- crfat_title (text)
- crfat_description (text) This corresponds to the short_description of the Community_Wishlist/Focus_area template.

See T387957 for the equivalent task for the wishes' DB structure.

Tipps for QA:

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	sql: redesign schema, starting with a clean slate	mediawiki/extensions/CommunityRequests	master	+696 -564
	sql: update schema for focus areas to include translations	mediawiki/extensions/CommunityRequests	master	+137 -26

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
Resolved	MusikAnimal	T366194 Migrate Community Wishlist to CommunityRequests extension
Resolved	dmaza	T388207 Add <focus-area> parser function to save focus area data
Resolved	MusikAnimal	T388223 New database tables for focus areas

Event Timeline

Cparle created this task.Mar 7 2025, 11:57 AM

Cparle mentioned this in T388207: Add <focus-area> parser function to save focus area data.Mar 7 2025, 11:59 AM

MusikAnimal edited parent tasks, added: T366194: Migrate Community Wishlist to CommunityRequests extension; removed: T387956: Build an extension version of the community wishlist gadget(s).Mar 10 2025, 5:13 PM

MusikAnimal added a parent task: T388207: Add <focus-area> parser function to save focus area data.Mar 11 2025, 3:57 AM

Cparle added a project: MediaWiki-extensions-CommunityRequests.Mar 11 2025, 4:15 PM

Cparle moved this task from Backlog to Focus areas on the MediaWiki-extensions-CommunityRequests board.

Samwilson updated the task description. (Show Details)Mar 12 2025, 1:43 AM

Looks good! Minor corrections:

communityrequests_focus_areas should be community_requests_focus_areas (assuming we don't care to rename existing tables)
communityrequests_focus_area_texts could instead be community_requests_focus_area_translations for parity with T387957 (or the inverse)

MusikAnimal mentioned this in T366194: Migrate Community Wishlist to CommunityRequests extension.Mar 20 2025, 8:15 PM

I think *_translations is clearest, although slightly longer.

Samwilson updated the task description. (Show Details)Mar 21 2025, 1:31 AM

Samwilson updated the task description. (Show Details)Mar 21 2025, 1:34 AM

Removed the PK from community_requests_focus_areas based on the reasoning in https://phabricator.wikimedia.org/T387957#10659061 (i.e. we don't really need a separate auto-incrementing PK as there will always be a corresponding page)

Cparle mentioned this in T387957: Update db schema for wishes to include translations.Mar 28 2025, 12:08 PM

Cparle renamed this task from New database tables for focus areas, plus php interface for them to New database tables for focus areas.Apr 29 2025, 4:30 PM

Cparle updated the task description. (Show Details)

• JWheeler-WMF set the point value for this task to 3.Apr 29 2025, 4:30 PM

MusikAnimal claimed this task.Apr 29 2025, 10:52 PM

MusikAnimal edited projects, added Community-Tech (Sea Lion Squad); removed Community-Tech.

MusikAnimal moved this task from Backlog - groomed to In Development on the Community-Tech (Sea Lion Squad) board.

Change #1139951 had a related patch set uploaded (by MusikAnimal; author: MusikAnimal):

[mediawiki/extensions/CommunityRequests@master] sql: update schema for focus areas to include translations

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

gerritbot added a project: Patch-For-Review.Apr 29 2025, 11:24 PM

MusikAnimal moved this task from In Development to Feedback and Review on the Community-Tech (Sea Lion Squad) board.Apr 29 2025, 11:24 PM

Change #1139950 had a related patch set uploaded (by MusikAnimal; author: MusikAnimal):

[mediawiki/extensions/CommunityRequests@master] sql: update schema to include translations, remove votes table

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

Change #1139951 abandoned by MusikAnimal:

[mediawiki/extensions/CommunityRequests@master] sql: update schema for focus areas to include translations

Reason:

merged into Ic8f0442f8a2d59760d2ea2bb9cba64fb20f80fed

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

KSiebert updated the task description. (Show Details)May 7 2025, 1:06 PM

@MusikAnimal I added a section for "QA Tipps" as this is something we generally neglect, see QA concerns during Retro.
As this is a database change and won't be surfaced to the UI, how will QA be able to verify this?

KSiebert updated the task description. (Show Details)May 7 2025, 1:11 PM

In T388223#10800248, @KSiebert wrote:

@MusikAnimal I added a section for "QA Tipps" as this is something we generally neglect, see QA concerns during Retro.
As this is a database change and won't be surfaced to the UI, how will QA be able to verify this?

They won't! Tim is essentially the QA for the database schema :)

I think it may be a bit before we need QA. https://wishlist-test.toolforge.org/wiki/Community_Wishlist will eventually be where testing is done, but right now what you see isn't data coming from the extension. I'll work with George to come up with a test plan when the time comes.

Change #1139950 merged by jenkins-bot:

[mediawiki/extensions/CommunityRequests@master] sql: redesign schema, starting with a clean slate

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

MusikAnimal mentioned this in rECORbb0c91dbad62: sql: redesign schema, starting with a clean slate.May 14 2025, 11:42 PM

Maintenance_bot removed a project: Patch-For-Review.May 15 2025, 12:30 AM

MusikAnimal closed this task as Resolved.May 19 2025, 8:19 PM

MusikAnimal removed a parent task: T366194: Migrate Community Wishlist to CommunityRequests extension.May 19 2025, 8:27 PM

MusikAnimal moved this task from Focus areas to Entities on the MediaWiki-extensions-CommunityRequests board.Nov 25 2025, 8:49 PM