from billfn import get_schema def test_schema_exposes_expected_version_and_tables() -> None: schema = get_schema() assert schema["version"] == 6 model_names = [table["modelName"] for table in schema["schemas"]] assert model_names == [ "billingAccounts", "subscriptions", "checkoutSessions", "entitlementSnapshots", "usageMeters", "usageLedger", "webhookReceipts", "billingEvents", "refunds", "subscriptionChangeRequests", "reconciliationJobs", "reconciliationCursors", "unlinkedWebhookEvents", "replacedProviderReferences", "entitlementGrants", "lifecycleEvents", ] def test_schema_includes_webhook_and_usage_uniqueness_indexes() -> None: schema = get_schema() tables = {table["modelName"]: table for table in schema["schemas"]} usage_indexes = tables["usageMeters"]["indexes"] webhook_indexes = tables["webhookReceipts"]["indexes"] subscription_indexes = tables["subscriptions"]["indexes"] assert tables["webhookReceipts"]["fields"]["processingClaimedAt"] == { "type": "string", "required": False, } assert any(index["unique"] and index["fields"] == ["billingAccountId", "resource"] for index in usage_indexes) assert any(index["unique"] and index["fields"] == ["provider", "providerEventId"] for index in webhook_indexes) assert any( index.get("unique") and index["fields"] == ["provider", "providerSubscriptionId"] for index in subscription_indexes ) assert any( index.get("unique") and index["fields"] == ["provider", "providerChargeId"] for index in subscription_indexes ) assert any( index.get("unique") and index["fields"] == ["provider", "providerEventId"] for index in tables["unlinkedWebhookEvents"]["indexes"] ) unlinked_index_fields = [index["fields"] for index in tables["unlinkedWebhookEvents"]["indexes"]] assert ["provider", "providerReference", "status"] in unlinked_index_fields assert ["provider", "providerSecondaryReference", "status"] in unlinked_index_fields assert any( index.get("unique") and index["fields"] == ["provider", "providerReference"] for index in tables["replacedProviderReferences"]["indexes"] ) assert ["provider", "replacedReferencesPending"] in [index["fields"] for index in subscription_indexes] assert ["billingAccountId", "createdAt"] in [index["fields"] for index in tables["entitlementGrants"]["indexes"]] assert ["expiresAt"] in [index["fields"] for index in tables["entitlementGrants"]["indexes"]] assert ["eventsPending", "updatedAt"] in [index["fields"] for index in tables["entitlementGrants"]["indexes"]] assert ["status", "nextAttemptAt"] in [index["fields"] for index in tables["lifecycleEvents"]["indexes"]] assert tables["lifecycleEvents"]["fields"]["id"]["unique"] is True def test_schema_includes_lifecycle_and_reconciliation_indexes() -> None: schema = get_schema() tables = {table["modelName"]: table for table in schema["schemas"]} assert any( index.get("unique") and index["fields"] == ["provider", "providerRefundId"] for index in tables["refunds"]["indexes"] ) assert any( index.get("unique") and index["fields"] == ["provider", "cursorKey"] for index in tables["reconciliationCursors"]["indexes"] ) assert any( index["fields"] == ["kind", "status", "updatedAt"] for index in tables["reconciliationJobs"]["indexes"] ) for model_name in [ "refunds", "subscriptionChangeRequests", "reconciliationJobs", "reconciliationCursors", ]: assert tables[model_name]["fields"]["id"]["unique"] is True