Weekly Team Meeting 2017 03 13

Issues discussed:

• Issue #39: Support for Docker on Windows?
  • No, devops not providing that support (yet?).
• MVP has changed.
  • Card "Delta sankey diagram" is highest priority. [Data is already available from history endpoint in web service, which is not deployed publicly yet, but is working in local dev environments.]
  • Card "Service Area Budgets" is stretch goal. [Data is already available from history endpoint in web service, which is not deployed publicly yet, but is working in local dev environments.]
  • Card "Budget Map" is lowest priority. [Hack Oregon's Budget Team does not have any data to support this functionality yet.]
• Tests for Docker on Travis?
• Code/value lists for historical data.
  • For example, to support dropdown menus in the UI, such as a list of Service Areas or a list of Bureaus.
  • To be delivered from the web service, not hard-coded in the UI.
  • Designed a new db table to hold these values.
  • Data is available in Hack Oregon hx budget data ASV2.xlsx.
  • Implementation will start this week.
• Turn off Django's default 'POST' functionality in web services.
  • Fixed in Pull Request #59 by subclassing from ListAPIView.
• Simplified API.
  • Removed out-dated, alternative, redundant implementations.
  • Merged Pull Request #59.
  • Closed Issue #43.
  • Closed Issue #49.
• Historical Data.
  • Extracted data Hack Oregon hx budget data ASV2.xlsx has been transformed and loaded into PostgreSQL running in AWS EC2 instance.
  • Merged Pull Request #60, which implemented a /history endpoint.
  • Closed Issue #19.
• Case-insensitive values.
  • Fixed in Pull Request #59 by appending "__iexact" to the key name, so that query parameter values are matched case-insensitive, e.g. query parameter bureau_name=PORTLAND WATER BUREAU will match "Portland Water Bureau" as a value in the database.
• Develop against local database.
  • Discussed how to use project_config.py to specify database to be used in developer's local environment.