DecimalField workaround for SQLite's lack of a real fixed-point field

sqlite_decimal_field.py

import logging
from decimal import Decimal

from django import db
from django.db.models import DecimalField as DjangoDecimalField

logger = logging.getLogger(__name__)
#logger.setLevel(logging.DEBUG)


class DecimalField(DjangoDecimalField):
    """On SQLite, store as an integer.  On all other backends, use DecimalField"""

    def get_internal_type(self):
        if db.connection.vendor == 'sqlite':
            return "IntegerField"
        else:
            return "DecimalField"

    def get_db_prep_save(self, value, connection):
        if connection.vendor == 'sqlite':
            logger.debug("value: %r, connection: %r", value, connection)
            result = int(value * 10**self.decimal_places)
            logger.debug("result: %r", result)
            return result
        else:
            return super().get_db_prep_save(value, connection)

    def from_db_value(self, value, expression, connection):
        if connection.vendor == 'sqlite':
            logger.debug("value: %r, expression: %r, connection: %r", value, expression, connection)
            result = Decimal(value) / 10**self.decimal_places
            logger.debug("result: %r", result)
            return result
        else:
            return super().from_db_value(value, expression, connection)