Importing Timezone Info?
### Context
I am using pytest-mysql to unit test queries to MariaDB. One of the queries uses the [convert_tz](https://mariadb.com/kb/en/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](https://mariadb.com/kb/en/mariadb-tzinfo-to-sql/) 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?
1 条评论