English 中文(简体)
django smart decimal Field
原标题:django smart decimal field

I am creating an app that basically stores shoe sizes, along with other information. I have been using the Django Decimal field to store the sizes, however the decimal field stores sizes like 10 as 10.0, so my question is, is there a way to make or if already exists a field that when provided an int ( 10 ) it stores the value as int and when provided a decimal ( 10.5 ) then stores it as decimal ?

最佳回答

TBH涉及一只鞋场,可能使用一个有选择的沙田——有效鞋子数量相对较少,因此,你可以如何安排他们。

如果它属于可能包含除鞋以外的东西的产品模式的一部分,那么规模的沙田就是有益的,因为你也可以储存M 、L 、XXL等值。

你不敢在鞋子上做任何算术,这样就没有点要使用 Dec。

出于这一原因,它实际上并不涉及 d中挽救的东西,只有你所显示的,而且......j_syk在评论中提出了与这些内容大致相同的好备选建议。

问题回答

难道不简单地把它交给你细致的工作吗? 你可以把你储存起来,但在提交你的数据时,把数字安排到你所喜欢的身上。

>>> str(Decimal(10))
 10 
>>> str(Decimal(10.5))
 10.5 
>>> str(Decimal(10.0))
 10 

我通过了这一解决办法:

  1. Create a custom Django model Field
  2. Which return a custom decimal.Decimal instance that implements the trick in __unicode__ because this is just a matter of representation

The snippet:

class PyPrettyDecimal(decimal.Decimal): 

    def __unicode__(self): 
        # TODO: to improve with decimal properties ?!? 
        mod = self - int(self) 
        if not mod: 
            rv = int(self) 
        else: 
            rv = self.quantize(mod.normalize()) 
        return unicode(rv) 

class PrettyDecimalField(models.DecimalField): 

    __metaclass__ = models.SubfieldBase 

    def to_python(self, value): 
        if value is None: 
            return value 
        try: 
            return PyPrettyDecimal(value) 
        except decimal.InvalidOperation: 
            raise exceptions.ValidationError(self.error_messages[ invalid ]) 




相关问题
Can Django models use MySQL functions?

Is there a way to force Django models to pass a field to a MySQL function every time the model data is read or loaded? To clarify what I mean in SQL, I want the Django model to produce something like ...

An enterprise scheduler for python (like quartz)

I am looking for an enterprise tasks scheduler for python, like quartz is for Java. Requirements: Persistent: if the process restarts or the machine restarts, then all the jobs must stay there and ...

How to remove unique, then duplicate dictionaries in a list?

Given the following list that contains some duplicate and some unique dictionaries, what is the best method to remove unique dictionaries first, then reduce the duplicate dictionaries to single ...

What is suggested seed value to use with random.seed()?

Simple enough question: I m using python random module to generate random integers. I want to know what is the suggested value to use with the random.seed() function? Currently I am letting this ...

How can I make the PyDev editor selectively ignore errors?

I m using PyDev under Eclipse to write some Jython code. I ve got numerous instances where I need to do something like this: import com.work.project.component.client.Interface.ISubInterface as ...

How do I profile `paster serve` s startup time?

Python s paster serve app.ini is taking longer than I would like to be ready for the first request. I know how to profile requests with middleware, but how do I profile the initialization time? I ...

Pragmatically adding give-aways/freebies to an online store

Our business currently has an online store and recently we ve been offering free specials to our customers. Right now, we simply display the special and give the buyer a notice stating we will add the ...

Converting Dictionary to List? [duplicate]

I m trying to convert a Python dictionary into a Python list, in order to perform some calculations. #My dictionary dict = {} dict[ Capital ]="London" dict[ Food ]="Fish&Chips" dict[ 2012 ]="...

热门标签