Page MenuHomePhabricator

Migrate donation tracking data to new table
Closed, ResolvedPublic3 Estimated Story Points

Description

Acceptance criteria

  • The database migration copies the existing tracking data of donations to the new tracking table.

Implementation details

  • Create a migration that adds the new entity table and adds the tracking_id property to the donation (spenden) table
  • Create a script that reads existing donations and their tracking information, creating new entries in the tracking table as needed (each campaign/keyword combination should be unique) and updating the donation. Don't do this in the migration because you need to query and modify the 7Mio+ donations in batches. Test the script in the test environment with the full production data set.

Event Timeline

kai.nissen set the point value for this task to 8.May 17 2023, 11:57 AM
kai.nissen changed the point value for this task from 8 to 5.Mar 18 2025, 10:42 AM
kai.nissen removed the point value 5 for this task.
kai.nissen added a subscriber: AbbanWMDE.
gabriel-wmde set the point value for this task to 3.Apr 1 2025, 9:58 AM

we can run the migration in our test infrastructure and have to test whether making donations is still possible

Deployed to test, fixed structure & data migration. This now needs to be rolled out to prod (without the data migration), see instructions in T390996: Integrate Donation tracking changes in Fundraising Application

gabriel-wmde moved this task from Doing to Done on the WMDE-FUN-Sprint-2025-04-01 board.
kai.nissen claimed this task.