TypeError: issubclass() arg 1 must be a class when having a field with a complex type

[Matthieu-Tinycoaching]

First Check

• I added a very descriptive title to this issue.
• I used the GitHub search to find a similar issue 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

from datetime import datetime from typing import Optional, List, Tuple, Dict, Union from sqlmodel import Field, SQLModel, create_engine 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[Tuple[int, Dict[str, Union[str, int, float]]]] ## sqlite sqlite_file_name = "database.db" sqlite_url = f"sqlite:///{sqlite_file_name}" engine = create_engine(sqlite_url, echo=True) SQLModel.metadata.create_all(engine)

Description

I would like to create a semantic_search table in the database.db sqlite database with the 6 fields specified.

The last field semantic_search_result with List[Tuple[int, Dict[str, Union[str, int, float]]]] type seems to cause the error.

semantic_search_result looks like this for example:

[ (0, { "acquisCode": str, "code": str, "level": int, "title": str, "similarity_score": float}), (1, { "acquisCode": str, "code": str, "level": int, "title": str, "similarity_score": float}), (2, { "acquisCode": str, "code": str, "level": int, "title": str, "similarity_score": float}) ] 

When running the code I got the following error:

Traceback (most recent call last): File "/home/matthieu/Code/Python/fastapi-graphql/test_SQLModel.py", line 6, in <module> class SemanticSearch(SQLModel, table=True): File "/home/matthieu/anaconda3/envs/sts-transformers-gpu-fresh/lib/python3.8/site-packages/sqlmodel/main.py", line 292, in __new__ col = get_column_from_field(v) File "/home/matthieu/anaconda3/envs/sts-transformers-gpu-fresh/lib/python3.8/site-packages/sqlmodel/main.py", line 415, in get_column_from_field sa_type = get_sqlachemy_type(field) File "/home/matthieu/anaconda3/envs/sts-transformers-gpu-fresh/lib/python3.8/site-packages/sqlmodel/main.py", line 373, in get_sqlachemy_type if issubclass(field.type_, str): TypeError: issubclass() arg 1 must be a class 

I got the same error if I tried to define a subclass of the typing_extensions.TypedDict class:

class SemanticSearchDict(TypedDict): acquis_code: str code: str level: int title: str similarity_score: float 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[Tuple[int, SemanticSearchDict]] 

I couldn't find a solution but #57 seems to have the same problem since having the same error.

Operating System

Linux

Operating System Details

Ubuntu 18.04 LTS

SQLModel Version

0.0.4

Python Version

3.8.8

Additional Context

No response

[ademoverflow]

🆙

[Matthieu-Tinycoaching]

Up!

[lobotmcj]

different cause it seems, but #121 has a similar error.

[bjoernh]

same Problem

[txemac]

same problem here!

[data-djinn]

thank you to the maintainers & contributors of this awesome library!

For anyone who encounters this bug while trying to assign a Literal type, the workaround that I used was defining a separate class of Enum instances:

from enum import Enum class ValidValues: class FirstField(str, Enum): FIRST_VAL = 'First val', SECOND_VAL = 'Second val' class SecondField(str, Enum): FIRST_VAL = 'First val', SECOND_VAL = 'Second val' # etc.. class MyTable(SQLModel, table=True): first_field: ValidValues.FirstField second_field: ValidValues.SecondField some_str_field: str # etc... 

[memark]

Any update on this issue?

[SPablo2191]

same happen using UUID4 for id

[ShravanSunder]

Its because of the get_sqlachemy_type function. literals and perhaps dict isnt recognized

you can bypass this using sa_column for literal types

 kind: t.Annotated[t.Literal["resource"])] = Field( default="resource", sa_column=Column(String) ) 

i think dicts need to be typed to json

[YuriiMotov]

You need to specify the column type for SQLAlchemy (Field(sa_type=JSON) in this case):

 semantic_search_result: List[Tuple[int, Dict[str, Union[str, int, float]]]] = Field( sa_type=JSON )

Runnable code example in the details:

from typing import Dict, List, Optional, Tuple, Union from sqlmodel import JSON, Field, Session, SQLModel, create_engine class SemanticSearch(SQLModel, table=True): id: Optional[int] = Field(default=None, primary_key=True) ... semantic_search_result: List[Tuple[int, Dict[str, Union[str, int, float]]]] = Field( sa_type=JSON ) ## sqlite sqlite_url = "sqlite:///" engine = create_engine(sqlite_url, echo=True) def main(): SQLModel.metadata.create_all(engine) with Session(engine) as session: ss = SemanticSearch( semantic_search_result=[ (2, {"acquis_code": "asd"}), (1, {"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][0] == 2 assert ss_db.semantic_search_result[0][1]["acquis_code"] == "asd" assert ss_db.semantic_search_result[1][0] == 1 assert ss_db.semantic_search_result[1][1]["acquis_code"] == "qwerty" if __name__ == "__main__": main()