blocks|key|410791|text|我认为我应该将字段创建为models.CharField()，然后将字典编码为JSON字符串，并将该字符串保存到数据库中。然后，您可以在读出JSON字符串时将其解码回字典中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|410792|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I think that I would create the field as models.CharField() and then encode the dictionary as a JSON string and save that string into the database. Then you can decode the JSON string back into a dictionary when you read it out.

blocks|key|625972|text|也许最干净的做法是创建另一个"Products“表，并具有多对多关系。(请看这里：https://docs.djangoproject.com/en/dev/topics/db/models/#many-to-many-relationships。在文档中，他们使用了比萨饼有很多配料的例子。)|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|625973|另一种选择是序列化bill_products。在这种情况下，您应该这样做：|625974|bill_products+=+json.dumps([rand_products])|code-block|syntax|javascript|625975|这将在for循环之外(尽管在上面的示例中，rand_products只是一个值，因此您需要修复它)。|625976|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/dev/topics/db/models/#many-to-many-relationships^0|15|2A|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

Probably the cleanest thing to do would be to create another "Products" table and have a many-to-many relationship. (See here: <a href="https://docs.djangoproject.com/en/dev/topics/db/models/#many-to-many-relationships" rel="noreferrer">https://docs.djangoproject.com/en/dev/topics/db/models/#many-to-many-relationships</a> . In the docs they use the example of a pizza having many toppings.)

The other option would be to serialize your bill_products. In that case, you'd do something like:

<pre><code>bill_products = json.dumps([rand_products])
</code></pre>

This would be outside of the for loop (although, in your example above, rand_products is only a single value, so you'll need to fix that).

blocks|key|626029|text|在模型中存储JSON表示的一种方便方法是使用自定义字段类型：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|626030|class+JSONField(models.TextField):
++++"""
++++JSONField+is+a+generic+textfield+that+neatly+serializes/unserializes
++++JSON+objects+seamlessly.
++++Django+snippet+#1478

++++example:
++++++++class+Page(models.Model):
++++++++++++data+=+JSONField(blank=True,+null=True)


++++++++page+=+Page.objects.get(pk=5)
++++++++page.data+=+{'title':+'test',+'type':+3}
++++++++page.save()
++++"""

++++__metaclass__+=+models.SubfieldBase

++++def+to_python(self,+value):
++++++++if+value+==+"":
++++++++++++return+None

++++++++try:
++++++++++++if+isinstance(value,+basestring):
++++++++++++++++return+json.loads(value)
++++++++except+ValueError:
++++++++++++pass
++++++++return+value

++++def+get_db_prep_save(self,+value,+*args,+**kwargs):
++++++++if+value+==+"":
++++++++++++return+None
++++++++if+isinstance(value,+dict):
++++++++++++value+=+json.dumps(value,+cls=DjangoJSONEncoder)
++++++++return+super(JSONField,+self).get_db_prep_save(value,+*args,+**kwargs)|code-block|syntax|javascript|626031|我将这个utils/fields.py保存在我的模型from+utils.fields+import+JSONField中。在django-annoying应用程序中还有更多的好东西，这就是这个代码片段的来源。|offset|length|style|CODE|626032|entityMap|0|LINK|mutability|MUTABLE|url|https://bitbucket.org/offline/django-annoying^0|0|0|Q|Y|1R|F|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@$I|X|J|Y|K|L]]|9|@$I|Z|J|10|1|11]]|A|$]]|$1|M|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

One convenient way to store a JSON representation in a model is to use a custom field type:

<pre><code>class JSONField(models.TextField):
 """
 JSONField is a generic textfield that neatly serializes/unserializes
 JSON objects seamlessly.
 Django snippet #1478

 example:
 class Page(models.Model):
 data = JSONField(blank=True, null=True)


 page = Page.objects.get(pk=5)
 page.data = {'title': 'test', 'type': 3}
 page.save()
 """

 __metaclass__ = models.SubfieldBase

 def to_python(self, value):
 if value == "":
 return None

 try:
 if isinstance(value, basestring):
 return json.loads(value)
 except ValueError:
 pass
 return value

 def get_db_prep_save(self, value, *args, **kwargs):
 if value == "":
 return None
 if isinstance(value, dict):
 value = json.dumps(value, cls=DjangoJSONEncoder)
 return super(JSONField, self).get_db_prep_save(value, *args, **kwargs)
</code></pre>

I saved this utils/fields.py and in my model <code>from utils.fields import JSONField</code>. There are many more goodies in the <a href="https://bitbucket.org/offline/django-annoying" rel="noreferrer">django-annoying</a> app, which is where this snippet came from.

blocks|key|410958|text|您可以在pickle模块中使用序列化/反序列化：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|410959|http://docs.python.org/library/pickle.html|offset|length|410960|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|16|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

You can use serialization/deserialization from pickle module:

<a href="http://docs.python.org/library/pickle.html" rel="nofollow">http://docs.python.org/library/pickle.html</a>

blocks|key|626102|text|如果postgres是您的后端，请考虑hstore字段，它具有来自django的本地支持|type|unstyled|depth|inlineStyleRanges|entityRanges|data|626103|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If postgres is your backend, consider the hstore field which has native support from django

blocks|key|626153|text|使用自定义字段类型是我的首选解决方案--我宁愿有几行自定义代码，也不愿为一个字段类型支持整个第三方库。Tony+Abou-Assaleh有一个很好的解决方案，但不适用于更新版本的Django。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|626154|这已被验证可以与Django+1.10.4一起使用|626155|import+json

from+django.db+import+models
from+django.core.serializers.json+import+DjangoJSONEncoder


class+JSONField(models.TextField):
++++"""
++++JSONField+is+a+generic+textfield+that+neatly+serializes/unserializes
++++JSON+objects+seamlessly.
++++Django+snippet+#1478

++++example:
++++++++class+Page(models.Model):
++++++++++++data+=+JSONField(blank=True,+null=True)


++++++++page+=+Page.objects.get(pk=5)
++++++++page.data+=+{'title':+'test',+'type':+3}
++++++++page.save()
++++"""

++++def+to_python(self,+value):
++++++++if+value+==+"":
++++++++++++return+None

++++++++try:
++++++++++++if+isinstance(value,+str):
++++++++++++++++return+json.loads(value)
++++++++except+ValueError:
++++++++++++pass
++++++++return+value

++++def+from_db_value(self,+value,+*args):
++++++++return+self.to_python(value)

++++def+get_db_prep_save(self,+value,+*args,+**kwargs):
++++++++if+value+==+"":
++++++++++++return+None
++++++++if+isinstance(value,+dict):
++++++++++++value+=+json.dumps(value,+cls=DjangoJSONEncoder)
++++++++return+value|code-block|syntax|javascript|626156|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Using a custom field type is my preferred solution - I'd rather have a few lines of custom code than support an entire 3rd party library for a single field type. Tony Abou-Assaleh has a great solution, but won't work for newer versions of Django.

This is verified to work with Django 1.10.4

<pre><code>import json

from django.db import models
from django.core.serializers.json import DjangoJSONEncoder


class JSONField(models.TextField):
 """
 JSONField is a generic textfield that neatly serializes/unserializes
 JSON objects seamlessly.
 Django snippet #1478

 example:
 class Page(models.Model):
 data = JSONField(blank=True, null=True)


 page = Page.objects.get(pk=5)
 page.data = {'title': 'test', 'type': 3}
 page.save()
 """

 def to_python(self, value):
 if value == "":
 return None

 try:
 if isinstance(value, str):
 return json.loads(value)
 except ValueError:
 pass
 return value

 def from_db_value(self, value, *args):
 return self.to_python(value)

 def get_db_prep_save(self, value, *args, **kwargs):
 if value == "":
 return None
 if isinstance(value, dict):
 value = json.dumps(value, cls=DjangoJSONEncoder)
 return value
</code></pre>

blocks|key|626176|text|如果使用PostGres，可以将其存储在本地支持的JSON字段中：https://docs.djangoproject.com/en/dev/ref/contrib/postgres/fields/#jsonfield|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|626177|否则我会推荐@ramiro+answer+with第三方lib+https://stackoverflow.com/a/16437627/803174|626178|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/dev/ref/contrib/postgres/fields/#jsonfield|1|https://stackoverflow.com/a/16437627/803174^0|X|24|0|0|W|17|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

If using PostGres you can store it in natively supported JSON field:
<a href="https://docs.djangoproject.com/en/dev/ref/contrib/postgres/fields/#jsonfield" rel="nofollow noreferrer">https://docs.djangoproject.com/en/dev/ref/contrib/postgres/fields/#jsonfield</a>

Otherwise I'd recommend @ramiro answer with 3rd party lib <a href="https://stackoverflow.com/a/16437627/803174">https://stackoverflow.com/a/16437627/803174</a>

blocks|key|411107|text|根据Django+doc的说法，你可以使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|411108|from+django.contrib.postgres.fields+import+JSONField
from+django.db+import+models

class+Dog(models.Model):
++++name+=+models.CharField(max_length=200)
++++data+=+JSONField()

++++def+__str__(self):
++++++++return+self.name|code-block|syntax|javascript|411109|然后用这个来创建：|411110|Dog.objects.create(name='Rufus',+data={
+++++'breed':+'labrador',
+++++'owner':+{
+++++++++'name':+'Bob',
+++++++++'other_pets':+[{
+++++++++++++'name':+'Fishy',
+++++++++}],
+++++},
})|411111|我希望这能对你有所帮助。|411112|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/3.0/ref/contrib/postgres/fields/#jsonfield^0|9|3|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|12|8|@]|9|@]|C|$G|H]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|C|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

according to Django <a href="https://docs.djangoproject.com/en/3.0/ref/contrib/postgres/fields/#jsonfield" rel="nofollow noreferrer">doc</a> you can use :
<pre><code>from django.contrib.postgres.fields import JSONField
from django.db import models

class Dog(models.Model):
 name = models.CharField(max_length=200)
 data = JSONField()

 def __str__(self):
 return self.name
</code></pre>
and create with this :
<pre><code>Dog.objects.create(name='Rufus', data={
 'breed': 'labrador',
 'owner': {
 'name': 'Bob',
 'other_pets': [{
 'name': 'Fishy',
 }],
 },
})
</code></pre>
I hope this could help you.

I need to save a dictionary in a model's field. How do I do that?

For example I have this code:

<pre><code>def create_random_bill(self):
 name_chars = re.compile("[a-zA-Z0-9 -_]")
 bill_name = "".join(random.choice(name_chars for x in range(10)))
 rand_products = random.randint(1,100)
 for x in rand_products:
 bill_products = 
 new_bill = Bill.new(name=bill_name, date=datetime.date, products=bill_products)
 new_bill.save()
</code></pre>

What do I write for "bill_products=" so it saves some random products, from my Product model to this bill?

This is the bill's model description:

<pre><code>class Bill(models.Model):
 name = models.CharField(max_length=255)
 date = models.DateTimeField(auto_now_add=True)
 products = models.ManyToManyField(Product, related_name="bills")
</code></pre>

And also the product's model description:

<pre><code>class Product(models.Model):
 name = models.CharField(max_length=255)
 price = models.IntegerField()
</code></pre>

If there's anything else i should add just leave a comment. Thanks!

How to store a dictionary in a Django database model's field

数据库

Django

JSON

我需要在模型的字段中保存一个字典。我该怎么做？例如，我有这样的代码：def create_random_bill(self):    name_chars = re.compile("[a-zA-Z0-9 -_]")    bill_name = "".join(random.choice(name_chars for...

问如何在Django数据库模型的字段中存储字典
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Django数据库模型的字段中存储字典EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Django数据库模型的字段中存储字典
EN