Add database migration verification test for Stripe billing tables #1151

Open
opened 2026-04-12 16:56:17 -04:00 by pook · 0 comments
Owner

Write a test that verifies the stripe_customers and stripe_subscriptions tables (created by merged migration PR #656) exist with correct schema. Test should: (1) connect to test database, (2) run information_schema query to get column names and types for both tables, (3) verify required columns exist: stripe_customers (id, stripe_customer_id, email, user_id, created_at), stripe_subscriptions (id, stripe_subscription_id, stripe_customer_id, status, current_period_start, current_period_end, cancel_at_period_end, created_at), (4) verify status column supports required enum values. Fail on schema mismatch.


Generated by CEO Planner (priority: 3)

Write a test that verifies the stripe_customers and stripe_subscriptions tables (created by merged migration PR #656) exist with correct schema. Test should: (1) connect to test database, (2) run information_schema query to get column names and types for both tables, (3) verify required columns exist: stripe_customers (id, stripe_customer_id, email, user_id, created_at), stripe_subscriptions (id, stripe_subscription_id, stripe_customer_id, status, current_period_start, current_period_end, cancel_at_period_end, created_at), (4) verify status column supports required enum values. Fail on schema mismatch. --- *Generated by CEO Planner (priority: 3)*
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
pook/compliancebot#1151
No description provided.