error when use superset db migrate about superset HOT 1 OPEN

@hieuthanhpro Hello there! I'm a bot designed to help you solve bugs, answer questions, and become a contributor. I'm here to assist you while waiting for a human maintainer.

To resolve the PostgreSQL ENUM type requires a name error when running superset db migrate after adding public and organizationId columns to the dashboard model, you need to ensure that the ENUM type is given a name. In SQLAlchemy, you can specify the name of the ENUM type using the name parameter.

Here is an example of how you can define the ENUM type with a name in your model:

from sqlalchemy import Column, Integer, Enum

class Dashboard(Base):
    __tablename__ = 'dashboard'
    
    id = Column(Integer, primary_key=True)
    public = Column(Enum('private', 'public', name='public_enum'))
    organizationId = Column(Integer)

Make sure to replace 'private' and 'public' with the actual values you want in your ENUM type. The name='public_enum' part is crucial as it provides a name for the ENUM type, which is required by PostgreSQL.

After making this change, run superset db migrate again, and the error should be resolved ^[1].

To continue talking to Dosu, mention @dosu.

from superset.