Django snippets: SelectRelatedManager

SelectRelatedManager

class SelectRelatedManager(models.Manager):
    def get_query_set(self):
        return super(SelectRelatedManager, self)\
            .get_query_set()\
            .select_related('organization')

class SomeModel(models.Model):
    ...
    organization = models.ForeignKey(Organization, blank=True, null=True)
    ....

    objects = SelectRelatedManager()

More like this

Allow foreign key attributes in list_display with '__' by jcushman 3 months, 2 weeks ago
Left Outer join Q object by karsu 5 years, 12 months ago
Limit ForeignKey filter values to those that have a relationship with current model by overclocked 2 years, 6 months ago
Manager method for limiting GenericForeignKey queries by zerok 4 years, 9 months ago
RelatedNullFilterSpec: django-admin custom filter all/null/not null/choices by Codeko 2 years, 7 months ago

Because select_related() only works on ForeignKeys that are not null or blank, when you are customizing the admin, even if you set "list_select_related=True" you can still end up with way too many querys in the Admin changelist. By adding this code to your model you can decrease the queries dramatically.

I found I needed this when I was working with Django apps with a lot of legacy data and I couldn't set the ForeignKey null=False.

Author:: realmac
Posted:: September 15, 2011
Language:: Python
Django Version:: 1.2
Tags:: admin manager select queryset
Score:: 0 (after 0 ratings)

Tools

Comments

lankrappsamue (on October 17, 2011):

