pytest-mysql
pytest-mysql copied to clipboard
Importing Timezone Info?
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?