Make your computer a home for your AI partner. Avibe is the local-first Agent OS: Vibey, its built-in AI partner, works out of the box, and Claude Code, Codex & OpenCode run unchanged beside it — reach them from your browser, phone, or any chat app.
Python agentagent-osaiai-agentsai-partnerchatopsclaudeclaude-codecodexdevtoolsdiscord-botlark-botllmlocal-firstlong-term-memoryopencodeslack-botvibe-codingvibeywechat
"""Existing disabled Web Push rows must not gain repair consent on upgrade."""
import sqlite3
import pytest
from alembic import command
from storage import migrations, web_push_service
from storage.db import create_sqlite_engine
pytestmark = pytest.mark.no_sqlite_template
def test_upgrade_keeps_legacy_disabled_failure_opted_out(tmp_path):
path = tmp_path / "state.sqlite"
migrations.run_migrations(path, revision="20260907_0061")
with sqlite3.connect(path) as conn:
conn.executemany(
"""
insert into web_push_subscriptions (
id, user_key, endpoint, p256dh, auth, enabled, last_failure_at,
failure_count, created_at, updated_at
) values (?, 'remote:user-a', ?, 'key', 'auth', ?, ?, 1, 'old', 'old')
""",
[
(
"opted-out",
"https://push.example.test/sub/opted-out",
0,
"2026-09-01T00:00:00Z",
),
(
"still-enabled",
"https://push.example.test/sub/still-enabled",
1,
"2026-09-01T00:00:00Z",
),
],
)
migrations.run_migrations(path)
engine = create_sqlite_engine(path)
with engine.begin() as conn:
disabled = web_push_service.get_by_endpoint(
conn,
endpoint="https://push.example.test/sub/opted-out",
user_key="remote:user-a",
)
assert disabled is not None
assert disabled["last_failure_at"] is not None
assert disabled["provider_invalidated_at"] is None
assert web_push_service.upsert_background_rotated_subscription(
conn,
user_key="remote:user-a",
payload={
"endpoint": "https://push.example.test/sub/rotated",
"keys": {"p256dh": "key", "auth": "auth"},
},
previous_endpoints=[disabled["endpoint"]],
) is None
enabled = web_push_service.get_by_endpoint(
conn,
endpoint="https://push.example.test/sub/still-enabled",
user_key="remote:user-a",
)
assert enabled is not None
assert enabled["enabled"] is True
web_push_service.mark_send_failure(conn, endpoint=enabled["endpoint"], disable=True)
with sqlite3.connect(path) as conn:
assert conn.execute("select version_num from alembic_version").fetchone() == (
"20261030_0072",
)
command.downgrade(migrations.alembic_config(path), "20260907_0061")
with sqlite3.connect(path) as conn:
assert conn.execute(
"select provider_invalidated_at from web_push_subscriptions where id = 'still-enabled'"
).fetchone() == (None,)
migrations.run_migrations(path)
with sqlite3.connect(path) as conn:
assert conn.execute(
"select provider_invalidated_at from web_push_subscriptions where id = 'still-enabled'"
).fetchone() == (None,)