Hi there,
I know there's a previous thread, but that's a bit old, so I thought
I'd make a new one. The UniqueConstraint for the declarative style
doesn't seem to be working for me. Using code from the last thread, I
have this:
=====
class Group(Base):
__tablename__ = "groups"
__table_args__ = (schema.UniqueConstraint("name", "site"), {})
id = Column(Integer, primary_key = True)
name = Column(String)
site = Column(String)
=====
I add to the DB using session.merge(group) in the hope that it'll
merge the records together, but no luck. It's still placing tons of
redundant data into the system.
I want to have the ID as a primary key so I don't have to refer to the
composite when it's used as a foreign key, but not being able to stop
SQLAlchemy placing redundant data in the table is frustrating! If I
use the composite primary key, then it stops inserting the junk.
What am I doing wrong?
Thank you!
Chris Lewis
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
