cannot change column.key in reflect event without corrupting primary key

from sqlalchemy import *
from sqlalchemy import event


e = create_engine("sqlite://", echo=True)
e.execute("""
    create table sample (
        Id integer primary key,
        Name varchar,
        Description varchar,
        IsActive varchar
    )
""")

@event.listens_for(Table, "column_reflect")
def new_col(inspector, table, column_info):
    column_info['key']('key') = column_info['name']('name').lower()


m = MetaData()
t = Table('sample', m, autoload=True, autoload_with=e)

assert t.c.id in set(t.primary_key)

Comments (2)