QuerySets Evaluation in Django

  • Creating a QuerySet does not involve any Database(DB) activity until it is evaluated. 
  • QuerySets usually return another unevaluated QuerySet. 
  • You can concatenate as many filters as you like to a QuerySet, and you will not hit the database until the QuerySet is evaluated. 
  • When a QuerySet is evaluated, it translates into an SQL query to the database.
  • QuerySets are only evaluated in the following scenarios:
    • The first time you iterate over them
    • When you pickle or cache them
    • When you slice them, for Ex:, Posts.objects.all()[:5]
    • When you call repr() or len() on them
    • When you explicitly call list() on them
    • When you test them in a statement, such as bool(), or, and, or if

Comments

Post a Comment

Popular posts from this blog

Internationalization (Language Setting) in Django

If your project want to run in English and a Spanish version edit the settings.py file of your project and add the following LANGUAGES setting to it.  Place it next to the LANGUAGE_CODE setting:                LANGUAGES = (                ('en', 'English'),                ('es', 'Spanish'),              ) The LANGUAGES setting contains two tuples that consist of a language code and a name .  Language codes can be locale-specific , such as en-us or en-gb , or generic , such as en . With this setting, we specified that application will only be available in English and Spanish.  If you don't define a custom LANGUAGES setting, the site will be available in all the languages that Django is translated into. Make your LANGUAGE_CODE setting look as follows:            ...
Read more

reverse_lazy() Method in Django

Use reverse_lazy() to generate the URL for the link attribute. The reverse() method allows you to build URLs by their name and pass optional parameters. The reverse_lazy() utility function is a lazily evaluated version of reverse(). It allows you to use a URL reversal before the project's URL configuration is loaded.
Read more

CharFilter in Django

  CharFilter filter does simple character matches, used with CharField and TextField by default. ex: char_filter_field_name = CharFilter(field_name='char_filter_field_name', lookup_expr='icontains', label='Char Filter Field Name', widget=forms.TextInput(attrs={'class': 'col-md-12 mr-2','placeholder': 'Please Enter Char Filter Field Name', 'style': 'width: 263px'}))     
Read more