Re: [SQLObject] relation

2009-11-27 Thread Oleg Broytman
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

[SQLObject] relation

2009-11-26 Thread inf200475
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

[SQLObject] relation attributes

2006-07-29 Thread Jonathon Anderson
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_

Re: [SQLObject] Relation Attributes

2006-07-20 Thread Rick Flosi
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

[SQLObject] Relation Attributes

2006-07-20 Thread Jonathon Anderson
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