Hi again,
I have this table, which has a composite primary key, and no sequence:
# \d log_members
Table "public.log_members"
Column | Type | Modifiers
------------+---------+-----------
memberID | integer | not null
logentryID | integer | not null
Indexes:
"log_members_pkey" PRIMARY KEY, btree ("memberID", "logentryID")
"logentryID_index" btree ("logentryID")
"memberID_index" btree ("memberID")
Foreign-key constraints:
"logtypeID_fk" FOREIGN KEY ("logentryID") REFERENCES activity_log
("logentryID") ON DELETE CASCADE
"memberID_fk" FOREIGN KEY ("memberID") REFERENCES members
("memberID") ON DELETE CASCADE
I was able to accommodate the composite key easily, but default
SqlAlchemy models want a sequence number to bump upon insert. How do I
handle this in SqlAlchemy?
My model code:
class LogMember(Base):
"""
Class which ties activity log entries to member ids.
"""
__tablename__ = 'log_members'
logentryID = Column(Integer,primary_key=True)
member_id = Column(Integer,primary_key=True,name='memberID')
ForeignKeyConstraint(['logentryID', 'member_id'],
['activity_log.logentryID', 'members.memberID'])
def __init__(self,logentryID,memberID):
self.logentryID = logentryID
self.memberID = memberID
def __repr__(self):
return "<Affiliation('%s','%s')>" \
% (self.logentryID, self.memberID)
Thank you in advance!
Gloria
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
