test_update.py

import asyncio
from app.schemas import CategoryUpdate
from app.repositories.categories_repo import CategoryRepository
from app.database import get_db

async def main():
    repo = CategoryRepository()
    # Try updating color_code for category 1
    db = get_db()
    cat = repo.get_by_id(1)
    print("Before:", cat)
    updated = repo.update(1, {"color_code": "#FFB3BA"})
    print("Updated:", updated)
    cat_after = repo.get_by_id(1)
    print("After:", cat_after)

if __name__ == "__main__":
    asyncio.run(main())