feat: add 'paused' value to stripe.subscription_status enum #197
Conversation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
|
Fixing the failing formatting here - #198 |
|
🎉 This PR is included in version 0.45.0 🎉 The release is available on GitHub release Your semantic-release bot 📦🚀 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
2 participants
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
What kind of change does this PR introduce?
Feature: Add support for "paused" subscription status in the database enum.
What is the current behavior?
The subscription_status enum in the database currently supports: trialing, active, canceled, incomplete,
incomplete_expired, past_due, and unpaid. However, Stripe supports an additional "paused" status for
subscriptions, but this value cannot be stored in the database due to the enum constraint.
Related issue: #196
What is the new behavior?
• The subscription_status enum now includes the "paused" value
• Subscriptions with "paused" status from Stripe webhooks can now be properly stored in the database
• The existing webhook handler for customer.subscription.paused events will now work correctly with
database persistence
Additional context
This change aligns the database schema with Stripe's complete subscription status API. The code already
handles customer.subscription.paused webhook events in stripeSync.ts, but the database enum was missing
this value, potentially causing issues when trying to sync paused subscriptions.
Migration details:
• Added migration file: 0039_add_paused_to_subscription_status.sql
• Uses PostgreSQL ALTER TYPE ... ADD VALUE to extend the existing enum
• Safe operation that doesn't affect existing data