DjangoでMySQLにマイグレーションすると以下の警告が出た。
WARNINGS:
?: (mysql.W002) MySQL Strict Mode is not set for database connection 'default'
HINT: MySQL's Strict Mode fixes many data integrity problems in MySQL, such as data truncation upon insertion, by escalating warnings into errors. It is strongly recommended you activate it. See: https://docs.djangoproject.com/en/3.1/ref/databases/#mysql-sql-mode
調べると settings.pyにOPTIONSを追加することで解決。
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'my_db',
'OPTIONS': {
'init_command': "SET sql_mode='STRICT_TRANS_TABLES'",
},
}
}
参考
https://qiita.com/hayato1130/items/27093d62d786ca0abc14
https://django-mysql.readthedocs.io/en/latest/checks.html