crate/cratedb-django

Support `TimeField`

Aperta

#53 aperta il 24 dic 2025

 (0 commenti) (0 reazioni) (0 assegnatari)Python (4 fork)auto 404
enhancementgood first issue

Metriche repository

Star
 (6 stelle)
Metriche merge PR
 (Metriche PR in attesa)

Descrizione

CrateDB does not support storage for timetz, all times have to be stored either in a timestamp or timestamptz.

TimeField only takes the time part of a timestamp, CrateDB trips if we try to do:

TimeField(datetime.datetime.now().time().isoformat())
# SQLParseException[Cannot cast value `22:43:10.001021` to type `timestamp without time zone`]

Because CrateDB needs the full timestmap.

But if we pass a timestamp, the validator of the field trips with: django.core.exceptions.ValidationError: ['“2020-01-01T22:43:10.001021” value has an invalid format. It must be in HH:MM[:ss[.uuuuuu]] format.']

To fix this we should modify the validator of cratedb.fields.TimeField

Guida contributor