How to support StarRocks in Alembic

[jaogoy]

I've tested Alembic with StarRocks by using MySQL protocol.
Of course there are a lot of syntax that Alembic doesn't support. And I know, if I want Alembic to support StarRocks, I need to implement StarRocksDialect in SQLAlchemy and some important functions, such as autogenerate, in Alembic.
But, I know a little about how to support a dialect for Alembic. Does there any good docs for me to understand Alembic well to support StarRocks?

And I've read the discussion, but it seems that Alembic still doesn't support StarRocks, there is still only one column in table alembic_version.

[CaselIT]

Hi,

There seems to be an official dialect for starrocks https://pypi.org/project/starrocks

I'm not sure what level of alembic support it has, but I would expect to start from there and look into it. Maybe asking on their discussion board is also an option

[jaogoy]

O, great, I'll take a look.
Thank you so much.

[jaogoy]

@CaselIT I'm not familar with SQLAlchemy and alembic. Although I can create a starrocks table with SQLAlchemy-starrocks, I don't know how to use it in Alembic, even I've import the starrocks module in env.py. I don't know how to register the starrocks module into Alembic. And the error I encounter is:

  File ".../alembic/alembic/ddl/impl.py", line 134, in get_by_dialect
    return _impls[dialect.name]
KeyError: 'starrocks'

Thank you very much.