python - Django - Multi-table inheritance - reverse relation to SubClass -


i appreciate following problem. lets use models django documentation illustrate situation.

models.py

from django.db import models  class place(models.model):     owner = djangomodels.foreignkey('owner', related_name='places')     objects = passthroughmanager.for_queryset_class(placequeryset)()  class restaurant(place):     ... members ...     objects = passthroughmanager.for_queryset_class(restaurantqueryset)()  class pub(place):     ... members ...     objects = passthroughmanager.for_queryset_class(pubqueryset)()  class owner(models.model):     ... members ...

queryset.py

class placequeryset(djangomodels.query.queryset):     .. common place filters ...  class restaurantqueryset(placequeryset):     .. restaurant specific filters ...  class pubqueryset(placequeryset):     .. pub specific filters ...

so can see above have 1 base model 'place' , 2 sub models 'restaurant' , 'pub'. base model 'place' has link 'owner' object. querysets (placequeryset, restaurantqueryset, pubqueryset) have same inheritance hierarchy models (place, restaurant, pub).

the challenge having somehow retrieve pubqueryset containing pub objects linked owner....

i know 1 way need add owned_by(owner) filter pubqueryset , call following:

pub.objects.owned_by(owner)

but has performance issues because '.objects' not use prefetched results , hits db.

my thoughts:

when call 

# owner instance of owner class >>owner.places.all()

it returns

placequeryset[<place object ><place object ><place object >....]

but how 

pubqueryset[<pub object ><pub object >]

???

i know select_subclasses() method django-model-utils(1) can downcast objects in queryset if this

# owner instance of owner class >>owner.places.select_subclasses('pub')

i placequeryset instances of pub class

placequeryset[<pub object ><pub object >]

but still receive placequeryset , not pubqueryset...

thank help

jano


Comments

Post a Comment

Popular posts from this blog

php - Add the correct number of days for each month -

using following function can display years , months between 2 dates, how can add correct days each month array within each month? can't add days manually need account leap years etc. function yearmonth($start_date, $end_date) { $begin = new datetime( $start_date ); $end = new datetime( $end_date); $interval = new dateinterval('p1m'); // 1 month interval $period = new dateperiod($begin, $interval, $end); foreach ( $period $dt ) $years[$dt->format( "y" )][] = $dt->format( "f" ); return $years; } $list = yearmonth("2007-03-24", "2009-06-26"); var_dump($list); since nobody else answered: function yearmonth($start_date, $end_date) { $begin = new datetime( $start_date ); $end = new datetime( $end_date); $interval = new dateinterval('p1d'); // 1 month interval $period = new dateperiod($begin, $interval, $end); $lastmonth = null; $lastyear = null; $aresult = array(); forea...
Read more

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more