an-farmview

Python 3.11.3, FastAPI based webpage using SNMP to get temperatures, all running via poetry.

• Run client/record_temp.bat locally at an interval to record temperatures to the database
• Web page (main.py/home.html) only reads data from the database
• Web page refreshes every 30 seconds

create /an_farmview/.env file to set some environment variables, use env_template.txt as an example:

SNMP_COMMUNITY=public
SNMP_IP=ip of snmp device

Make sure poetry is using Python 3.11

$ where python
C:\Program Files\Python311\python.exe

poetry env use "C:\Program Files\Python311\python.exe"

first time install dependencies

poetry install

Client

Record temperature from SNMP

Create a scheduled task to run the client bat file an_farmview/client/record_temp.bat at a 5min interval or whatever you like.

Dev

run fastapi via uvicorn, use same port as flask did and allow other IPs

poetry run uvicorn an_farmview.main:app --reload --host 0.0.0.0 --port 5000

Uses jinja2 templates just like flask but need to install manually

runs here

http://localhost:5000/

Heroku

When you manually copy $DATABASE_URL from heroku into .env copy it verbatum, it will be converted to postgresql:// instead of postgres:// so it works local and on heroku

sqlalchemy needs psycopg2 for some reason not installed with it.

poetry add psycopg2

Alembic migrations

Just like in django but needed to set it up [https://devpress.csdn.net/python/62f5096cc6770329307fb178.html](I followed this article)

poetry add alembic

# init migrations (first time only)
poetry run alembic init migrations

# make migration(revision?)
poetry run alembic revision --autogenerate -m "added vray ubl"

# migrate
poetry run alembic upgrade head