I have the following models/schemas: class UserBase(SQLModel): full_name: str email: EmailStr is_active: bool = True is_superuser: bool = False class UserRead(UserBase): id: uuid.UUID clas...

I'm trying to find a way to get SqlModel and Alembic play nice together. My goal is to not have to hand-edit the auto-generated alembic migrations. Here's my model class: class SongBase(SQLModel): ...

I'm trying to define a JSON column via SQLModel: from typing import Optional from sqlmodel import Field, Session, SQLModel, create_engine, JSON class Hero(SQLModel, table=True): id: Optional[int...

I am trying to get the number of rows matched in a one to many relationship. When I try parent.children_count I get : sqlalchemy.exc.MissingGreenlet: greenlet_spawn has not been called; can't call...

I searched for this error a lot, but I only find some with more information behind that like "FATAL: ...". Mine has none. It only says sqlalchemy.exc.OperationalError: (psycopg2.Operation...

In my Python FastAPI app, I need Pydantic version 2 to solve an issue with Unions that is fixed in version 2 only. Since FastAPI version 0.100.0 and onward supports Pydantic v2, I was first hopeful...

When working with modular imports with FastAPI and SQLModel, I am getting the following error if I open /docs: TypeError: issubclass() arg 1 must be a class Python 3.10.6 pydantic 1.10.2 fastapi...

I was trying to use fastapi users package to quickly Add a registration and authentication system to my FastAPI project which uses the PostgreSQL database. I am using asyncio to be able to create a...

class Hero(SQLModel, table=True): id: int = Field(primary_key=True) name: str age: int = Field(default=None) status:str I created the table using SQLModel.metadata.create_all(engine), when I c...

I'm experimenting with SQLModel (https://sqlmodel.tiangolo.com/) and I get to the point that I had to create a composite index between several fields and I can't how to do it using SQLModel library...

With SQLAlchemy it is possible to create a constraint on two or more columns using the UniqueConstraint declaration. What would be the most idiomatic way of doing that using SQLModel? For example: ...

I want to define a model that has a self-referential (or recursive) foreign key using SQLModel. (This relationship pattern is also sometimes referred to as an adjacency list.) The pure SQLAlchemy i...

Does anyone know if its possible to get a INSERT OR IGNORE function with SQLModel? And if not, does anyone know if there is a workaround to get the same results? I haven't tried anything to get the...

Using SQLModel how to get alembic to recognise the below model? from sqlmodel import Field, SQLModel class Hero(SQLModel, table=True): id: int = Field(default=None, primary_key=True) name: str ...

After working through the tutorial of SQLModel, I don't remember seeing anything on how to implement 1:1 relationships using Relationship attributes. I found documentation for SQLAlchemy, but it's ...

I'm using FastAPI & SQLModel to insert data into SQLite database (I'm posting a few fields, then SQLModel adds UUID and datetime fields and inserts into db). While posting data to FastAPI, I oc...

I'm struggling to get the syntax to create a UUID field when creating a model in my FastAPI application. I'm using SQLModel. So basically, my models.py file looks like this: from datetime import da...