"key" attribute on Column glitch

from sqlalchemy import *

engine = create_engine('sqlite:///:memory:')
metadata = BoundMetaData(engine)


def main():
   test_table_one = Table('test_table_one', metadata,
       Column('legacy_test_id', Integer, primary_key=True, key="id"),
       Column('test_column_one', String(50)),
   )

   try:
       test_table_two = Table('test_table_two', metadata,
           Column('id', Integer, primary_key=True),
           Column('t_one_id', Integer,
ForeignKey('test_table_one.id'), key="tid"),
           Column('test_column_two', String(50)),
       )
   except Exception, e:
       print "Test Table Two build with explicit key name on FK failed"
       print "Exception was on %s " % e

   try:
       test_table_two = Table('test_table_two', metadata,
           Column('id', Integer, primary_key=True),
           Column('t_one_id', Integer, ForeignKey('test_table_one.id')),
           Column('test_column_two', String(50)),
           redefine=True
       )
   except Exception, e:
      print "Test Table Two build without explicit key name on FK failed"
      print "Exception was on %s " % e

   else:
      print "Test Table Two build without explicit key name on FK succedded"

if __name__=="__main__":
   main()
Comments (1)
