OceanBase mysql tenant use pymysql to connect to OceanBase database.
But the DDL of OceanBase is slightly different from MySQL, and user will get some warnings when reflecting metadata from OceanBase.
Alembic thus cannot work with OceanBase directly.
This package is a workaround to make Alembic work with OceanBase.
pip install sqlalchemy-oceanbase
from sqlalchemy import create_engine
engin = create_engine('msyql+oceanbase://user:password@host:port/dbname')
from sqlalchemy.ext.asyncio import create_async_engine
engin = create_async_engine('msyql+oceanbase://user:password@host:port/dbname')