Accounting: Update queries to work with `subscriptions` to `products` migration - Githubissues

polarsource / polar

From first donation to IPO. Polar is the funding & monetization platform for developers.

https://polar.sh

Apache License 2.0

1.52k stars 50 forks source link

Accounting: Update queries to work with `subscriptions` to `products` migration #3306

Open birkjernstrom opened 1 month ago

birkjernstrom commented 1 month ago

Just a log of changes we're making and thereafter need to make to our accounting queries & scripts.

From https://github.com/polarsource/polar/pull/3287

subscription_tiers has been renamed to products
subscription_tier_prices has been renamed to product_prices
Transaction.subscription_tier_price_id has been renamed to Transaction.product_price_id
Subscription.subscription_tier_id has been renamed to Subscription.product_id

From https://github.com/polarsource/polar/pull/3298

Transaction.subscription_id and Transaction.product_price_id are removed in favor of Transaction.order_id.
An Order is a new object representing a purchase (one-time or a recurring invoice for a subscription). It's linked to products, product_prices and, if it's a subscription, subscriptions.
EDIT 27/05: following #3345, Sale is now Order. Updated it above to reflect this.

birkjernstrom commented 1 month ago

@frankie567 Created this issue as a log of the changes I'll make later. Feel free to comment here in the future or continue to ping me in PRs (appreciate it) and I'll add them.