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:

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()