DEV Community

Discussion on: Applying a Naming Convention to Constraints via SQLAlchemy & Alembic

View post
Collapse
 
arashfatahzade profile image
Arash Fatahzade • • Edited

I have signup to just say THANK YOU <3.
Worked like charm on postgres.

EDIT: postgres naming conventions:

metadata = MetaData(                                                             
    naming_convention={                                                          
        "ix": "%(column_0_label)s_idx",                                                                                  
        "uq": "%(table_name)s_%(column_0_name)s_key",                            
        "ck": "%(table_name)s_%(constraint_name)s_check",                        
        "fk": "%(table_name)s_%(column_0_name)s_%(referred_table_name)s_fkey",   
        "pk": "%(table_name)s_pkey"                                              
    }                                                                            
)