Coding
PromptBeginner5 minmarkdown
Markdown Converter
Agent skill for markdown-converter
22
Short, actionable guidance for AI coding agents working on the housegur-api FastAPI project.
Sign in to like and favorite skills
Short, actionable guidance for AI coding agents working on the housegur-api FastAPI project.
Keep instructions concise and focused on discoverable repository patterns. Refer to the files named below when you need concrete examples.
app/main.py).app/routers/ and are included in app/main.py with prefixes: /auth, /properties, /transactions.app/database.py but code uses raw SQL and stored procedures (no ORM models).app/crud.py contains DB calls (uses sqlalchemy.text) and calls stored procedures (e.g., sp_comprar_tokens, sp_vender_tokens) in the housegur schema.app/schemas.py and used as response_model in routers.SessionLocal() from app/database.py for DB access and always close the session in a finally block. See app/crud.py and app/routers/properties.py.text(...) and stored-procedure calls for write operations (this project relies on DB side logic). Example: app/crud.comprar_tokens calls CALL housegur.sp_comprar_tokens(...).app/routers/*) are thin and delegate to app/crud.py. When adding features, add the API signature in app/schemas.py, implement DB logic in app/crud.py, then wire a new router and include it in app/main.py.app/crud.py that must match the Pydantic response model field names (note Spanish names like propiedad_id, usuario_id, nombre).app/database.py reads DATABASE_URL via python-dotenv. Ensure .env has DATABASE_URL for local runs.app/schemas.py.app/crud.py using SessionLocal() and sqlalchemy.text (or call an existing stored proc).app/routers/ with appropriate prefix and response_model and delegate to app.crud.app/main.py with a clear prefix and tags entry.app/main.py — how routers are included.app/routers/auth.py — simple POST login wiring to crud.login_user.app/crud.py — examples of INSERT, SELECT and stored-proc usage.app/database.py — engine/session setup and .env usage.app/schemas.py — Pydantic request/response shapes.If any section is unclear or you want deeper details (examples of stored-proc inputs, a recommended local DB fixture, or automated tests), tell me which area and I'll expand the guidance.