19 lines
589 B
Python
19 lines
589 B
Python
"""Cloud saves became an explicit permission; keep them for existing system roles."""
|
|
import sqlalchemy as sa
|
|
from alembic import op
|
|
|
|
revision = "0004"
|
|
down_revision = "0003"
|
|
branch_labels = depends_on = None
|
|
|
|
|
|
def upgrade():
|
|
op.get_bind().execute(sa.text(
|
|
"UPDATE roles SET permissions = array_append(permissions, 'saves.cloud') "
|
|
"WHERE is_system AND name IN ('moderator', 'player') AND NOT ('saves.cloud' = ANY(permissions))"))
|
|
|
|
|
|
def downgrade():
|
|
op.get_bind().execute(sa.text(
|
|
"UPDATE roles SET permissions = array_remove(permissions, 'saves.cloud')"))
|