This post is a thought. It's a short note that I make about someone else's content online. Learn more about the process thoughts

Here's my thought on 💭 Filter Data - WHERE - SQLModel

When fetching pydantic models from the database with sqlmodel, and you cannot select your item by id, you probably need to use a where clause. This is the sqlmodel way of doing it.

Here is a snippet of how I am using sqlmodel select and where to find a post by link in my thoughts database.

async def get_post_by_link(
    session: Session = Depends(get_session),
    link: str,
) -> PostRead:
    "get one post by link"
    link = urllib.parse.unquote(link)
    print(f'link: {link}')
    post = session.exec(select(Post).where(
    if not post:
        raise HTTPException(status_code=404, detail=f"Post not found for link: {link}")

    return post

This post was a thought by Waylon Walker see all my thoughts at