Skip to main content

Django queryset and serialization together

Project description

django-qserializer

Continuos Integration Continuos Delivery

Django QSerializer started as an internal Buser project to improve our serialization process.

Database queries and serialization are two separated steps, but really ORM coupled. Relationships must be fetched from database before serialization, but Django don't have an easy way to setup that.

Start with a custom manager SerializableManager.

from django.db import models
from django_qserializer import SerializableManager


class Company(models.Model):
    name = models.CharField(max_length=64)


class Bus(models.Model):
    objects = SerializableManager()
    company = models.ForeignKey(Company, on_delete=models.SET_NULL)

A basic serializer implementation would be:

from django_qserializer import BaseSerializer


class BusSerializer(BaseSerializer):
    select_related = ['company']

    def serialize_object(self, obj):
        return {
            'id': obj.id,
            'company': {
                'name': obj.company.name,
            }
        }

Add the serializer to your queryset as:

buses = Bus.objects.to_serialize(BusSerializer).all()

for bus in buses:
    # The serialize method is bound to BusSerializer.serialize_object.
    print(bus.serialize())

API

BaseSerializer.select_related

List of model fields to add to queryset with a select_related call.

BaseSerializer.prefetch_related

List of model fields to add to queryset with a prefetch_related call.

class BusSerializer(BaseSerializer):
    prefetch_related = ['company']

    def serialize_object(self, obj):
        return {
            'id': obj.id,
            'company': {
                'name': obj.company.name,
            }
        }

BaseSerializer.prepare_queryset

Callable to change the queryset. It is possible to implement select_related and prefetch_related attributes with it, but they work together with prepare_queryset.

class BusSerializer(BaseSerializer):
    select_related = ['company']

    def prepare_queryset(self, qs):
        return qs.annotate(state=Value('broken'))

BaseSerializer.prepare_objects

Prepare objects after they are loaded to memory. Add data in bulk to them, like fetching information from cache and attaching to loaded objects.

BaseSerializer.serialize_object

Required implementation. It converts the Django model to a serializable dict. Avoid slow calls here because it will cause N+1 issues.

BaseSerializer.serialize

Execute serialize_object for each model object.

Development

To run the project, it is necessary the following tools:

To create a virtual environment, run

python3  -m venv .venv

To activate the virtual environment, run

source .venv/bin/activate

To install the project's requirements in the virtual environment, run

pip install -e .\[test\]

To deactivate the virtual environment, run deactivate.

Run the commands of the following sections with the virtual environment active.

Quality

The quality metrics of the project are reproduced by the continuos integration (CI) pipeline of the project. CI configuration in .github/workflows/ci.yml file.

Tests and linter

To run tests, coverage report and linter, run

pytest

To see the html report, check htmlcov/index.html.

Tests and coverage configuration in setup.cfg file, at [tool:pytest] section.

Linter configuration in setup.cfg file, at [flake8] section.

License

This repository is licensed under the terms of MIT License.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django_qserializer-0.2.9.tar.gz (8.4 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

django_qserializer-0.2.9-py3-none-any.whl (8.9 kB view details)

Uploaded Python 3

File details

Details for the file django_qserializer-0.2.9.tar.gz.

File metadata

  • Download URL: django_qserializer-0.2.9.tar.gz
  • Upload date:
  • Size: 8.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.0.1 CPython/3.12.8

File hashes

Hashes for django_qserializer-0.2.9.tar.gz
Algorithm Hash digest
SHA256 3e576a3e1b704aa782f6ed2116e7745eb2d210d351412f17db66e32f2cdf1357
MD5 28b86bdd511903c1597b1df7a174070f
BLAKE2b-256 955d062e0517aba387a90c3f50909771fe2dd081ae39b38fb6c66b2e51b2ad55

See more details on using hashes here.

File details

Details for the file django_qserializer-0.2.9-py3-none-any.whl.

File metadata

File hashes

Hashes for django_qserializer-0.2.9-py3-none-any.whl
Algorithm Hash digest
SHA256 e7bc9d7561eade8186a7cbbf95fa616f64417eb4da8d1ea6998f93d441d1ce10
MD5 9426834d14e23286374b198732a1fd70
BLAKE2b-256 15939603d0456a19047d4d71a941870823057b968be0dcbab32a5d86b88b3f1e

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page