sqlmodel+fastapi+uvicorn: 3 of 4 startoptions resulting in "sqlalchemy.exc.InvalidRequestError: Table 'team' is already defined for this MetaData instance."

[peddyspg]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

#!env python3

## Starting with one of these methods:
##  a) ./bla.py
##  b) python3 bla.py
##  c) uvicorn "bla:app" --reload --host localhost --port 8000
##  d) Run or Debugger in vscode


import uvicorn
from fastapi import FastAPI
from fastapi import Cookie, Header, Form, status,  Path, Query, Body, Response
from sqlmodel import Field, Relationship,  SQLModel

class TeamBase(SQLModel):
    name: str = Field(index=True)
    headquarters: str

## c) is running
## a, b and d are crashing with:
##      sqlalchemy.exc.InvalidRequestError: Table 'team' is already defined for this MetaData instance. \
##      Specify 'extend_existing=True' to redefine options and columns on an existing Table object.
class Team(TeamBase, table=True):
    id: int | None = Field(default=None, primary_key=True)



app = FastAPI()
@app.get("/")
def root():
    return {"hello worldd": 42}


if __name__ == "__main__":
    uvicorn.run("bla:app", host="0.0.0.0", port=8000, reload=True)

Description

Only startoption c) (uvicron from shell) do not produce the errror.

I used an example from SQL-Model online-documentation

Operating System

Linux, macOS

Operating System Details

No response

SQLModel Version

0.0.18

Python Version

Python 3.12.3

Additional Context

Working with vscode and internal debugger. The same problem.

[peddyspg]

Sorry, I'm a new in programming python and nearly zero python skills.
Maybe someone with more more skills are to see whats going, when using the additional logger:

Code:

import logging
import sys

# Create a custom logger
logger = logging.getLogger(__name__)
logger.setLevel(logging.DEBUG)  # Set the default log level

# Create handlers
stdout_handler = logging.StreamHandler(sys.stdout)
stderr_handler = logging.StreamHandler(sys.stderr)

# Set levels for handlers
stdout_handler.setLevel(logging.DEBUG)
stderr_handler.setLevel(logging.ERROR)

# Create formatters and add them to the handlers
formatter = logging.Formatter('%(asctime)s - %(name)s - %(levelname)s - %(message)s')
stdout_handler.setFormatter(formatter)
stderr_handler.setFormatter(formatter)

# Add handlers to the logger
logger.addHandler(stdout_handler)
logger.addHandler(stderr_handler)

# Example usage
logger.debug('This is a debug message')
logger.info('This is an info message')
logger.warning('This is a warning message')
logger.error('This is an error message')
logger.critical('This is a critical message')

Log ./bla.py

─> ./bla.py
2024-05-29 15:49:13,216 - __main__ - DEBUG - This is a debug message
2024-05-29 15:49:13,216 - __main__ - INFO - This is an info message
2024-05-29 15:49:13,216 - __main__ - WARNING - This is a warning message
2024-05-29 15:49:13,216 - __main__ - ERROR - This is an error message
2024-05-29 15:49:13,216 - __main__ - ERROR - This is an error message
2024-05-29 15:49:13,216 - __main__ - CRITICAL - This is a critical message
2024-05-29 15:49:13,216 - __main__ - CRITICAL - This is a critical message
INFO:     Will watch for changes in these directories: ['/Users/petersa/git/in/boilerplate-python-k8s/src']
INFO:     Uvicorn running on http://0.0.0.0:8000 (Press CTRL+C to quit)
INFO:     Started reloader process [72617] using WatchFiles
2024-05-29 15:49:13,720 - __mp_main__ - DEBUG - This is a debug message
2024-05-29 15:49:13,720 - __mp_main__ - INFO - This is an info message
2024-05-29 15:49:13,720 - __mp_main__ - WARNING - This is a warning message
2024-05-29 15:49:13,720 - __mp_main__ - ERROR - This is an error message
2024-05-29 15:49:13,720 - __mp_main__ - ERROR - This is an error message
2024-05-29 15:49:13,720 - __mp_main__ - CRITICAL - This is a critical message
2024-05-29 15:49:13,720 - __mp_main__ - CRITICAL - This is a critical message
2024-05-29 15:49:13,756 - bla - DEBUG - This is a debug message
2024-05-29 15:49:13,756 - bla - INFO - This is an info message
2024-05-29 15:49:13,756 - bla - WARNING - This is a warning message
2024-05-29 15:49:13,756 - bla - ERROR - This is an error message
2024-05-29 15:49:13,756 - bla - ERROR - This is an error message
2024-05-29 15:49:13,756 - bla - CRITICAL - This is a critical message
2024-05-29 15:49:13,756 - bla - CRITICAL - This is a critical message
INFO:     Started server process [72621]
INFO:     Waiting for application startup.
INFO:     Application startup complete.

Log: uvicorn "bla:app" --reload --host localhost --port 8000

╰─> uvicorn "bla:app" --reload --host localhost --port 8000
INFO:     Will watch for changes in these directories: ['/Users/petersa/git/in/boilerplate-python-k8s/src']
INFO:     Uvicorn running on http://localhost:8000 (Press CTRL+C to quit)
INFO:     Started reloader process [72924] using WatchFiles
2024-05-29 15:50:32,477 - bla - DEBUG - This is a debug message
2024-05-29 15:50:32,477 - bla - INFO - This is an info message
2024-05-29 15:50:32,477 - bla - WARNING - This is a warning message
2024-05-29 15:50:32,477 - bla - ERROR - This is an error message
2024-05-29 15:50:32,477 - bla - ERROR - This is an error message
2024-05-29 15:50:32,477 - bla - CRITICAL - This is a critical message
2024-05-29 15:50:32,477 - bla - CRITICAL - This is a critical message
INFO:     Started server process [72926]
INFO:     Waiting for application startup.
INFO:     Application startup complete.