Spaces:
Build error
Build error
"""Add string user ID | |
Revision ID: eced1ae3918a | |
Revises: 3821f7adaca9 | |
Create Date: 2023-07-19 11:02:52.002939 | |
""" | |
from alembic import op | |
import sqlalchemy as sa | |
# revision identifiers, used by Alembic. | |
revision = 'eced1ae3918a' | |
down_revision = '3821f7adaca9' | |
branch_labels = None | |
depends_on = None | |
def upgrade() -> None: | |
op.add_column('interactions', sa.Column( | |
'user_id', sa.String(50), nullable=True)) | |
# Populate the new column with the old column's data | |
op.execute(""" | |
UPDATE interactions | |
SET user_id = CAST(client_id AS TEXT) | |
""") | |
# TODO: make the user_id column non-nullable after prod migration. | |
# Skip for now given production servers are distributed. Note this is not | |
# relevant if you deploy locally. | |
def downgrade() -> None: | |
op.drop_column('interactions', 'user_id') | |