如何使用SQL Alchemy和SQL Alchemy Utils URLType使其只保存主机名？

pip install SQLAlchemy
pip install SQLAlchemy-Utils

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy_utils import URLType

engine = create_engine('sqlite:///database.db')
Base = declarative_base(bind=engine)

class MyModel(Base):
    __tablename__ = 'mymodel'
    id = Column(Integer, primary_key=True)
    url = Column(URLType(schemes=['http', 'https'], only_host=True))

Base.metadata.create_all()

# 创建一个新的实例
instance = MyModel(url='http://www.example.com')

# 添加到会话中
session.add(instance)
session.commit()

# 查询数据
result = session.query(MyModel).first()
print(result.url)  # 输出主机名：www.example.com