Hi ALL!

Does tometadata have to change foreign key schema name if it already
specified?
For example if I have column 'user_id' with 'system.users.id' FK -
tometadata change 'system' schema to SOME_SCHEMA. Is it ok, or
tometadata have to set schema to SOME_SCHEMA for street_id,
locality_id columns _only_ ?

transactions_t = Table('transactions', meta.metadata,
                                   Column('id', Integer,
primary_key=True, autoincrement=False),
                                   Column('user_id', Integer,
ForeignKey('system.users.id'), nullable=False),
                                   Column('street_id', Integer,
ForeignKey('streets.id'), nullable=False),
                                   Column('locality_id', Integer,
ForeignKey('locality.id'), nullable=False),
                                   Column('sum', Integer,
nullable=False)
                             )

transactions_t.tometadata(metadata, schema='SOME_SCHEMA').create()

Thanks a lot!



--~--~---------~--~----~------------~-------~--~----~
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 
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to