pytest-mysql icon indicating copy to clipboard operation
pytest-mysql copied to clipboard

Importing Timezone Info?

Open michaeligreenberg opened this issue 1 year ago • 1 comments

Context

I am using pytest-mysql to unit test queries to MariaDB. One of the queries uses the convert_tz function to shift a DateTime from one timezone to another. MySQL / MariaDB rely on metadata about timezones to perform this operation. The metadata is often loaded using the mysql_tzinfo_to_sql tool and the system's zoneinfo dataset. The output of that tool is meant to be piped into the mysql command-line interface.

Question

Is there a way that I can use the mysql CLI to access a pytest-mysql instance? Is there any other known way to import timezone metadata into a pytest-mysql instance?

michaeligreenberg avatar Jul 02 '24 20:07 michaeligreenberg