-
First Check
Commit to Help
Example Codefrom typing import Optional
from sqlmodel import Field, SQLModel, Column, JSON
class EmployeeMasterBase(SQLModel):
additional_info: Optional[dict] = Field(sa_column=Column(JSON))Descriptioni was creating a Sqlmodel to conncect with postgres. \site-packages\fastapi\_compat.py", line 370, in get_model_definitions
m_schema, m_definitions, m_nested_models = model_process_schema(
File "pydantic\schema.py", line 582, in pydantic.schema.model_process_schema
File "pydantic\schema.py", line 623, in pydantic.schema.model_type_schema
File "pydantic\schema.py", line 249, in pydantic.schema.field_schema
File "pydantic\schema.py", line 217, in pydantic.schema.get_field_info_schema
File "pydantic\schema.py", line 996, in pydantic.schema.encode_default
File "pydantic\json.py", line 90, in pydantic.json.pydantic_encoder
TypeError: Object of type 'Column' is not JSON serializable
### Operating System
Windows
### Operating System Details
Windows 10, 64 bit
### SQLModel Version
sqlmodel = "^0.0.8"
### Python Version
Python 3.10.7
### Additional Context
_No response_ |
Beta Was this translation helpful? Give feedback.
Replies: 6 comments 1 reply
-
|
How we approach when using json type in sqlmodel |
Beta Was this translation helpful? Give feedback.
-
|
iam upgraded to sqlmodel version 0.0.11, still the issue exist. additional_info: Optional[dict] = Field(default={}, sa_column=Column(JSON))additional_info: Optional[dict] = Field(default_factory=dict, sa_column=Column(JSON))
i have used both above ways, no change |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
|
iam closing it , i have to check on it again. |
Beta Was this translation helpful? Give feedback.
-
|
Iam posting this to avoid the same mistake by other created_on: datetime =Column(
DateTime(timezone=True),
server_default=func.now()
)
updated_on: datetime = Column(
DateTime(timezone=True),
server_default=func.now(),
server_onupdate=func.now()
)corrected code is as follows created_on: datetime = Field(sa_column=Column(
DateTime(timezone=True),
server_default=func.now()
))
updated_on: datetime = Field(sa_column=Column(
DateTime(timezone=True),
server_default=func.now(),
server_onupdate=func.now()
)) |
Beta Was this translation helpful? Give feedback.
-
|
use this instead "Here's how to define a JSON field in SQLModel: Define the field with sa_column: In your SQLModel class, define the field that will store JSON data and specify its SQLAlchemy column type using sa_column=Column(JSON). |
Beta Was this translation helpful? Give feedback.
-
|
Hi everyone I suggest to have a global variable like I have done this by monkey patching import sqlmodel.main
from typing import Union, Annotated
from pydantic import JsonValue as PydanticJsonValue
from pydantic.types import Json as PydanticJson
from sqlalchemy.types import JSON as SQLAlchemyJSON
# I use pascal case for constants
TypeAnnotationMap = {
PydanticJson: SQLAlchemyJSON,
PydanticJsonValue: SQLAlchemyJSON
}
_gst = sqlmodel.main.get_sqlalchemy_type
def get_sqlalchemy_type(field: Any) -> Any:
try:
return _gst(field)
except Exception as exc:
type_ = None
if hasattr(field, 'type_'):
type_ = field.type_
elif field.annotation:
type_ = field.annotation
if (
get_origen(type_) is Union
and len(type_.__args__) == 2
and type(None) in type_.__args__
):
type_ = next(arg for arg in type_.__args__ if arg is not None)
if get_origen(type_) is Annotated:
type_ = type(type_.__metadata__[0])
if type_ in TypeAnnotationMap.keys():
return TypeAnnotationMap[type_]
raise exc
sqlmodel.main.get_sqlalchemy_type = get_sqlalchemy_type |
Beta Was this translation helpful? Give feedback.
Iam posting this to avoid the same mistake by other
The issue was in another line of code, where i missed the Field
corrected code is as follows