Re: [SQLObject] Handling relations with multiple keys

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

On Fri, 2003-06-20 at 18:22, Bruno Trevisan wrote:
> Hi there
> 
> Continuing my experiences on using SQLObject I fall in another question:
> is it possible to have a object linked to some other using more than one
> table attribute as foreignKey ?
> 
> My problem is: I have a Product Class and this product has a SubFamily
> object which defines some extra product properties to me. It happens
> that to query products for its subfamily I have to do a comparsion using
> 2 fields from the subfamily table (subfamilly_id and family_id). Using
> the foreignKey Col Class atribute I'm able, AFAIK, to set only one
> field, which in my case isn't enough to pick the unique subfamily
> object.
> 
> How to handle this ?

I'm not entirely clear on your schema, but you probably should create
the getter yourself, something like:

    def _get_subFamily(self):
        return SubFamily.selectBy(subfamilyID=self.subfamilyID, 
                                  familyID=self.familyID)[0]

Or something like that... along those lines at least.

  Ian