sqlalchemy-fields 0.3.0

SQLAlchemy fields

SQLAlchemy Fields

---

Table of Contents

• Installation
• Custom Types

Installation

pip install sqlalchemy-fields
pip install 'sqlalchemy-fields[full]'

Custom Types

• EmailType
• FileType
• ImageType
• IPAddressType
• URLType
• UUIDType

from sqlalchemy import Column, Integer, create_engine
from sqlalchemy.orm import Session, declarative_base
from sqlalchemy_fields.types import IPAddressType


Base = declarative_base()
engine = create_engine("sqlite:///example.db")


class Example(Base):
    __tablename__ = "example"

    id = Column(Integer, primary_key=True)
    ip = Column(IPAddressType)


example = Example(ip="127.0.0.1")
with Session(engine) as session:
    session.add(example)
    session.commit()
    print(example.ip)
"""
IPv4Address("127.0.0.1")
"""