sqlalchemy.exc.CompileError: Can't generate DDL for NullType(); did you forget to specify a type on this Column? #1520
Answered by YuriiMotov
Matthieu-Tinycoaching asked this question in Questions
-
First Check
Commit to Help
Example Codefrom datetime import datetime from typing import Optional, List, Tuple, Dict, Union from typing_extensions import TypedDict from sqlmodel import Field, SQLModel, create_engine from sqlalchemy_utils.functions import database_exists, create_database class InnerSemanticSearchDict(TypedDict): acquis_code: str code: str level: int title: str similarity_score: float class SemanticSearchDict(TypedDict): rank: int value: InnerSemanticSearchDict 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 semantic_search_result: List[SemanticSearchDict] ## sqlite sqlite_file_name = "database.db" sqlite_url = f"sqlite:///{sqlite_file_name}" if not database_exists('postgresql://postgres:postgres@localhost:5432/embeddings_sts_tf'): create_database('postgresql://postgres:postgres@localhost:5432/embeddings_sts_tf') engine = create_engine('postgresql://postgres:postgres@localhost:5432/embeddings_sts_tf', echo=True) SQLModel.metadata.create_all(engine)DescriptionI would like to create a But I got the following error code: Operating SystemLinux Operating System DetailsUbuntu 18.04 LTS SQLModel Version0.0.4 Python Version3.8.8 Additional ContextNo response |
Beta Was this translation helpful? Give feedback.
Answered by YuriiMotov Aug 14, 2025
Replies: 2 comments
-
| Same error with custom types: #42 |
Beta Was this translation helpful? Give feedback.
0 replies
-
| You need to specify column type for SQLAlchemy: semantic_search_result: List[SemanticSearchDict] = Field(sa_type=ARRAY(JSON))Runnable code example in the details: from typing import List, Optional from sqlalchemy_utils.functions import create_database, database_exists from sqlmodel import ARRAY, JSON, Field, Session, SQLModel, create_engine from typing_extensions import TypedDict class InnerSemanticSearchDict(TypedDict): acquis_code: str ... class SemanticSearchDict(TypedDict): rank: int value: InnerSemanticSearchDict class SemanticSearch(SQLModel, table=True): id: Optional[int] = Field(default=None, primary_key=True) ... semantic_search_result: List[SemanticSearchDict] = Field(sa_type=ARRAY(JSON)) db_url = "postgresql://postgres:mysecretpassword@localhost:5432/embeddings_sts_tf" def main(): if not database_exists(db_url): create_database(db_url) engine = create_engine(db_url, echo=True) SQLModel.metadata.drop_all(engine) SQLModel.metadata.create_all(engine) with Session(engine) as session: ss = SemanticSearch( semantic_search_result=[ SemanticSearchDict( rank=2, value=InnerSemanticSearchDict(acquis_code="asd") ), SemanticSearchDict( rank=1, value=InnerSemanticSearchDict(acquis_code="qwerty") ), ] ) session.add(ss) session.commit() with Session(engine) as session: ss_db = session.get(SemanticSearch, 1) assert ss_db.semantic_search_result[0]["rank"] == 2 assert ss_db.semantic_search_result[0]["value"]["acquis_code"] == "asd" assert ss_db.semantic_search_result[1]["rank"] == 1 assert ss_db.semantic_search_result[1]["value"]["acquis_code"] == "qwerty" if __name__ == "__main__": main() |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by YuriiMotov
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You need to specify column type for SQLAlchemy:
Runnable code example in the details: