[Sqlalchemy-tickets] [sqlalchemy] #2811: cannot change column.key in reflect event without corrupting primary key

[sqlalchemy <mi...@zz...>]

#2811: cannot change column.key in reflect event without corrupting primary key
---------------------+------------------------------------
 Reporter:  zzzeek   |           Owner:  zzzeek
     Type:  defect   |          Status:  new
 Priority:  highest  |       Milestone:  0.8.xx
Component:  schema   |        Severity:  major - 1-3 hours
 Keywords:           |  Progress State:  in queue
---------------------+------------------------------------
 {{{
 #!python
 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'] = column_info['name'].lower()


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

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

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2811>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python