BUG#35832148: Fix Django timezone.utc deprecation warning

nmariz · nmariz · commit fdb01277a058 · 2023-11-16T15:40:48.000Z
The use of the django.utils.timezone.utc alias triggers a deprecation
warning from Django, when Python warnings are enable.

This patch fixes this issue by using the Python built-in
datetime.timezone.utc in the Connecton/Python Django operations
module.

Change-Id: If76904b41966979d54efd6135708b87942ed21e4
diff --git a/CHANGES.txt b/CHANGES.txt
@@ -17,6 +17,7 @@ v8.3.0
 - WL#15942: Improve type hints and standardize byte type handling
 - WL#15523: Support Python DB API asynchronous execution
 - BUG#35912790: Binary strings are converted when using prepared statements
+- BUG#35832148: Fix Django timezone.utc deprecation warning
 - BUG#35710145: Bad MySQLCursor.statement and result when query text contains code comments
 
 v8.2.0
diff --git a/lib/mysql/connector/django/operations.py b/lib/mysql/connector/django/operations.py
@@ -30,14 +30,14 @@
 
 """Database Operations."""
 
-from datetime import datetime, time
+from datetime import datetime, time, timezone
 from typing import Optional
 
 from django.conf import settings
 from django.db.backends.mysql.operations import (
     DatabaseOperations as MySQLDatabaseOperations,
 )
-from django.utils import timezone
+from django.utils import timezone as django_timezone
 
 try:
     from _mysql_connector import datetime_to_mysql, time_to_mysql
@@ -74,7 +74,7 @@ def value_to_db_datetime(self, value: Optional[datetime]) -> Optional[bytes]:
         if value is None:
             return ans
         # MySQL doesn't support tz-aware times
-        if timezone.is_aware(value):
+        if django_timezone.is_aware(value):
             if settings.USE_TZ:
                 value = value.astimezone(timezone.utc).replace(tzinfo=None)
             else:
@@ -96,7 +96,7 @@ def value_to_db_time(self, value: Optional[time]) -> Optional[bytes]:
             return None
 
         # MySQL doesn't support tz-aware times
-        if timezone.is_aware(value):
+        if django_timezone.is_aware(value):
             raise ValueError("MySQL backend does not support timezone-aware times")
 
         if not self.connection.use_pure:
