Andrew Svetlov asvetlov

CPython Core Developer, aiohttp maintainer

imankulov / sqlalchemy_with_pydantic.py

Last active October 22, 2024 07:35

Using pydantic models as SQLAlchemy JSON fields (convert beween JSON and pydantic.BaseModel subclasses)

	#!/usr/bin/env ipython -i
	import datetime
	import json
	from typing import Optional

	import sqlalchemy as sa
	from sqlalchemy.orm import declarative_base, sessionmaker
	from sqlalchemy.dialects.postgresql import JSONB

	from pydantic import BaseModel, Field, parse_obj_as