This ticket is about changing how the analysis code queries the donation database - querying database for donations with matching campaign and keywords instead of iterating over donations and checking the tracking data in PHP.

Affected repositories

• Fundraising Operation Center

Implementation Details:

1. Change the test code to automatically create the tracking entities before creating the donation entities (e.g. by reusing the same Tracking entities and assigning them to different donations). Don't remove the tracking info from the data blob yet (to avoid breaking the tests)
2. Change DatabaseDonationReader:
   1. join the tracking table the query builder and query it with the given keywords and campaign.
   2. remove the if statement that checks for a $trackingData match
   3. create the Tracking object from the $row result instead of unserializing data
3. Remove the embedding of the tracking data (calls to encodeAndSetData) from the test code

The changes might break AnalysisTest. If that happens, you'll have to investigate if the data migration in T338509: Adapt donation fixtures for tests was not done properly or if there is another underlying cause.