Hi,
I've got a problem with the svn trunk and table creation of tables that contain
foreign keys.
Demo programm:
engine = create_engine('oracle://dsn=orcl&user=asfd&password=asfd')
foo = Table('foo', engine,
Column('id', Integer, Sequence('foo_seq'), primary_key=True))
bar = Table('bar', engine,
Column('id', Integer, Sequence('bar_seq'), primary_key=True),
Column('foo_id', Integer, ForeignKey('foo.id')))
foo.create()
bar.create()
Error:
Traceback (most recent call last):
File "testalchemy.py", line 75, in ?
bar.create()
File
"/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.1.3-py2.4.egg/sqlalchemy/schema.py",
line 212, in create
self.engine.create(self)
File
"/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.1.3-py2.4.egg/sqlalchemy/engine.py",
line 319, in create
entity.accept_schema_visitor(self.schemagenerator(**params))
File
"/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.1.3-py2.4.egg/sqlalchemy/schema.py",
line 179, in accept_schema_visitor
return visitor.visit_table(self)
File
"/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.1.3-py2.4.egg/sqlalchemy/ansisql.py",
line 578, in visit_table
self.append("\t" + self.get_column_specification(column,
override_pk=len(pks)>1, first_pk=column.primary_key and not first_pk))
File
"/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.1.3-py2.4.egg/sqlalchemy/databases/oracle.py",
line 313, in get_column_specification
colspec += " REFERENCES %s(%s)" %
(column.column.foreign_key.column.table.name,
column.column.foreign_key.column.name)
AttributeError: 'Column' object has no attribute 'column'
I now go back to sqlalchemy 0.1.2.
Regards,
Florian
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
