Flask Migration: Problem creating table and using existing Enum in database. `create_type=False` Do not work

Question

I am using flask-migrate, SQLAlchemy and alembic to manage my database. I want to create a new table in the database. The new table has a column which uses an existing Enum. I have read on many SO questions that you can use an existing Enum with create_type=False flag. This seems that is not working for me. See upgrade() function in my revision file below.

def upgrade():
    op.create_table(
        'label',
        sa.Column('id', UUID(as_uuid=True), default=uuid4),
        sa.Column('labelText', sa.Text, nullable=False),  
        sa.Column('sourceCountry', sa.Enum('it', 'gb', 'gr', 'bg', 'pt', name='country', create_type=False), nullable=True),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('id')

    )
    op.add_column('entity', sa.Column('labelId', UUID(as_uuid=True)))
    op.create_foreign_key(
        'fk_entity_label',
        'entity', 'label',
        ['labelId'], ['id'],
    )

Here are my versions:

Flask==1.1.1
Flask-Ext==0.1
Flask-Migrate==2.5.3
Flask-Script==2.0.6
Flask-SQLAlchemy==2.4.1
alembic==1.4.1

My error:

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.DuplicateObject) type "country" already exists

[SQL: CREATE TYPE country AS ENUM ('it', 'gb', 'gr', 'bg', 'pt')]
(Background on this error at: http://sqlalche.me/e/f405)

DarioB · Accepted Answer · 2020-03-20 14:51:42Z

6

Found the problem. I was using sqlalchemy.Enum(), where I should use postgres.ENUM() instead. Changing that made everything work.

answered Mar 20, 2020 at 14:51

DarioB

1,6593 gold badges29 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Khine Zar Thwe · Accepted Answer · 2020-07-21 13:45:52Z

0

The same error occurs during flask upgrade. By changing the name attribute, it works well.

name = 'country' to name = 'country_name'

OR if you are using Postgres with pgadmin4, remove the 'country' type object and re-run.

edited Jul 21, 2020 at 13:45

answered Jul 18, 2020 at 13:44

Khine Zar Thwe

11 bronze badge

Collectives™ on Stack Overflow

Flask Migration: Problem creating table and using existing Enum in database. `create_type=False` Do not work

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related