gpt4 book ai didi

python - 无法将 None 分配给 Django DateTimeField()

转载 作者:行者123 更新时间:2023-12-05 08:56:28 24 4
gpt4 key购买 nike

我可以判断这是一个错误吗?DateTimeField继承自DateField,可以是可选的

我读过: How to make Django's DateTimeField optional? How can I make my model fields optional in Django?

模型.py

class Circuit(SoftDeletionModel):
...
created_datetime = models.DateTimeField(default=timezone.now)
updated_datetime = models.DateTimeField(auto_now=True)
expiry_datetime = models.DateTimeField(null=True, blank=True, default=None)

在终端

$ python -B manage.py makemigrations --settings=config.settings.docker
apps.circuits is ready
apps.circuits_networkdevices is ready
apps.core is ready
apps.customers is ready
apps.networkdevices is ready
apps.networkscripts is ready
apps.portal is ready
apps.bod is ready
apps.scheduler is ready
You are trying to add a non-nullable field 'updated_datetime' to circuit without a default; we can't do that (the database needs something to populate existing rows).
Please select a fix:
1) Provide a one-off default now (will be set on all existing rows)
2) Quit, and let me add a default in models.py
Select an option: 1
Please enter the default value now, as valid Python
The datetime and django.utils.timezone modules are available, so you can do e.g. timezone.now()
>>> None
Migrations for 'circuits':
0022_auto_20161102_1714.py:
- Add field expiry_datetime to circuit
- Add field updated_datetime to circuit

迁移文件.py

# -*- coding: utf-8 -*-
# Generated by Django 1.9.9 on 2016-11-02 10:14
from __future__ import unicode_literals

from django.db import migrations, models


class Migration(migrations.Migration):

dependencies = [
('circuits', '0021_auto_20161102_1653'),
]

operations = [
migrations.AddField(
model_name='circuit',
name='expiry_datetime',
field=models.DateTimeField(blank=True, default=None, null=True),
),
migrations.AddField(
model_name='circuit',
name='updated_datetime',
field=models.DateTimeField(auto_now=True, default=None),
preserve_default=False,
),
]

Django 错误:

django.db.utils.IntegrityError: column "updated_datetime" contains null values

错误 Postgres:

postgres_1       | ERROR:  column "expiry_datetime" contains null values
postgres_1 | STATEMENT: ALTER TABLE "circuits_circuit" ADD COLUMN "expiry_datetime" timestamp with time zone NOT NULL

规范:

In [2]: django.VERSION
Out[2]: (1, 9, 9, 'final', 0)

$ python --version
Python 3.5.1

> SELECT version();
+------------------------------------------------------------------------------------------+
| version |
|------------------------------------------------------------------------------------------|
| PostgreSQL 9.5.3 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit |
+------------------------------------------------------------------------------------------+

最佳答案

你误会了什么auto_now

Automatically set the field to now every time the object is saved.

您仍然需要指定一个有效的默认值或使用 null=True 允许空值

关于python - 无法将 None 分配给 Django DateTimeField(),我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/40377580/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com