Login

django-pyodbc MoneyField

Author:
Tarken
Posted:
October 30, 2008
Language:
Python
Version:
1.0
Tags:
money convert pyodbc django-pyodbc
Score:
0 (after 0 ratings)

This is a very small, simple piece of code, but essential for using fields of type 'money' on MS SQL Server, through FreeTDS. This took me quite some time to hunt down, as get_placeholder() is in fact an undocumented feature.

Example:

class MyModel(models.Model):
    price = MoneyField()
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
from django.db import models

class MoneyField(models.DecimalField):
    
    def __init__(self, *args, **kwargs):
        # Default to the max size for SQL Server's money datatype
        kwargs['max_digits'] = kwargs.get('max_digits', 20)
        kwargs['decimal_places'] = kwargs.get('decimal_places', 2)
        super(MoneyField, self).__init__(*args, **kwargs)
    
    def get_placeholder(self, value):
        return r'CONVERT(money, %s)'

More like this

  1. Widget for Money values on Geraldo Reports by marinho 6 years ago
  2. Integer based MoneyField by Jay 5 years, 6 months ago
  3. dollarize numbers by alexdong 8 years ago
  4. Currency filter by kljensen 7 years, 3 months ago
  5. Support for {% macro %} tags in templates, version 2 by mludvig 7 years, 8 months ago

Comments

Please login first before commenting.