Functions
def	downgrade ()

def	upgrade ()

Variables
string	AST_BOOL_NAME = 'ast_bool_values'

list	AST_BOOL_VALUES

	ast_bool_values = ENUM(*AST_BOOL_VALUES, name=AST_BOOL_NAME, create_type=False)

list	COLUMNS

string	down_revision = 'bd335bae5d33'

string	revision = '74dc751dfe8e'

string	YESNO_NAME = 'yesno_values'

list	YESNO_VALUES = ['yes', 'no']

	yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=False)

Function Documentation

◆ downgrade()

def downgrade ( )

Definition at line 115 of file 74dc751dfe8e_more_permission_boolean_columns.py.

def downgrade():
    for table_name, column_list in itertools.groupby(COLUMNS, operator.itemgetter(0)):
        subject = table(table_name)
        values_exprs = {}
        for _, column_name in column_list:
            subject.append_column(column(column_name))
            values_exprs[column_name] = cast(
                case((or_(subject.c[column_name] == text("'yes'"),
                          subject.c[column_name] == text("'1'"),
                          subject.c[column_name] == text("'on'"),
                          subject.c[column_name] == text("'true'")), text("'yes'")),
                     else_=text("'no'")),
                ast_bool_values)
 
        op.execute(
            subject.update().values(values_exprs)
        )
 
    for table_name, column_list in itertools.groupby(COLUMNS, operator.itemgetter(0)):
        with op.batch_alter_table(table_name) as batch_op:
            for _, column_name in column_list:
                batch_op.alter_column(column_name,
                                      type_=yesno_values,
                                      existing_type=ast_bool_values,
                                      postgresql_using='"{}"::text::{}'.format(column_name, YESNO_NAME))

References table, and text.

◆ upgrade()

def upgrade ( )

Definition at line 106 of file 74dc751dfe8e_more_permission_boolean_columns.py.

def upgrade():
    for table_name, column_list in itertools.groupby(COLUMNS, operator.itemgetter(0)):
        with op.batch_alter_table(table_name) as batch_op:
            for _, column_name in column_list:
                batch_op.alter_column(column_name,
                                      type_=ast_bool_values,
                                      existing_type=yesno_values,
                                      postgresql_using='"{}"::text::{}'.format(column_name, AST_BOOL_NAME))
 

Variable Documentation

◆ AST_BOOL_NAME

string AST_BOOL_NAME = 'ast_bool_values'

Definition at line 97 of file 74dc751dfe8e_more_permission_boolean_columns.py.

◆ AST_BOOL_VALUES

list AST_BOOL_VALUES

Initial value:

=  [ '0', '1',
                    'off', 'on',
                    'false', 'true',
                    'no', 'yes' ]

Definition at line 98 of file 74dc751dfe8e_more_permission_boolean_columns.py.

◆ ast_bool_values

ast_bool_values = ENUM(*AST_BOOL_VALUES, name=AST_BOOL_NAME, create_type=False)

Definition at line 104 of file 74dc751dfe8e_more_permission_boolean_columns.py.

◆ COLUMNS

list COLUMNS

Definition at line 22 of file 74dc751dfe8e_more_permission_boolean_columns.py.

◆ down_revision

string down_revision = 'bd335bae5d33'

Definition at line 11 of file 74dc751dfe8e_more_permission_boolean_columns.py.

◆ revision

string revision = '74dc751dfe8e'

Definition at line 10 of file 74dc751dfe8e_more_permission_boolean_columns.py.

◆ YESNO_NAME

string YESNO_NAME = 'yesno_values'

Definition at line 94 of file 74dc751dfe8e_more_permission_boolean_columns.py.

◆ YESNO_VALUES

list YESNO_VALUES = ['yes', 'no']

Definition at line 95 of file 74dc751dfe8e_more_permission_boolean_columns.py.

◆ yesno_values

yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=False)

Definition at line 103 of file 74dc751dfe8e_more_permission_boolean_columns.py.

Functions

Variables