# unboil-sqlalchemy-types
## Installation
```bash
pip install unboil-sqlalchemy-types
```
## Usage Example
```python
from pydantic import BaseModel
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column
from unboil_sqlalchemy_types import PydanticJSON
class Base(DeclarativeBase):
pass
class Profile(BaseModel):
age: int
bio: str
Meta = str | int | dict
class User(Base):
__tablename__ = 'users'
id: Mapped[int] = mapped_column(primary_key=True)
profile: Mapped[Profile] = mapped_column(PydanticJSON(Profile))
meta: Mapped[Meta] = mapped_column(PydanticJSON(Meta))
```
Raw data
{
"_id": null,
"home_page": null,
"name": "unboil-sqlalchemy-types",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.9",
"maintainer_email": null,
"keywords": "pydantic, sqlalchemy, types, unboil",
"author": "eyueldk",
"author_email": null,
"download_url": "https://files.pythonhosted.org/packages/3c/1b/2103cfc1689b661db3645572527b273a022d5d22407aee4ee46723ce3bfb/unboil_sqlalchemy_types-0.1.6.tar.gz",
"platform": null,
"description": "\n# unboil-sqlalchemy-types\n\n\n## Installation\n```bash\npip install unboil-sqlalchemy-types\n```\n\n## Usage Example\n```python\nfrom pydantic import BaseModel\nfrom sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column\nfrom unboil_sqlalchemy_types import PydanticJSON\n\n\nclass Base(DeclarativeBase):\n pass\n\nclass Profile(BaseModel):\n age: int\n bio: str\n\nMeta = str | int | dict\n\nclass User(Base):\n __tablename__ = 'users'\n id: Mapped[int] = mapped_column(primary_key=True)\n profile: Mapped[Profile] = mapped_column(PydanticJSON(Profile))\n meta: Mapped[Meta] = mapped_column(PydanticJSON(Meta))\n```",
"bugtrack_url": null,
"license": "MIT",
"summary": "A library to expand SQLAlchemy types.",
"version": "0.1.6",
"project_urls": {
"homepage": "https://github.com/eyueldk/unboil-sqlalchemy-types",
"repository": "https://github.com/eyueldk/unboil-sqlalchemy-types"
},
"split_keywords": [
"pydantic",
" sqlalchemy",
" types",
" unboil"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "401f24886cba4751db7d70aeabe8988e3d07a9df4ea55227594e78d0bdeb34bd",
"md5": "379e83274bd21993e7261dafc66ec328",
"sha256": "5b1ca87bcfe43d6d8d940bb8005e3db4751a87343b67745a89f9857308f8a8ac"
},
"downloads": -1,
"filename": "unboil_sqlalchemy_types-0.1.6-py3-none-any.whl",
"has_sig": false,
"md5_digest": "379e83274bd21993e7261dafc66ec328",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9",
"size": 3124,
"upload_time": "2025-08-16T08:55:43",
"upload_time_iso_8601": "2025-08-16T08:55:43.794259Z",
"url": "https://files.pythonhosted.org/packages/40/1f/24886cba4751db7d70aeabe8988e3d07a9df4ea55227594e78d0bdeb34bd/unboil_sqlalchemy_types-0.1.6-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "3c1b2103cfc1689b661db3645572527b273a022d5d22407aee4ee46723ce3bfb",
"md5": "00dce22c2a3e4af208eb68eb912c77b5",
"sha256": "d510112b2b817e3c56c2548d1fad2dd8856086874641921abf8a04498246b749"
},
"downloads": -1,
"filename": "unboil_sqlalchemy_types-0.1.6.tar.gz",
"has_sig": false,
"md5_digest": "00dce22c2a3e4af208eb68eb912c77b5",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9",
"size": 36830,
"upload_time": "2025-08-16T08:55:44",
"upload_time_iso_8601": "2025-08-16T08:55:44.504042Z",
"url": "https://files.pythonhosted.org/packages/3c/1b/2103cfc1689b661db3645572527b273a022d5d22407aee4ee46723ce3bfb/unboil_sqlalchemy_types-0.1.6.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-08-16 08:55:44",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "eyueldk",
"github_project": "unboil-sqlalchemy-types",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "unboil-sqlalchemy-types"
}
JSON
