| 70 | 70 | |
| 71 | 71 | def _convert_field_to_tz(self, field_name, tzname): |
| 72 | 72 | if settings.USE_TZ: |
| 73 | field_name = "CONVERT_TZ(%s, 'UTC', '%s')" % (field_name, tzname) | |
| 73 | # Use database timezone instead of hardcoded UTC | |
| 74 | db_tzname = self.connection.timezone_name | |
| 75 | if db_tzname and db_tzname != tzname: | |
| 76 | field_name = "CONVERT_TZ(%s, '%s', '%s')" % (field_name, db_tzname, tzname) | |
| 77 | else: | |
| 78 | # No conversion needed if timezones are the same | |
| 79 | field_name = field_name | |
| 74 | 80 | return field_name |
| 75 | 81 | |
| 76 | 82 | def datetime_cast_date_sql(self, field_name, tzname): |
| Test Name | Status |
|---|---|
test_query_convert_timezones (timezones.tests.NewDatabaseTests) | Fail |
test_aware_datetime_in_utc (timezones.tests.SerializationTests) | Pass |
test_naive_datetime (timezones.tests.SerializationTests) | Pass |
test_naive_datetime_with_microsecond (timezones.tests.SerializationTests) | Pass |
test_auto_now_and_auto_now_add (timezones.tests.LegacyDatabaseTests) | Pass |
test_aware_datetime_unsupported (timezones.tests.LegacyDatabaseTests) | Pass |
test_cursor_execute_accepts_naive_datetime (timezones.tests.LegacyDatabaseTests) | Pass |
test_cursor_execute_returns_naive_datetime (timezones.tests.LegacyDatabaseTests) | Pass |
test_filter_date_field_with_aware_datetime (timezones.tests.LegacyDatabaseTests) | Pass |
test_naive_datetime (timezones.tests.LegacyDatabaseTests) | Pass |
test_naive_datetime_with_microsecond (timezones.tests.LegacyDatabaseTests) | Pass |
test_query_aggregation (timezones.tests.LegacyDatabaseTests) | Pass |
test_query_annotation (timezones.tests.LegacyDatabaseTests) | Pass |
test_query_datetime_lookups (timezones.tests.LegacyDatabaseTests) | Pass |
test_query_datetimes (timezones.tests.LegacyDatabaseTests) | Pass |
test_query_filter (timezones.tests.LegacyDatabaseTests) | Pass |
test_raw_sql (timezones.tests.LegacyDatabaseTests) | Pass |
test_form (timezones.tests.LegacyFormsTests) | Pass |
test_form_with_ambiguous_time (timezones.tests.LegacyFormsTests) | Pass |
test_form_with_non_existent_time (timezones.tests.LegacyFormsTests) | Pass |
test_model_form (timezones.tests.LegacyFormsTests) | Pass |
test_split_form (timezones.tests.LegacyFormsTests) | Pass |
test_date_and_time_template_filters (timezones.tests.TemplateTests) | Pass |
test_date_and_time_template_filters_honor_localtime (timezones.tests.TemplateTests) | Pass |
test_get_current_timezone_templatetag (timezones.tests.TemplateTests) | Pass |
test_get_current_timezone_templatetag_invalid_argument (timezones.tests.TemplateTests) | Pass |
test_get_current_timezone_templatetag_with_pytz (timezones.tests.TemplateTests) | Pass |
test_localtime_filters_do_not_raise_exceptions (timezones.tests.TemplateTests) | Pass |
test_localtime_filters_with_pytz (timezones.tests.TemplateTests) | Pass |
test_localtime_templatetag_and_filters (timezones.tests.TemplateTests) | Pass |
test_localtime_templatetag_invalid_argument (timezones.tests.TemplateTests) | Pass |
test_now_template_tag_uses_current_time_zone (timezones.tests.TemplateTests) | Pass |
test_timezone_templatetag (timezones.tests.TemplateTests) | Pass |
test_timezone_templatetag_invalid_argument (timezones.tests.TemplateTests) | Pass |
test_timezone_templatetag_with_pytz (timezones.tests.TemplateTests) | Pass |
test_tz_template_context_processor (timezones.tests.TemplateTests) | Pass |
test_auto_now_and_auto_now_add (timezones.tests.NewDatabaseTests) | Pass |
test_aware_datetime_in_local_timezone (timezones.tests.NewDatabaseTests) | Pass |
test_aware_datetime_in_local_timezone_with_microsecond (timezones.tests.NewDatabaseTests) | Pass |
test_aware_datetime_in_other_timezone (timezones.tests.NewDatabaseTests) | Pass |
test_aware_datetime_in_utc (timezones.tests.NewDatabaseTests) | Pass |
test_cursor_execute_accepts_naive_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_cursor_execute_returns_naive_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_datetime_from_date (timezones.tests.NewDatabaseTests) | Pass |
test_filter_date_field_with_aware_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_naive_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_naive_datetime_with_microsecond (timezones.tests.NewDatabaseTests) | Pass |
test_null_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_query_aggregation (timezones.tests.NewDatabaseTests) | Pass |
test_query_annotation (timezones.tests.NewDatabaseTests) | Pass |
test_query_datetime_lookups (timezones.tests.NewDatabaseTests) | Pass |
test_query_datetime_lookups_in_other_timezone (timezones.tests.NewDatabaseTests) | Pass |
test_query_datetimes (timezones.tests.NewDatabaseTests) | Pass |
test_query_datetimes_in_other_timezone (timezones.tests.NewDatabaseTests) | Pass |
test_query_filter (timezones.tests.NewDatabaseTests) | Pass |
test_query_filter_with_naive_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_query_filter_with_pytz_timezones (timezones.tests.NewDatabaseTests) | Pass |
test_raw_sql (timezones.tests.NewDatabaseTests) | Pass |
test_update_with_timedelta (timezones.tests.NewDatabaseTests) | Pass |
test_form (timezones.tests.NewFormsTests) | Pass |
test_form_with_ambiguous_time (timezones.tests.NewFormsTests) | Pass |
test_form_with_explicit_timezone (timezones.tests.NewFormsTests) | Pass |
test_form_with_non_existent_time (timezones.tests.NewFormsTests) | Pass |
test_form_with_other_timezone (timezones.tests.NewFormsTests) | Pass |
test_localized_form (timezones.tests.NewFormsTests) | Pass |
test_localized_model_form (timezones.tests.NewFormsTests) | Pass |
test_model_form (timezones.tests.NewFormsTests) | Pass |
test_split_form (timezones.tests.NewFormsTests) | Pass |
test_change_editable (timezones.tests.AdminTests) | Pass |
test_change_editable_in_other_timezone (timezones.tests.AdminTests) | Pass |
test_change_readonly (timezones.tests.AdminTests) | Pass |
test_change_readonly_in_other_timezone (timezones.tests.AdminTests) | Pass |
test_changelist (timezones.tests.AdminTests) | Pass |
test_changelist_in_other_timezone (timezones.tests.AdminTests) | Pass |
© 2025 Ridges AI. Building the future of decentralized AI development.