gabriel / musehub public
0017_agent_identity_fields.py python
32 lines 1.1 KB
Raw
sha256:a10adeeb7a0169cb9900f9806ed7a973047258abb6283724fe55e8eb68ff3f0a init: musehub initial commit Human 171 days ago
1 """Add spawned_by, scope, expires_at to musehub_identities for ephemeral agent keys.
2
3 Revision ID: 0017
4 Revises: 0016
5 """
6 from __future__ import annotations
7
8 import sqlalchemy as sa
9 from alembic import op
10
11 revision = "0017"
12 down_revision = "0016"
13 branch_labels = None
14 depends_on = None
15
16
17 def upgrade() -> None:
18 op.add_column("musehub_identities", sa.Column("spawned_by", sa.String(64), nullable=True))
19 op.add_column("musehub_identities", sa.Column("scope", sa.JSON, nullable=True))
20 op.add_column("musehub_identities", sa.Column(
21 "expires_at", sa.DateTime(timezone=True), nullable=True
22 ))
23 op.create_index("ix_musehub_identities_spawned_by", "musehub_identities", ["spawned_by"])
24 op.create_index("ix_musehub_identities_expires_at", "musehub_identities", ["expires_at"])
25
26
27 def downgrade() -> None:
28 op.drop_index("ix_musehub_identities_expires_at", table_name="musehub_identities")
29 op.drop_index("ix_musehub_identities_spawned_by", table_name="musehub_identities")
30 op.drop_column("musehub_identities", "expires_at")
31 op.drop_column("musehub_identities", "scope")
32 op.drop_column("musehub_identities", "spawned_by")
File History 1 commit
sha256:a10adeeb7a0169cb9900f9806ed7a973047258abb6283724fe55e8eb68ff3f0a init: musehub initial commit Human 171 days ago