SQLAlchemy index names unique

Question

Im building a table with index=True where i would like the name to always be a unique index name possible using UUID as suffix .. something like ix__uuid

Below my code for table creation

    add = Table('src_add_lookup', metadata,
                Column('id', Integer, Sequence('seq_add', schema='can'), primary_key=True, index=True)

metadata.drop_all(engine, tables=[add]) # using 'tables' param to only create the necessary table
metadata.create_all(engine, tables=[add])

This will always create an index named ix_src_add_lookup_id that i woudl like to avoid.

IS there some method available for something like this ?

See [this answer](https://stackoverflow.com/a/10061143). You need to use a `UniqueConstraint` object. — SuperShoot, Jul 24 '18 at 22:58

score 1 · Accepted Answer · answered Jul 26 '18 at 16:07

End up using the Index api together with uuid() lib to generate the desired unique index name like code below.

from sqlalchemy import Index

add = Table('src_add_lookup', metadata,
            Column('id', Integer, Sequence('seq_add', schema='can'), primary_key=True)

Index('idx_add_{}'.format(uuid.uuid4().hex), add.c.id, unique=True)

SQLAlchemy index names unique

1 Answers1