Page MenuHomePhabricator

Use new database schema in export script
Closed, ResolvedPublic1 Estimated Story Points

Description

Acceptance criteria

Implementation Notes

  • The SQL queries for this change are encapsulated in the ExportQueryBuilder classes in the DonationExport, MembershipExport and SubscriptionExport namespaces.
  • The query in ExportQueryBuilder can be extended to join the payment tables.
  • The query building should be changed to use Doctrine DBAL.
  • We should introduce using the payment tables for getting the data.
  • Create custom export fields as needed and
  • Nested JSON syntax is probably different in SQLite and mysql. If so, don't unit test in SQLite.
  • Add a membership application fixture using a PayPal payment.

Related Objects

StatusSubtypeAssignedTask
OpenNone
OpenNone
OpenNone
OpenNone
ResolvedNone
OpenNone
OpenNone
Resolvedgabriel-wmde
Resolvedgabriel-wmde
Resolvedgabriel-wmde
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
Resolvedkai.nissen
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
InvalidNone
ResolvedNone
ResolvedNone
Resolvedkai.nissen
Resolvedgabriel-wmde
ResolvedNone
Resolvedkai.nissen
ResolvedNone
ResolvedNone
ResolvedNone
Resolvedgabriel-wmde
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
Resolvedgabriel-wmde
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
ResolvedNone
Resolvedkai.nissen
Resolvedgabriel-wmde
ResolvedNone
ResolvedNone
ResolvedNone
DuplicateNone
Resolvedkai.nissen
ResolvedNone
Resolvedkai.nissen
DuplicateNone
OpenNone
ResolvedNone
OpenNone
ResolvedNone

Event Timeline

PR https://github.com/wmde/fundraising-backend/pull/737 uses the new payment tables for memberships, the payment-related Export fields can be copied into the Export field collection for donations. We should not do that during the campaign.

kai.nissen set the point value for this task to 13.
kai.nissen changed the point value for this task from 13 to 3.Jun 28 2023, 10:29 AM
kai.nissen changed the point value for this task from 3 to 2.
kai.nissen changed the point value for this task from 2 to 1.Jul 24 2023, 10:21 AM