v2 URL cannot be casted to DB

[gaborbernat]

sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) can't adapt type 'pydantic_core._pydantic_core.Url'

This used to work in v1, translating to str automatically.

Selected Assignee: @adriangb

[adriangb]

I’m guessing it’s because it’s not a subclass of str. I don’t use SQLAlchemy but isn’t there a way to register conversions? Calling str() on it should suffice.

[adriangb]

I think you'll have to do something like:

from psycopg2.extensions import register_adapter, AsIs
from pydantic_core import Url

def adapt_pydantic_url(url):
    return AsIs(str(url))

register_adapter(Url, adapt_pydantic_url)

[davidhewitt]

Related notes from the migration guide:

https://docs.pydantic.dev/latest/migration/#url-and-dsn-types-in-pydanticnetworks-no-longer-inherit-from-str