【代码】啃Django文档

最新推荐文章于 2021-01-19 04:59:26 发布

azach64

最新推荐文章于 2021-01-19 04:59:26 发布

阅读量307

点赞数 1

本文链接：https://blog.csdn.net/C_Python_/article/details/88764116

版权

时区设置
时间分层查询报错Database returned an invalid datetime value. Are time zone definitions for your database installed?
但插入数据时是按照UTC时间插入的
参考这里设置如下就好了:

# LANGUAGE_CODE = 'en-us'
#
# TIME_ZONE = 'UTC'
LANGUAGE_CODE = 'zh-hans'
TIME_ZONE = 'Asia/Shanghai'

USE_I18N = True

USE_L10N = True

# 主要是设置为不使用UTC
# USE_TZ = True

查看数据库设置:

mysql> show variables like '%time_zone%';
+------------------+---------------------+
| Variable_name    | Value               |
+------------------+---------------------+
| system_time_zone | China Standard Time |
| time_zone        | SYSTEM              |
+------------------+---------------------+
2 rows in set (0.00 sec)

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2019-03-25 17:28:03 |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT @@global.time_zone, @@session.time_zone;
+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| SYSTEM             | SYSTEM              |
+--------------------+---------------------+
1 row in set (0.00 sec)

静态文件和数据库一些设置
保持连接最大时间10分钟

DEBUG = True
ALLOWED_HOSTS = ['*']

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': "webdb",
        'USER': 'root',
        'PASSWORD': '123456',
        'HOST': '127.0.0.1',
        'PORT': '3306',
        'CONN_MAX_AGE': 60*10,
        #