[HTML_REMOVED][HTML_REMOVED]top wedding dress[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]wedding dress fantasy[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]the cheap wedding dress[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]a-line v-neck wedding dresses[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]bowknot wedding dress[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]fancy dress royal wedding[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]prom dresses vintage[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]cocktail dresses[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]party dresses for women[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]bridesmaid dresses wholesale[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About top wedding dress blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About www.comedress.com blog [HTML_REMOVED]

saisarch (on October 18, 2011):

[HTML_REMOVED][HTML_REMOVED]top wedding dress[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]wedding dress fantasy[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]the cheap wedding dress[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]a-line v-neck wedding dresses[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]bowknot wedding dress[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]bridesmaid dresses wholesale[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]vintage bridesmaid dresses[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]new look wedding dresses[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]big size wedding dress[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]vintage bridesmaid dresses[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About top wedding dress blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About www.comedress.com blog [HTML_REMOVED]

saisarch (on October 25, 2011):

. In this love poem Black-Eyed Susan and Sweet William were separated by circumstance continued to search for each other. In wildflower gardens around the world, the Black-Eyed Susan and Sweet William wild flowers are said to bloom at the same time and look stunning together.[HTML_REMOVED] [HTML_REMOVED] Wedding seed favor kits speak volumes about your philosophy on never ending love and friendship. Although the wedding day has passed and the big event is over, the spirit of friendship and natural joy lives on as the flowers take bloom[HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About blog [HTML_REMOVED]

saisarch (on October 25, 2011):

[HTML_REMOVED][HTML_REMOVED]christian laboutin[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]christian louboutin boots[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]christian louboutin sale[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]christian louboutin shoes[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]christian louboutin online[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]discount louboutin dorsays[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Cheap Christian Louboutin heels[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]christian louboutin wedding[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]christian louboutin wedges[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]christian louboutin wedges[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] . The thought which you could obtain a popular brand name at the expense that would not give you blinking wanted to tremendous enthusiastic. You observed the ideal marketing the manufacturer fake as they quite simply named it and you simply ended up on your way to owning the most beneficial pair at any time.

This kind of Louboutin Fake ladies is along seeing that ages. You have worn the criminals to every single function all ready but yet they continue to look like new. One more time you wore the property to your place of work celebration you may look at the praise writ big within your bosses confront[HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About christian laboutin blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About loginchristianlouboutin.com blog [HTML_REMOVED]

saisarch (on October 25, 2011):

[HTML_REMOVED][HTML_REMOVED]Canada Goose Trillium Parka[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] canada goose outlet[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] Canada Goose[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Canada Goose Discount[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] Buy Canada Goose[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Canada Goose Mens Chilliwack Bomber MidGrey CG01004 [HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Canada Goose Mens Chilliwack Bomber CelticGreen CG01002 [HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Canada Goose Chilliwack Parka Womens CelticGreen CG60007[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Canada Goose Mens Chilliwack Bomber Yellow CG01011[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Canada Goose Men's Yorkville Parka MilitaryGreen CG30010 [HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] . CVWMA As Neighborhood Days

Increase and Motorcycle the Dyke

You have access to your wetland in various strategies. Your infinite tracks of boardwalks, all natural hiking trails as well as dykes that include typically the wetland debris requires someone to almost every corner of this wetland. Most tracks is generally found via next to and / or within the CVWMA Presentation Centre located just southerly involving Hwy #3 around the western team of your vly.

2 different trendy accesses, particularly pertaining to Duck Ocean, can be found off all motorways 3A, south from Creston[HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About Canada Goose Trillium Parka blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About mycanadagoosestore.org blog [HTML_REMOVED]

saisarch (on October 25, 2011):

[HTML_REMOVED][HTML_REMOVED]outlet north face[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] north face[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] the north face outlet[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]the north face coats[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] the north face[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] down jackets women[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]north face for sale[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]north face jacket[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] north face mens[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] the north face women[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] . [HTML_REMOVED] [HTML_REMOVED] The main visitor attraction is the Bedlington Country Park. The country park on the north side of the River Blyth, has a picnic area and childrens play area as well as pleasant horse and nature trails. There is a variety of wildlife within the park. An environmental attraction and research centre includes a recycled textile company, brewery and organic farm. The site also has a nature reserve with organic plants for sale. Various events are held throughout the year and tours for groups and school children can be arranged[HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About outlet north face blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About newnorthfacesale.org blog [HTML_REMOVED]

saisarch (on October 25, 2011):

.Non- clumping mascaras currently have contents prefer glycerin in addition to silk draw out that reduces the mascara with clogging.[HTML_REMOVED] [HTML_REMOVED] 3.Brush[HTML_REMOVED] [HTML_REMOVED] Curved brushes are able to coat far more lashes right away simultaneously.Straight brushes usually are best to get applying mascara to the lashes of this corners with the eyes, which have been difficult to get to.[HTML_REMOVED] [HTML_REMOVED] five.Formulations[HTML_REMOVED] [HTML_REMOVED] Eyelashes, like virtually all hair, are made of protein that might be susceptible to help you brittleness and even shedding on account of harsh chemical substances[HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About blog [HTML_REMOVED]

saisarch (on October 25, 2011):

.Here are really a few tips to help you get over cherished dress hump definitely will less are sweating.[HTML_REMOVED] [HTML_REMOVED] 1.The gown Comes First[HTML_REMOVED] Whilst it may choose both options, the theme on your dress should really follow a person's desired concept or vice versa.Some couples pick out theme before selecting a gown, and fundamentally, they come up with the ensemble fit a theme they also have chosen.But for many people, the range of gown shows up first, and therefore the theme from the wedding follows complete theme[HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About blog [HTML_REMOVED]

saisarch (on October 25, 2011):

[HTML_REMOVED]<a href="http://www.

loginlouisvuitton.com/">Louis Vuitton[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED]<a href="http://www.

loginlouisvuitton.com/">Louis Vuitton Handbags[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED]<a href="http://www.

loginlouisvuitton.com/">LV Handbags[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED]<a href="http://www.

loginlouisvuitton.com/">LV Bags Store[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED]<a href="http://www.

loginlouisvuitton.com/">Buy Louis Vuitton[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]louis vuitton on sale[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Louis Vuitton Travel Bags sale[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]louis vuitton mahina leather[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]buy lv bags taiga leather[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]LV men bags[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] . All of the Reproductions receives diligently made, lower, applying most of the ideal rubber stamps. Almost all of the reproductions of vintage designs take this YYZ zip fasteners, crucial set up, and then steel fasten. Some even carry the initial unit phone numbers plus serial numbers.

For example a site can give Louis Vuitton fake that happen to be of second-best with high quality whereas when compared to original documents, and can also end up being commercialized to create a high quality basically mainly because amazing since the originals[HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About Louis Vuitton blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About loginlouisvuitton.com blog [HTML_REMOVED]

saisarch (on October 25, 2011):

[HTML_REMOVED][HTML_REMOVED]Moncler[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] Moncler outlet[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] Moncler discount[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Moncler Coats[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED] Cheap Moncler[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Moncler Mens Multiple Logo Vest in Black MC20009[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Moncler Classic Branson Down Jacket in Blue MC14023[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Moncler Womens Gaelle Fully Lined Vest in Purple MC40007 [HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Moncler Angers Belted Down Jacket in Black MC30009[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED][HTML_REMOVED]Moncler Womens Gaelle Fully Lined Vest in Red MC40008 [HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] . To generate your personal corduroy shirt stand above the target audience, opt for a lean truck driver jacket. This kind of jeans coat compensates financially even more focus on pattern. It is actually close becoming on the human body and somewhat extended inside the abs. Don it during the night the moment out with your pals and that you will make one or two green with envy appears.

Military Style Hat Shirt: If you ever pay out ones saturdays and sundays while travelling then you will genuinely understand a classy government hat[HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About Moncler blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About pricemoncler.org blog [HTML_REMOVED]

saisarch (on October 25, 2011):

. The show doesn't have a set plot -- the audience is in fact creating it along with the cast. If you enjoy unrehearsed and spontaneous performances, you will like this show. But in order to truly enjoy it, it is recommended that you loosen up and start interacting with the actors -- like talking and maybe even dancing. During the whole show the actors are coming over to the tables and talking to the people from the audience. They hope that you will react and participate in the jokes, but they won't bother you if you just want to watch without interacting with them[HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About blog [HTML_REMOVED]

saisarch (on November 8, 2011):

[HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] Other About blog [HTML_REMOVED][HTML_REMOVED][HTML_REMOVED][HTML_REMOVED] About blog [HTML_REMOVED]

Django snippets

SelectRelatedManager

More like this

Tools

Comments

Snippets

About