Store Donation tracking data in new table
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	gabriel-wmde
	Oct 15 2025, 4:34 PM

Description

We forgot to actually store the donation tracking data when refactoring.

Acceptance Criteria

The donation_tracking table contains tracking values when a donation gets stored
When a donation is read, the code first tries to read from trackingInfo and then falls back to legacy data blob data
Existing donations are migrated (no no-symlink deployment needed)

Data migration on deployment

create the file migrations-db.php file in the project root directory (current-release), with PDO connection data returned as an array. You can convert the db section from the JSON configuration file into PHP syntax.
run data migration script: php8.4 -d display_errors=1 -d memory_limit=4G vendor/wmde/fundraising-donations/bin/migrate-donation-tracking-data.

Related Objects
Search...

Status	Assigned	Task
Open	None	T203654 Improve Code and Architecture of Fundraising Frontend
Open	None	T203684 Improve code and architecture of Fundraising Operation Center
Open	None	T203679 Refactor fundraising database schema
Open	None	T328075 Move tracking out of donation data blob
Resolved	None	T407401 Store Donation tracking data in new table

Event Timeline

gabriel-wmde created this task.Oct 15 2025, 4:34 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 15 2025, 4:34 PM

gabriel-wmde moved this task from Backlog to Current Sprint on the WMDE-Fundraising-Tech board.Oct 17 2025, 7:43 PM

gabriel-wmde mentioned this in T336848: Change how the donation bounded context stores tracking data.Oct 17 2025, 7:56 PM

gabriel-wmde updated the task description. (Show Details)Oct 17 2025, 7:58 PM

gabriel-wmde added a parent task: T328075: Move tracking out of donation data blob.

PR for donations: https://github.com/wmde/fundraising-donations/pull/332
PR for application (draft until we have a new minor release of donations): https://github.com/wmde/fundraising-application/pull/3153

gabriel-wmde moved this task from In Progress / Deployment (max. 4 tasks) to Code Review (max. 4 tasks) on the WMDE-FUN-Funban-2025 board.Oct 21 2025, 2:18 PM

CorinnaHillebrand_WMDE moved this task from Code Review (max. 4 tasks) to Deploy to Test (max. 4 tasks) on the WMDE-FUN-Funban-2025 board.Oct 23 2025, 3:06 PM

CorinnaHillebrand_WMDE moved this task from Deploy to Test (max. 4 tasks) to Deploy to Production on the WMDE-FUN-Funban-2025 board.Oct 24 2025, 8:04 AM

deployed to production

tbd:

create the file migrations-db.php file in the project root directory (current-release), with PDO connection data returned as an array. You can convert the db section from the JSON configuration file into PHP syntax.
run data migration script: php8.4 -d display_errors=1 -d memory_limit=4G vendor/wmde/fundraising-donations/bin/migrate-donation-tracking-data.

When running php8.4 -d display_errors=1 -d memory_limit=4G vendor/wmde/fundraising-donations/bin/migrate-donation-tracking-data the script failed and stated an error in

migrate-donation-tracking-data on line 6,
failing to open autoload.php from the vendor's folder

CorinnaHillebrand_WMDE moved this task from Deploy to Production to Ready for Work on the WMDE-FUN-Funban-2025 board.Oct 29 2025, 1:53 PM

Try running php8.4 -d display_errors=1 -d memory_limit=4G vendor/bin/migrate-donation-tracking-data instead, that should take care of the autoload problems

CorinnaHillebrand_WMDE moved this task from Ready for Work to Deploy to Production on the WMDE-FUN-Funban-2025 board.Oct 29 2025, 3:36 PM

that works, thanks!

the script is currently running in screen -r donationTrackingDataMigration since 16:40