clickhouse-sqlalchemy
clickhouse-sqlalchemy copied to clipboard
xzkostyan
ClickHouse dialect for SQLAlchemy
**Describe the bug** With flask-sqlalchemy, ORM class showed as below, inherit db.Model where db come from SQLAlchemy(app) ```python from flask import Flask from flask_sqlalchemy import SQLAlchemy app = Flask(__name__) app.config["SQLALCHEMY_DATABASE_URI"]...
- fixes #252 Checklist: - [x] Add tests that demonstrate the correct behavior of the change. Tests should fail without the change. - [x] Add or update relevant docs, in...
**Describe the bug** Support for Geo Data Types are missing. https://clickhouse.com/docs/en/sql-reference/data-types/geo
**Describe the bug** SAMPLE method is not working select().sample(1) -> SELECT .id FROM SAMPLE, but now it looks like SELECT .id FROM **To Reproduce** from sqlalchemy import Column from sqlalchemy.orm...
Hello, Thanks a lot for this great project. I'm using it on a daily basis and works very well. I was wondering if it could be interesting to add a...
developers should know that they can change clickhouse setting in http driver mode by setting `ch_settings`. ```python from sqlalchemy import create_engine engine = create_engine( 'clickhouse+http://localhost/test', connect_args={"ch_settings": {'max_execution_time': 10}} ) ```
**Describe the bug** When creating for ex 2 alembic branches they are written into alembic_version as 2 lines. but order_by=func.tuple( in ReplacingMergeTree doesn't switch off sorting. After some time or...
When using `.dictinct(Model.field)` in a query, there is a deprecation warning: > SADeprecationWarning: DISTINCT ON is currently supported only by the PostgreSQL dialect. Use of DISTINCT ON for other backends...
**Describe the bug** I'm using `.final()` but there are no changes in query. Code: ``` query = AccountActualStatesGQ.get_query(info) # SQLAlchemy query query = apply_requested_fields(info, query, AccountActualStates) qs = query.filter_by(**kwargs) qs...