I've mentioned this before, but I thought that, rather than a simple question, the issue might deserve full discussion.There needs to be a better way to model a many-to-many relationship with relational attributes.
Lets have an example:--database schema--item| id| namelist| id| namelist_item| list_
Yes, try something like this:
class Item(SQLObject):
name = StringCol(notNull=True, alternateID=True)
groups = SQLRelatedJoin('Group', createRelatedTable=False)
class Group(SQLObject):
name = StringCol(notNull=True, alternateID=True)
items = SQLRelatedJoin('Item', createRelat
Is it possible to have relation attributes in a RelatedJoin?For example, I have Items and Groups:Item ID NameGroup ID NameTo put items in groups, you would have an intermediate table:
ItemGroupMap item_id group_idNow say I want this group to have order. So, in an RDB I would chang
