Update Heroku stack

[danrademacher]

I was looking at Heroku for ECG and noticed this alert for our ETL scripts for Crashmapper:

Past updates have been quick -- reading some docs to see how to do it, running the commands, seeing that nothing is broken, and then pushing the update. More full featurede apps might be harder, but fingers crossed these scripts will be smooth

┆Issue is synchronized with this Asana task

[gregallensworth]

Need to update the script to work with a later Python.

• The heroku-20 and heroku-22 stacks change the default Python from 2 to 3, but we explicitly have been using python-3.8.2 via runtime.txt

• But Python 3.8.x is trailing-edge, available on heroku-20 and not on heroku-22. The heroku-22 includes 3.9, 3.10, and and 3.11 being the newest, is also the recommended.

• [x] set up Python 3.11 on my PC

• [x] test the main ETL scripts on Python 3.11

  • we keep things pretty basic, but Python moves very quickly these days and each release causes some new surprises
  • [x] main.py
  • [ ] ~walkmapper/mysql2carto.py~ I don't think this has worked in some time, was a prototype

• [x] change runtime.txt to python-3.11.2

• [x] change the stack via the Dashboard

• [x] deploy, confirm upgrade in Heroku dashbboard

• [x] tomorrow morning, check heroku logs -a nyc-crash-mapper-etl and see how the run went. it runs at 12 noon UTC, so about 4am our time

[gregallensworth]

Nice. Last night's heroku-22 and Python 3.11 run worked just fine. 👍