alembic: Remove batch operations (and sqlite support)
[asterisk/asterisk.git] / contrib / ast-db-manage / config / versions / 339a3bdf53fc_expand_accountcode_to_80.py
1 """expand accountcode to 80
2
3 Revision ID: 339a3bdf53fc
4 Revises: 28ce1e718f05
5 Create Date: 2015-11-05 10:10:27.465794
6
7 """
8
9 # revision identifiers, used by Alembic.
10 revision = '339a3bdf53fc'
11 down_revision = '28ce1e718f05'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
17 def upgrade():
18     with op.batch_alter_table('ps_endpoints') as batch_op:
19         batch_op.alter_column('accountcode', type_=sa.String(80))
20     with op.batch_alter_table('sippeers') as batch_op:
21         batch_op.alter_column('accountcode', type_=sa.String(80))
22     with op.batch_alter_table('iaxfriends') as batch_op:
23         batch_op.alter_column('accountcode', type_=sa.String(80))
24     pass
25
26
27 def downgrade():
28     with op.batch_alter_table('ps_endpoints') as batch_op:
29         batch_op.alter_column('accountcode', type_=sa.String(20))
30     with op.batch_alter_table('sippeers') as batch_op:
31         batch_op.alter_column('accountcode', type_=sa.String(40))
32     with op.batch_alter_table('iaxfriends') as batch_op:
33         batch_op.alter_column('accountcode', type_=sa.String(20))
34     pass