1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
import datetime
from pytest import fixture
from sqlalchemy import Column, MetaData, Table, select
from sqlalchemy_utc import UtcDateTime, utc, utcnow
TABLE = Table(
'test_table', MetaData(),
Column('time', UtcDateTime, default=utcnow()))
@fixture
def fx_connection(fx_engine):
connection = fx_engine.connect()
try:
transaction = connection.begin()
try:
TABLE.create(connection)
yield connection
finally:
transaction.rollback()
finally:
connection.close()
def test_utcnow_timezone(fx_connection):
fx_connection.execute(TABLE.insert(), [{}])
rows = fx_connection.execute(select(TABLE)).fetchall()
server_now = rows[0].time
local_now = datetime.datetime.now(utc)
assert server_now.tzinfo is not None
assert abs(server_now - local_now) < datetime.timedelta(seconds=30)
|
