API tools faq
paste
YaKotikTvoy

alembic

YaKotikTvoy
Sep 25th, 2023 (edited)
151
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 6.77 KB | None | 0 0
raw download clone embed print report
  1. """add autoprognoz
  2.  
  3. Revision ID: fc49ba06da43
  4. Revises: 5b554fb985f3
  5. Create Date: 2023-06-01 16:28:19.632651
  6.  
  7. """
  8. from alembic import op
  9. import sqlalchemy as sa
  10. import sqlmodel             # NEW
  11. from sqlalchemy.dialects import postgresql
  12.  
  13. # revision identifiers, used by Alembic.
  14. revision = 'fc49ba06da43'
  15. down_revision = '5b554fb985f3'
  16. branch_labels = None
  17. depends_on = None
  18.  
  19.  
  20. def upgrade():
  21.     # ### commands auto generated by Alembic - please adjust! ###
  22.     op.drop_index('ix_partner_info_gender', table_name='partner_info')
  23.     op.drop_index('ix_partner_info_id', table_name='partner_info')
  24.     op.drop_index('ix_partner_info_lat', table_name='partner_info')
  25.     op.drop_index('ix_partner_info_lng', table_name='partner_info')
  26.     op.drop_index('ix_partner_info_scenary_id', table_name='partner_info')
  27.     op.drop_index('ix_partner_info_type', table_name='partner_info')
  28.     op.drop_index('ix_partner_info_user_id', table_name='partner_info')
  29.     op.drop_table('partner_info')
  30.     op.drop_index('ix_user_natal_horoscope_id', table_name='user_natal_horoscope')
  31.     op.drop_index('ix_user_natal_horoscope_user_id', table_name='user_natal_horoscope')
  32.     op.drop_table('user_natal_horoscope')
  33.     op.add_column('user_prognoz', sa.Column('description', sa.TEXT(), nullable=True))
  34.     op.add_column('user_prognoz', sa.Column('is_ready', sa.BOOLEAN(), nullable=True))
  35.     op.add_column('user_prognoz', sa.Column('is_active', sa.BOOLEAN(), nullable=True))
  36.     op.drop_index('ix_user_prognoz_scenary_id', table_name='user_prognoz')
  37.     op.drop_index('ix_user_prognoz_type', table_name='user_prognoz')
  38.     op.drop_column('user_prognoz', 'type')
  39.     op.drop_column('user_prognoz', 'scenary_id')
  40.     op.drop_index('ix_users_gender', table_name='users')
  41.     op.drop_index('ix_users_lat', table_name='users')
  42.     op.drop_index('ix_users_lng', table_name='users')
  43.     op.drop_column('users', 'language_code')
  44.     op.drop_column('users', 'name')
  45.     op.drop_column('users', 'lng')
  46.     op.drop_column('users', 'gender')
  47.     op.drop_column('users', 'birthday')
  48.     op.drop_column('users', 'tz_info')
  49.     op.drop_column('users', 'town')
  50.     op.drop_column('users', 'user_name')
  51.     op.drop_column('users', 'lat')
  52.     # ### end Alembic commands ###
  53.  
  54.  
  55. def downgrade():
  56.     # ### commands auto generated by Alembic - please adjust! ###
  57.     op.add_column('users', sa.Column('lat', sa.NUMERIC(), autoincrement=False, nullable=True))
  58.     op.add_column('users', sa.Column('user_name', sa.VARCHAR(), autoincrement=False, nullable=True))
  59.     op.add_column('users', sa.Column('town', sa.VARCHAR(length=150), autoincrement=False, nullable=True))
  60.     op.add_column('users', sa.Column('tz_info', sa.VARCHAR(length=150), autoincrement=False, nullable=True))
  61.     op.add_column('users', sa.Column('birthday', postgresql.TIMESTAMP(), autoincrement=False, nullable=True))
  62.     op.add_column('users', sa.Column('gender', sa.INTEGER(), server_default=sa.text('1'), autoincrement=False, nullable=True))
  63.     op.add_column('users', sa.Column('lng', sa.NUMERIC(), autoincrement=False, nullable=True))
  64.     op.add_column('users', sa.Column('name', sa.VARCHAR(length=20), autoincrement=False, nullable=True))
  65.     op.add_column('users', sa.Column('language_code', sa.VARCHAR(), autoincrement=False, nullable=True))
  66.     op.create_index('ix_users_lng', 'users', ['lng'], unique=False)
  67.     op.create_index('ix_users_lat', 'users', ['lat'], unique=False)
  68.     op.create_index('ix_users_gender', 'users', ['gender'], unique=False)
  69.     op.add_column('user_prognoz', sa.Column('scenary_id', sa.INTEGER(), autoincrement=False, nullable=True))
  70.     op.add_column('user_prognoz', sa.Column('type', sa.INTEGER(), autoincrement=False, nullable=False))
  71.     op.create_index('ix_user_prognoz_type', 'user_prognoz', ['type'], unique=False)
  72.     op.create_index('ix_user_prognoz_scenary_id', 'user_prognoz', ['scenary_id'], unique=False)
  73.     op.drop_column('user_prognoz', 'is_active')
  74.     op.drop_column('user_prognoz', 'is_ready')
  75.     op.drop_column('user_prognoz', 'description')
  76.     op.create_table('user_natal_horoscope',
  77.     sa.Column('id', sa.INTEGER(), sa.Identity(always=True, start=1, increment=1, minvalue=1, maxvalue=2147483647, cycle=False, cache=1), autoincrement=True, nullable=False),
  78.     sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False),
  79.     sa.Column('horoscope', sa.TEXT(), autoincrement=False, nullable=True),
  80.     sa.Column('aspects', sa.TEXT(), autoincrement=False, nullable=True),
  81.     sa.Column('description', sa.TEXT(), autoincrement=False, nullable=True),
  82.     sa.PrimaryKeyConstraint('id', name='userNatalHoroscope_pkey')
  83.     )
  84.     op.create_index('ix_user_natal_horoscope_user_id', 'user_natal_horoscope', ['user_id'], unique=False)
  85.     op.create_index('ix_user_natal_horoscope_id', 'user_natal_horoscope', ['id'], unique=False)
  86.     op.create_table('partner_info',
  87.     sa.Column('id', sa.INTEGER(), sa.Identity(always=True, start=1, increment=1, minvalue=1, maxvalue=2147483647, cycle=False, cache=1), autoincrement=True, nullable=False),
  88.     sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False),
  89.     sa.Column('birthday', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
  90.     sa.Column('town', sa.VARCHAR(length=150), autoincrement=False, nullable=True),
  91.     sa.Column('horoscope', sa.TEXT(), autoincrement=False, nullable=True),
  92.     sa.Column('type', sa.INTEGER(), autoincrement=False, nullable=True),
  93.     sa.Column('aspects', sa.TEXT(), autoincrement=False, nullable=True),
  94.     sa.Column('tz_info', sa.VARCHAR(length=150), autoincrement=False, nullable=True),
  95.     sa.Column('lat', sa.NUMERIC(), autoincrement=False, nullable=True),
  96.     sa.Column('lng', sa.NUMERIC(), autoincrement=False, nullable=True),
  97.     sa.Column('name', sa.VARCHAR(length=100), autoincrement=False, nullable=True),
  98.     sa.Column('gender', sa.INTEGER(), autoincrement=False, nullable=True),
  99.     sa.Column('couple_natal', sa.TEXT(), autoincrement=False, nullable=True),
  100.     sa.Column('couple_aspects', sa.TEXT(), autoincrement=False, nullable=True),
  101.     sa.Column('scenary_id', sa.INTEGER(), autoincrement=False, nullable=True),
  102.     sa.PrimaryKeyConstraint('id', name='partner_info_pkey')
  103.     )
  104.     op.create_index('ix_partner_info_user_id', 'partner_info', ['user_id'], unique=False)
  105.     op.create_index('ix_partner_info_type', 'partner_info', ['type'], unique=False)
  106.     op.create_index('ix_partner_info_scenary_id', 'partner_info', ['scenary_id'], unique=False)
  107.     op.create_index('ix_partner_info_lng', 'partner_info', ['lng'], unique=False)
  108.     op.create_index('ix_partner_info_lat', 'partner_info', ['lat'], unique=False)
  109.     op.create_index('ix_partner_info_id', 'partner_info', ['id'], unique=False)
  110.     op.create_index('ix_partner_info_gender', 'partner_info', ['gender'], unique=False)
  111.     # ### end Alembic commands ###
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!