On Thu, Nov 26, 2009 at 10:19:24PM -0500, [email protected] wrote:
> Hi , first of all sorry for my english, I speak Spanish, but I am working
> with SQLObject
> and I am a newbie,
Welcome!
> and I dont know how to make a relation among 3 tables M:M
Probably you need 3 separate relatio
Hi , first of all sorry for my english, I speak Spanish, but I am working with
SQLObject
and I am a newbie, and I dont know how to make a relation among 3 tables M:M
Thanks
--
Participe en Universidad 2010,
del 8 al 12 de febrero del 2010
La Habana, Cuba
http://www.universidad2010.cu
http://ww
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