databases icon indicating copy to clipboard operation
databases copied to clipboard

create table does not create unique keys and indexes

Open YuriFontella opened this issue 1 year ago • 0 comments

By defining the index on the columns and as a unique key, the table is created with the CreateTable function, but the keys are not.

users = Table(
    'users',
    metadata,
    Column('id', Integer, primary_key=True),
    Column('name', String(length=255)),
    Column('email', String(length=255), unique=True, index=True)
)
for table in metadata.tables.values():
    schema = sqlalchemy.schema.CreateTable(table, if_not_exists=True)
    query = schema.compile(dialect=postgresql.dialect())

    await database.execute(query=str(query))

YuriFontella avatar Jan 20 '24 15:01 YuriFontella