appenlight Files · backend/src/appenlight/migrations/versions/e9fcfbdd9498_connect_resources_to_alert_channels.py

Merge pull request from pagenoare/master...

Merge pull request from pagenoare/master Option to blacklist certain resources from AlertChannels

pagenoare - - Load All Authors

File last commit:

r123:a4ed66c8


                r124:a5053823

Download file

             e9fcfbdd9498_connect_resources_to_alert_channels.py
        
                    30 lines
            
             | 763 B
            
                | text/x-python
            
             |
                PythonLexer
            
             / backend / src / appenlight / migrations / versions / e9fcfbdd9498_connect_resources_to_alert_channels.py
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      """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',

                                      ondelete='CASCADE', onupdate='CASCADE')),

              sa.Column('resource_id', sa.Integer,

                        sa.ForeignKey('resources.resource_id',

                                      ondelete='CASCADE', onupdate='CASCADE'))

          )

      def downgrade():

          op.drop_table('channels_resources')

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

				"""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',
				ondelete='CASCADE', onupdate='CASCADE')),
				sa.Column('resource_id', sa.Integer,
				sa.ForeignKey('resources.resource_id',
				ondelete='CASCADE', onupdate='CASCADE'))
				)


				def downgrade():
				op.drop_table('channels_resources')