e9fcfbdd9498_connect_resources_to_alert_channels.py
32 lines
| 835 B
| text/x-python
|
PythonLexer
/ backend / src / appenlight / migrations / versions / e9fcfbdd9498_connect_resources_to_alert_channels.py
r123 | """connect resources to alert_channels | |||
Revision ID: e9fcfbdd9498 | ||||
Revises: 55b6e612672f | ||||
Create Date: 2018-02-28 13:52:50.717217 | ||||
""" | ||||
# revision identifiers, used by Alembic. | ||||
revision = 'e9fcfbdd9498' | ||||
down_revision = '55b6e612672f' | ||||
from alembic import op | ||||
import sqlalchemy as sa | ||||
def upgrade(): | ||||
op.create_table( | ||||
'channels_resources', | ||||
sa.Column('channel_pkey', sa.Integer, | ||||
sa.ForeignKey('alert_channels.pkey', | ||||
r126 | ondelete='CASCADE', onupdate='CASCADE'), | |||
primary_key=True), | ||||
r123 | sa.Column('resource_id', sa.Integer, | |||
sa.ForeignKey('resources.resource_id', | ||||
r126 | ondelete='CASCADE', onupdate='CASCADE'), | |||
primary_key=True) | ||||
r123 | ) | |||
def downgrade(): | ||||
op.drop_table('channels_resources') | ||||