anthonycepeda / fastapi-sqlmodel Goto Github PK

A newbie here! Why do we put the functions for accessing data into the crud file and later call it in view files, usually I get answers like "to increase security" for this kind of question, but no one is able to explain it, can you please answer that. Thank you.

I love how you structured this. Would it be possible to add an example of many to many models? I'm having a difficult time getting them to work with your structure. The issue here is if you had a many to many model with heroes (going off the example from the SQL Model docs) you'd need to make a link table in the public/hero/models.py file. But what would the HeroCreate model look like? And what additional routes would you add in the routes.py file? Thank you so much!

Hi man, I'm working with fastapi and sqlmodel to develop a rest api.
Observing your way of working I see that to create the database you have to execute the created_db.py module.
Looking at the official sqlmodel page they propose to create the database and tables using the "starup" event provided by fastapi.
(attached link https://sqlmodel.tiangolo.com/tutorial/fastapi/simple-hero-api/#create-database-and-tables-on-startup)
In this way, when executing the app with the command "uvicoirn main:app --reload" the database and tables are immediately created.
I tried to do it, but it generates an error, precisely because of the "starup" event. The shell tells me that this event (which apparently comes from starlette) needs other arguments.
I appreciate any help.

I believe the function is not called here?

 @app.on_event("startup")
    def on_starup():
        create_db_and_tables  # should be create_db_and_tables()