On Tuesday 05 December 2006 18:17, Diez B. Roggisch wrote:
> Hi,
>
> I just found out that multiple inheritance doesn't work over more than one
> level. Is this an oversight, and people are interested in having a solution
> for this, or is it by design?

I have to paraphrase that: the real problem seems not to be that the support 
isn't there - it it that the childName columns value isn't distinguishing 
_all_ subclasses on the topmost class, as I was expecting. Consider this 
example:

class A(InhSQLO):
    pass

class B(A):
    pass

class C(B):
   pass

This will result in a table "a" with a childName column. But additionally, 
table "b" will have a childName column.

If creating an instance of C, you'd end up with a row in 'a' that has 
childName set to 'B', and then a row in 'b' that has also a childName, which 
then is set to 'C'.

The problem here for me is: how do I create a sql query that filters over the 
different types? 

Using 

A.select(B.q.childName == 'C')

to get all Cs translates to 

SELECT a.id, a.child_name, a.a FROM a WHERE ((a.child_name) = ('C'))

So - any idea how to accomplish that?

Regards,

-- 
>> Diez B. Roggisch
>> Developer

T  +49 (30) 443 50 99 - 27
F  +49 (30) 443 50 99 - 99
M  +49 (179) 11 75 303
E  [EMAIL PROTECTED]


>> artnology GmbH

A  Milastraße 4 / D-10437 Berlin
T  +49 (30) 443 50 99 - 0
F  +49 (30) 443 50 99 - 99
E  [EMAIL PROTECTED]
I  http://www.artnology.com

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to