python source code of 2019_09_30_7b11c2291b8f_fix_cascade

Project: sticker-finder (GitHub Link)

sticker-finder-master
- initdb.py
- poetry.lock
- Makefile
- stickerfinder.toml
- stickerfinder
  - sentry.py
  - db.py
  - config.py
  - stickerfinder.py
  - telegram
    - message_handlers.py
    - error_handler.py
    - commands
      - misc.py
      - maintenance.py
      - chat.py
      - tag.py
      - __init__.py
      - usage.py
      - sticker_set.py
      - admin.py
    - callback_handlers
      - menu.py
      - newsfeed.py
      - tagging.py
      - report.py
      - check_user.py
      - __init__.py
      - sticker_set.py
      - settings.py
      - admin.py
    - inline_query
      - search.py
      - sql_query.py
      - offset.py
      - __init__.py
      - context.py
    - jobs.py
    - keyboard
      - maintenance.py
      - tag.py
      - __init__.py
      - main.py
      - settings.py
  - models
    - sticker.py
    - sticker_usages.py
    - inline_query.py
    - report.py
    - task.py
    - user.py
    - inline_query_request.py
    - chat.py
    - tag.py
    - __init__.py
    - sticker_set.py
    - proposed_tags.py
    - change.py
  - helper
    - telegram.py
    - text.py
    - image.py
    - cleanup.py
    - maintenance.py
    - plot.py
    - tag_mode.py
    - callback.py
    - tag.py
    - __init__.py
    - display.py
    - sticker_set.py
    - session.py
    - corrections.py
  - __init__.py
- CHANGELOG.md
- travis_stickerfinder.toml
- LICENSE.md
- setup.cfg
- main.py
- .travis.yml
- README.md
- migrations
  - env.py
  - versions
    - 2019_04_15_8a2e4bc65260_add_original_emojis_relation_for_sticker.py
    - 2019_03_14_4ef4a89fe68b_bannable_stickers.py
    - 2019_10_15_3919491ac655_scan_scheduled_flag.py
    - 2019_06_06_e948b90172ab_remove_username_unique_constraint.py
    - 2018_11_30_2daaec987d76_fix_inline_query_request.py
    - 2019_04_11_7d9cf9d4337c_.py
    - 2018_11_30_b179e344cc02_check_constraints.py
    - 2019_04_18_aa5613fcff22_deluxe_set.py
    - 2020_03_01_e699cecf40cf_new_id_column_for_sticker.py
    - 2019_04_04_4834f469968b_remove_old_flags.py
    - 2019_09_30_b5e309bfc338_user_notification_flag.py
    - 2019_04_04_9b7bc182196a_add_chat_to_change.py
    - 2019_04_04_f972b83f1baa_tag_mode.py
    - 2019_05_20_9503a8aea135_fix_change_check_task_delete_cascade.py
    - 2019_04_13_69d10714ee45_rewrite_changes_and_tags.py
    - 2019_05_13_10c95d1f1272_remove_proposed_tags_sticker_foreign_key.py
    - 2019_09_29_25d327218c4d_user_flags.py
    - 2019_08_09_bde4d8e2916a_sticker_change_cascade.py
    - 2019_04_04_5333a07d4ea9_add_updated_at_to_chat.py
    - 2019_03_20_b17dcce8c3f3_sticker_usages.py
    - 2019_04_13_888b710775ea_move_change_tags_to_new_format.py
    - 2018_11_30_6c854954ca33_fuck_languages_part_2.py
    - 2018_12_01_367c804c5170_sticker_pack_search.py
    - 2019_04_04_9fa624eb51ab_cascade_on_chat_sticker_file_id.py
    - 2019_05_13_a80fa524a2ba_add_proposed_tags.py
    - 2019_08_29_1cc051f593f8_boolean_flag_fuzzy_on_inline_query_.py
    - 2019_04_01_4c9a81798173_remove_expecting_sticker_set.py
    - 2019_04_15_35223866defb_fix_tag_schema.py
    - 2019_09_30_7b11c2291b8f_fix_cascade.py
    - 2019_09_29_c95f92b9e1f1_rename_international.py
    - 2019_04_08_11597b0662d3_rename_vote_ban.py
    - 2019_09_21_10aa7e1f95ec_is_animated_flag.py
    - 2019_08_09_be7577571b15_sticker_change_cascade.py
    - 2018_11_30_7ddf4da81c22_rename_default_language.py
  - README
  - script.py.mako
- tests
  - maintenance
    - test_user_revert.py
  - factories.py
  - tag
    - test_tag_sticker.py
    - test_tag_extraction.py
    - test_emojis.py
  - __init__.py
  - fixtures.py
  - inline_query
    - test_inline_query_with_usage.py
    - test_offset.py
    - test_context.py
    - test_set_inline_query.py
    - test_fuzzy_inline_query.py
    - test_inline_query.py
  - helper.py
  - conftest.py
  - testing
    - test_session.py
- queries
  - clean_authorized_user_data.sql
  - inline_query_results.sql
  - clear_user_data.sql
  - changes_by_user.sql
- pyproject.toml
- bin
  - syncDb.sh
  - watch.sh
  - backup.sh
- alembic.ini
- .gitignore

"""Fix cascade

Revision ID: 7b11c2291b8f
Revises: b5e309bfc338
Create Date: 2019-09-30 01:34:27.469599

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '7b11c2291b8f'
down_revision = 'b5e309bfc338'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint('chat_current_task_id_fkey', 'chat', type_='foreignkey')
    op.create_foreign_key('chat_current_task_id_fkey', 'chat', 'task', ['current_task_id'], ['id'], ondelete='SET NULL')
    op.alter_column('user', 'notifications',
               existing_type=sa.BOOLEAN(),
               server_default=None,
               existing_nullable=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('user', 'notifications',
               existing_type=sa.BOOLEAN(),
               server_default=sa.text('true'),
               existing_nullable=False)
    op.drop_constraint('chat_current_task_id_fkey', 'chat', type_='foreignkey')
    op.create_foreign_key('chat_current_task_id_fkey', 'chat', 'task', ['current_task_id'], ['id'], ondelete='CASCADE')
    # ### end Alembic commands ###