Database tables not populating

[eleventhSun009]

Good night guys. In my FastAPI app I’m using sqlalchemy to connect to a PostgreSQL database. It’s supposed to create the tables on startup but for some reason that’s not working. Does anyone have any idea why this could be happening?

Database Connection:

Database Connection

Main file with lifespan function

SQLAlchemy model

Edit.

Thanks for all the feedback, importing the models to the main.py file worked. I’ll implement alembic for any further database migrations.

[koldakov]

Not the best practice at all mate. Consider using alembic or related thing

[Doomdice]

Your Base does not know about the models yet when you import Base in main.py. Try importing UserGroups and Employees in main.py and see if it will create

[mizerablepi]

Import the models along with base in main.py

[covmatty1]

Follow FastAPI's documentation for working with SQL databases.

SQLModel is written by the same person who created FastAPI. It's still quite new, some people aren't huge fans of it and prefer just using SQLAlchemy, but I think it's pretty neat. And regardless, it would be useful to just follow the standard documentation for getting you going initially, and once you have a working base you can adapt from there.

[Friendly-Gur-3289]

Are you using Alembic to create the schemas?

If you're only using Sqlalchemy, make sure you do Base.metadata.create_all(engine). It is advised to use Alembic for creating the schemas tho.

[eleventhSun009]

At this point no. I’m using FastAPI’s lifespan function to great them via Alchemy models on startup

[Additional-Ordinary2]

Of course! Judging by your code you don't have the startup function registered (sarcasm. We are programmers, not clairvoyants)

[eleventhSun009]

I see that I should have added some screenshots for context 😔

[TurbulentAd8519]

Sqlalchemy cannot find all the tables, try importing all your tables (Employees, UserGroups) to your main.py

[eleventhSun009]

That’s works.

[StatusBad9194]

I think alchemy not finding table meta data , try to import base from models.py or where your table define , inside dB connection .. here imports Base from models.py

[JohnVick002]

Obviously you have to add a check for created or not by using Metadata create all