Support/example for creating views

[yuvalshi0]

Hi!
Thanks for the awesome orm support, wanted to ask if this library supports creating of a simple views?

I haven't found any examples/references in the code?

[xzkostyan]

Hi.

There is example is sample project (see docs):

• creating: https://github.com/xzkostyan/clickhouse-sqlalchemy-alembic-example/blob/main/simple/migrations/versions/7ea9419bdb87_add_mat_view.py
• altering: https://github.com/xzkostyan/clickhouse-sqlalchemy-alembic-example/blob/main/simple/migrations/versions/07efb1bef54d_add_metric2_to_mat_view.py

Please note, that database must have Ordinary engine now.

[xzkostyan]

Oh, I see.

You want to create simple views. I didn't try to use them. Sorry.