Re: [sqlalchemy] Re: AsyncEngine always returns UTC time for datetime column
using the "sync" engine I would assume you are using psycopg2, which is going
to use native Postgresql client libraries. asyncpg I think is written in
cython and doesn't actually use libpq if im reading it correctly.
therefore the difference may be a libpq related setting of the local timezone
when the program runs, though I can't produce specific links to support this
theory.
On Wed, Sep 15, 2021, at 3:27 AM, Ivan Randjelovic wrote:
> 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=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
>
> .
--
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/e1d66368-0390-44f7-9792-21205b9b7089%40www.fastmail.com.
[sqlalchemy] Re: AsyncEngine always returns UTC time for datetime column
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=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.
[sqlalchemy] Re: AsyncEngine always returns UTC time for datetime column
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/e7f24870-80d0-49f7-99a0-de4d141f33b9n%40googlegroups.com.
