clickhouse-sqlalchemy

Version bumped to 0.3.1

Version bumped to 0.3.0

Version bumped to 0.2.7

Version bumped to 0.2.6

Version bumped to 0.2.5

Added

• [Native] DateTime('timezone'). Solves issue #230.
• Async driver support via asynch. Pull request #214 by randomowo.
• ILIKE clause compilation. Pull request #229 by howbownotnow.
• MATCH clause via Column.regexp_match. Pull request #221 by TeddyCr.

Fixed

• Trigger after_drop and before_drop events while dropping table. Pull request #246 by vanchaxy. Solves issue #245.
• SAMPLE with ARRAY JOIN. Pull request #241 by dpaluch-piw. Solves issue #45.
• Alembic comparators respect non-ClickHouse engines for multi-db. Pull request #236 by Skorpyon.
• INNER/OUTER joins strictness on multiple joins.
• [Native] Handle quoted passwords. Solves issue #185.

Added

• [U]Int128/256 types. Pull request #184 by akolov. Solves issue #176.
• WITH CUBE/WITH ROLLUP modifiers for GROUP BY. Pull request #210 by reflection.
• Boolean type. Pull request #213 by AntonFriberg. Solves issue #212.

Fixed

• FULL JOIN sql generation. Pull request #144 by poofeg. Solves issue #193.
• Allow CASE without ELSE clause.
• Arrays compilation in has* functions. Solves issue #205.
• Do not render foreign key constraints. Solves issue #208.
• Inconsistency in ischema_names type converters. Pull request #216 by AntonFriberg. Solves issue #215.
• LowCardinality and Nullable alembic autogeneration. Solves issue #217.

Added

• Table and column comments creation and reflection. Solves issue #149.

Fixed

• [HTTP] Use query params to specify clickhouse data format. Pull request #180 by save-my-heart.

Changed

• Switch from nose test runner to pytest.

Fixed

• Add supports_statement_cache = True. Solves issue #169.
• Add cache_ok = True for IP types.
• Mixed text() and pure strings in engine parameters handling. Solves issue #173.
• Engine creation in alembic migrations.
• CREATE and DROP Materialized views. Solves issue #177.

With changes from 0.1.9 and 0.1.10.

Added

• LEFT ARRAY JOIN clause. Pull request #167 by Fozar.

Changed

• Supported SQLAlchemy version is 1.4.

Version bumped to 0.1.12

Version bumped to 0.1.11

Added

• Documentation on Read the Docs: https://clickhouse-sqlalchemy.readthedocs.io

Fixed

• AFTER clause rendering in ADD COLUMN.
• Broken Materialized views creation via .create().
• Engine creation in migrations for alembic 1.6+. Engine is subclass of Constraint now.

Fixed

• ReplicatedReplacingMergeTree reflection. Solves issue #164.
• Inline inserts with literal binds for alembic support.

Added

• Tuple and Map types. Pull request #163 by joelynch.
• Materialized views alembic migrations autogeneration.

Fixed

• Handle unsupported engines in table reflection.
• EXISTS and DESCRIBE table quoting.
• Default Unicode error handler to replace. Pull request #166 by cwurm.
• [Native] Inserts with literal_column values. Solves issue #133.
• Alembic nullable reflection.

Changed

• Migrate from Travis CI to GitHub Actions.

Added

• Support for distinctness comparisons (is_distinct_from / isnot_distinct_from). Pull request #144 by wlhjason. Solves issue #143.
• [HTTP] Cert auth. Pull request #128 by evgG.
• [HTTP] Session factories. Pull request #131 by carlosefr.
• [HTTP] Raw engine execute. Pull request #134 by FishermanZzhang.
• [HTTP] DateTime('timezone') support. Pull request #141 by lance-plusai.
• Optional disabling engine reflection. Solves issue #140.
• AFTER clause in ALTER TABLE ... ADD COLUMN. Pull request #153 by eivasch.
• Column default reflection from DESCRIBE TABLE default_expression. Pull request #153 by eivasch.

Fixed

• SAMPLE BY reflection. Solves issue #127.
• [HTTP] verify behavior in requests. Pull request #128 by evgG.

Added

• [HTTP] Optional custom requests.Session. Pull request #119 by carlosefr.
• DateTime64 type. Pull request #116 by aamalev.
• [HTTP] Keep HTTP connection open between queries. Pull request #117 by carlosefr.

Fixed

• [HTTP] Don't lose information on unicode conversion. Pull request #120 by carlosefr.
• [HTTP] Fix server version parsing (non-numeric build). Pull request #118 by carlosefr.
• [HTTP] Handle nullable columns. Pull request #121 by carlosefr.
• Reflection for schema and views handling. Pull request #125 by hodgesrm.
• Expressions reflection in *MergeTree engines. Solves issue #123.
• Columns compilation fix. Replace default dialect. Solves issue #124.
• [HTTP] Proper handling verify flag when parsing DSN. Pull request #126 by yhvicey.

Added

• MATERIALIZED and ALIAS column options.
• LIMIT BY clause support. Pull request #97 by ods.
• Basic engines reflection.
• TTL param for *MergeTree engines. Pull request #111 by aamalev.

Changed

• Session parametrization in tests.
• Exclude table name from DEFAULT column option.
• Allow multiple columns in PARTITION BY.
• Replace uuid1 with uuid4 for automatic query_id generation. Solves issue #99.

Fixed

• Remove table names during JOIN withUSING clause.
• [Native] Case insensitiveVALUES clause check for (%s)-templates.
• Render sqlalchemy.Boolean as UInt8 instead of BOOLEAN. Solves issue #93.
• Allow multiple columns in SummingMergeTree.
• Proper JOIN clause rendering. Solves issue #108.

Removed

• Drop Python 3.4 support due to urllib3 drop.

Fixed

• if_exists and on_cluster AttributeError on table drop. Pull request #94 by vmarkovtsev.

Added

• Engines: ReplicatedReplacingMergeTree, VersionedCollapsingMergeTree, ReplicatedVersionedCollapsingMergeTree. Solves issue #70.
• File engine. Pull request #72 by armymaksim.
• [HTTP] SSL certificates verification. Pull request #75 by NiyazNz.
• Decimal type reflection. Pull request #74 by armymaksim.
• ALTER DELETE. Pull request #81 by sdrenn. Solves issue #65.
• ALTER UPDATE. Pull request #82 by sdrenn. Solves issue #65.
• [HTTP] Session tests, assorted fixes. Pull request #73 by hhell.
• FINAL clause. Pull request #79 by sdrenn.
• CODEC column option. Pull request #89 by athre0z.
• Add literal binds support to IP types. Improve IP types IN and NOT IN comparators. Pull request #91 by AchilleAsh.

Changed

• Minimal SQLAlchemy version supported is 1.3 now.
• Named arguments should go after positional in ReplacingMergeTree, SummingMergeTree. Pull request #80 by sdrenn.
• sample keyword argument changed to sample_by in *MergeTree.
• version_col, keyword argument changed to version in ReplacingMergeTree.

Fixed

• [Native] Remove (%s)-templates from VALUES clause.
• [HTTP] fetchone elements order. Solves issue #77.
• Fix ReplacingMergeTree creation with no version.
• License file now included in the package. Solves issue #86.
• Columns are now prefixed with table name if necessary. Solves issue #35 and issue #87.
• Generate pure DLL without literals on Replicated tables creation.

Fixed

• Generic Table reflection in case of autoload=True.
• [HTTP] Fix get_schema_names.

Fixed

• Set default strictness to INNER for join.
• MergeTree PARTITION BY clause now accepts functions.

Added

• Enum without explicit size. Pull request #69 by ei-grad.
• [Native] Passing all parameters to clickhouse-driver by using querystring in DSN.
• [Native] Bypass types_check to clickhouse-driver via execution_options.
• [Native] Store rowcount on INSERT. Returning rows count from INSERT FROM SELECT is not supported.
• Python 3.8 in Travis CI build matrix.
• Assorted fixes and improvements from a downstream internal fork. Pull request #62 by hhell.
• LowCardinality type modifier. Pull request #59 by hhell.
• [Native] IPv4 and IPv6 types. Pull request #52 by AchilleAsh.
• Nested types. Pull request #49 by aCLr.
• Support for FULL parameter in JOIN rendering. Pull request #50 by PiwikPRO.
• ARRAY JOIN clause. Pull request #44 by aCLr.

Fixed

• [Native] Allow empty auth in DSN.
• [Native] Allow default secure port.
• Engine columns bool comparison errors.
• [HTTP] UnicodeDecodeError. Pull request #51 by aminought.

Changed

• Ability to use custom partition key and primary keys differs from sorting keys for *MergeTree. Pull request #48 by aCLr.
• Cursor performance increased infetchmany and fetchall.
• Add dependencies environment markers in setup.py. Pull request #58 by nitoqq.
• Joins support refactor. Added strictness (ANY/ALL), distribution (GLOBAL) parameters. Pull request #53 by aCLr.

Added

• Self-signed certificate support. Pull request #46 by rrockru.
• UUID type. Pull request #41 by BolshakovNO.
• Enum type reflection. Pull request #33 by sochi.
• Decimal type. Pull request #38 by nikitka.

Changed

• Minimal SQLAlchemy version supported is 1.2 now.

Fixed

• Handling additional columncomment_expression in DESCRIBE TABLE results during reflection (in ClickHouse server >= 18.15).

Added

• ON CLUSTER clause in CREATE TABLE, DROP TABLE.

Fixed

• Raw connection execute. Pull request #40 by AchilleAsh. Solves issue #39.

Added

• Streaming support via yield_per.
• Python 3.7 in Travis CI build matrix.

Fixed

• Handling boolean values of secure query parameter of database url.
• Cursor.__iter__ now conforms with PEP 479. Pull request #29 by khvn26. Solves issue #27.
• Multiprocessing/asyncio pickling issues. Pull request #36 by jhirniak. Solves issue #13.

Fixed

• Handling NULL values in arrays as strings. Pull request #23 by Joozty.

Added

• Schema names as databases support. Pull request #16 by AchilleAsh.
• DateTime type.
• Reflection Array, FixedString and Nullable types.

Fixed

• Pip install in editable mode.

Removed

• Python 3.3 support.

Added

• JOIN clause support via tuple_().
• Version detection in setup.py.

Changed

• Using native driver parameters substitution via pyformat.

Fixed

• Binary mod operation compilation issue #8.

Added

• SAMPLE clause.
• Code coverage.
• Additional engines: AggregatingMergeTree, GraphiteMergeTree, ReplacingMergeTree, ReplicatedMergeTree, ReplicatedCollapsingMergeTree, ReplicatedAggregatingMergeTree, ReplicatedSummingMergeTree. Distributed, Log, TinyLog, Null.
• Changelog.
• Lambda functions generation.

Added

• extract('year', x) alias to toYear(x)/toMonth(x)/toDayOfMonth(x). Pull request #2 by gribanov-d.
• External tables in native interface support.
• Nullable type support in CREATE TABLE.
• WITH TOTALS clause support for GROUP BY.
• Passing settings via execution_options.

Changed

• Native driver elements reverse order issue fixed.
• Fixed count(expr) rendering. Pull request #3 by gribanov-d.
• Fixed empty string parse error over HTTP. Pull request #5 by gribanov-d.
• Nested Array type generation fixed.
• Structure refactored.

Added

• Travis CI.
• flake8 syntax check.
• Native (TCP) interface support.
• Python 3.3+ support.

Changed

• ELSE clause is required in CASE.

Added

• HTTP/HTTPS protocol support.
• Python 2.7 support.
• Engine declaration support in __table_args__
• DROP TABLE IF EXISTS clause.
• Automatic registering as dialect clickhouse://.
• Chunked INSERT INTO in one request.
• Engines: MergeTree, CollapsingMergeTree, SummingMergeTree, Buffer, Memory.