Re: [SQLObject] Additionnal datas on joins

[Ian B. <ia...@co...>]

On Mon, 2003-07-28 at 08:41, Brad Bollenbach wrote:
> The cleanest way is to figure out how we want to define composite
> primary keys.
> 
> Like this?
> 
> class SiteMonitor(SQLObject):
>     site = ForeignKey("Site")
>     monitor = ForeignKey("Monitor")
> 
>     _primary_key = (site, monitor)

I'm thinking:

    id = ('site', 'monitor')
or:
    id = (site, monitor)
both should be equivalent.

This goes along with using:
    id = StringCol()
when you have a non-integer primary key.

When using a composite keys, obj.id should return a tuple of the
respective columns -- ids should be hashable and immutable, which fits
tuples nicely.

  Ian