Hi Jonathan,
I use postgres docker image from docker hub version 12 with this settings
in docker-compose file:
db:
image: postgres:12
environment:
POSTGRES_USER: test_db
POSTGRES_DB: test_db
POSTGRES_PASS: test_db
POSTGRES_HOST_AUTH_METHOD: trust
TZ: America/New_York
volumes:
- pgdata:/var/lib/postgresql/data
ports:
- 5532:5432
restart: unless-stopped
networks:
- postgres-net
Also when I create async engine the url is like this (copied from sqlaclemy
docs):
'postgresql+asyncpg://0.0.0.0:5532/test_db?user=test_db&password=test_db'
Regular create_engine (not async) returns datetime with correct timezone
info as expected, so this is an issue only when I use async engine
basically on the same way as regular one.
Thanks,
Ivan
On Wednesday, September 15, 2021 at 12:20:07 AM UTC+2 Jonathan Vanasco
wrote:
> Can you share the database drivers / dialects you use? The discrepancy
> could be there.
> On Tuesday, September 14, 2021 at 7:03:27 AM UTC-4
> ivan.ran...@themeanalytics.com wrote:
>
>> Hi all,
>>
>> I am trying to figure it out why AsyncEngine always returns UTC time for
>> datetime column, any help is appreciated?
>>
>> I am working with sqlalchemy core and async engine. Column definition:
>> *Column('test', DateTime(timezone=True), nullable=False)*
>>
>> Also tried with this, but no luck:
>>
>> *_connect_args = {'server_settings': {'timezone':
>> ''America/New_York''}}async_db: AsyncEngine =
>> create_async_engine(async_url_from_config(), connect_args=_connect_args)*
>>
>> When I tried with regular create_engine, everything worked as expected
>> with the same database data.
>> Data in the database (configured for New York) contains timezone info:
>>
>> *test | 2021-08-26 16:02:46.057288-04*
>>
>> BR,
>>
>> Ivan
>>
>>
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/944fd8d0-a842-46b0-83ee-48785141b5c0n%40googlegroups.com.
