Hi Michael
2008/7/18 Michael Bayer <[EMAIL PROTECTED]>:
>
>
> On Jul 18, 2008, at 9:37 AM, Ryan Tracey wrote:
>
>> sqlalchemy.exc.NoSuchTableError: manufacturer
>>
>> Just to sum up:
>>
>> dbengine = create_engine('mysql://u:[EMAIL PROTECTED]/schema1')
>> meta = MetaData()
>> meta.bind = dbengine
>>
>> Table('tableX', meta, autoload=True)
>> ...
>>
>> Table('tableA', meta, autoload=True, schema='schema2')
>> Table('tableB', meta, autoload=True, schema='schema2')
>>
>>
>> tableX is okay, and tableA loads okay too. However tableB has a FK
>> referencing tableA. Bang! I get a NoSuchTableError for tableA.
>>
>> I'll try get some ipython output. Or figure out how pdb works.
>>
>
> its likely mysql reflection doesn't yet know how to reflect cross-
> schema foreign keys. put up a trac ticket with a short test case.
Will do.
(Sorry for the late reply. Just moved house and still waiting for
phone/adsl line to be installed.)
Cheers,
Ryan
--
Ryan Tracey
Citizen: The World
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
