Function main

app/scripts/verify_sunset_subscriptions.py:18–117

()

def main():
    # Get environment variables
    stripe_secret_key = os.getenv('STRIPE_SECRET_KEY')
    if not stripe_secret_key:
        logger.error("STRIPE_SECRET_KEY environment variable not set")
        sys.exit(1)

    stripe.api_key = stripe_secret_key

    logger.info("Checking for sunset legacy subscriptions...")

    # Counters
    total_active = 0
    sunset_legacy = 0
    cancelling_other_reason = 0
    not_cancelling = 0

    sunset_subscriptions = []

    try:
        # Get all active subscriptions
        has_more = True
        starting_after = None

        while has_more:
            params = {
                'status': 'active',
                'limit': 100,
            }
            if starting_after:
                params['starting_after'] = starting_after

            subscriptions = stripe.Subscription.list(**params)

            for sub in subscriptions.data:
                total_active += 1

                cancel_at_period_end = sub.get('cancel_at_period_end', False)
                cancellation_reason = sub.get('metadata', {}).get('cancellation_reason')

                # This is the exact check from the webhook handler
                if cancel_at_period_end and cancellation_reason == 'billing_model_change':
                    sunset_legacy += 1

                    # Get customer email for display
                    customer_email = 'unknown'
                    try:
                        customer = stripe.Customer.retrieve(sub.get('customer'))
                        customer_email = customer.get('email', 'unknown')
                    except:
                        pass

                    # Calculate days until cancellation
                    current_period_end_ts = sub.get('current_period_end')
                    if current_period_end_ts:
                        current_period_end = datetime.fromtimestamp(current_period_end_ts)
                        days_until_cancel = (current_period_end - datetime.now()).days
                        cancel_date = current_period_end.strftime('%Y-%m-%d')