wish/FastApi

Wishing Tree — FastAPI service

Setup

Create a .env file (or set environment variables) with your database connection. Do NOT commit secrets.

Recommended (preferred): set a full SQLAlchemy DATABASE_URL environment variable with URL-encoded password.

Example (PowerShell):

$env:DATABASE_URL = "mysql+pymysql://root:%40%40qinys12346..@192.168.1.177:3306/wishing_tree?charset=utf8mb4&serverTimezone=Asia/Shanghai&use_unicode=true&characterEncoding=utf-8"

Or set components separately (Windows PowerShell):

$env:DB_USER = "root" $env:DB_PASS = "@@qinys12346.." $env:DB_HOST = "192.168.1.177" $env:DB_PORT = "3306" $env:DB_NAME = "wishing_tree"

Dependencies

Install runtime dependencies for database access:

pip install sqlalchemy pymysql

Optional: install python-dotenv to auto-load a .env file located at project root

pip install python-dotenv

Running

Start the app in development (example):

uvicorn main:app --reload --host 0.0.0.0 --port 8000

Notes

• The project reads DATABASEURL if present; otherwise it composes a URL from DB* vars.
• Passwords with special characters must be URL-encoded when used in DATABASE_URL.
• Keep .env out of version control; use the provided .env.example as a template.