Asterisk - The Open Source Telephony Project  21.4.1
2b7c507d7d12_add_queue_log_option_log_restricted_.py
1 """add queue_log option log-restricted-caller-id
2 
3 Revision ID: 2b7c507d7d12
4 Revises: bd9c5159c7ea
5 Create Date: 2024-06-12 17:00:16.841343
6 
7 """
8 
9 # revision identifiers, used by Alembic.
10 revision = '2b7c507d7d12'
11 down_revision = 'bd9c5159c7ea'
12 
13 from alembic import op
14 import sqlalchemy as sa
15 from sqlalchemy.dialects.postgresql import ENUM
16 
17 AST_BOOL_NAME = 'ast_bool_values'
18 AST_BOOL_VALUES = [ '0', '1',
19  'off', 'on',
20  'false', 'true',
21  'no', 'yes' ]
22 
23 def upgrade():
24  # ast_bool_values have already been created, so use postgres enum object
25  # type to get around "already created" issue - works okay with mysql
26  ast_bool_values = ENUM(*AST_BOOL_VALUES, name=AST_BOOL_NAME, create_type=False)
27  op.add_column('queues', sa.Column('log_restricted_caller_id', ast_bool_values))
28 
29 def downgrade():
30  op.drop_column('queues', 'log_restricted_caller_id')