postgreSQL: SQLModel.metadata.create_all(engine) doesn't create the database file #66

Activity

1. Matthieu-Tinycoaching

   added

   questionFurther information is requestedFurther information is requested

   on Sep 1, 2021
2. rodg commented on Sep 2, 2021

   

   rodg

   on Sep 2, 2021

   More actions

   From this stack-overflow post you can't create a postgresql database via create_engine or create_all. Following the steps in that SO answer works, with the caveat of the SQLAlchemy 2.0 engine not allowing you to just execute on text (and create_engine from SQLModel has future=True by default). For 2.0 you need to use the text() construct to execute text like that. YOLO importing text from SQLModel seems to import the right thing, so you don't even need to import it from SQLAlchemy apparently but I've not seen this import documented anywhere.

   from datetime import datetime
   from typing import Optional, Dict
   from sqlmodel import Field, SQLModel, create_engine, text
   
   class SemanticSearch(SQLModel, table=True):
       id: Optional[int] = Field(default=None, primary_key=True)
       id_user: int
       date_time: datetime
       query: str
       clean_query: str
       
   engine = create_engine('postgresql://postgres:postgres@localhost:5432/postgres', echo=True)
   
   conn = engine.connect()
   conn.execute(text("commit"))
   conn.execute(text("create database your_db_name"))
   conn.close()
   conn.dispose()
   
   engine = create_engine('postgresql://postgres:postgres@localhost:5432/your_db_name', echo=True)
   
   SQLModel.metadata.create_all(engine)

   👍React with 👍2Reacted by Gabriel and synodriver
3. fastapi

   locked and limited conversation to collaborators on Aug 15, 2025
4. YuriiMotov

   converted this issue into a discussion #1523 on Aug 15, 2025