Skip to content
This repository has been archived by the owner on Jan 26, 2021. It is now read-only.

Create DEV environment for Google Sheets #40

Open
lucasmbrown opened this issue Jul 22, 2020 · 0 comments
Open

Create DEV environment for Google Sheets #40

lucasmbrown opened this issue Jul 22, 2020 · 0 comments

Comments

@lucasmbrown
Copy link
Contributor

Right now, when we're testing new functionality and want to confirm the data is posted to Google Sheets and that it appears to be accurate, it's a little dangerous to test because we override all of the data in the Google Sheets used for production every time we run the main extract_transform_and_load_covid_data method.

(We do have some buffer from PROD because Ryan copies and pastes this data into other sheets that back DataWrapper and the website.)

Could we create a folder of Google Sheets that are used as a DEV or STAGING environment for testing things before they're merged to master?

For instance, a simple approach to this might be to create a dictionary of environment names mapped to a dictionary of sheet names mapped to sheet identifiers. That way when you're running in DEV/STAGING, you'll post all the data to a different set of sheet identifiers.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant