clickhouse-sqlalchemy
clickhouse-sqlalchemy copied to clipboard
xzkostyan
ClickHouse dialect for SQLAlchemy
**Describe the bug** No support for sessions in http protocol. Current url that contains session_id cuts get param to kwargs and does not use it. This leads to problems with...
- fixes # Checklist: - [ ] Add tests that demonstrate the correct behavior of the change. Tests should fail without the change. - [ ] Add or update relevant...
Trying to connect to clickhouse using `https://:8443` It is not clear to me from the docs where I would pass the [driver options](https://clickhouse-sqlalchemy.readthedocs.io/en/latest/connection.html#driver-options), such as `protocol='https'`.
Usually, create a ORM class as below: ```python from sqlalchemy import Column from clickhouse_sqlalchemy.ext.declarative import declarative_base ChBase = declarative_base() class TbFile(ChBase): __tablename__ = 'tb_file' __table_args__ = {'comment': 'File Info Table...
- fixes #219 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** When specifying clickhouse_after keyword argument in a Column it should not affect table creation since `AFTER` statements are not allowed in `CREATE TABLE` statements. It might seem...
**Describe the bug** Hi! I know that you can specify `{'clickhouse_cluster': '{cluster}'}` in the `__table_args__` of a model in order to add the `ON CLUSTER '{cluster}'` clause to the CREATE...
**Describe the bug** Using a (standard) batch insertion with `sqlalchemy`, i.e. a list of dictionaries with each dict corresponding to a new row, results in an error. **To Reproduce** ```python...
**Describe the bug** clickhouse-sqlalchemy support 2 kinds of uri uri = 'clickhouse+native://localhost/default' with native tcp port(9000) uri = 'clickhouse://localhost/default' with http port(8123) with http mode, for example, I have a...