• Python - Some extra libraries and features and tips and tricks of python programming language you must know

• Python - Django Best Practices For Model Design

• Python - Simple Tricks to Level Up Your Python Coding

• Python - Python Pandas tips to make data analysis faster

• Python - How to Create Custom Django Management Commands

• Python - How to Setup a SSL Certificate on Nginx for a Django Application

• Python - How to Use Celery and RabbitMQ with Django

• Python - How to Use JWT Authentication with Django REST Framework

• Python - Django Tips for Designing Better Models

• Python - Django Query Tips select & prefetch_related

• Python - Django Tips for Working with Databases

• Python - Django REST Framework: adding additional field to ModelSerializer

• Python - How to Implement Dependent/Chained Dropdown List with Django

Django REST Framework: adding additional field to ModelSerializer

class FooSerializer(serializers.ModelSerializer):
  my_field = serializers.SerializerMethodField('is_named_bar')

  def is_named_bar(self, foo):
      return foo.name == "bar" 

  class Meta:
    model = Foo
    fields = ('id', 'name', 'my_field')

You can change your model method to property and use it in serializer with this approach.

class Foo(models.Model):
    . . .
    @property
    def my_field(self):
        return stuff
    . . .

class FooSerializer(ModelSerializer):
    my_field = serializers.ReadOnlyField(source='my_field')

    class Meta:
        model = Foo
        fields = ('my_field',)

Django how do i view query in manage shell

Start your shell with

:- python manage.py shell_plus --print-sql

Run a query

In [1]: Book.objects.all()
Out[1]: SELECT "book_book"."id", "book_book"."name", "book_book"."author_id" FROM "book_book" LIMIT 21

Execution time: 0.087548s [Database: default]

, ]>

If you don't want to append --print-sql every time, in your django settings, you can set

SHELL_PLUS_PRINT_SQL = True

An alternate way is to enable logging for db queries.

LOGGING = {
    'version': 1,
    'loggers': {
        'django.db.backends': {
            'level': 'DEBUG',
            'handlers': ['console'],
        }
    },
    'handlers': {
        'console': {
            'level': 'DEBUG',
            'class': 'logging.StreamHandler',
            'filters': ['require_debug_true'],
        }
    },
    'filters': {
        'require_debug_true': {
            '()': 'django.utils.log.RequireDebugTrue',
        }
    },
}