18F / imls-pi-stack

Other
7 stars 0 forks source link

migrate to bigint for start/end #72

Closed cantsin closed 2 years ago

cantsin commented 2 years ago

Adds docker-compose directus migrations.

And introduces our very first migration (other than the initial schema setup). Yay! The main motivation for this change is to allow Directus (via it's standard start._gte and end.lt API filters) properly filter for start/end values. (If we have a text field, comparison operators via the API are not valid -- doing so will either return all or no values.)

This is one of the primary changes I had to make to get data visualization work. I know we switch back between datetimes/epochs and we still haven't 100% nailed down all timezone issues but ...