5139253c0423_make_q_member_uniqueid_autoinc Namespace Reference

Functions
	downgrade ()
	upgrade ()

Variables
str	down_revision = '1758e8bbf6b'
str	revision = '5139253c0423'

Function Documentation

downgrade()

downgrade

(

)

Definition at line 49 of file 5139253c0423_make_q_member_uniqueid_autoinc.py.

def downgrade():
    # Was unable to find a way to use op.alter_column() to remove the
    # unique index property.
    if op.get_context().bind.dialect.name == 'mssql':
        op.drop_constraint('uq_queue_members_uniqueid', 'queue_members')
    op.drop_column('queue_members', 'uniqueid')
    op.add_column('queue_members', sa.Column(name='uniqueid', type_=sa.String(80), nullable=False))

upgrade()

upgrade

(

)

Definition at line 35 of file 5139253c0423_make_q_member_uniqueid_autoinc.py.

def upgrade():
    # Was unable to find a way to use op.alter_column() to add the unique
    # index property.
    op.drop_column('queue_members', 'uniqueid')
    op.add_column('queue_members', sa.Column(name='uniqueid', type_=sa.Integer,
                                             nullable=False, unique=True))
    # The postgres and mssql backends do not like the autoincrement needed for
    # mysql here.  It is just the backend that is giving a warning and
    # not the database itself.
    op.alter_column(table_name='queue_members', column_name='uniqueid',
                    existing_type=sa.Integer, existing_nullable=False,
                    autoincrement=True)
 
 

Variable Documentation

down_revision

str down_revision = '1758e8bbf6b'

Definition at line 29 of file 5139253c0423_make_q_member_uniqueid_autoinc.py.

revision

str revision = '5139253c0423'

Definition at line 28 of file 5139253c0423_make_q_member_uniqueid_autoinc.py.