add postgres unit tests #4
Description
Hey @ramnathv, following up from pairing--I open a PR with code I was using to test tidymetrics against postgres. Let me know if there are any adjustments that would be useful!
Right now it's running well against a local db (spun up using the included docker-compose.yml file), but would need a couple tweaks to get up on travis.
I set it up to work with a subset of flights data, and copied one of the existing tests to work against postgres.
Couple things to note
- I set the port to be 5433 locally (since my system wide postgres uses the default), and the default 5432 on Travis.
- I think there is a slight issue with the calculation of calendar dates (copied from datacamp's data-pipeline-views), causing the test to fail...
The datacamp code sets the date here to "2012-12-31", but the test expects "2013-01-01".
