For this you'd need a compound primary key, something that SQLObject
doesn't currently support iirc.
Lee
On 22/11/05, icylamb <[EMAIL PROTECTED]> wrote:
>
> Thanks for your solutions. However, I've still got some bugs to fix.
> My model is as following:
>
> class Wiki(SQLObject):
> wikiname = StringCol(alternateID=True, length=30)
> frontpage = StringCol()
> pages = MultipleJoin('Page')
>
> class Page(SQLObject):
> pagename = StringCol(alternateID=False, length=30)
> data = StringCol()
> wikiId = ForeignKey('Wiki')
>
> This allows wiki names are unique across Wiki table (alternateID=True)
> but in Page table, I set alternateID=False, which allows page names to
> be repeated as long as they belongs to different wiki (different
> wikiId). Say
> wikiId = 1, pagename = FrontPage
> wikiId = 2, pagename = FrontPage
>
> should be working fine. But it doesn't work for the constraint of same
> pagename within a wiki if I do so. Say
>
> wikiId = 1, pagename = FrontPage
> wikiId = 1, pagename = FrontPage
>
> is not acceptable.
>
> How can I correct this?
>
>
