crate-python
crate-python copied to clipboard
Inserting aware Datetime returns an error.
I'm trying to insert some DateTime data to CrateDB, but I'm getting an error.
The datetime I'm trying to insert looks so:

The column is a Timestamp with time zone column.
But I get this error:
File "/Users/chuckaguilar/PycharmProjects/postgres-cratedb-migration-tool/venv/lib/python3.7/site-packages/crate/client/http.py", line 82, in default
delta = o - self.epoch
TypeError: can't subtract offset-naive and offset-aware datetimes
But the CrateJsonEncoder (self.epoch) is naive:

tzinfo is None
So... it won't work. Either I make my datetime naive, or the self.epoch gotta be aware.
It'd work converting it to a string via datetime.strftime("%Y-%m-%dT%H:%M:%S.%f%z")
thanks, @autophagy :)
Related to #359