sqlalchemy-fields 0.1.0

SQLAlchemy fields

SQLAlchemy Fields

---

Table of Contents

• Installation
• License

Installation

pip install sqlalchemy-fields

Extra SQLAlchemy column types

• Email
• File
• IP
• URL
• UUID

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

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

class Example(Base):
    __tablename__ = "example"

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


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