[BUG] timezone offset issue

[iamtalhaasghar]

Bug Description

Introduced in #238

Steps to Reproduce

1. Mysql timezone is set to +4:30
2. Clickhouse timezone is also set to Asia/Kabul
3. timezone in docker image is also set to Asia/Kabul
4. run replicate docker image

Expected Behavior

In real-time replication, there shouldn't be any offset in datetime columns.

Actual Behavior

It adds an offset of +4:30pm.

Environment

• mysql_ch_replicator version: 0.1.10
• Operating System: debian 12
• Python version: 3.11.2

MySQL Configuration

will provide if required.

Replicator Configuration

mysql:
  host: 'some-host'
  port: 3306
  user: 'test'
  password: 'pass'

clickhouse:
  host: 'localhost'
  port: 8123
  user: 'default'
  password: ''
  #cluster: 'somecluster'

binlog_replicator:
  data_dir: '/app/data'
  records_per_file: 100000

databases: ['test']
log_level: 'info'
mysql_timezone: 'Asia/Kabul'
ignore_deletes: true

Additional Information

docker image was run with env variable -e Asia/Kabul

[iamtalhaasghar]

related #237 & #230

[bakwc]

Will try to reproduce

[iamtalhaasghar]

os.environ['TZ'] = os.environ.get('TZ', 'UTC')

Should fix this! Respecting TZ env var passed to docker via -e flag.