Hey Andrija,
Thanks a lot, that did help with the creation. Yes, one of my problem is not
visible in the trunk, however the strange identifier problem persists. I'll do
a demo programm for that one.
Quoting Andrija Zaric <[EMAIL PROTECTED]>:
> Hi Florian,
>
> the following patch sorts out creation problem. btw. i couldn't repeat
> the other problems you have - your test code worked without problem on
> svn trunk.
>
> - andrija
>
> On 08/03/06, Florian Boesch <[EMAIL PROTECTED]> wrote:
> > 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
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
> >
>
-------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
