flask integration

[fgbs]

Can you provide an example of how integrate with flask-sqlalchemy?

Best regards.

[xzkostyan]

Hi!

Currently there is no integration with flask-sqlalchemy. You can create engine, metadata and pure SQLAlchemy session in following way: https://github.com/xzkostyan/clickhouse-sqlalchemy#sqlalchemy-declarative-support

What kind of integration do you need? Flask thread-local session, config variables, etc? Just want to know.

Two main problems are in custom Table class and get_declarative_base function that uses the same table class. There are some another customizations too.

It's possible to make flask-wrapper for this package, but direct integration with flask-sqlalchemy is hard and maybe monkeypatching way.

[zenglanmu]

from flask_sqlalchemy import SQLAlchemy
from clickhouse_sqlalchemy.orm.query import Query as ChBaseQuery
ch_db = SQLAlchemy(query_class=ChBaseQuery)

found the SQLAlchemy support to pass custom query_class, so above codes just work for me.