mirror of
https://github.com/block/buzz.git
synced 2026-10-27 04:30:52 +00:00
76f7e5ef0c
Make the push gateway origin configurable across the relay, gateway, mobile client, and deployment chart. This is a fresh deployment. The gateway has only run on personal development infrastructure, and push has no existing enabled users. Legacy migration, configured-to-unconfigured mobile transitions, and rolling upgrades from pre-launch gateway binaries are not supported. Populated pre-launch databases are rejected with an informative error before migrations run; their data is untouched. Mobile builds may omit the gateway URL, leaving push unavailable. Once push is enabled, subsequent builds must retain that configuration. ### Validation - All applicable CI checks pass at `5f546cfaf403f0386f146d213adfb4392f4ec29c`, including Rust, mobile/Swift, desktop/integration, security, image builds, and Helm checks. An unrelated agent cancellation test passed on retry. - PostgreSQL CI passed 384 tests, including the production-entry-point regression for refusing populated pre-launch databases before migrations, fresh initialization, and subsequent initialized deployments. - Focused local validation passed all 10 gateway PostgreSQL tests under the CI discovery filter and all 3 unconfigured-mobile tests. Repository-wide PostgreSQL discovery validation and the complete pre-push hooks passed. - Physical-device APNs/App Attest behavior and deployment to a live cluster were not verified in this work. --------- Signed-off-by: Tom Brow <tomb@block.xyz> Co-authored-by: Codex <noreply@openai.com>
12 lines
549 B
SQL
12 lines
549 B
SQL
ALTER TABLE push_gateway_installations
|
|
DROP CONSTRAINT push_gateway_installations_app_attest_key_id_key;
|
|
ALTER TABLE push_gateway_installations
|
|
DROP CONSTRAINT push_gateway_installations_app_profile_token_fingerprint_key;
|
|
|
|
CREATE UNIQUE INDEX push_gateway_installations_active_app_attest_key
|
|
ON push_gateway_installations (app_attest_key_id)
|
|
WHERE revoked_at IS NULL;
|
|
CREATE UNIQUE INDEX push_gateway_installations_active_profile_token
|
|
ON push_gateway_installations (app_profile, token_fingerprint)
|
|
WHERE revoked_at IS NULL;
|