LAMP Reports

Host: https://visual.lamp.digital

A lightweight Flask app that lets users, analysts, and admins run site‑specific Python report scripts and download the results as PDF or HTML.
Generated files live in outputs/, while the source scripts stay in reports/<site>/.

Authentication: Uses AWS DynamoDB for user management with support for IAM roles on ECS.

Project structure

text . ├── app.py # Flask logic, auth, endpoints, CLI helpers ├── user_repository.py # DynamoDB user management ├── dynamo_config.py # DynamoDB configuration ├── pyproject.toml # Project dependencies ├── uv.lock # Locked dependency versions ├── templates/ # Jinja2 HTML (Bootstrap 5 UI) │ ├── base.html │ ├── index.html │ └── login.html ├── static/ # CSS / JS │ └── style.css ├── reports/ # 1 folder per site, 1 + *.py per report │ ├── bidmc/ │ │ ├── demographics.py │ │ └── adherence.py │ └── butler/ │ └── overview.py └── outputs/ # auto‑created; finished PDFs/HTML + progress *.json

Quick‑start (local dev)

```bash

clone & install uv

git clone https://github.com/your‑org/LAMP-cortex-cnl.git cd LAMP-data-reports curl -LsSf https://astral.sh/uv/install.sh | sh

install dependencies

uv sync

configure AWS credentials (see LOCALTESTINGGUIDE.md for details)

export AWSACCESSKEYID=yourkey export AWSSECRETACCESSKEY=yoursecret export AWSREGION=us-east-1 export DYNAMODBTABLE_NAME=dev-data-reports-users

create the first admin account

uv run flask create-admin # prompts for username + password

run the dev server

uv run python app.py # http://localhost:5000 ```

User management commands

| Action | Command | | ------ | ------- | | List accounts | uv run flask users list | | Add user John to bidmc | uv run flask users add John --role user --site bidmc | | Add analyst | uv run flask users add <name> --role analyst --site <site> | | Add admin | uv run flask users add <name> --role admin | | Reset password | uv run flask users passwd <username> | | Delete account | uv run flask users delete <username> |

Adding a new report script

bash mkdir -p reports/<site> cp template_report.py reports/<site>/my_new_report.py

Each script must accept the CLI flags specified in app.py.
Flask’s auto‑reload makes the new report appear instantly in the dropdown for users allowed to see that site.

Debugging cheatsheet

| Issue | Checklist | | ----- | --------- | | “Report not found” | 1 ) File exists in outputs/?
2 ) Filename contains the task‑ID? | | Progress stuck at 0 % | Open <task>_progress.json in outputs/ for the error message. | | Script crashes | Run it manually: python reports/<site>/<file>.py --help | | DB quirks | Open database.db with DB Browser for SQLite or TablePlus. |

Set FLASK_DEBUG=1 for verbose tracebacks.

Happy reporting!
© 2025 BIDMC Division of Digital Psychiatry